• 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.
    Next Modeling Floating (Variable) Rate Debt

    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

    Important: Access to take courses on this legacy platform will end October 1, 2022. Click here to learn how to transition to the new Accelerator 2.0. Dismiss