Introduction to Real Estate in Excel

Course details

Course Overview

A Real Estate financial model is the abstract representation of an investment scenario. Building a Real Estate Financial Model requires theory, maths and excel.

This one day course has been developed to teach essential real estate financial modelling theory, functions and formulas to individuals working in the real estate sector. The training aims to give delegates a grasp of MS Excel and its usage in real estate cash flow modelling. You will be able to set up a financial modelling cash flow from a blank spreadsheet by using the most common shortcuts, formulas and functions. We will also cover the use of pivot tables to clean and organise your data.

This is an excellent starter/refresher course, whether you’re a recent graduate or a mid/senior professional.

On this course, you will…Learn spreadsheet modelling best practice

• Look over excel tips for general day to day use in MS Excel
• Recognise spreadsheet navigation and presentation tricks
• Understand financial mathematics & conventional valuations
• Identify Real Estate cash flow model single-let common functions and formulas

Course Outline

Conventional Valuations
Term & Reversion
Layer Method
Over Rented
Equivalent Yield

Real Estate Cash Flow Models (Single-Let)

• Annual Discounted Cash Flows
• “What If” Analysis
• Quarterly Discounted Cash Flow
• Cash Flows with Rent Review
• Multiple Rent Reviews
• NPV, IRR, Equity Multiple, Cash on Cash

Additional topics:

• IF, SUMIF & Switches’
• Sensitivity Analysis: Data Table & Changing Calculation Options

Other Excel tips and tricks, including navigation and presentation:
Functions and formulas included: General formatting, data entry, manipulation and creating formulas, Copy/Paste and general navigation with shortcuts, Solver (used to calculate equivalent yield), Scenarios, Customise spreadsheet, Navigation Shortcuts, SUM, TODAY, PV, IRR, EDATE, EOMONTH, DAY, MONTH, YEAR, NPV, YEARFRAC Updated on 11 November, 2025