ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
www.MSOfficeGeek.com
3
Sum of Year's Digit Depreciation Calculator
4
(Excel, OpenOffice, & Google Sheet)
5
6
Sum of Years Depreciation
7
Value of Asset $ 1,000,000.00 Total Depreciable Value $ 1,000,000.00
8
Additional Costs Of Set-up $ 200,000.00 Book Value at the end of Life Span $ 200,000.00
9
Total Value $ 1,200,000.00 First Year Depreciation$333,333.33
10
Life Span in Years (Estimated)5First Year Depreciation %33.33%
11
Estimated Scrap Value $ 200,000.00 Actual Scrap Value $ 200,000.00
12
Difference $ -
13
14
Sum of Years Depreciation ScheduleImportant Sum of Years Depreciation Formulas
15
YearDepreciationBook Value
16
0 $ 1,200,000.00 Sum of Years Depreciation Formula
17
1$333,333.33 $ 866,666.67 (Cost Value - Scrap Value) X (Year / Sum of Years)
18
2$266,666.67 $ 600,000.00
19
3$200,000.00 $ 400,000.00
20
4$133,333.33 $ 266,666.67
21
5$66,666.67 $ 200,000.00 Excel Function for Declining Balance Depreciation
22
 $ 200,000.00 FunctionSYD Function
23
 $ 200,000.00 Syntax=SYD (cost, salvage, life, period)
24
 $ 200,000.00
25
 $ 200,000.00 Formula to Calculate Depreciation Percentage
26
 $ 200,000.00 (Depreciation / (Cost Value - Salvage Value) X 100
27
 $ 200,000.00
28
 $ 200,000.00
29
 $ 200,000.00
30
 $ 200,000.00
31
 $ 200,000.00
32
 $ 200,000.00
33
 $ 200,000.00
34
 $ 200,000.00
35
 $ 200,000.00
36
 $ 200,000.00
37
 $ 200,000.00
38
 $ 200,000.00
39
 $ 200,000.00
40
 $ 200,000.00
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