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.
Curriculum
- 4 Sections
- 49 Lessons
- Lifetime
- 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