O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required