Autoplay
Autocomplete
Previous Lecture
Complete and Continue
On-Demand | Capital Structures & Waterfalls: Private Equity Real Estate Modelling Certificate
Welcome | Capital Structures and Waterfalls: PERE Modelling
Welcome
Learning Hub
Course Overview
Course Handbook
Faculty
Community Forum
Excel Keyboard shortcuts
Further Reading & Resources
Teachable Troubleshoot Document & Students Terms &Conditions
Disclaimer
Module 1 | Introduction to Private Equity Real Estate
Introduction (1:21)
What is Private Equity Real Estate (PERE)? (7:04)
Overview Private Equity Funds (4:19)
PERE Promote Structure
Test your Learning
Exercise Solution
Summary (4:54)
Module 2 | Performance Metrics, Key Pitfalls in PERE
Introduction (1:08)
PERE Performance Metrics & Assessment
Key Pitfalls and Considerations in PERE
Components of a PERE Valuation Model & Introduction to the Case Study (9:22)
Model Framework Set Up and Assumptions Inputs (11:45)
Test your Knowledge
Exercise Solutions
Summary
Module 3 | Capital Structures & Stakeholders Priority
Introduction (1:00)
Typical Capital Structure in PERE (3:21)
Unlevered Cash flow (Hands-On) (16:29)
Debt Capital - Senior Loans (11:47)
Case study: Senior Loan Cash flows (Hands On) (15:13)
Debt Capital - Mezzanine Finance & other loans (4:52)
Case Study- Mezzanine Finance Cashflow (Hands On) (11:56)
Test your Knowledge
Exercise Solution
Summary
Module 4| Performance & Promote Structure/ Waterfall structures
Introduction (1:02)
Performance Metrics
Partnership - Level Cash Flows - Waterfall Structure (25:57)
Profit Tables (14:59)
Test your Knowledge
Summary
Module 5 | Risk Analysis
Introduction (3:39)
Sensitivity Analysis (5:37)
Dynamic Scenario Model (12:38)
Monte Carlo Simulation in Excel using Random Number Generation (Non-VBA) (13:34)
Bonus: Advanced Investment Viability Analysis with Python and xlwings (video showcase) (1:52)
Test your knowledge
Summary
Wrap up
Your feedback
What's next
Bayfield 2026 Course Brochures
Bayfield Free Property Webinars
Stay Connected with Bayfield Training
Model Framework Set Up and Assumptions Inputs
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock