Venture Capital Model updates
March 23, 2025
Hello spring update to the Venture Capital Model (renamed from Venture Investor Model):
- Fixed a couple intermediate change issues in draft versions of the model post the last detailed update, all removed from the live version.
- Edited
Management Companysheet to reflect Quarters, not Years (the timescale should have said Quarters and should have been 80 periods). - Edited recycling calculations on
Forecastto eliminate possibility of calculating recycling larger than possible with proceeds in a given periods with certain recycling structure options (added a min() test to a few lines). - Edited % of Invested Capital per stage calcs on
Get Startedto correctly handle late-stage investments (previously did not account for the last two stages correctly). - Edited the scenario 2 and 3
Forecastsheets to bring them to parity with the changes to the LP waterfall. - Edited
Get Startedto provide more detail behind the average investment to make the difference between the number of investments and the invested capital clearer. - Brought back the option to use called capital as a base for management fees. This had been deprecated due to the complexity of calculating this without circulars, but was added back in using algebra method built into the
Forecastsheet. - Edited
Get Startedfor new method to forecast overall invested capital, and editedForecastto create the algebra to forecast the base for investments using assets under management and called capital. This was a heavy update, impacting management fees and deployment subcalcs. It will not always calculate a perfect called capital = committed capital under all scenarios, but is more reliable and still reflects the practical difficulties for funds budgeting for investments and fees with some of the recycling and fees options they may be using in their LPA. Someday I'll get the algebra perfect, until then we will live with a real life scenario.
As always, questions, ask anytime.