Microsoft® Office Excel 2003 Inside Out

Calculating Depreciation

Depreciation has an enormous effect on the bottom line of any business, and accurate calculation of depreciation is crucial if you want to avoid triggering a detailed scrutiny of your records by the IRS. These functions help you precisely determine the depreciation of an asset for a specific period. Table 16-2 lists the common arguments used in these functions:

Table 16-2. Depreciation Function Arguments

Argument	Description
Cost	Initial cost of the asset
Life	Length of time the asset will be depreciated
Period	Individual time period to be computed
Salvage	Asset's remaining value after it has been fully depreciated

The SLN Function

The SLN function determines the straight-line depreciation for an asset for a single period. This depreciation ...