Microsoft® Excel® 2010 Inside Out

Calculating Depreciation

Depreciation has an enormous effect on the bottom line of any business, and accurately calculating depreciation is crucial if you want to avoid triggering a detailed scrutiny of your financial records. 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. All of the functions for calculating depreciation are available on the Formulas tab, in the Function Library group’s Financial drop-down list.

Table 16-2. Depreciation Function Arguments

Argument	Description
Cost	Initial cost of the asset.
Life	Length of time ...