Real Estate Investment & Financial Modelling

Summary

Learn how to construct valuation models and discounted cash flow models for single-tenant and multi-tenant buildings.

Understand sensitivity analysis to allow you to make better investment decisions.

Master real estate finance fundamentals which will enhance your property investment analysis and underwriting processes.

Course Content

Best practice in financial models

  • Simple tips to help you become an efficient financial modeller
  • How to avoid errors and present your models in a persuasive way

Implicit investment valuation methods

  • Term & Reversion
  • Layer / Hardcore
  • Property yields
  • Defining term and reversionary yields
  • Calculating the equivalent yield

Build your cash flow from scratch

  • Inputs: passing rent, estimated rental value, initial and exit yields, market growth, review cycles and most importantly, target returns
  • Outputs: internal rate of return, net present value and worth
  • Annual and quarterly discounted cash flows: modelling purchase price, passing rent, rent reviews, exit rent and exit price

Analyse the results

  • IRR, NPV and maximum bidding price
  • Data tables & sensitivity analysis
  • Risk visualisation (charts)

Case study:

  • Single-tenant office building in the UK

Rent Forecast of Multiple Tenant Properties

  • Modelling tenancy schedules
  • Rent reviews, upward-only, break options, lease expiry
  • Modelling hypothetical second leases
  • Void period, rent free and estimated rental values
  • Time-varying rental growth

Net Operating Income Forecast

  • Modelling capital expenditure for refurbishment and operating costs (letting fees, void costs, empty rates)

Investment decision

Case study: multi-tenant office building in the UK

Entry-level graduates and APC candidates.

Real estate banking and lending analysts, investment surveyors and property consultants

Aaron Vagarwal

"Maria's teaching style is engaging and easy to follow along. I also like the fact Maria shares her past experience of the investment world, where relevant to the course. That was invaluable and wouldn't be learned in a book."

Aaron Vagarwal
Finance Director
Bridges Fund Management
Dates & Prices
DurationDuration CPD HoursCPD Hours LocationLocation LevelLevel DatesDates
2 days 14 London/Online Beginner

Virtual Live Course

In-Person Course

Early Bird Prices
plus VAT

Book Early & Save

Book & Pay min. 30 days before
course start date
£1,375
£1,720
Book Now Book Now
Regular Prices
plus VAT

Quality Training

Book and/or pay less than 30
days in advance
£1,520
£1,895
Book Now Book Now

Our Featured Resources

CTA

You may submit an application to be considered for the scholarship program.