• A.CRE
    • Accelerator Home
    • A.CRE Home
    • CRE Event Calendar
    • CRE Job Board
    • Education
    • Library of Excel Models
  • TRY ACCELERATOR 2.0
  • COURSES
  • LEARN MORE
  • ENROLL
  • LOGIN
    • Accelerator Member
    • Enterprise Member
A.CRE AcceleratorA.CRE Accelerator
  • A.CRE
    • Accelerator Home
    • A.CRE Home
    • CRE Event Calendar
    • CRE Job Board
    • Education
    • Library of Excel Models
  • TRY ACCELERATOR 2.0
  • COURSES
  • LEARN MORE
  • ENROLL
  • LOGIN
    • Accelerator Member
    • Enterprise Member
CoursesAcceleratorAdvanced Concepts in Real Estate Financial Modeling
  • Advanced Concepts - Property and Portfolio-Level 21

    Advanced tutorials (not required for Accelerator completion) related to property-level and portfolio-level cash flow modeling

    • Lecture1.1
      Introduction to Advanced Concepts
    • Lecture1.2
      Modeling Floating (Variable) Rate Debt
    • Lecture1.3
      Real Estate Sensitivity Analysis Using a Data Table in Excel
    • Lecture1.4
      A Framework for Modeling Mixed-Use Investments
    • Lecture1.5
      Modeling Multiple Tranches of Capital Sources Dynamically
    • Lecture1.6
      Modeling a Construction Loan Takeout
    • Lecture1.7
      Add a Recalculate Button to Your Development Model to Avoid Circular References
    • Lecture1.8
      Considerations in Portfolio-Level Modeling
    • Lecture1.9
      Creating In-Cell Buttons, Toggles, and Navigation Buttons
    • Lecture1.10
      Ground Leases, Valuation, and Impact on Cash Flow
    • Lecture1.11
      Modeling Variability in Income and Expense Line Items
    • Lecture1.12
      Development Cash Flow: Creating a Steady Decrease Formula (Inverse to the Steady Growth Formula)
    • Lecture1.13
      Altering The Development Model For Pari Passu Coverage of Development Costs Between Debt and Equity
    • Lecture1.14
      Dynamically Forecasting Development Cash Flows
    • Lecture1.15
      Advanced Lender Risk Metrics – Duration and Average Life
    • Lecture1.16
      Using Stochastic (Probabilistic) Analysis and Monte Carlo Simulations
    • Lecture1.17
      Mortgage Prepayment Fees, Including Yield Maintenance and Defeasance
    • Lecture1.18
      After-Tax Analysis in Real Estate (Coming Soon)
    • Lecture1.19
      Tax Credit Modeling (Coming Soon)
    • Lecture1.20
      Advanced Formatting Techniques for More User-Friendly Real Estate Models (Coming Soon)
    • Lecture1.21
      Using VBA to Create Buttons to Add or Delete Rows and Columns (Coming Soon)
  • Advanced Concepts - Partnership-Level 6

    Advanced tutorials related to partnership-level (i.e. waterfall) cash flow modeling

    • Lecture2.1
      Two Techniques for Modeling a GP Catch Up Provision
    • Lecture2.2
      One Technique for Modeling an LP Clawback Provisions
    • Lecture2.3
      Modeling Partnership Crystallization / Ownership Reset
    • Lecture2.4
      Modeling Annual Partnership Distributions with Monthly Property-Level Cash Flows
    • Lecture2.5
      Break Out Promote, Preferred Return, Excess Cash Flow, and Return of Capital Plus Separate Returns Before and After Fees
    • Lecture2.6
      Modeling Unique Contributions of Equity
    This content is protected. Join A.CRE Accelerator to take this course. Already a member? Login now.
    Prev Altering The Development Model For Pari Passu Coverage of Development Costs Between Debt and Equity
    Next Advanced Lender Risk Metrics – Duration and Average Life

    Search Accelerator

    Navigate Accelerator

    • A.CRE
      • Accelerator Home
      • A.CRE Home
      • CRE Event Calendar
      • CRE Job Board
      • Education
      • Library of Excel Models
    • TRY ACCELERATOR 2.0
    • COURSES
    • LEARN MORE
    • ENROLL
    • LOGIN
      • Accelerator Member
      • Enterprise Member
    Accelerator - Learn More
    logo-eduma-the-best-lms-wordpress-theme

    [email protected]

    Company

    • About A.CRE
    • Library of Excel Models
    • CRE Careers
    • CRE Education

    Accelerator

    • Login
    • Changelog
    • Courses
    • Enroll

    Support

    • Accelerator Guide
    • Forums
    • Contact Us
    • FAQ

    Other Resources

    • Glossary of CRE Terms
    • Graduate Education
    • CRE Interviews
    • Deep Dive Series

    Presented by Adventures in CRE - Copyright 2021

    • Privacy
    • Terms
    • Disclaimer

    In Jan 2022, we launched our new Accelerator 2.0 platform. This legacy platform will be phased out by Q4 2022. Click here to learn how to transition to the new Accelerator 2.0. Dismiss