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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access