Video Overview:
This template uses IRR hurdles to determine how the cash is split between the LP and GP or between two parties in a joint venture. It becomes relevant if the GP is contributing some percentage of the investment requirement and is not receiving a pari passu return on the first IRR hurdle. In those cases, their IRR will be less than the LP after the first hurdle is hit. You can define the catch-up rate to be whatever you desire, and it will attribute cash to the GP until that is reached before moving on to the next hurdles.
During the catch-up period, the GP will receive 100% of the cash flows. After that, the cash is split per the remaining hurdle rates accordingly.
A final annual summary, visualizations, and a DCF Analysis for each party is displayed.
Similar Products
Other customers were also interested in...
All My Financial Models, Spreadsheets, Templates, ...
Lifetime access to all future templates as well! Here is a set of spreadsheets that have some of the... Read more
Joint Venture and Fund Cash Flow Waterfall Templat...
Here are all the spreadsheets I've built that involve cash flow distributions between GP/LP. Include... Read more
Preferred Equity Cash Distribution Model – 2...
A 10-year joint venture model to plan out various scenarios for the way cash is shared between a GP ... Read more
Franchisor Licensing: Financial Model with Cap Tab...
Build up to a 10 year financial forecast with assumptions directly related to the startup and operat... Read more
Small Business Playbook (Financial / Tracking Temp...
About the Template Bundle: https://youtu.be/FPj9x-Ahajs These templates were built with the ... Read more
Investment Fund Preferred Return Tracker: Up to 30...
Track preferred returns for investors in a fund with this template. Premium joint venture tracking t... Read more
Top 16 Google Sheet Templates
This is a bundle of all the most useful and efficient google sheet templates I have built over the y... Read more
Cumulative LP Distribution Joint Venture Waterfall...
A 6 Tier cash flow waterfall template. Plug in the distributable cash flow (+/-) and set the hurdle ... Read more
Cost Segregation Study: Estimated Benefit Summary ...
This calculator has inputs for many different asset categories and their resulting recovery periods.... Read more
Inventory Valuation Using FIFO – Automatical...
Any accountant that needs to comply with IFRS will have to use the FIFO valuation method for calcula... Read more
You must log in to submit a review.