Car Cost Calculator - New vs. Old

	A	B	C	D	E	F	G
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				Year			Costs
6	My Old Car			1	2	3
7	Value (sales value)	20000		20000	17000	14450
8	Costs
9	Depreciation pr. year (%)		15	3000	2550	2168	7718
10	Financing - cost by using own savings [share of value (%), interest rate (%)]	100	2	400	340	289	1029
11	Financing - cost loan [share of value (%), interest rate (%)]	0	5	0	0	0	0
12							0
13	Insurance cost pr. year		800	800	800	800	2400
14	Road tax pr. year		200	200	200	200	600
15	Fuel [distance pr year (km, miles), cost per distance unit (cost/km, cost/miles)]	20000	0.15	3000	3000	3000	9000
16	Service				800		800
17	New tires			1000		1000	2000
18	Repairs			1000	1000	1000	3000
19							0
20							0
21	Costs			9400	8690	8457	26547
22
23				Year			Costs
24	My New Car			1	2	3
25	Value (cost to buy)	40000		40000	32800	26896
26	Costs
27	Depreciation pr. year (%)		18	7200	5904	4841	17945
28	Financing - cost by using savings [share of value (%), interest rate (%)]	50	2	200	170	145	515
29	Financing - cost of loan [share of value (%), interest rate (%)]	50	5	500	425	361	1286
30							0
31	Insurance cost pr. year		1000	1000	1000	1000	3000
32	Road tax pr. year		200	200	200	200	600
33	Fuel [distance pr year (km, miles), cost per distance unit (cost/km, cost/miles)]	20000	0.12	2400	2400	2400	7200
34	Service				1000		1000
35	New tires					1000	1000
36	Repairs						0
37							0
38							0
39	Costs			11500	11099	9947	32546
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