VDB(C, S, L, S, E)

 

Description

This function returns the depreciation of an asset between two specific periods using the fixed-declining balance method.

 

Parameters

 

C

The initial cost of the asset.

 

S

Salvage value (the value at the end of the depreciation).

 

L

Life (the total number of periods over which the asset is being depreciated).

 

S

Start period (first period in the calculation).

 

E

End period (last period in the calculation).

 

Examples

 

VDB(10000, 500, 120, 2, 4) = 319.6289