Course Content
LessonsStatus
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