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.
Course Features
- Lectures 57
- Quiz 0
- Duration Lifetime access
- Skill level All levels
- Language English
- Students 3002
- Certificate No
- Assessments Yes
- 4 Sections
- 57 Lessons
- Lifetime
- 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
