Page 402 - Excel 2013 All-in-One For Dummies

384 Depreciation Functions
Figure 4-4:
A Depreciation table show- ing 10-year depreciation of an asset using various methods.
The Formula bar shown in Figure 4-4 shows the SLN formula that I entered into cell B8:
=B7-SLN($C$3,$C$5,$C$4)
This formula subtracts the amount of straight-line depreciation to be taken in the first year of service from the original cost of $50,000. (This value is brought forward from cell C3 by the formula =C3.) After creating this origi- nal formula in cell B8, I then used the Fill handle to copy it down to cell B17, which contains the final salvage value of the asset in the 10th year of service.
Cell C8 contains a similar formula for calculating the sum-of-years-digits depreciation for the office furniture. This cell contains the following formula:
=C7-SYD($C$3,$C$5,$C$4,$A8)
This formula subtracts the amount of sum-of-years-digits depreciation to be taken at the end of the first year from the original cost of $50,000 in cell C7 (also brought forward from cell C3 by the formula =C3). After creating this original formula in cell C8, I again used the Fill handle to copy it down to cell C17, which also contains the final salvage value of the asset in the 10th year of service.