A growth rate over the wrong number of years
An Excel formula exercise from Formuladrill. Solve it with a formula bar on a live sheet in your browser, and it is checked the moment you submit.
The task
The sheet reports the compound annual growth rate of revenue from 2021 to 2025, and the figure looks too low. One formula is wrong. Find it and fix it.
What this exercise teaches
Five year-end figures span four years of growth, so the exponent is 1/4. Using the number of data points instead of the number of periods is the standard CAGR mistake, and it always understates growth: 10% a year shows as 7.92%.
A hint if you get stuck
Count the years of growth between the first and the last figure, not the number of figures.
Try it now, free, no account needed
Your first 15 exercises on Formuladrill are free. Open it on the practice page, solve it, and get instant feedback with a hint. A free account adds the worked solution; Pro unlocks every exercise, timed mode and the certificate.
Open this exerciseMore exercises in Find the error
- The budget that looks fine
- A rate typed into a formula
- Commission copied down
- Growth that does not add up
- The wrong price column
- An average with the wrong count
- A region total that misses a row
- A loan payment that is far too high
- Variance with the wrong sign
- A count that ignores its threshold
- The lookup without FALSE
- An NPV discounted one year too many
- Grades tested in the wrong order