Autoplay
Autocomplete
Previous Lesson
Complete and Continue
BLENDED LEARNING | Cambridge Real Estate Financial Modelling Programme
Cambridge Real Estate Financial Modelling Programme | Induction
Welcome to your E-learning Hub
Course Handbook for the 6-Month E-Learning Programme
Faculty
Community Forum
Excel Tips
Teachable Troubleshoot Document & Course T&C
Phase One: In-person course in Cambridge
Phase One: Handbook - In-person
Cambridge Course: Venue/s
Completed Course Excel Files
Completed Workshop/Case Study files
Course Manuals
POST COURSE: Case study webinar
Phase One | Feedback
Phase Two | The University of Cambridge online Certificate in Real Estate Financial Modelling
Welcome - Phase Two (1:36)
Learning Hub
Course Handbook
Faculty (5:59)
Virtual Q&A Course Content Tutorials
Guest Speakers Insights (374:38)
Checklist
Excel Keyboard shortcuts
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 (39:26)
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
Further resources (23:31)
Final Graded Exercise | Real Estate Financial Modelling Certificate
Test your learning | Final Graded Exercise
Phase Three: Advanced Real Estate Modelling & Coaching
Complete Files
Course resources
121 Coaching
Wrap up
Course recap
Case studies to keep practising
What's next
Thank you for attending!
Congratulations ! Letter from the CEO
Your feedback is important to us
Bayfield 2026 Course Brochure
Your feedback is important to us
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock