01 · YOUR STARTING POINT
Editable exampleYour project
All three templates are available. Their figures are examples: replace them with your business assumptions.
Rename the project above and save to update it.
YOUR CONNECTED PROJECT
Continue with business planning
Take a copy of the current inputs into products, channels and 13-week cash flow. Review the proposal before applying it; your source project is retained. Current edits travel too, even when not saved yet.
Review project in business planning →02 · EXPLORE THE POSSIBILITIES
Monthly · USDOne plan. Three scenarios.
Adjust each assumption relative to the base scenario. Scenario names do not guarantee a better or worse result.
OPERATING RESULT · BASE$4,950.00/ month
Monthly units required to break even: 1,667.
| Item | Conservative | Base | Optimistic |
|---|---|---|---|
| Monthly units | 2,800 | 3,500 | 4,200 |
| Price per unit | $4.275 | $4.50 | $4.725 |
| Variable cost per unit | $1.98 | $1.80 | $1.80 |
| Monthly fixed costs | $4,950.00 | $4,500.00 | $4,500.00 |
| Monthly revenue | $11,970.00 | $15,750.00 | $19,845.00 |
| Monthly total costs | $10,494.00 | $10,800.00 | $12,060.00 |
| Gross profit | $6,426.00 | $9,450.00 | $12,285.00 |
| Gross margin | 53.68 % | 60 % | 61.9 % |
| Operating result | $1,476.00 | $4,950.00 | $7,785.00 |
| Break-even · units / month | 2,157 | 1,667 | 1,539 |
| Cash runway | No monthly loss | No monthly loss | No monthly loss |
* Break-even is unavailable without a positive contribution per unit. Cash runway is calculated only for an operating loss.
View formulas and report scope
- Revenue = price × monthly units.
- Total variable costs = variable cost per unit × units; total costs = total variable costs + monthly fixed costs.
- Gross margin = (revenue − total variable costs) / revenue. The percentage is undefined without revenue.
- Operating result = revenue − total variable costs − monthly fixed costs; excludes taxes, interest, and depreciation.
- Break-even = fixed costs / (price − variable cost per unit), rounded up. A positive contribution per unit is required.
- Cash runway = available cash / monthly operating loss, calculated only for a loss. Startup investment is shown separately and is not subtracted again from the available reserve.
- Scenarios: units, price, and costs are multiplied by 1 + adjustment / 100. Units are rounded to the nearest whole unit. Cost adjustments apply to both variable costs per unit and fixed costs.
These calculations use your assumptions. They are not predictions, guarantees, or a complete cash-flow statement.