0 ITEMS
Joint Venture and Fund Cash Flow Waterfall Templates – Bundle
Here are all the spreadsheets I’ve built that involve cash flow distributions between GP/LP. Includes preferred equity, preferred returns, IRR hurdles, and multi-member fund trackers.
Thanks for taking the time to check out these joint venture cash flow distribution tools. All the hard stuff is built here. If you have ever tried to model IRR hurdles, preferred equity, or tracked preferred returns of a multi-member fund, you know it is not easy. All of these templates provide a solid foundation for teaching and actually being used for joint venture deal structuring / negotiating with investors (LP) and sponsors (GP).
I also included a few general real estate models in this bundle (with their own cash flow waterfalls connected). You will see monthly IRR hurdles and annual ones throughout.
The following templates are included in the purchase (note, this is a one-time purchase, and any new templates that get added to this bundle will automatically be included in the future, simply email / contact me for a refresh whenever you want)
- Investment Fund Preferred Return Tracker: Up to 30 Members – Track preferred returns for investors in a fund with this template. Premium joint venture tracking tool.
- Preferred Equity Cash Distribution Model: 2 Hurdles – A 10-year joint venture model to plan various scenarios for how cash is shared between a GP and LP. Includes IRR and DCF analysis for each party.
- Joint Venture: Preferred Equity Model – A straightforward cash distribution testing model for joint ventures. Logic is built for preferred equity and common equity to exist.
- Preferred Return Template: Options for Shortfall Recovery & Compounding/Simple – this is a general template that can be used for any sort of joint venture that involves the limited partner (in most cases) having a preferred return over the sponsor (general partner).
- Cumulative LP Distribution Joint Venture Waterfall Model – A 6-Tier cash flow waterfall template. Plug in the distributable cash flow (+/-) and set the hurdle splits and hurdle amounts, then let the logic work.
- Waterfall Model for Joint Venture Real Estate Project – (versions 1 – 3) Dynamic financial model for calculating cash splits to sponsors/investors based on various IRR hurdles getting reached.
- 10-Year Multi-family Real Estate Model: Options for Joint Venture and Refi – An easy-to-use real estate model with particular assumptions that come along with multi-family real estate acquisitions. Model up to four properties at once.
- Multi-member Investment Fund Portfolio and Distribution Tracker – A fund management tool to track many positions over time as well as distributions to up to 20 members.
- Self-storage Real Estate Ramping Model: Up to 15 Years – This is an equity-only (joint venture capable) financial model for building / acquiring self-storage property for some time and then re-selling it to grow into bigger deals over time.
- Preferred return cash flow distribution template (simple interest / non-compounded) – It is a cash flow waterfall to determine distributions between two parties based on the LP (limited partner) achieving simple interest non-compounded returns.
- Cash Flow Waterfall w/ GP/Sponsor Catch-up Provision – Offers logic to demonstrate the option to catch up the GP on their IRR after the LP earns their first hurdle rate.
The total value of this product bundle is USD 820, priced at USD 199 package price (at more than 80% Price Discount!).
Each file has an instructional video included in it.
P.S. one of the coolest builds here is the self-storage multi-fund (model rolling through 6 JV funds based on assumptions about 6 different deals / hurdle rates / structures to see how a given equity investment can grow over time)
Similar Products
Other customers were also interested in...
Quantity Surveyor / Architect – Project Fina...
This Project Feasibility Model is purpose-built to assist Quantity Surveyors, Architects, Developers... Read more
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
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
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
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
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.