Model for forecasting a fund invested in venture funds, to help understand overall fund assumptions and how portfolio construction impacts returns. Creates an annual forecast of the cash flows and return multiples, IRR, and standard fund performance metrics.
The fund of funds model was built to help general partners starting a fund to invest as limited partners into venture capital funds, to model the performance of the funds and the performance of the fund of funds. Uses the same structure as the Venture Capital Model, Annual Forecast to forecast the underlying invested funds, consolidating the performance of the funds, and then layers on the capital structure and expenses of the fund of funds to calculate standard fund performance metrics.
More on how to model venture funds at How to Model a Venture Capital Fund
Show all 8 screenshots >
Live masterclass for founders, investors, and lawyers to learn the structures and math for building cap tables and exit waterfalls.
Join the masterclass for 4 live, 1.5 hour sessions to learn the terms, math, and important insights about how equity, convertible notes, SAFEs, and option pools impact cap tables, dilution, and ownership.
Taylor Davidson, Founder, Foresight
I created the financial models behind Foresight so early-stage entrepreneurs can spend less time on finance and more time on their products. I care about financial modeling because I believe that financial models can help us make critical business decisions even if the models themselves are not “always right”. Financial models can help even the earliest entrepreneurs if we build “minimum viable models” to focus on the decisions that matter most.
You will have the option to download a Microsoft Excel .xlsx file and copy a Google Sheet file immediately after purchase or submission or your email, and anytime through the link in your email receipt, as well as by logging into my transaction provider at Gumroad and creating an account.
Foresight's spreadsheet models can be used in both Excel and Google Sheets interchangeably; simply upload the Microsoft Excel model template from Foresight into Google Sheets, or download the Google Sheets to Excel, and everything will structurally work fine.
The models are originally built in Google Sheets, and the formatting is a bit better in Google Sheets; in Excel you may want to adjust the row spacing, fonts, and chart formatting to get the aesthetics you want.
We accept credit cards, debit cards, and PayPal. The transmission of your billing information is encrypted using secure socket layer technology (SSL/TLS) and will be processed by Gumroad. Foresight does not have access to your payment details (why it's safe).
You'll get a payment receipt by email immediately after purchase. Note, you will see Gumroad, not Foresight, on your payment card or PayPal statement.
Get help buying. Call (or text, WhatsApp, et.al.) 1-646-770-0052.