excel data table input

Data tables and valuations

You can use a data table as a handy tool for doing a sensitivity analysis on your enterprise value calculation. First, you'll need to do a 5 year forecast of revenues, expenses, as well as your balance sheet. You will need these to calculate your expected free cash flows, which are then used to calculate … Continue reading Data tables and valuations

Linking valuations to the cap table

Let's say you want to do a Series A capital raise of $5 million , and you've done some 5 year financial projections which you've used to value your company at $20 million. How is that going to affect your capitalization table? First of all, it's important to understand that the $20 million valuation is … Continue reading Linking valuations to the cap table