SLN Function

Named Arguments

Yes

Syntax

SLN(cost, salvage, life)


cost

Use: Required

Data Type: Double

The initial cost of the asset.


salvage

Use: Required

Data Type: Double

The value of the asset at the end of its useful life.


life

Use: Required

Data Type: Double

The length of the useful life of the asset.

Return Value

A Double representing depreciation per period.

Description

Computes the straight-line depreciation of an asset for a single period.

Rules at a Glance

  • The function uses a very simple formula to calculate depreciation:

    (cost - salvage) / life

  • The depreciation period is determined by the time period of life.

  • All arguments must be positive numeric values.

See Also

DDB Function, SYD Function
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.226.34.105