Manuals/calci/DDB
DDB(C ,salvage, L, P, F)
Where 'C' is the initial cost of the asset, 'salvage' is the value at the end of the depreciation, 'L' is the number of periods, 'P' is the period to calculate the depreciation, and 'F' is the rate at which the balance declines.
This function gives the depreciation of an asset for a specified period using the double-declining balance method.
- DDB uses the following formula to calculate depreciation for a period: Min( (cost - total depreciation from prior periods) * (factor/life), (cost - salvage - total depreciation from prior periods) )
'
DDB
[javascript:ToggleDiv('divExpCollAsst_4') Lets see an example,]
[javascript:ToggleDiv('divExpCollAsst_4') DDB(C ,salvage, L, P, F)]
[javascript:ToggleDiv('divExpCollAsst_4') B]
[javascript:ToggleDiv('divExpCollAsst_4') 3500]
[javascript:ToggleDiv('divExpCollAsst_4') 250]
[javascript:ToggleDiv('divExpCollAsst_4') 12]
=DDB(B2,B3,B4*365,1) is 1.598
=DDB(B2,B3,B4*12,1,2) is 48.61
=DDB(B2,B3,B4,1,2) is 583.33
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 3500 | |||
| Row2 | 250 | |||
| Row3 | 12 | |||
| Row4 | 1.5982 | |||
| Row5 | 48.6111 | |||
| Row6 | 583.3333 |
