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 Post Videos
- Case Studies + Technical Interview Exams
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.
-
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
