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

Posted on: Thu, 10/10/2019 - 19:46 By: Anonymous (not verified)


Event Information

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


Greater London



This event called Cambridge Finance Real Estate Investment & Financial Modelling in Excel - 2 days courseis taking place on

At West Africa Money our slogan is African Money Transfer, Currency And Exchange Rates

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.


Duration: 2 days
Location: London
CPD Hours: 12
Level: Basic
Maximum number of delegates: 6


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

Your Venue Location On Google Map

Your Google zip or post code look up is


Find more on Eventbite.