• A.CRE
    • A.CRE Help Home
    • A.CRE Home
    • Accelerator
      • Learn More
      • Login
    • Careers
    • CRE Event Calendar
    • CRE Job Board
    • Education
    • Library of Excel Models
    • Contributors
  • FAQs
  • Knowledge Base
  • Contact Us
  • A.CRE
    • A.CRE Help Home
    • A.CRE Home
    • Accelerator
      • Learn More
      • Login
    • Careers
    • CRE Event Calendar
    • CRE Job Board
    • Education
    • Library of Excel Models
    • Contributors
  • FAQs
  • Knowledge Base
  • Contact Us
home/Knowledge Base/I have a question about a model.../Equity Waterfall Model with Monthly Periods
Popular Search:How do I, What is, Why

What do I put in for the distribution if I have a 70/30 GP split?

4 views August 6, 2020 lizzieadventuresincre-com 0

If you intend to distribute 30% to the GP in a given hurdle, be sure that the ‘Distribution %’ for the GP is set to 30%.
Contributions are assumed to be made pari passu (at the same time). So if capital is going out investor-first, you would need to customize the model.
To be upfront, my suggestion would be to request a refund for the model and do this analysis custom. This model isn’t really meant for the type of structure you’re describing. Spencer’s cash-on-cash waterfall model is probably the closest, although that model also assumes pari passu equity contributions and uses annual periods. So you’d have to customize that model as well.
The challenge with waterfall model templates is that every partnership structure is different. We have numerous waterfall models, but even so those only cover a certain range of common partnership structures. Waterfall modeling is a custom exercise in many cases – either building something from scratch or modifying existing models to cover a given structure.

Was this helpful?

Yes  No
Related Articles
  • I need help to modify (customize) the model
  • Is there a way to add a scenario where we assume a refinance event in year 5 of the 10 year analysis?
  • Where do you put in the amount?
  • I downloaded the residential land development and monthly waterfall model, but the latter is included in the prior?
  • My proposal is a JV with property owner and developer. The value of the parcel is the owner’s equity contribution. Since there isn’t a cash outlay for acquisition during the investment period, should I include the value of the land in the calculator of the unlevered/IRR?
  • Where am I supposed to model the property-level cash flow in this model?
Leave A Comment Cancel reply

You must be logged in to post a comment.

Equity Waterfall Model with Monthly Periods

  • What do I put in for the distribution if I have a 70/30 GP split?
  • I need help to modify (customize) the model
  • Is there a way to add a scenario where we assume a refinance event in year 5 of the 10 year analysis?
  • Where do you put in the amount?
  • I downloaded the residential land development and monthly waterfall model, but the latter is included in the prior?
  • My proposal is a JV with property owner and developer. The value of the parcel is the owner’s equity contribution. Since there isn’t a cash outlay for acquisition during the investment period, should I include the value of the land in the calculator of the unlevered/IRR?
View All 7  

Popular Articles

  • I need help to modify (customize) the model
  • What happens when my Accelerator Membership Expires?
  • Argus vs. Excel vs. Others – And Why the Focus on Excel?
  • How to get the AIO model to refinance during the hold term
  • As a college student with no experience, do you recommend I take the ARGUS certification training and exam?

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
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
  • © 2020 Adventures in CRE, LLC. All Rights Reserved.