LIBRARY DESCRIPTION
The Library of Supplementary Learning Tools is a medium through which Michael and Spencer share additional resources to help Accelerator members practice and improve. The library will grow over time to include additional (or redundant):
- Watch Me Build Videos
- Forum Response Videos
- Case Studies
As with the content within the Advanced Concepts course, it is not necessary to complete any of the material included in this Library of Supplementary Learning Tools to obtain the Accelerator Certificate of Completion.
Additional materials are regularly added to this Library based on your recommendations. So if there is something you’d like added to this library, please let us know.
A NOTE ABOUT THE WATCH ME BUILD TUTORIALS
This Library was seeded with a series of Watch Me Build videos that were originally posted on the blog side of the Adventures in CRE website.
To make all of these exercises readily and conveniently available to Accelerator members, we’ve added these Watch Me Build Videos to this section.
What is covered in the Watch Me Build videos is a review of what you’ve already covered in more depth in the Accelerator. Nevertheless, practice makes perfect. So you’ll find value going through these exercises and applying a second time what you’ve already learned in the 16 core Accelerator courses.
-
Practice Case Studies
- Renovo Tower – Office Acquisition (Case + Solution + Video)
- Presidio – Apartment Acquisition (Case + Solution + Video)
- Global REPE Firm – Apartment Acquisition (Test)
- 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)
- The Cellon Group – Real Estate Asset Management Analyst Test (Test + Solution)
-
Watch Me Build Videos
Collection of real estate financial modeling Watch Me Build videos
- Introduction to this Watch Me Build Section
- Watch Me Build 30/360, Actual/365, Actual/360 Amortization Tables
- Watch Me Build a 3-Tier Real Estate Equity Waterfall Model
- 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
-
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 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
- 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
-
Additional Tools
