DB and DDB.xlsx

	A	B	D	E	F	G	H	I	K	L	M	N	O
1	DB	Fixed Declining Balance method
2	DDB	Double Declining Balance Method
3	VDB	Variable Declining Mehod
4	SLN	Straight Line Depreciation Method
5	SYD	Sum of Years Digits Depreciation Method
6
7
8	Item	Computer	Year	DB	DDB	VDB	SLN	SYD		Initial Cost	Depre. Rate	Depreciation	Closing cost
9	Initial Cost	35000	1	7770	14000	14000	$5,000.00	8333	22.2	35000	22.2	7770	27230
10	Salvage Value	10000	2	6045	8400	8400	$5,000.00	6667		27230	22.2	6045	21185
11	Life	5	3	4703	2600	2600	$5,000.00	5000		21185	22.2	4703	16482
12			4	3659	0	0	$5,000.00	3333		16482	22.2	3659	12823
13			5	2847	0	0	$5,000.00	1667		12823	22.2	2847	9976
14			Total	25024	25000	25000	25000	25000				25024
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100