ModeldrillYear over year growth
A financial modeling exercise from Modeldrill. Solve it with a live spreadsheet grid in your browser, with Fill right and Fill down, and it is checked the moment you submit.
The task
Six years of actual revenue are in row 5. Fill row 6 with the growth over the prior year, starting in C6 and filling right to G6.
What this exercise teaches
=C5/B5-1 compares each year with the one to its left. Because both references are relative, the pair slides along together when filled.
A hint if you get stuck
Growth is this year divided by last year, minus 1. The first year has no prior year, so start in C6.
Try it now, no account needed
This exercise is free. Open it on the practice page, solve it, and get instant feedback with a hint and a worked solution after two tries.
Open this exercise