I wouldn't recommend using this as a basis for building your model. Use it to assist you by all means but you'll learn a lot more by building your own, and it doesn't need to be anywhere near as complex as this one.
Always use relevant operational drivers for your business - this model is a very generic one that takes income by month as an input and then just grows it by arbitrary percentages after the first 3 months.
So e.g. for a web based business often key drivers will be traffic to your site, conversion rates, price of product (and percentage growth rates for these). Once you have these you can calculate revenues (which could then go into the spreadsheet linked to here if you really wanted to use it).
But it's this operational modelling that really is key to both helping you and any investors understand the economics of your business.
Make sure everything (revenues and costs) are broken down month by month for 3 years. Roll up to yearly totals on a summary sheet if you want.
You can build a decent model in two/three sheets. One for key assumptions/drivers + summary results, and one for an operational model and P+L. You could do cashflow on the 2nd sheet or separately on a 3rd.
Always use relevant operational drivers for your business - this model is a very generic one that takes income by month as an input and then just grows it by arbitrary percentages after the first 3 months.
So e.g. for a web based business often key drivers will be traffic to your site, conversion rates, price of product (and percentage growth rates for these). Once you have these you can calculate revenues (which could then go into the spreadsheet linked to here if you really wanted to use it).
But it's this operational modelling that really is key to both helping you and any investors understand the economics of your business.
Make sure everything (revenues and costs) are broken down month by month for 3 years. Roll up to yearly totals on a summary sheet if you want.
You can build a decent model in two/three sheets. One for key assumptions/drivers + summary results, and one for an operational model and P+L. You could do cashflow on the 2nd sheet or separately on a 3rd.