Allocate a partial-year window from one fixed origin
Enter separate formulas in E2:E5. B2:B4 are cost, salvage and whole useful years; B6 is the declining factor. B8 and B9 are elapsed-year window endpoints with 0 <= start <= end <= life. E2 is the difference between automatic-switch cumulative VDB charges from time zero through end and from time zero through start. E3 is the direct VDB charge over the window with no_switch TRUE. E4 and E5 are initial cost less cumulative charges from zero through end with switching allowed and with no switching. Keep fractional years and unrounded amounts.
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:B4 are cost, salvage and whole useful years; B6 is the declining factor. B8 and B9 are elapsed-year window endpoints with 0 <= start <= end <= life. E2 is the difference between automatic-switch cumulative VDB charges from time zero through end and from time zero through start. E3 is the direct VDB charge over the window with no_switch TRUE. E4 and E5 are initial cost less cumulative charges from zero through end with switching allowed and with no switching. Keep fractional years and unrounded amounts.
No account. No upload. Just try it.