truck_evaluation_extended.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Input Variables
2	Annual Mileage (miles)	6500
3	Fuel Cost per Gallon (USD)	3.5
4	---
5	Time Periods
6	Years	Annual Mileage	Fuel Cost/Gallon
7	5	6500	3.5
8	10	6500	4.25
9	15	6500	5
10	---
11	Option	Initial Cost	Trade-in value	Annual Maintenance	MPG	Annual Insurance	Resale Value (5yr)	Fuel Cost (5yr)	Total Cost (5yr)	Fuel Cost (10yr)	Total Cost (10yr)	Fuel Cost (15yr)	Total Cost (15yr)
12	Keep Existing Old Truck	$ -	-	2,000.00	15	1000	8500	7583.333333	$ 22,583.33	18416.66667	$ 48,416.67	32500	$ 77,500.00
13	Buy Newer Used Truck	$ 25,000.00	12,500.00	1,000.00	20	1500	18000	5687.5	$ 30,687.50	13812.5	$ 51,312.50	24375	$ 74,375.00
14	Buy Brand New Truck	$ 50,000.00	12,500.00	500.00	25	2000	40000	4550	$ 54,550.00	11050	$ 73,550.00	19500	$ 94,500.00
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