• 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

Advanced Concepts in Real Estate Financial Modeling

A.CRE Accelerator
The A.CRE Team
Accelerator
Enroll Now
advanced concepts
  • Overview
  • Curriculum
  • Instructor

COURSE DESCRIPTION

Advanced Concepts in Real Estate Financial Modeling is a supplemental bonus course offered as part of the Accelerator curriculum. This course is not required to earn an Accelerator Certificate of Completion, but instead is meant to teach concepts not directly addressed in the standard Accelerator curriculum but that you will likely use at some point in your career.

In this course you will:

  1. Learn to model floating (i.e. variable) rate debt
  2. Perform sophisticated real estate sensitivity and scenario analysis using Excel’s data table feature
  3. Model multiple tranches of capital sources, dynamic to order in which sources are deployed
  4. Learn a technique for modeling GP catch up provisions in equity waterfall modeling
  5. Learn a technique for modeling LP clawback provisions in equity waterfall modeling
  6. How to model quarterly and annual partnership distributions with monthly property-level cash flows
  7. Discover a variety of advanced formatting techniques for more user-friendly and intuitive real estate models
  8. Explore considerations in portfolio-level modeling
  9. Learn one method for modeling partnership crystallization (i.e. ownership reset) in equity waterfall modeling
  10. Model basic after-tax analysis, including the option to defer capital gains
  11. Use Probabilistic Modeling and Monte Carlo Simulations in real estate analysis
  12. And much more

Additional tutorials are regularly added to this course based on your recommendations. So if there is a real estate financial modeling topic not covered in the standard Accelerator curriculum, and you’d like to see Spencer or Michael teach it, let us know in this course’s forum.

CASE STUDY – NA

Unlike standard Accelerator courses, this course does not have any specific case study. Nor are there quizzes or completion requirements. This course is a series of video (i.e. Watch Me Build) tutorials. Each tutorial includes a template Excel file for you to use to follow along, and a completed Excel file to see the answers.

PROPERTY TYPE

  • All property types

SOFTWARE RECOMMENDED/REQUIRED

  • While we recommend using Microsoft Excel, as that is the industry standard, this course will work with most other spreadsheet software such as Google Sheets and OpenOffice Calc
  • This course was built using the Google Chrome browser, thus we recommend you use Google Chrome for optimal view experience
  • This course is best taken on a desktop computer, although the platform is compatible with tablet and mobile devices

EXCEL PROFICIENCY REQUIREMENT

  • The course assumes you’ve spent significant time in the Accelerator and have at least an intermediate proficiency in Excel

Course Features

  • Lectures 27
  • Quizzes 0
  • Skill level Advanced
  • Language English
  • Students 3149
  • Certificate No
  • Assessments Yes
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
A.CRE Accelerator
The A.CRE Team
Spencer and Michael started Adventures in CRE in their first year of graduate school. Since that time, the two have written over 350 in-depth articles on real estate financial modeling, careers, and education options; built and shared over 60 institutional-quality real estate financials models; developed an extensive glossary of real estate terms, recorded over 100 tutorial videos, and created the most comprehensive real estate financial modeling training program available.
Michael Belasco
Michael Belasco
Michael Belasco has ten years of real estate and construction experience. Throughout his career, he has managed, underwritten, consulted, and worked on more than $7 BN worth of commercial real estate opportunities across the United States and has recently concluded a three-year stint in San Francisco managing large-scale real estate projects for one of the largest and most respected development firms in the world.
Spencer Burton
Spencer Burton
Born and raised in the Northwest United States, Spencer Burton has nearly 20 years of residential and commercial real estate experience. Over his career, Spencer has helped close $4.5 billion and underwrite $30 billion of commercial real estate at some of the largest institutional real estate firms in the world. He is currently the Head of Real Estate Investments and member of the founding team at Stablewood Properties. Spencer Burton holds a Bachelor of Arts in International Affairs with an emphasis in economics from Florida State University and a Masters in Real Estate with a concentration in finance from Cornell University.
  • Overview
  • Curriculum
  • Instructor
Enroll Now
  • Share:

You May Like

i. Guide to Getting Started with A.CRE Accelerator Learn More
A.CRE Accelerator
The A.CRE Team

i. Guide to Getting Started with A.CRE Accelerator

3191
1. The Direct Cap Method to Valuing Real Estate Learn More
Spencer Burton
Spencer Burton

1. The Direct Cap Method to Valuing Real Estate

3175
2. The DCF Method to Valuing Real Estate Learn More
Michael Belasco
Michael Belasco

2. The DCF Method to Valuing Real Estate

3170
3. Anatomy of the Real Estate DCF Learn More
Spencer Burton
Spencer Burton

3. Anatomy of the Real Estate DCF

3184
3a. Calculating Key Risk and Return Metrics Learn More
Spencer Burton
Spencer Burton

3a. Calculating Key Risk and Return Metrics

3170

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