Car Cost Calculator - New vs. Old
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPQRSTUVW
1
Make your own Google Docs copy of this document (you must be logged into your Google account) - or download as an excel file to your computer - by using the "File" menu above!!
2
3
Car Cost Calculator - New vs. Old
4
Add values for the old and new car below.
5
YearCosts
6
My Old Car123
7
Value (sales value) 20000200001700014450
8
Costs
9
Depreciation pr. year (%)153000255021687718
10
Financing - cost by using own savings [share of value (%), interest rate (%)]10024003402891029
11
Financing - cost loan [share of value (%), interest rate (%)]050000
12
0
13
Insurance cost pr. year8008008008002400
14
Road tax pr. year200200200200600
15
Fuel [distance pr year (km, miles), cost per distance unit (cost/km, cost/miles)]200000.153000300030009000
16
Service800800
17
New tires100010002000
18
Repairs1000100010003000
19
0
20
0
21
Costs94008690845726547
22
23
YearCosts
24
My New Car123
25
Value (cost to buy) 40000400003280026896
26
Costs
27
Depreciation pr. year (%)1872005904484117945
28
Financing - cost by using savings [share of value (%), interest rate (%)]502200170145515
29
Financing - cost of loan [share of value (%), interest rate (%)]5055004253611286
30
0
31
Insurance cost pr. year10001000100010003000
32
Road tax pr. year200200200200600
33
Fuel [distance pr year (km, miles), cost per distance unit (cost/km, cost/miles)]200000.122400240024007200
34
Service10001000
35
New tires10001000
36
Repairs0
37
0
38
0
39
Costs1150011099994732546
40
41
42
Extend the calculation with more years by - inserting new columns to the right of column with year 3 - copy cell equations from year 3 to the new columns.
43
44
Add more cars by - ranging out row 5 to 21 - copy and paste the content below - make changes.
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
Loading...