Additional Case Studies 8

• Lecture1.1
  Renovo Tower – Office Acquisition (Case + Solution + Video)
• Lecture1.2
  Presidio – Apartment Acquisition (Case + Solution + Video)
• Lecture1.3
  Just the Facts – Retail Sale-Leaseback (Case Only)
• Lecture1.4
  The Stones Hotel – Acquisition (Test Only)
• Lecture1.5
  The Jefferson – Branded Condo Development (Case +Solution)
• Lecture1.6
  Global REPE Firm – Apartment Acquisition (Test)
• Lecture1.7
  Hamilton Park VIII – Industrial Development (Case + Solution)
• Lecture1.8
  The Cellon Group – Real Estate Asset Management Analyst Test (Test + Solution)

Forum Post Videos 30

Repository of videos created in response to questions asked in the Accelerator forums

• Lecture2.1
  One Technique for Manually Auditing an Excel Model
• Lecture2.2
  Creating Custom Conditional Formatting Rules
• Lecture2.3
  Troubleshooting Slow Excel Workbooks
• Lecture2.4
  Modeling a Simple Interest Preferred Return
• Lecture2.5
  Combining Multiple Uses from Two Models into One
• Lecture2.6
  Modeling Lease-Up Income During Construction
• Lecture2.7
  Waterfall with Mid-Hold Capital Event
• Lecture2.8
  Two Methods for Modeling Residential Lease-Up
• Lecture2.9
  Greater Explanation of Circuit Breaker
• Lecture2.10
  Adding an Operating Shortfall to Model
• Lecture2.11
  How to Model Multi-Tenant Industrial Building Converted to Condo
• Lecture2.12
  Hiding/Showing Excess Rows and Columns
• Lecture2.13
  Catch Up Provision Example
• Lecture2.14
  Modeling Existing Debt
• Lecture2.15
  Mezz Debt – Interest Partially Capitalized
• Lecture2.16
  Example of Variable Expenses in a Model
• Lecture2.17
  Boolean Logic in Amortization Schedule Exercise
• Lecture2.18
  Framework for Modeling Bridge + Construction Loan
• Lecture2.19
  Capital Stack with Customer Deposits as Source
• Lecture2.20
  Semi-Annual Compounding Debt and Amortization Exercise
• Lecture2.21
  Calculating Monthly Hurdle Rate Using an Actual Month and 365 Day Year
• Lecture2.22
  DCF Valuation Revisited – Solving for Present Value vs. Solving for IRR
• Lecture2.23
  Modeling a Custom Rent Schedule
• Lecture2.24
  How to Model CapEx Reserve Account
• Lecture2.25
  Modeling Potential Gross Rent in Long-Term Leases
• Lecture2.26
  Technique for Extending Analysis Period in an Existing Model
• Lecture2.27
  XIRR Dynamic to Analysis Start Date
• Lecture2.28
  How to Visualize an IRR Matrix Using Excel’s Charting Tools
• Lecture2.29
  Help Modeling Complex Multi-Partnership Structures
• Lecture2.30
  DCF Valuation – European Perspective

Watch Me Build Videos 16

Collection of real estate financial modeling Watch Me Build videos

• Lecture3.1
  Introduction to this Watch Me Build Section
• Lecture3.2
  Watch Me Build 30/360, Actual/365, Actual/360 Amortization Tables
• Lecture3.3
  Watch Me Build a 3-Tier Real Estate Equity Waterfall Model
• Lecture3.4
  Watch Me Build a 4-Tier Equity Multiple Waterfall Model
• Lecture3.5
  Watch Me Build a Construction Draw Schedule
• Lecture3.6
  Watch Me Build a Dynamic Mortgage Amortization Table in Excel
• Lecture3.7
  Watch Me Build a Multifamily Real Estate Model
• Lecture3.8
  Watch Me Build a Residential Land Development Model
• Lecture3.9
  Watch Me Build a Tenant Rollover Analysis Model
• Lecture3.10
  Watch Me Solve a REPE Technical Interview Modeling Test
• Lecture3.11
  Watch Me Add Mezz Debt To a Hotel Development Model
• Lecture3.12
  Watch Me Expand a Single Family Home Construction Pro Forma to Analyze Multiple Homes
• Lecture3.13
  Watch Me Build Data Tables for Real Estate Sensitivity Analysis
• Lecture3.14
  Watch Me Build – Capital Stack with Mezzanine Debt
• Lecture3.15
  Watch Me Build – American-Style Real Estate Equity Waterfall Model
• Lecture3.16
  Watch Me Build – IRR and Equity Multiple Partitioning

Additional Tools 3

• Lecture4.1
  Download and Use the A.CRE Geocoding Excel Add-in
• Lecture4.2
  The Definitive Guide to Microsoft Excel – The Functions and Features That Matter
• Lecture4.3
  The Definitive Guide to Microsoft Excel – The Features That Matter