- Home
- Courses
- Accelerator
- Library of Supplementary Learning Tools
Curriculum
- 4 Sections
- 49 Lessons
- Lifetime
Expand all sectionsCollapse all sections
- Practice Case Studies8
- 1.1Renovo Tower – Office Acquisition (Case + Solution + Video)
- 1.2Presidio – Apartment Acquisition (Case + Solution + Video)
- 1.3Global REPE Firm – Apartment Acquisition (Test)
- 1.4Just the Facts – Retail Sale-Leaseback (Case Only)
- 1.5The Stones Hotel – Acquisition (Test Only)
- 1.6The Jefferson – Branded Condo Development (Case +Solution)
- 1.7Hamilton Park VIII – Industrial Development (Case + Solution)
- 1.8The Cellon Group – Real Estate Asset Management Analyst Test (Test + Solution)
- Watch Me Build VideosCollection of real estate financial modeling Watch Me Build videos16
- 2.1Introduction to this Watch Me Build Section
- 2.2Watch Me Build 30/360, Actual/365, Actual/360 Amortization Tables
- 2.3Watch Me Build a 3-Tier Real Estate Equity Waterfall Model
- 2.4Watch Me Build a 4-Tier Equity Multiple Waterfall Model
- 2.5Watch Me Build a Construction Draw Schedule
- 2.6Watch Me Build a Dynamic Mortgage Amortization Table in Excel
- 2.7Watch Me Build a Multifamily Real Estate Model
- 2.8Watch Me Build a Residential Land Development Model
- 2.9Watch Me Build a Tenant Rollover Analysis Model
- 2.10Watch Me Solve a REPE Technical Interview Modeling Test
- 2.11Watch Me Add Mezz Debt To a Hotel Development Model
- 2.12Watch Me Expand a Single Family Home Construction Pro Forma to Analyze Multiple Homes
- 2.13Watch Me Build Data Tables for Real Estate Sensitivity Analysis
- 2.14Watch Me Build – Capital Stack with Mezzanine Debt
- 2.15Watch Me Build – American-Style Real Estate Equity Waterfall Model
- 2.16Watch Me Build – IRR and Equity Multiple Partitioning
- Forum Post VideosRepository of videos created in response to questions asked in the Accelerator forums22
- 3.1One Technique for Manually Auditing an Excel Model
- 3.2Creating Custom Conditional Formatting Rules
- 3.3Troubleshooting Slow Excel Workbooks
- 3.4Modeling a Simple Interest Preferred Return
- 3.5Combining Multiple Uses from Two Models into One
- 3.6Modeling Lease-Up Income During Construction
- 3.7Waterfall with Mid-Hold Capital Event
- 3.8Two Methods for Modeling Residential Lease-Up
- 3.9Greater Explanation of Circuit Breaker
- 3.10Adding an Operating Shortfall to Model
- 3.11How to Model Multi-Tenant Industrial Building Converted to Condo
- 3.12Hiding/Showing Excess Rows and Columns
- 3.13Catch Up Provision Example
- 3.14Modeling Existing Debt
- 3.15Mezz Debt – Interest Partially Capitalized
- 3.16How to Model CapEx Reserve Account
- 3.17Modeling Potential Gross Rent in Long-Term Leases
- 3.18Technique for Extending Analysis Period in an Existing Model
- 3.19XIRR Dynamic to Analysis Start Date
- 3.20How to Visualize an IRR Matrix Using Excel’s Charting Tools
- 3.21Help Modeling Complex Multi-Partnership Structures
- 3.22DCF Valuation – European Perspective
- Additional Tools3