The new Starter Model. Save $30 with code THANKYOU.  Click here
  +1.646.770.0052         hello@foresight.is
best seller Used by over 160 venture capitalists, accelerators, and angel investors worldwide to forecast a new fund or track the performance and forecasted returns of an existing portfolio.
  • 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.
  • 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, and a set of consolidated financial statements for the fund.
  • 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.
  • 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.
  • Instant download, use in Microsoft Excel™, Google Docs™, and other spreadsheet programs.
  • Everything can be modified to add in your own unique revenue calculations, as all formulas and cells are completely open and unlocked.
  • Purchase one-time, download instantly, customize however and whenever you want. Any updates to the model are emailed to you or can be re-downloaded anytime for free.
  • Venture Capital Funds (new funds, existing funds, early and late-stage)
  • Angel investors
  • Family offices
  • Accelerators
  • Incubators
  1. FAQ. Description of model, layout, and how to use it.
  2. Dashboard. Summarizes key economics for LPs and GPs and features a chart of distribution of exit multiples. Contains 10 key inputs to allow you to get a basic model done very quickly.
  3. Performance. Chart of contributions, distributions, Residual Value, Paid In Capital (PIC), Distributed to Paid in Capital (DPI), Residual Value to Paid in Capital over the fund’s lifetime.
  4. Assumptions. ~ 48 Detailed assumptions that shape the result of the model, organized, labeled and noted clearly. (More about assumptions structure here.) Assumptions include fund size, average check size (flexible for multiple investment strategies within a portfolio), carry, preferred return, capital call schedule, management fee schedule, startup organizational expenses, fund management expenses, and many more.
  5. 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.)
  6. 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.
  7. 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.
  8. Statements. Full consolidated fianncial statements for the fund, including statement of operating condition, income statement, and statement of cash flows.

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.

  • 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 108 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.

Use in Recommended Spreadsheet Programs

Integrate with Popular Financial Programs

“Foresight’s Venture Model was extremely helpful for us as we mapped out our capital allocation strategy for both existing and forecasted funds. The model is more robust than anything we could have built in-house in such a short time period. It provides all the information we want, from a portfolio dashboard to operating forecasts and financial statements for our funds & management company alike. Taylor’s published guidelines make it very easy to navigate the model, and in case that wasn’t enough, his customer support has been exceptional — he is prompt, thoughtful, and generously thoughtful with his responses to our questions. We look forward to continuing to use his products and services.”

Geri Kirilova, Laconia Capital

Geri Kirilova, Laconia Capital

Watch a Demo

Click below to watch me demo the model.

Packages

Model
  •  Model, downloadable immediately.
  •  One-time purchase, model updates are free.
  •  Free email customer support.
$350
Model
+
Get Started
  •  Model, downloadable immediately.
  •  One-time purchase, model updates are free.
  •  Free email customer support.
  •  1 Hour of assistance in completing the model, customization and review. Focus is on structuring and adjusting inputs for your business, and refining unit economics, cost budget, financial statements, and financing strategy.
  •  Additional customization may be necessary depending on your business; to be determined and billed separately.
$725
  •  Model, downloadable immediately.
  •  One-time purchase, model updates are free.
  •  Free email customer support.
  •  Model, downloadable immediately.
  •  One-time purchase, model updates are free.
  •  Free email customer support.
  •  1 Hour of assistance in completing the model, customization and review. Focus is on structuring and adjusting inputs for your business, and refining unit economics, cost budget, financial statements, and financing strategy.
  •  Additional customization may be necessary depending on your business; to be determined and billed separately.
$350
$725

All transactions are SSL secured and no payment details are stored. Refunds, returns and exchanges terms here.

Need a custom model?

Need help forecasting your business? Looking to fundraise but don’t know how much to raise or where to start with building a financial model? Need help taking your current fundraising deck or a financial model to the next level?

I work with startups and investment funds, assisting with financial models for fundraising, capital planning, and market development strategy. I have experience from both sides of the table as a venture capitalist and a part-time CFO, and I’ve worked with thousands of companies throughout my career.

How it Works

Screenshots

Learn Financial Modeling

In 5 free lessons I share what I’ve learned from helping more than 19,500 early-stage entrepreneurs from over 108 countries learn financial modeling.

How can I help?

Hi, this is Taylor. Is there anything I can do to help? I’m happy to explain more about the models or services and help determine what you need. Just call +1 646.770.0052 or email hello@foresight.is

Looking for a discount code?
Use THANKYOU at checkout for $30 off.