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 Brochure
Quarterly & Monthly DCF Models
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock