next up previous contents index
Next: DDB Up: A Function Reference Previous: DAYS360

DB

 

Syntax: @DB(C, S, L, N, M)

C = Initial cost of asset
S = Salvage value of asset
L = Number of periods over which the asset is depreciating (life)
N = Number of periods over which to calculate the depreciation
M = (Optional) Number of months in the first year. Assumed to be 12 if omitted.

@DB returns the fixed-declining real depreciation of an asset for a specified period.

Example:

@DB(40000, 100, 6, 3, 2) = 8323.1198


next up previous contents index
Next: DDB Up: A Function Reference Previous: DAYS360

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999