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