Real Estate Finance & Financial Modelling for SPR Members


Dates: 22 & 23 June, 2016

Times: 10 AM to 5 PM

Address: Covent Garden, London

Price: £995             SPR Rate: £595


Day 1

Best Practice in Financial Modelling

Simple tips to help you become an efficient financial modeller

How to avoid errors and present your models in a persuasive way

Property Investment Cash Flow

Forecasting commercial property rents: passing rent, market rents and indexation

Estimating purchase and sale prices

Calculating expected property returns

Multi-let Property

Dating cash flows

Intermediate dates and lease events table

Rents Forecast

Rent reviews, lease expiry, vacancy and second lease rent

Time-varying rental growth


Day 2

Rents Forecast (cont.)

Rent free period, break options, step-up rents

Net Operating Income Forecast

Capital expenditure for refurbishment

Operating costs (letting fees, void costs, empty rates)

Service charge caps

Debt Finance


Constant Amortisation

Sensitivity Analysis

1-way data table

Scenario Analysis

Scenario manager

Multi-way data table

Fair Value Discussion

Click here for Terms & Conditions