I need to build a double declining formula from scratch for the following information. gross cost 40000 eul 5 salvage value 10000 I should be able to drag the formula from the second year down and it should automatically calculate the depreciation. I am getting stuck as to how to make that work for DDB in the smallest/shortest formula as possible. We can not use the built in Excel formulas.

Gross Cost	40,000
EUL	5
Salvage Value	10,000
The formula used for year 1 could be either:		or
(this is obviously done in Excel)

	A	B	C
1
2
3
4	GROSS COST	40,000
5	EUL	5
6	SALVAGE VALUE	10,000
7
8
9
10
11	YEARS	STRAIGHTLINE	DOUBLE DECLINING BALANCE
12	1	$6,000.00	$16,000.00
13	2	$6,000.00
14	3	$6,000.00
15	4	$6,000.00
16	5	$6,000.00
17	TOTAL	$30,000.00