Introduction to Real Estate Financial Modelling

Name: Introduction to Real Estate Financial Modelling
Start: 2026-07-27T10:00:00+0100
End: 2026-11-18T16:00:00+0000
Location: London

Wed, 18 Nov, 10am - 4pm GMT

London

London, United Kingdom

Bayfield Training

Contact host

Description

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

Who will benefit from this course?

Graduate Real Estate professionals
Real Estate professionals at any level with exposure to Real Estate financial models on a frequent basis
APC candidates
Mid-Senior professionals looking for a refresher on core model building skills and best practice
Any professionals looking to learn how to build a Real Estate focused model from scratch.

Course Outline

10:00 am - 4:00 pm

Day One

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

Tickets for good, not greed Humanitix dedicates 100% of profits from booking fees to charity

Hostinformation

Bayfield Training

Contact host

View profile

Bridging the Gap Between Academic Learning and Professional Excellence in Real Estate

For more than twenty-five years, Bayfield Training has led the way in transforming academic understanding into practical, industry-ready expertise for Real Estate professionals. As the trusted training partner for commercial property consultancies, developers, asset managers, lenders, and REITs, we have played a pivotal role in shaping how the industry approaches Real Estate Financial Modelling.

What was once a niche technical skill — Discounted Cash Flow (DCF) modelling — is now a core requirement for analysts across investment, development, valuation, and asset management. Bayfield has been at the centre of this shift, equipping thousands of professionals with the modelling capability, analytical confidence, and commercial insight needed to excel in their roles.

Our mission is simple: to empower Real Estate professionals with the skills, clarity, and confidence to perform at the highest level today and throughout their careers.

Bayfield Training is a recognised leader in executive education for the real estate and finance sectors, offering a comprehensive suite of CPD-accredited courses designed to support both emerging talent and seasoned professionals. Their curriculum spans Real Estate Financial Modelling, Investment Analysis, Development Appraisal, Strategic Planning, and ESG in Real Estate, equipping learners with the technical and strategic skills needed to thrive in a competitive market.

Whether you’re an analyst building your first cash flow model or a senior executive refining investment strategies, Bayfield’s courses are structured to meet you where you are in your career journey. With a strong emphasis on practical application, participants gain hands-on experience using industry-standard tools and methodologies, ensuring immediate relevance to their roles.

By combining rigorous training with deep industry insight, Bayfield Training helps professionals build confidence, competence, and credibility—whether they’re launching careers or leading portfolios.

We offer a series of free property webinars designed to support real estate professionals with accessible, expert-led learning.

Delivered by seasoned industry practitioners and academic specialists, these sessions combine practical case studies with cutting-edge insights to ensure participants gain both theoretical knowledge and actionable skills.

Our webinars cover a wide range of industry-relevant topics, including property investment, financial modelling, market trends, and asset management, with new themes regularly introduced to reflect emerging trends such as ESG, PropTech, and advanced analytics.

Whether you’re a junior analyst, a mid-level manager, or a senior executive, our webinars provide valuable insights to help you stay competitive and informed in a fast-evolving sector.

Participants benefit not only from structured learning but also from interactive Q&A opportunities, enabling direct engagement with experts and peers