Buy new or used or repair

	A	B	C	D	E	F	G	H	I	J	K
1	Fuel cost, $/gal	4.25
2	DEF cost, $/Gal	4.5
3	Miles per year	200000
4	Calc period, years	3
5	Own capital rate (savings rate)	2%
6	Loan lenght, month	30
7	Loan rate, %	9.84
8
9			New truck	per month	per mile	Used	per month	per mile	Current	per month	per mile
10	Price		200000			70000.00
11	Loan amount		150000			40000.00
12	Down payment		50000			30000.00
13	Own capital cost			0.00	0.0000		0.00	0.0000	0.00	0.00	0.0000
14	Value after end of the calc period		40000			20000.00			5000
15	Ammortisation price loss/time		0	0.00	0.0000	16666.66667	1388.89	0.0833	-1666.666667	-138.89	-0.0083
16	Loan cost		19,816.78	330.28	0.0991	5284.47	88.07	0.0264	$0.00	$0.00	0.0000
17	Montly payment (loan + own capital)		$7,327.23			$2,509.48			$0.00
18	Insurance	33	9800	816.6666667	0.0490	2310	192.5	0.0116	0	0	0.0000
19	Repair		1000.00	83.33	0.0050	7000.00	583.33	0.0350	17000.00	1416.67	0.0850
20	Fuel, mpg		8.8			7.5			6.9
21	Fuel , $		96591	8049	0.4830	113333	9444	0.5667	123188	10266	0.6159
22	Def, 1/50 of diesel ammount		2045	170	0.0102	2400	200	0.0120	0	0	0.0000
23	Total			9450	0.646		11897	0.7350		11543	0.6926
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