Calculating Depreciation

image with no caption

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




Initial cost of the asset.


Length of time the ...

Get Microsoft® Excel® 2010 Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.