Forecasting template
Sales Forecast Template (12 Months)
Forecast sales for the next year from two inputs: starting revenue and monthly growth. Each month builds on the previous one, so you can test scenarios in seconds.
Opening a template uses no credits.
What's inside
| Row | A | B |
|---|---|---|
| 1 | Assumption | Value |
| 2 | Starting revenue | 50,000 |
| 3 | Monthly growth | 5% |
| 4 | Month | Revenue |
| 5 | Jan | =B2 |
| 6 | Feb | =B6*(1+$B$3) |
| 7 | Total | =SUM(B6:B17) |
Preview with sample numbers. Formulas are shown in green.
The formulas, explained
B7 =B6*(1+$B$3)
Each month grows from the previous month by the growth rate. The $ signs lock the assumption cell.
B18 =SUM(B6:B17)
Total forecast revenue for the year.
Make it yours by asking
Try a request like this in Tabstra:
"Build a 12-month sales forecast driven by starting revenue and a monthly growth assumption"