Start-Up Dynamic Template

This dynamic template is focussed on modelling a Start-Up business through a sequence of equity raisings.

Different rounds of funding allow the user to assess the impact cap raises have on the overall shape of the business, as well as the other cohorts of shareholder.

The specific modules developed for this model are:

• Ordinary Equity (Start-Up).  This module contains category-based equity analysis that allow the user to investigate the impact of separate capital raises, issue prices, etc. The module also has its own dashboard that shows the impact of raises on each shareholder's value.
• Multiples Valuation.  This is a simple module, with precedent links in from total revenue, EBIT, NPAT, etc.  Multiples are entered as assumptions and a valuation profile is calculated as the output.  NB: this is all periods analysis rather than forecast-only.
• Cash Runway.  Single dashboard module.  Brings in the main cash flows and works out alternative cash balance projections based on no funding, no revenue, no nothing, etc. Also shows number of days to cash death.

This model is designed for broader strategic purposes, such as investigating 3-to-7 year funding, growth and value realisation profiles.

The attached is not for budgeting purposes. To the extent people are looking to model the detailed cash flows of a start-up, I recommend using the wider Modano monthly content. In Australia, this would need to include detailed GST, comprehensive working capital analysis, and so on.

If you have any comments or questions then feel free to add them below.

Cheers. J.