Compare fixed and accelerated declining balances
Enter separate formulas in E2:E5. B2:B5 are cost, salvage, whole useful years and selected year. B6 is the DDB factor; B7 is the number of months in the first fiscal year. E2 is DB for the selected year using B7. E3 is the DDB charge for that whole year using B6; DDB has no month argument. E4 is cost less all DB charges through B5. E5 is the additional DB charge at period life+1 when the first year has fewer than 12 months, otherwise numeric zero. Do not force the DB ending balance to equal salvage.
The answer cells begin blank. Enter a reusable formula and check it against the published practice datasets. Hints and the solution are available when you choose them.
Practice stays on this device. No worksheet data is uploaded.
A checkpoint records a fresh check of every dataset. This attempt tracks built-in hints, solutions, steps and worked examples; it does not establish independent authorship.
Help recorded: none of these built-in aids opened.
Make the formula your own.
View task requirements
Enter separate formulas in E2:E5. B2:B5 are cost, salvage, whole useful years and selected year. B6 is the DDB factor; B7 is the number of months in the first fiscal year. E2 is DB for the selected year using B7. E3 is the DDB charge for that whole year using B6; DDB has no month argument. E4 is cost less all DB charges through B5. E5 is the additional DB charge at period life+1 when the first year has fewer than 12 months, otherwise numeric zero. Do not force the DB ending balance to equal salvage.
No account. No upload. Just try it.