Video Tutorial:
This is a joint venture model that can be used in any business context where the deal involves the cash flow distributions being driven by the total distributions to the LP (limited partner) over time. Each hurdle is a dollar value, once the dollar value is eclipsed, the logic goes to the next cash flow split to derive the amount going to the GP and LP over time.
The model runs for up to 60 periods so you can use it for a 5-year monthly or if you just want to use it on annual periods, simply delete any unused columns and nothing will break. All charts update accordingly with no issue.
This does account for the fact that cross-over periods will involve some of the distributable cash flow split at one hurdle rate and some at another or many. For example, period 3 may have a big cash flow distribution that results in multiple hurdles being met all at once. This will split the cash properly for each hurdle and the total periodic split will be the amount for each hurdle level.
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
Small Business Playbook (Financial / Tracking Temp...
About the Template Bundle: https://youtu.be/FPj9x-Ahajs These templates were built with the ... 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
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
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
Private Equity Fund Model (Investor Cashflows)
Private Equity Financial Model to analyze fund cashflows and returns available to Limited Partners (... Read more
Private Equity Fund Financial Model & Economic...
Introducing our Comprehensive Excel Financial Model Template, a versatile and robust tool designed t... Read more
Startup Company Financial Model – 5 Year Fin...
Highly-sophisticated and user-friendly financial model for Startup Companies providing a 5-Year adva... Read more
You must log in to submit a review.