Autoplay
Autocomplete
Previous Lecture
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
Timetable for virtual sessions over the 6 months
Excel Tips
Teachable Troubleshoot Document & Course T&C
PHASE ONE: IN-PERSON COURSE IN CAMBRIDGE
Phase One: Handbook - In-person
Cambridge Course: Venue/s
Course Manuals
Completed Course Excel Files
POST COURSE: Case study webinar (75:09)
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 (26:27)
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 Two :Feedback
What's next
PHASE THREE: ADVANCED REAL ESTATE MODELLING AND VIRTUAL COACHING
Welcome to Phase three (3:31)
Course Handbook
Faculty (1:28)
Live Webinars
Terminology: Python, useful statistical and real estate concepts
Module 1: Introduction to Real Estate Data Analytics
Introduction -Defining Real Estate Analytics (7:30)
Real Estate Data & Applications (10:20)
Real Estate Analytics Spectrum (8:31)
The Value Add of Real Estate Analytics to Financial Modelling and Decision-Making (6:26)
Analytics in Practice - AI Tools and Software (8:40)
Summary
Test your Learning (3:52)
Further Reading
Module 2: Introduction to Python - Practical Applications for Real Estate
Introduction (1:25)
Why Python? (2:24)
Environmental Setup: Choosing between Anaconda & Google Colab (6:29)
Essential Python Libraries for Real Estate Analytics (26:21)
Hands-on Exercise : Comparison of analysis for each library in Python and Excel (46:22)
Summary
Test your Learning
Further Reading
Module 3: Enhancing Real Estate Spreadsheet Models with Python
Introduction (1:40)
Integrate Python with Excel using xlwings (6:24)
Sensitivity Analysis in Excel Using Python (22:19)
Dynamic Scenario Analysis in Excel using Python (12:30)
Building a Python-Based Monte Carlo Simulation in Excel (14:19)
Summary (1:21)
Test your Learning
Further Reading
Module 4: AI-Powered Analytics & Prompt Engineering for Real Estate
Introduction (2:16)
Fine-Tuning and Best Practice for AI- Assisted Assumption Generation (8:40)
AI-Powered Market Research (Perplexity) (27:46)
AI-Driven Sentiment Analysis (Chat GPT & Deepseek) (15:47)
AI-Assisted Report Generation & Report Summaries (11:02)
Summary (3:09)
Test your Learning
Further Reading
Module 5: AI Enhanced Assumptions Generation and Integration for Real Estate Financial Modelling (Hands-on)
Introduction (3:41)
Understanding Key Real Estate Model Inputs and Assumptions with AI - Chat GPT (12:00)
Using AI to Generate Robust Financial Assumptions for Excel Model Inputs (12:30)
Using AI & Python for Enhanced Analysis - Produce Multivariate sensitivity tables (17:31)
Using AI & Python for Enhanced Analysis - Dynamic Scenario Modelling (14:49)
Using AI & Python for Enhanced Analysis - Monte Carlo Simulation (18:37)
AI-Powered Financial Model Summary and Reporting (21:40)
Summary
Test your Learning
Further Reading
Module 6: The Capstone Project
Capstone Project
Congratulations
121 COACHING SESSION PER STUDENT
How does this work?
Available Times
Wrap Up
Course Content Recap
Your Feedback
Thank you for attending!
Congratulations ! Letter from the CEO
Your feedback is important to us
Bayfield 2026 Course Brochure
Bayfield Free Property Webinars
Virtual Q&A Course Content Tutorials
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock