Manuals/calci/db

DB(C, Salvage, L, P, M)

where,

C - the initial cost of the asset.

Salvage - the value at the end of depreciation.

L - the number of periods over which the assst is being depreciated.

P - the period for which to calculate the depreciate.

M - the number of months in the first year.If month is omitted, it is assumed to be 12.

This function calculates the depreciation of an asset for specified period by using the fixed-declining balance method.

Whenever the C<0,Salvage <0 ,P <=0, M <=0 or L<=0, DB shows the ERROR value.

If M <P, DB returns the ERROR value.

DB

Lets see an example in (Column2,Row1)

=DB(200000,1000,5)

=DB(C1R1,C1R2,C1R3)

DB returns 76183.3333.

Consider another example

=DB(100000,10000,2,1,7)

DB returns 39900.

Syntax

Remarks

Examples

Description