ModeldrillFixed asset roll-forward
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
Roll the fixed asset balance forward. Closing balance (row 8) is opening plus capital spending less depreciation. Each year after the first opens with the prior year's closing balance (row 5).
What this exercise teaches
Linking each opening balance to the prior closing balance is what makes a schedule hold together: change one year's spending and every later balance moves.
A hint if you get stuck
Write B8 first and fill it right. Then C5 just points at B8, the closing balance one column to the left, and fills right as well.
This exercise is part of Pro
Pro unlocks all 45 exercises, with worked solutions and progress saved to your account. The free exercises work without an account.
You create a free account first, so Pro is attached to it.
Monthly is charged today and then every month until you cancel, in one click from your account page. Lifetime is one payment with no renewals. Full refund within 14 days of paying.