![]() ![]() ![]() Spreadsheets - primarily Microsoft Excel and Google Sheets - are the most common tools used to build financial models for venture capital funds, because of the accessibility and familiarity that most emerging managers have with the tools. I focus on creating models that help managers understand their strategies, using their expectations of their investment thesis to understand if their strategies “work” based on their assumptions. Extreme outcomes from a small number of investments usually drive overall portfolio returns, and the resulting power laws make it difficult to create deterministic forecasts of when and how these extreme outcomes will happen. The best models for venture funds are built with the intent of reflecting their investment strategies. Contact me if you have questions on modeling alternative venture structures. For this post, we will focus on closed-ended venture funds making investments into equity or equity-like structures (convertible notes, SAFEs, SAFTs, and other token structures). Open-ended venture funds, evergreen funds, venture debt, revenue-sharing venture funds, and fund of funds share many similarities regarding capital budgeting and deployment, but often differ in the timing and nature of proceeds and recycling. Similarly, hedge funds have different structures and expectations around investment and limited partner liquidity, making them substantially different from venture funds. Private equity funds and real estate investment funds often have fund structures and expectations in how and when proceeds are received that differ substantially from venture capital funds. Modeling a venture fund can vary from modeling other types of private equity investments. For background on that topic, I’ve written a post for AngelList, How to Make a Budget for a Rolling Fund that provides advice that’s comparable for modeling management companies managing any type of fund. This post will focus on creating a model for a fund, not for the management company. to create a forecast of cash flows and financials. Modeling the management company is similar to modeling any operating company, and typically consists of modeling revenues - primarily management fees from the fund(s) - and expenses - salaries, overhead, legal, accounting, travel, etc.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |