Real Estate Investment & Financial Modelling
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.
- Overview
- Prices & Dates
- Content
- Participants
- Testimonials
Real Estate Investment & Financial Modelling
Overview
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.
Day 1
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 Worth
- Data tables & sensitivity analysis
- Risk visualisation (charts)
Case study
Single-tenant office building in the UK
Day 2
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