The Venture Capital Returns Model is used to provide an analysis of an investment return for a VC fund. This model includes a distribution waterfall and IRRS and NPVs for all partners in the fund and the fund in total.
The model starts with an Assumptions Section where you can enter in the amount raised, expected return, and net cash flows distributed.
The two cells highlighted in gray are tied to the Sensitivity Analysis at the bottom.
The Venture Capital Waterfall breaks down the Equity Contribution and the distributions to the LP and GP investors.
The allocation percentages for equity invested and cash flow distributed can be adjusted in the GP/LP Structure box.
Accrued Return is based on the IRR for each tier. After that, the model contains the Net Present Value (NPV) and Internal Rate of Return (IRR) for each investor and the fund in total.
Lastly, there is a sensitivity analysis for LP IRR based on Cash Invested and YoY Return from the Assumptions Section.
All cells in blue font are input cells where custom information can be entered. All cells in black font are formulas set to streamline the model.
Similar Products
Other customers were also interested in...
Private Equity Fund Model (Investor Cashflows)
Private Equity Financial Model to analyze fund cashflows and returns available to Limited Partners (... Read more
Leveraged Buyout (LBO) Financial Projection Model
User-friendly financial model to project and analyse the financial outcomes (IRR, projected financia... Read more
Investment Holding Company 3 Statement Financial P...
3 statement 5 or 8 year rolling financial projection Excel model for an investment holding company h... Read more
Amortization Schedules Template (Loans, Mortgages,...
User friendly template including Amortization Schedules for Loans, Mortgages, Operating and Finance ... Read more
Mergers and Acquisition (M&A) Financial Projec...
User-friendly financial model to project and analyze the financial outcomes and feasibility of an Me... Read more
Private Equity Acquisition Model
The Private Equity Acquisition Model provides a business valuation of a target company for investmen... Read more
Leveraged Buyout (LBO) Model Template
The Leveraged Buyout (LBO) Model provides a business valuation of a target company for investment. T... Read more
Mergers & Acquisitions (M&A) Model
The Mergers & Acquisition (M&A) Model provides a projection for a company looking to potentially... Read more
Basic Founder’s Package – Business Valuati...
To help you get a discount out of buying multiple financial model templates for business valuation, ... Read more
Basic Founder’s Package – Financial Foreca...
This is a bundle of financial model templates best suited for financial forecasting and for startups... Read more
Reviews
Good entry level model to work from. Provides enough basis to evolve and build off to adapt the model to your needs.
10 of 23 people found this review helpful.
Help other customers find the most helpful reviews
Did you find this review helpful?
Wow! It took me all day just to find this great template here!
24 of 52 people found this review helpful.
Help other customers find the most helpful reviews
Did you find this review helpful?
You must log in to submit a review.