-
Additional Case Studies + Technical Interview Exams
- Renovo Tower – Office Acquisition (Case + Solution + Video)
- Presidio – Apartment Acquisition (Case + Solution + Video)
- Just the Facts – Retail Sale-Leaseback (Case Only)
- The Stones Hotel – Acquisition (Test Only)
- The Jefferson – Branded Condo Development (Case +Solution)
- Hamilton Park VIII – Industrial Development (Case + Solution + Video)
- Global REPE Firm – Apartment Acquisition (Test)
- The Cellon Group – Real Estate Asset Management Analyst Test (Test + Solution + Video)
- Walgreens vs. Walgreens – STNL Investor (Case + Solution)
- UK Debt Advisory Firm Modeling Test – Single-Let Office Building (Case + Solution)
-
Forum Post Videos
Repository of videos created in response to questions asked in the Accelerator forums
- One Technique for Manually Auditing an Excel Model
- Creating Custom Conditional Formatting Rules
- Troubleshooting Slow or Very Large Excel Workbooks
- Modeling a Simple Interest Preferred Return
- Combining Multiple Uses from Two Models into One
- Modeling Lease-Up Income During Construction
- Waterfall with Mid-Hold Capital Event
- Two Methods for Modeling Residential Lease-Up
- Greater Explanation of Circuit Breaker
- Adding an Operating Shortfall to Model
- How to Model Multi-tenant Industrial Building Converted to Condo
- Hiding/Showing Excess Rows and Columns
- Catch Up Provision Example
- Modeling Existing Debt
- Mezz Debt – Interest Partially Capitalized
- Example of Variable Expenses in a Model
- Boolean Logic in Amortization Schedule Exercise
- Framework for Modeling Bridge + Construction Loan
- Capital Stack with Customer Deposits as Source
- Semi-Annual Compounding Debt and Amortization Exercise
- Calculating Monthly Hurdle Rate Using an Actual Month and 365 Day Year
- DCF Valuation Revisited – Solving for Present Value vs. Solving for IRR
- Modeling a Custom Rent Schedule
- How to Model CapEx Reserve Account
- Modeling Potential Gross Rent in Long-Term Leases
- Technique for Extending Analysis Period in an Existing Model
- XIRR Dynamic to Analysis Start Date
- How to Visualize an IRR Matrix Using Excel’s Charting Tools
- Help Modeling Complex Multi-Partnership Structures
- DCF Valuation – European Perspective
-
Watch Me Build Videos
Collection of real estate financial modeling Watch Me Build videos
- Introduction to this Watch Me Build Section
- Watch Me Build a 3-Tier Real Estate Equity Waterfall Model
- Watch Me Build 30/360, Actual/365, Actual/360 Amortization Tables
- Watch Me Build a 4-Tier Equity Multiple Waterfall Model
- Watch Me Build a Construction Draw Schedule
- Watch Me Build a Dynamic Mortgage Amortization Table in Excel
- Watch Me Build a Multifamily Real Estate Model
- Watch Me Build a Residential Land Development Model
- Watch Me Build a Tenant Rollover Analysis Model
- Watch Me Solve a REPE Technical Interview Modeling Test
- Watch Me Add Mezz Debt To a Hotel Development Model
- Watch Me Expand a Single Family Home Construction Pro Forma to Analyze Multiple Homes
- Watch Me Build Data Tables for Real Estate Sensitivity Analysis
- Watch Me Build – Capital Stack with Mezzanine Debt
- Watch Me Build – American-Style Real Estate Equity Waterfall Model
- Watch Me Build – IRR and Equity Multiple Partitioning
- Watch Me Build – Custom Rent Schedule Module
-
Additional Excel Resources
This content is protected, please login and enroll course to view this content!
