Compare annual charges and the remaining carrying value
Enter separate formulas in E2:E4. B2 is initial cost, B3 is salvage, B4 is whole useful years and B5 is the selected whole year. E2 is one straight-line annual charge. E3 is the SYD charge for B5. E4 is initial cost less all SYD charges for years 1 through B5, including the selected year. Keep calculated amounts unrounded.
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:E4. B2 is initial cost, B3 is salvage, B4 is whole useful years and B5 is the selected whole year. E2 is one straight-line annual charge. E3 is the SYD charge for B5. E4 is initial cost less all SYD charges for years 1 through B5, including the selected year. Keep calculated amounts unrounded.
No account. No upload. Just try it.