Visual Basic 2005 in a Nutshell (In a Nutshell (OReilly))

Class

Microsoft.VisualBasic.Financial

Syntax

Dim result As Double = SLN(cost, salvage, life)

cost (required; Double)

The initial cost of the asset

salvage (required; Double)

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

life (required; Double)

The length of the useful life of the asset

Description

The SLN function computes the straight-line depreciation of an asset for a single period. Each period receives an equal depreciation share.

Usage at a Glance

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

  depreciation = (cost - salvage) / life

• All arguments must be positive numeric values.

See Also

DDB Function, SYD Function