Level 1Analyst HabitsPractice, 3 min
Project next year
The task
The growth assumption lives in E2. In C2, project 2027 revenue from 2026, pointing at the assumption with
$E$2 instead of typing 12%.The data
The starting sheet. Cells outlined in green are where your formulas go.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | 2026A | 2027E | Growth | ||
| 2 | Revenue | $966,000 | 12% |