next up previous contents index
Next: DEGREES Up: A Function Reference Previous: DB

DDB

 

Syntax: @DDB(C, S, L, P)

C = cost
S = salvage value
L = allowable life
P = the period for which the double declining depreciation allowance is being calculated

@DDB returns the double-declining depreciation allowance given cost C, salvage value S, allowable life L, and N number of depreciation periods. The function is given by:

displaymath16051

where bookvalue is the current book value of the asset and L is the estimated life of the asset. The double declining balance depreciation allowance for the Pth depreciation period (DDB) is calculated by the following iteration formula, where BV is the book value for the ith depreciation period.

  tex2html_wrap_inline16053 

for ¯i=1 to P do

tex2html_wrap_inline16059

tex2html_wrap_inline16061

Examples:

@DDB(200, 120, 25, 10) = 9.6

@DDB(F9, F5, 10, 6) = 524.29, where F5 = $1800.00 and F9 = $8000.00

@DDB(200, 220, 10, 7) = error!, must have ``cost'' >= ``salvage'' >= 0


next up previous contents index
Next: DEGREES Up: A Function Reference Previous: DB

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