Exercises / Finance and business maths · 4 of 14
Project revenue five years out
A model grows each year from the year before: next = previous × (1 + growth). Keep the growth rate in one input cell and anchor it, so the whole projection changes with one edit.
Your taskRevenue for 2026 is in B4. In C4, grow the previous year by the rate in B1. It will be copied right to G4.
Pro
Unlock this exercise and every module after the basics.
Pro opens every exercise in every module, your review schedule, and the final test for the course certificate.
| Row | A | B | C | D | E | F | G |
|---|---|---|---|---|---|---|---|
| 1 | Growth | 8% | per year | ||||
| 2 | |||||||
| 3 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | |
| 4 | Revenue | $1,200,000.00 |