All Industries, Financial Model, General Excel Financial Models |
Cap Table, Fundraising, IRR (Internal Rate of Return), Private Equity, Venture Capital |
The model allows to easily calculate the cap table of a business post-investment (for 5 shareholders in the current state of the mode) and for multiple rounds. (for 3 rounds in the current state of the model). The model also includes a section to calculate IRR and return on investment multiple for each of the shareholders based on an equity value at exit, assuming no dividends were paid over the investment period.
At first, the user needs to input the pre-money equity value of the company and to indicate the current ownership structure
Then for each round the user will input Pre-money equity value along with the investment amount of each shareholder that will go toward capital raising and the details for each shareholder of the value of shares bought from another shareholder / sold to another shareholder. The post-investment cap table will then be computed automatically.
In the second section, assuming in the current state of the model that Firm value at exit is calculated on an EBITDA multiple, the user needs to input EBITDA at exit, EBITDA multiple at exit, Debt at exit and Cash at exit. Please note that the user can easily just plug in an equity value at exit in the Equity Value at exit cell if he wants to.
Finally the user will need to input the date of each round to allow the model to calculate a IRR and an investment multiple for each of the shareholders. Please note that due to how the IRR function works in Excel, the user will need to manually adjust the IRR function for each shareholder so that the formula starts with the first round in which the shareholder has made an investment.
This could be automated using notably the OFFSET function but this would greatly complexify the formulas and in my opinion the the trade off between simplicity and automation would not be worth it.
Similar Products
Other customers were also interested in...
Due Diligence P&L – Exhaustive Revenue a...
Model for in depth understanding of high level profit and loss and revenue analysis. Big-4 like chec... Read more
Multiple rounds Cap Table including Safe, pro-rata...
Multiple rounds cap table including SAFE conversion, Management option pool and investment performan... Read more
Price Volume Mix Charts and Analysis – On re...
Best practice model for a complete Price Volume Mix (PVM) analysis on revenue and on gross profit by... Read more
Private Equity Fund Model (Investor Cashflows)
Private Equity Financial Model to analyze fund cashflows and returns available to Limited Partners (... Read more
All My Financial Models, Spreadsheets, Templates, ...
Lifetime access to all future templates as well! Here is a set of spreadsheets that have some of the... Read more
Cap Tables & Investor Returns Model
User-friendly Cap Table Model for a startup company or early-stage venture including multiple rounds... Read more
Advanced Financial Model with DCF & Valuation
New Version Updates:• Model is now dynamic. Users can select the desired forecast length for up to... Read more
Investment Financial Models – All-in-One Bundle ...
A collection of templates suitable for investment decisions in various types of businesses/industrie... Read more
Franchisor Licensing: Financial Model with Cap Tab...
Build up to a 10 year financial forecast with assumptions directly related to the startup and operat... Read more
Preferred Equity Cash Distribution Model – 2...
A 10-year joint venture model to plan out various scenarios for the way cash is shared between a GP ... Read more
You must log in to submit a review.