Autoplay
Autocomplete
Previous Lecture
Complete and Continue
FREE Sample Module | Capital Structures & Waterfalls: Private Equity Real Estate Modelling Certificate
Welcome | Capital Structures and Waterfalls: PERE Modelling
Bayfield 2026 Brochures
Bayfield Free Property Webinars
Capital Structures and Waterfalls: PERE Course Brochure
Welcome
Learning Hub
Course Overview
Course Handbook
Faculty
Community Forum
Excel Keyboard shortcuts
Further Reading & Resources
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
PERE Performance Metrics & Assessment
Key Pitfalls and Considerations in PERE
Components of a PERE Valuation Model & Introduction to the Case Study
Model Framework Set Up and Assumptions Inputs
Test your Knowledge
Exercise Solutions
Summary
Module 3 | Capital Structures & Stakeholders Priority
Introduction
Typical Capital Structure in PERE
Unlevered Cash flow (Hands-On)
Debt Capital - Senior Loans
Case study: Senior Loan Cash flows (Hands On)
Debt Capital - Mezzanine Finance & other loans
Case Study- Mezzanine Finance Cashflow (Hands On)
Test your Knowledge
Exercise Solution
Summary
Module 4| Performance & Promote Structure/ Waterfall structures
Introduction
Performance Metrics
Partnership - Level Cash Flows - Waterfall Structure
Profit Tables
Test your Knowledge
Summary
Module 5 | Risk Analysis
Introduction
Sensitivity Analysis
Dynamic Scenario Model
Monte Carlo Simulation in Excel using Random Number Generation (Non-VBA)
Bonus: Advanced Investment Viability Analysis with Python and xlwings (video showcase)
Test your knowledge
Summary
Wrap up
Your feedback
What's next
Exercise Solutions
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock