Autoplay
Autocomplete
Previous Lecture
Complete and Continue
On-Demand | Real Estate Financial Modelling Certificate
INDUCTION | The University of Cambridge online Certificate in Real Estate Financial Modelling
Welcome
Learning Hub
Course Handbook
Faculty (5:59)
Guest Speakers Recording (374:38)
Module Exercise Solutions (154:02)
Community Forum
Checklist
Excel Keyboard shortcuts
Teachable Troubleshoot Document
Disclaimer
Module One | Economic Context
Introduction (2:03)
The Real Estate Market System (3:44)
Real Estate Mathematics
Financial Model Integrity
Summary
Test your learning
Further resources
Module Two | Cash Flow Fundamentals
Introduction (2:39)
Components of a Basic Cash Flow Model (31:40)
Setting Up a Basic Cash Flow Model (43:16)
Summary
Test your learning
Further Resources (29:03)
Module Three | Developing the Cash Flow
Introduction (1:36)
Quarterly & Monthly DCF Models (8:31)
The Rent Function (20:43)
Summary
Test your learning
Further Resources
Module Four | Real Estate Data
Introduction (1:55)
Lease Contract Data (3:10)
Rent and Yield Projections
Rental Growth and Lease Events (11:11)
Summary
Test your learning
Further Resources
Survey: Halfway Point | Feedback
Module Five | Development Appraisals
Introduction (1:41)
Residual Appraisals (25:36)
Property Development Cash Flows
The Cost Function (7:38)
Development Return Metrics (7:56)
Summary
Test your learning
Further resources (20:49)
Module Six | Multi-Let Cash Flows
Introduction (1:31)
Real Estate Model Design (22:20)
The Tenancy Schedule (7:10)
Advanced Date Functions (7:03)
Advanced Rent Functions (46:09)
Investment Cost Functions
Summary
Test your learning
Further resources (53:15)
Module Seven | Real Estate Project Finance
Introduction (1:51)
Debt Finance (22:45)
The Repayment Function
Term Loans (14:06)
Working Capital
Introduction to Development Finance - New Add-On | 2025 (69:47)
Summary
Test your learning
Further resources (19:30)
Module Eight | Model Interpretation and Risk Analysis
Introduction (2:20)
State Variables (23:06)
Risk Analysis (9:13)
Visualisation Techniques (16:21)
Summary
Test your learning | Final Graded Exercise
Further resources (23:31)
Wrap up
Course recap
Your feedback
What's next
Bayfield 2026 Course Brochures
Bayfield Free Property Webinars
The Real Estate Market System
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock