Manuals/calci/db
Jump to navigation
Jump to search
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
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 200000 | 100000 | ||
| Row2 | 1000 | 10000 | ||
| Row3 | 5 | 2 | ||
| Row4 | 76183.3333 | 1 | ||
| Row5 | 7 | |||
| Row6 | 39900 |
