Venture Investor Model

Best for venture capitalists, angel investors, and accelerators looking to forecast a new fund or track the performance and forecasted returns of an existing portfolio. Instant download, use in Microsoft Excel™, Google Docs™, and other spreadsheet programs.

best seller Used by over 160 venture funds and angel investors worldwide, the Venture Investor Model is a spreadsheet template financial model to help individual and venture capital investors track and forecast their investments, portfolio, and returns for their investment strategy.
The model is flexible enough to use for any investment strategy (early- and/or late-stage) and any fund size. Market benchmark data is built into the model, and you can customize the model to fit your own expectations of your portfolio strategy. All formulas and cells are completely open and unlocked so you can customize however and whenever you want. Purchase one-time, and updates to the model are automatically distributed for free.

Who Should Use This

▾

Venture Capital Funds (new funds, existing funds, early and late-stage)
Angel investors
Family offices
Accelerators
Incubators

Why I Built This

▾

I built many versions of portfolio tracking and forecasting models as a venture capitalist and a consultant to multiple funds, and I wanted to share what I’ve built to provide a better structure for investors for tracking and forecasting.

Key Features

▾

Forecasts the potential future of a venture capital business
Used for portfolio tracking (if you have existing or known investments), for portfolio forecasting, or a combination of the two (to forecast future capital needs and returns for an existing portfolio combined with a forecasted set of future investments)
Creates full limited partner and general partner economics, a full set of key metrics around the fund’s performance
Includes charts of the distribution of exit multiples and a chart of contributions, distributions and residual value over the fund’s lifetime
The model uses a mix of assumptions to estimate all revenue and cost line-items on a half-year basis over a flexible twenty year period. For all inputs, you can easily set the start date and year for key decisions and the model adjusts automatically.
All formulas and sheets are open for editing, anything is open for editing. I don’t believe that models should be locked, everything should be open for you to edit so that you can model your business exactly as you want.

What’s Inside

▾

FAQ. Description of model, layout, and how to use it.
Dashboard. Summarizes key economics for LPs and GPs, chart of distribution of exit multiples, and graph of contributions, distributions, and residual value over the fund lifetime. Contains 10 key inputs to allow you to get a basic model done very quickly.
Assumptions. ~ 48 Detailed assumptions that shape the result of the model, organized, labeled and noted clearly. (More about assumptions structure here.)
Existing Investments. Optional, but allows user to track your investments - equity, convertibles notes and SAFEs - and automatically update your forecasted investments. For example, if you want to track your existing investments and forecast future investments, the model will automatically update your forecasts (remaining funds to invest and # of future deals, and returns) based on new investments you enter into the model. It’s simple to manually input the parameters of your deals and update it for new investments and new rounds. (More about how to track existing investments here.)
Portfolio. Core calculations to use the assumptions around fund size, check size, stage allocations, follow on participation, shape of distribution timeline, and more to create the core investment and portfolio performance results.
Operating Forecast. Core calculations of the model, forecasting the entire flow from capital calls to investments through the full waterfall from proceeds to hurdle calculations (optional) to carry. Also forecasts key metrics like residual value, paid in capital, etc., as well as the operating expenses from the fund.
Statements. Full consolidated fianncial statements for the fund, including statement of operating condition, income statement, and statement of cash flows.

Model Inputs

▾

Fund Size and Total Capital Invested
Average check size
Number of investments
Follow-on allocation (optional)
Investment Horizon
Gross Return Multiple Distribution
Management Fees (optional)
Carry (optional)
Hurdle Rate (optional)
Fees Recyling (optional)
Existing, already made investments and exits (optional)
Fund management and employee salaries, operating costs
And more, all open for editing by user.

Payment, Terms and Conditions

▾

Instant Download - one .xlsx Excel file. Immediately after purchase you will receive a download link and an invoice for your records.
Updates to the model are free, and the model can be re-downloaded at any time.
Credit/Debt Cards and PayPal accepted; all transactions are SSL secured and no payment details are stored by Foresight (see here to understand the details behind our transaction provider, their security and how they never store payment details).
All inputs and formulas are clearly labled; all formulas are open for editing and can be changed by user (i.e. no locked cells).
Works for any currency; Foresight models have been used by entrepreneurs from over 98 countries.
Use in Microsoft Excel™, Google Docs™, and other spreadsheet programs.
If applicable, VAT is extra.
Bulk license purchases available, details here.
Purchase signifies acceptance of terms and privacy policy.

Venture Investor Model

Packages

Need a custom model?

How it Works

Download Instantly

Input your most important assumptions

Refine your Projections

Understand your Forecasts

Need Help?

Screenshots

→