Views:

Description

Calculate the straight-line depreciation of an asset for one period.

Signature 

Depreciation_SLN('cost', 'salvage', 'life')

Parameters

NameRequiredTypeDescription
costYesdoubleThe initial cost of the asset.
salvageYesdoubleThe value of the asset at the end of the depreciation
lifeYesdoubleThe number of periods over which the asset is depreciated

Example 1

Depreciation_SLN(1000,200,5) Returns 160