Revenue for 2026 is in B5 and the yearly growth rate is in B2. In C5, write a formula that grows the prior year by the rate in B2. Then fill it right to F5 (drag the fill handle, or select C5:F5 and press Ctrl+R). Lock the rate with dollar signs so it stays put when the formula is copied.
fx
A
B
C
D
E
F
1
2
Revenue growth per year
8.0%
3
4
Year
2026
2027
2028
2029
2030
5
Revenue
$1,200,000
6
Highlighted cells are yours. The sheet works like Excel: type in a cell or the formula bar, Enter, Tab, Shift+arrows, Ctrl+C and Ctrl+V, Ctrl+D, the fill handle, F2, F4, Ctrl+Z. Press Enter on a cell when you are done to check.