Course Content
Lessons
Status
1
Module 1: Introductory Crash Course and Full Build-Out of 60-minute In-Person Case Study Model from Scratch
-
Funds Detail
-
Capital Structure
-
Introduction to the On-Site Case Study
-
Breaking Down LBO Models
-
Begin LBO Model in Excel
-
Breaking Down Sources and Uses
-
Sources and Uses in Excel
-
Breaking Down Cash Flow Forecasts
-
Cash Flow Forecasting in Excel
-
Breaking Down the Time Value of Money and Returns Metrics
-
Finish LBO Model in Excel
- Funds Detail
- Capital Structure
- Introduction to the On-Site Case Study
- Breaking Down LBO Models
- Begin LBO Model in Excel
- Breaking Down Sources and Uses
- Sources and Uses in Excel
- Breaking Down Cash Flow Forecasts
- Cash Flow Forecasting in Excel
- Breaking Down the Time Value of Money and Returns Metrics
- Finish LBO Model in Excel
2
Module 2: In-Depth Acquisition from Scratch with Source Materials with Step-by-Step Model Buildout and Theoretical Context
-
Verdant Apartments Offering Memorandum
-
Rent Roll Overview
-
Spread the Rent Roll in Excel
-
Overview of the T12 Operating Financials
-
Create T12 Summary Template
-
Map the T12 to our Summary Template
-
Begin Modeling Verdant Apartments Cash Flows
-
Complete our Revenue Forecasts
-
Forecast Controllable Expenses and Utilities
-
Build our Cash Flow Projection Template
-
Forecast Renovations
-
Forecast Entry and Exit Value
-
Breaking Down Real Estate Taxes
-
Forecast Real Estate Taxes
-
Breaking Down Property Insurance
-
Forecast Property Insurance and Summarize our Monthly Cash Flows
-
Finish Verdant Apartments Model
- Verdant Apartments Offering Memorandum
- Rent Roll Overview
- Spread the Rent Roll in Excel
- Overview of the T12 Operating Financials
- Create T12 Summary Template
- Map the T12 to our Summary Template
- Begin Modeling Verdant Apartments Cash Flows
- Complete our Revenue Forecasts
- Forecast Controllable Expenses and Utilities
- Build our Cash Flow Projection Template
- Forecast Renovations
- Forecast Entry and Exit Value
- Breaking Down Real Estate Taxes
- Forecast Real Estate Taxes
- Breaking Down Property Insurance
- Forecast Property Insurance and Summarize our Monthly Cash Flows
- Finish Verdant Apartments Model