How to use this tool
- Enter the cash currently available and conservative/optimistic sales assumptions.
- Expand Monthly forecast inputs and adjust the six example months to match expected seasonality.
- Review expected closing balances by month and compare all three scenarios.
How the result works
Each month adds sales receipts and subtracts inventory buying, operating expenses, labor, and fees. Conservative and optimistic scenarios scale sales and sales-linked fees while holding fixed cost estimates unchanged.
Use opening cash that is actually available, not inventory value or unused credit. Add tax payments, loan repayments, owner draws, and one-off bills into the relevant month. A forecast is not a guarantee of future sales.