- Spend Some Time to Get Familiar with Excel
- Constants, Parameters, etc.
- Equations
- Formatting
- Characterize Your Prospective Clients, What They Will Buy, and When
- Build an Arrival Model based on Advertising, Sales Staff or Whatever Drives Your Sales
- Model Your Cost of Sales
- Add in Your Fixed Costs
- Model Your Cashflow
- Calculate Funding Requirements to Cashflow Break Even
- Calculate Time to Cashflow Break Even
It is best to break things out on to separate sheets once you master equations with values on other sheets.
It may seem like overkill but use months as your unit of time, it is what everyone is used to seeings and how everyone thinks.
Be realistic on how long it takes to sell. The time to close is proportional to the price.
Be realistic about how long it takes to raise money. It ALWAYS takes longer than you think.