ModeldrillGrow revenue from one assumption
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.
| 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.