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
Initial cost of the asset
Length of time the asset will be depreciated
Individual time period to be computed
Asset's remaining value after it has been fully depreciated
The SLN function determines the straight-line depreciation for an asset for a single period. This depreciation ...