Overview

The Venture Capital Returns Model is used to provide an
analysis into 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 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.
 

Reviews Add a review
No reviews yet

More From D'Errico Financial Services LLC

Browse our top rated business templates. See All
Multi-Family Housing Rental Renovation Model
2,825
0
The Multi-Family Housing Rental Renovation model projects monthly future cash flows from the renovation and rental of a multi-family housing…
Real Estate Development Model
3,141
0
 The Real Estate Development model projects monthly future cash flows from a development property from the purchase of the land…
Consumer Loan Model
3,012
0
The Consumer Loan model breaks down the financing structure of a bundle of consumer loans absorbed by a lender. This…
DCF Valuation Financial Model
3,397
2
The DCF Valuation Model builds on the 3 Statement model by adding a business valuation component for investment through the…
Private Equity Financial Model
3,148
3
The Private Equity Acquisition Model provides a business valuation of a target company for investment. The Private Equity Acquisition Model…
Mergers & Acquisitions (M&A) Financial Model
3,730
3
The Mergers & Acquisition (M&A) Model provides a projection for a company looking to potential merger or acquire another company.…
See All