DDB

Returns the depreciation of an asset, using the Double Declining Balance Method,
for each period of the asset's lifetime.
=DDB($B$1, $B$2, $B$3, 1)
DDB() Year 1 Result is $4,000.00
=DDB($B$1, $B$2, $B$3, 2)
DDB() Year 2 Result is $2,400.00
=DDB($B$1, $B$2, $B$3, 3)
DDB() Year 3 Result is $1,440.00
=DDB($B$1, $B$2, $B$3, 4)
DDB() Year 4 Result is $864.00
=DDB($B$1, $B$2, $B$3, 5)
DDB() Year 5 Result is $296.00