Cambridge Finance Real Estate Investment & Financial Modelling in Excel - 2 days course

• London United Kingdom
• Start: Jul 19 2022 00:00
• Finish: Dec 01 2024 00:00
• Time zone: Europe/London

Construct a robust real estate financial model from scratch and use it to assess the financial risk and return profile of an investment, income-producing real estate asset.
This course is aimed at banking and lending analysts for real estate, investment surveyors,  real estate finance professionals and property consultants seeking a best practice approach to building robust real estate financial models.
Delegates will learn to construct valuation models and discounted cash flow models for single-tenant and multi-tenant buildings and perform sensitivity analysis for the investment decision. Delegates will also learn real estate finance fundamentals which will enhance their property investment analysis and underwriting processes.
Who should attend this course:
The Real Estate Investment and Financial Modelling in Excel courses are suitable for anyone seeking to develop their modelling skills. From entry-level graduates, APC candidates to experienced professionals and modellers, the fundamentals and techniques taught in our courses will help anyone improve their financial modelling expertise and reduce modelling errors.
Details
Duration: 2 daysLocation: LondonCPD Hours: 12Level: BasicMaximum number of delegates: 6
Content
Day 1
Best practices 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
Property yields
Defining term and reversionary yields
Calculating the equivalent yield
Value calculation using conventional valuation methods
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
Gearing: adding senior debt “bullet” loan
Analyse the results
The maximum bidding price
Data tables & sensitivity analysis
Risk visualisation (charts)
Case study: single-tenant office building in the UK
Day 2
Dating the cash flow
The dating problem
Intermediate calculations
Rent Forecast
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)
Logic Functions
Investment decision
Sensitivity tables
Risk versus return analysis
Case study: multi-tenant office building in the UK