Compare annual charges and the remaining carrying value
Your goal: Use SLN and SYD on the same cost, salvage and useful life, then reconcile cumulative SYD allocation.
Full 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.
Year three of a seven-year assetIdentify the depreciable base
Read cost, salvage, life and period controls beside their original A labels. Keep fractional inputs and model policies. Calculated results appear after your formulas pass.
| # | ||
|---|---|---|
| 1 | ||
| 2 | ||
| 3 | ||
| 4 | ||
| 5 | ||
| 6 | ||
| 7 | ||
| 8 | ||
| 9 |
Step 1 of 4
Identify the depreciable base
Rules for this step
Select initial cost and salvage. The depreciable base retains currency precision; equal values produce numeric zero.