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
How does this work?
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock