Real Estate Analyst (Investment Cash Flow Modelling in Excel)

Learn how to structure an investment cash flow from first principles and how to value and appraise property investments

Build annual and quarterly discounted cash flows

Look in depth at modelling tenancy schedules: rent reviews, upward-only, break options, lease expiry

Build OPEX and CAPEX into your cash flow

Analyse risk using sensitivity tables and charts

Employ best practice and find solutions to common modelling problems

Real Estate Investors

Surveyors

Portfolio Analysts

Investment Managers

Asset Managers

Real Estate professionals at any level with exposure to real estate financial models on a frequent basis

Mid-level to senior Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members

Junior or new Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members

APC candidates who would like the opportunity to consolidate their competencies by understanding how theory and variables interact within the precision context of a financial model.

Term & Reversion and Layer Method Valuation (Intro to Excel)

Equivalent Yield (Solver, Scenario and Goal Seek functions)

Single-Let Discounted Cash Flow

Cash Flow inputs (Rents, Yields, Growth Rates, Target Returns)

Analysis and use of date series

Internal Rate of Return (IRR) and Net Present Value (NPV)

Comparing Value, Price and Worth

Adding borrowing and analysing geared returns

Introducing Rent Reviews and other ‘events’ into cash flows

The ‘Rent Function’ concept and Logic functions (IF,OR,AND)

Sensitivity analysis

The ‘Rent Function’ and Multi-let cash flows

The ‘date problem’ and assumptions in property asset cash flows

Reducing the rent function, intermediate calculations and modelling theory

Modelling lease expiries, break clauses, voids, and upward only covenants

Incorporating time-varying rental growth rates

Analysing multi-let cash flows to see if the leases are sufficiently diversified

Further IRR analysis (XIRR, MIRR)

CPD Accredited Certificate & LinkedIn Proficiency Badge

Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee

Course Files

Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)

Post Course Support - Two Months of Questions & Answers, and One year of support is available for an additional fee