Autoplay
Autocomplete
Previous Lecture
Complete and Continue
NEW !! Introduction to Real Estate Financial Modelling in Excel
Bayfield Training | Executive Education
Learn more about us...
2026 Brochures: Online and Instructor -Led courses
Introduction to the course
Welcome - Course Introduction (5:27)
Learning Hub
The Trainer & Team Behind the Course
Excel shortcuts
Community Forum
Useful Real Estate Terminology
Teachable Troubleshoot Document
Disclaimer
Section One: Foundations of Financial Modelling
Introduction (1:59)
Microsoft Excel Foundations (13:24)
Financial Mathematics (49:28)
How to Value Real Estate | Convencional Valuation Methods (52:08)
Test your learning
Summary (0:53)
Section Two: Building an Annual Cash Flow
Introduction
Setting up the Cash flow (17:34)
Building the Cash Flow (19:37)
Initial Performance Metrics: NPV & IRR (18:56)
Test your Learning
Summary
Section Three: Developing the Cash Flow
Introduction
Cash Flow Complexity (15:14)
Understanding Net Initial Yield (14:38)
Capital Expenditure (12:06)
More Performance Metrics: Equity Multiple (11:03)
Test your Learning
Summary
Section Four: Making a Dynamic Cash Flow
Introduction
Logical Functions: IF, OR AND (34:27)
Make your model Shine (38:16)
Test your Learning
Summary
Practice your Learning: Homework excercise
Introduction and Overview of the Homework Exercise
Homework – Complete File
Extra Resources - Introduction to Real Estate FInancial Modelling- Step by step Manual
Course completed excel worksheet
Online Manual and Files
Explore More Video Resources on the Bayfield YouTube Channel
Wrap up
What's next?
Feedback Survey
Follow up Courses
Initial Performance Metrics: NPV & IRR
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock