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
Unlevered Cash flow (Hands-On)
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock