All templates
Finance
Revenue Forecast
Project income month by month and see the effect of changes.
Forecast3 rows
| # | AMonth | BCustomers | CAvg order | DRevenue | EGrowth | FCumulative |
|---|---|---|---|---|---|---|
| 1 | Jan | 38 | 210 | 7,980 | — | 7,980 |
| 2 | Feb | 41 | 215 | 8,815 | 10.5% | 16,795 |
| 3 | Mar | 45 | 218 | 9,810 | 11.3% | 26,605 |
What it tracks
- Monthly revenue
- Growth assumptions
- Best and worst case
Included sheets
ForecastAssumptionsChart data
Key calculations
- Revenue
- =Customers*AvgOrder
- Growth
- =IFERROR(D3/D2-1,0)