Formuladrill

Level 7: Find the error Exercise 118 of 118

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 exercise

More exercises in Find the error