DB

Returns the depreciation of an asset, using the Fixed Declining Balance Method,
for each period of the asset's lifetime.
=DB($B$1, $B$2, $B$3, 1)
DB() Year 1 Result is $3,690.00
=DB($B$1, $B$2, $B$3, 2)
DB() Year 2 Result is $2,328.39
=DB($B$1, $B$2, $B$3, 3)
DB() Year 3 Result is $1,469.21
=DB($B$1, $B$2, $B$3, 4)
DB() Year 4 Result is $927.07
=DB($B$1, $B$2, $B$3, 5)
DB() Year 5 Result is $584.98
And with depreciation only starting after 6 months.
=DB($B$1, $B$2, $B$3, 1, 6)
DB() Year 1 Result is $1,845.00
=DB($B$1, $B$2, $B$3, 2, 6)
DB() Year 2 Result is $3,009.20
=DB($B$1, $B$2, $B$3, 3, 6)
DB() Year 3 Result is $1,898.80
=DB($B$1, $B$2, $B$3, 4, 6)
DB() Year 4 Result is $1,198.14
=DB($B$1, $B$2, $B$3, 5, 6)
DB() Year 5 Result is $756.03
=DB($B$1, $B$2, $B$3, 6, 6)
DB() Year 6 Result is $238.53