Senior Portfolio Analyst

JOB SUMMARY

The CBRE Loan Services Senior Portfolio Analyst position is responsible for interaction within our internal organization, borrowers, clients, contractors, attorneys, title companies, architects, brokers, appraisers, and other deal related parties. The position requires the ability to independently perform: preparation of formal written presentations analyzing a wide spectrum of issues relating to both loan and property-level requests, delivery of the highest level of customer service to both internal and external clients, prepare detailed financial analysis, modeling and commercial mortgage underwriting duties, abstracting of loan and transactional documents, property inspections, and other functions including; market / sub-market research and presentation and creation of written presentations.

ESSENTIAL DUTIES AND RESPONSIBILITIES

Assists Portfolio Managers by performing tasks involved in monitoring the performance and progress under business plans related to a defined portfolio of assigned commercial real estate loans and joint venture investments.

Mentors, trains, and sometimes manages Portfolio Analysts

Provides excellent customer service and problem resolution for client, borrower, and internal / external customers.

Review and interpret loan documents, joint venture and other deal documents and monitors compliance in accordance with those documents.

Analysis of property level financial statements including operating statements, balance sheets and rent rolls.

Conducts research and financial analysis of commercial real estate properties, loans and portfolios.

Assists with data compilation for client decisions. Makes presentation of analysis that will be used for investment decisions.

Build and maintain complex financial models to track the performance of transactions from inception through deal exit, that require advanced excel skills and a solid understanding of time value of money principals

Build and maintain financial models to track contracts and cash flows from the sellout of Condominium projects or similar sellout type projects

Build and maintain complex financial models to track capital inflows and outflows related to ground up and major renovation commercial real estate deals with multiple capital partners

Reconcile and review loan draws for funding of construction, leasing and capital costs.

Ability to identify project risks, develop risk mitigation and contingency plans, and implement action plans to reduce or eliminate project risks.

Perform valuations of properties in excel and Argus.

Upon request, conduct property inspections coordination with client and/or 3rd party inspector.

Review budgets annually and monitor operating statements on a periodic basis, spreading both to industry standards upon receipt and benchmarking to the underwriting projections.

Other duties and special projects as assigned.

SUPERVISORY RESPONSIBILITIES

May be responsible for training, mentoring or managing Portfolio Analysts or Associates.

QUALIFICATIONS

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. The requirements listed below are representative of the knowledge, skill, and/or abilities requisite to this position:

Exceptional professional writing and verbal communication skills are essential.

General underwriting capabilities and an understanding of commercial and construction real estate asset types.

Experience tracking construction projects for capital providers a plus.

Ability to work in a fast-paced environment and simultaneously manage and effectively prioritize numerous complex transactions and issues.

Detail oriented and dedicated to accuracy.

Extensive MS Excel experience building models, both for tracking performance and forecasting cash flows.

Complete understanding of time value of money concepts a must.

Excellent organizational skills.

Strong problem resolution skills.

Great attention to detail, analytical mindset and ability to work independently as well as in a team environment.

Previous work experience in commercial real estate with focus on cash flow modeling, construction loan administration, valuation and / or loan servicing.

EDUCATION and EXPERIENCE

High School diploma or General Education Degree (GED) required with a minimum of 3 years related experience. Bachelor’s degree from a four-year college or university preferred.

CERTIFICATES and/or LICENSES

None

COMMUNICATION SKILLS

Ability to read, analyze and interpret loan documents and industry reports.

Ability to prepare clear, concise, complete, and compelling transactional presentations, reports, and business correspondence.

Ability to effectively present information to external clients and customers as well as internal management.

Ability to communicate directions and guidance to others.

FINANCIAL KNOWLEDGE

Advanced understanding of the principles of real estate and finance, including time value of money principals. Ability to perform financial calculations.

REASONING ABILITY

Ability to define problems, collect data, establish facts, and draw valid conclusions.

Ability to interpret an extensive variety of instructions in written or diagram form and deal with disparate abstract and concrete variables.

OTHER SKILLS and/or ABILITIES

Proficient in comment Microsoft products such as Word, Excel, Outlook, etc.

SCOPE OF RESPONSIBILITY

Decisions made with general understanding of procedures and company policies to achieve set results and deadlines. Errors in judgment may cause short-term impact to co-workers and supervisor.