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 press Fill right to copy it out to F5. 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 to fill. Click one, type a formula and press Enter, or use Fill right and Fill down to copy it across the row or down the column with the references adjusted. The grid scrolls sideways when it is wide.