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
Further Resources
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock