Joint Venture

These templates contain logic that involves defining how profit is distributed between multiple parties. The spreadsheets are constructed as a sponsor (GP or General Partner) and investor (LP or Limited Partner). 

$199.00 USD - Joint Venture Spreadsheets bundle
(lifetime access to all joint venture templates I ever build)

The cash flow distribution spreadsheets / templates will be immediately available for download after purchase.

  • Preferred Return Fund Tracker ($125) This tracker is natively ready for 30 members with varying start/end dates as well as configurable preferred returns, cash distribution rates per hurdle, and varying investment amounts. The fund goes for 20 years and investors can be tracked for up to 15 years. There is a really nice fund level cash flow planner to make it easy to manage cash deployment, profits, and distributions.
  • General Cash Flow Waterfall: 3 IRR Hurdles ($45) (up to 10 periods) This is the staple of joint venture modeling. Structure as a hard preferred interest, soft preferred, and all the logic is laid out plainly per hurdle and in aggregate.
  • Cumulative Distribution Hurdles ($75) (up to 60 periods) This model has 6 tiers that define how the cash is split as the LP reaches greater total distributions.
  • Preferred Equity ($45) (Up to 10 year annual and this is designed to drop in the cash contributions/distributions and the logic goes from there). This does include a waterfall distribution with IRR hurdles for the common equity pool if needed.
  • Preferred Equity (type 2) ($125) (Up to 10 year annual) This has two main hurdles. The first is that 100% of distributions go to the preferred equity leg until the initial investment is paid back in full. Then, a defined % goes to the preferred equity until a defined equity return multiple has been reached. After that, cash is split at a final rate for anything beyond the return multiple. 
  • Preferred Return ($45) (Up to 10 year annual) This is different than the preferred equity in that the initial investment is not paid back in full before cash is split. Instead, the distributions are based on a rate against the investment only and then a defined profit share of remaining cash after the preferred return has been met. Options for rolling the unpaid pref. return are available.
  • Monthly Waterfall ($75) (multiple versions, including a 5 scenario analysis and splits between the sponsor leg)
  • Multifamily Real Estate Acquisition ($45) (multi-family or unit-based model) This has logic that would be useful for multi-family real estate acquisitions and it goes for up to 10 years. There is a waterfall distribution model with IRR hurdles as well as logic to account for a Refi and interest only period if applicable). Recently updated to model up to 4 properties on the same workbook.
  • Multi-Member Fund Management ($75) (up to 20 years) This is a tool to track long-only funds for stocks or crypto that have up to 20 members (expandable with some work). Includes client reports, IRR, and a preferred return waterfall as well as option for fund management fees. Everything displayed on monthly and annual basis. Accommodate up to 50 unique assets.
  • Self Storage: Multi-fund ($45) (a model to allow sponsors or investors to plan out up to 6 self storage acquisitions / developments and run / exit them over time. Purpose is to show how equity (through joint ventures) can be ramped up by exiting deals and taking those proceeds to bigger deals over time.
  • Mixed-Use Real Estate ($75) Plan up to 7 unique 'use' types each with their own acquisition / development / operating / exit assumptions but all rolled into the same model timeline. Very comprehensive leverage assumptions if required as well as option for joint venture waterfall.
Most sheets are in the context of real estate acquisition, but the preferred return and preferred equity templates could be used to define cash distribution splits for any kind of joint venture deal.

All of these templates and spreadsheets let the user drop in contributions/distributions manually except for the real estate acquisition model, which has bottom up assumptions for driving revenues/expenses/debt/and the resulting cash flow.

Similar template - (includes preferred return/preferred equity/irr hurdle): Ultra scaling model (up to 40 acquisitions for MHP and/or multi-family real estate properties on the same timeline with unique assumptions / debt/refi): MHP model

You can buy all financial model templates and tools from smarthelping.com in one large bundle here: https://www.smarthelping.com/p/excel.html (see 'buy in bulk' dropdown at the top of the page there)