• A.CRE
    • A.CRE Home
    • A.CRE Accelerator
      • Learn More
      • Login
      • Manage Membership
    • Artificial Intelligence
    • Careers
    • Consulting and Advisory
    • CRE Event Calendar
    • CRE Job Board
    • Education
    • Library of Excel Models
    • University Profiles
    • Contributors
  • FAQs
  • Knowledge Base
  • Contact Us
  • A.CRE
    • A.CRE Home
    • A.CRE Accelerator
      • Learn More
      • Login
      • Manage Membership
    • Artificial Intelligence
    • Careers
    • Consulting and Advisory
    • CRE Event Calendar
    • CRE Job Board
    • Education
    • Library of Excel Models
    • University Profiles
    • Contributors
  • FAQs
  • Knowledge Base
  • Contact Us
home/Knowledge Base/I have a question about a model.../Waterfall Model with IRR and Equity and Multiple Hurdles/Waterfall Distribution % and Promote Calculation
Popular Search:How do I, What is, Why

Waterfall Distribution % and Promote Calculation

35 views 0 January 21, 2023

We regularly get a question about the difference between the Promote input and the Distribution % calculation (i.e. “Dist. % to GP” or “Dist. % to LP”) in several of the real estate equity waterfall models shared to A.CRE.

In our waterfall models, ‘Distribution %’ refers to the proportion of cash flow in a given waterfall tier distributed to a given partner. Promote refers to an incentive paid by the partnership to the GP/Sponsor when the investment has achieved certain profit thresholds (i.e. the Preferred Return). If the GP/Sponsor being paid the promote has contributed capital to the partnership, the promote will NOT equal the Distribution %. That is because the GP/Sponsor, as a member of the partnership, is paying a portion of the Promote.

To further explain this concept, below find an excerpt from our Accelerator real estate financial modeling training program, course 15, lesson 3 of the core curriculum:

——

Allow me to quickly teach you how to calculate the distribution percentages based on a given promote. 

  • Assume a structure where the promote is paid by the partnership.
  • Assume the GP owns 10% of the partnership, while the LP owns 90%.
  • Assume all distributions are made pro rata based on each partners ownership share.
  • Assume the GP is promoted 20% after the LP achieves a 12%.

Here is language that might represent this structure.

First, each distribution will be made to the partners in accordance with their partnership percentages until the Limited Partner has achieved the 12% promote hurdle; and second, the balance will be distributed (a) 80% to the partners in accordance with their partnership percentages, and (b) 20% to the General Partner as a promote.

So how do we calculate the distribution percentage to each partner above a 12% hurdle?

The formula to calculate Distribution % for the GP looks like this:

GP Distribution % = Promote % + (Pro Rata Share x 1 – Promote %)

The formula to calculate Distribution % for the LP looks like this:

LP Distribution % = 1 – GP Distribution %

 

 

Was this helpful?

Yes  No
Related Articles
  • Strikethrough Lines Appear in Certain Cells After Downloading and Using an A.CRE Model
  • Macros are disabled – I downloaded your model and the macros are disabled. How do I enable them?
  • I need help to modify (customize) the model
  • Is debt yield always calculated on the first loan amount (total loan amount) rather than the present value considering amortizing each year?
  • In an acquisition investment where the company is going to renovate all the units in the first 2 years (50% each year), how can we calculate the net cash flow yield on cost?
  • I own a property and am interested in creating a ground lease and have some questions.

No luck finding what you need? Contact Us

Waterfall Model with IRR and Equity and Multiple Hurdles

  • Waterfall Distribution % and Promote Calculation
  • I need help to modify (customize) the model
  • I only have one hurdle, how do I turn the other hurdles off?
  • Can I add more sponsors?

Popular Articles

  • Argus vs. Excel vs. Others – And Why the Focus on Excel?
  • Do you have any calculators for yield maintenance pre-payment penalty on multifamily loans?
  • I need help to modify (customize) the model
  • As a college student with no experience, do you recommend I take the ARGUS certification training and exam?
  • What happens when my Accelerator Membership Expires?

KB Categories

  • The Accelerator (Non-member
  • The Accelerator (Members
  • Website Troubleshooting
  • I have a question about a model…
    • A.CRE Geocoding Excel Add-In
    • All-In-One
    • 3-Tiered Acquisition Debt Module
    • Actual + Forecast Construction Draw Schedule
    • Advanced Amortization Model
    • Apartment Acquisition Model with Monte Carlo Simulation Module
    • Apartment Development Model
    • Back-of-the-Envelope Office, Retail, Industrial Acquisition Model
    • Basic Hotel Acquisition Model
    • Commercial Mortgage Loan Analysis Model
    • Condominium Development Model
    • Construction Draw and Interest Calculation Model
    • Ground Lease Valuation Model
    • Equity Waterfall Model with Monthly Periods
    • Excel Pro Forma for Flipping Houses
    • Hotel Acquisition 2.0
    • Hotel Development Model
    • Hotel Valuation Model
    • Industrial Real Estate Development Model
    • Loan Payment Schedule and Balance Tracking Tool
    • Mixed-Use Development Model: Condo and Retail
    • Multifamily Apartment Acquisition Model
    • Multifamily Redevelopment Model
    • Multifamily Value-Add Acquisitions
    • Real Estate Acquisition Due Diligence Checklist
    • Real Estate Acquisition Model – 2.0
    • Real Estate Capital Account Tracking Tool
    • Real Estate Portfolio Valuation Model
    • Residential Land Development Pro Forma
    • S-Curve Forecasting
    • Self Storage Development Model
    • Simple Acquisition Model for Office, Retail, and Industrial
    • Single Family Home Construction Pro Forma for Home Builders
    • Single Family Residential Investment Analysis Model
    • Single tenant NNN Lease Valuation Model
    • Value-Add Apartment Acquisition Model
    • 4-Tier Equity Multiple Waterfull
    • Waterfall Model for Real Estate Joint Ventures with Catch-Up
    • Waterfall Model with Cash-On-Cash Hurdle
    • Waterfall Model with Catch Up and Clawback
    • Waterfall Model with IRR and Equity and Multiple Hurdles
  • What model should I use for…?
  • Career Advice
  • Financial Modeling Questions

  What is the best investment analysis for determining whether to wholesale or fix/flip a sfr property? Is it IRR or NPV?

Strikethrough Lines Appear in Certain Cells After Downloading and Using an A.CRE Model  

Not finding an answer to your question?

Click here to contact us

About A.CRE

Adventures in CRE is the most popular real estate financial modeling, education, and careers website on the web. Use this section to get help with models, the site, or the Accelerator.

Help Sections
  • A.CRE Help
  • My Account
  • FAQs
  • Knowledge Base
  • Glossary
Knowledge Base

I have a question about a model…

What model should I use for…?

The Accelerator (Non-member)

The Accelerator (Members)

Career Advice

A.CRE

A.CRE Home

Join the Accelerator

Download a Model

CRE Careers

 

 

 

  • Privacy Policy
  • Terms of Use
  • © Adventures in CRE, LLC. All Rights Reserved.

Popular Search:How do I, What is, Why