About this lesson
Building revenue from stores and sales per store in Google Sheets
In Google Sheets, build revenue from its drivers: sales per store grows by its own rate (=B5*(1+C3)), the store count is averaged across the year (=AVERAGE(B2:C2)), and revenue is average stores × sales per store (=C6*C5). Keep inputs as typed numbers in their own cells and every calculation as a formula that points at them.
Using Excel? Do this lesson in Excel.
=B5*(1+C3)What you'll practise
Build Kookaburra Coffee's three-year revenue forecast from store numbers and sales per store, keeping every assumption in its own input cell.
4 steps · 40 points · the cells outlined in gold below
- revenue build
- price × volume
- inputs vs calculations
- forecasting
The data
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Financial year | FY25 | FY26 | FY27 | FY28 |
| 2 | Stores at 30 June | 38 | 42 | 47 | 51 |
| 3 | Sales per store growth | 3% | 3.5% | 2.8% | |
| 4 | |||||
| 5 | Sales per store ($k) | 1,850 | |||
| 6 | Average stores | ||||
| 7 | Revenue ($k) | ||||
| 8 | Revenue growth |