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 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 ...
Get Microsoft® Office Excel® 2007 Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
