Sheets in the basic marketplace financial model
Financial model sheets
If you want to quickly understand what is in the basic marketplace model, here are all the sheets and a brief explanation so you know what is in the model.
Detailed Look at the Basic Marketplace Model Architecture
Summary of all the sheets
This is a one-liner explanation of what is in each sheet.
| Sheets | Comment |
|---|---|
| Formatting | Input your model start dates and basic formatting assumptions |
| Control | Model variables are centralised here. You can set sheets to be simple or detailed, how marketing works etc. You can start out with simple calcs and then make them more detailed if you like. You can also turn some sheets on/off |
| P&L Actual | This is the P&L of your actual numbers. Put in your actuals and they get represented in your combined P&L. A few actuals feed into the forecasts |
| P&L Forecast | Detailed forecast P&L of your startup. Output of all your assumptions. This is the P&L you care about most |
| P&L Combined | This combines the forecast and actual sheets together so numbers progress |
| P&L for deck | This combines the summary forecast and actual sheets together for the first 12 months and for 3 years annual to insert in your pitch deck. Do whatever you want to it |
| KPI Forecast | A detailed summary of all your forecasted KPIs |
| Chart | Summary of charts from across sheets. Use to sense check trends etc |
| Source and Use | Use this to figure out how much to raise and to present your 'sources and use' of money you raise in your 'ask' slide |
| Payment | Calculates your payment costs |
| Staff | Forecasts for all staff, and all the related staff and G&A costs |
| Revenue - S | Calculates your revenue for the supply side. You can choose what streams you have |
| Revenue - D | Calculates your revenue for the demand side. Basically the same as the supply sheet |
| Conversion | Assumptions for converting registrations into customers and the calculations for it |
| Registrations | Forecast how many registrations you will have on the demand and supply side as well as marketing costs |
Go back to the Marketplace model
Now that you’ve had fun here, you can had back to the main sheet if you like?
Basic Marketplace model features
If you’d like to learn the details of what the model can do, read on my dear friend.
Comments (0)
There are no comments yet :(