Buying Guide Help

	A	B	C	D	E	F	H	I	J	K	L	N	O	P	Q	R	T	U	V	W	X	Z	AA	AB	AC	AD	AF	AG	AH	AI	AJ	AL	AM	AN	AO	AP
1	Vehicle	20?? Toyota Corolla					2008 Toyota Corolla					2012 Toyota Corolla					2015 Toyota Corolla					NEW Toyota Corolla					2015 Toyota Tundra					NEW Toyota Tundra
2	Mileage	140,000					150,000					120,000					60-100k					0/NEW					60k-100k miles					0/New
3	Status	Already owned					Bought used					Bought used					Bought used					Bought New					Bought used					Bought New
4	Outright Purchase Cost	$0.00					$7,000.00					$10,000.00
5	Down Payment	$0.00					$0.00					$0.00					$3,000.00					$3,000.00					$6,000.00					$6,000.00

6
7		Avg Svc Cost/mo	Car Payment	Interest	Annual Cost	Mileage	Avg Svc Cost	Car Payment	Interest	Annual Cost	Mileage	Avg Svc Cost	Car Payment	Interest	Annual Cost	Mileage	Avg Svc Cost	Car Payment	8% Interest	Annual Cost	Mileage	Avg Svc Cost	Car Payment	8% Interest	Annual Cost	Mileage	Avg Svc Cost	Car Payment	8% Interest	Annual Cost	Mileage	Avg Svc Cost	Car Payment	8% Interest	Annual Cost	Mileage
8	Year 1	$130.00	$0.00		$1,560.00	140,000	$135.00	$0.00		$1,620.00	150,000	$110.00	$0.00		$1,320.00	120,000	$105.00	$243.32	$19.47	$4,413.43	80,000	$25.00	$405.53	$32.44	$5,555.67	0	$115.00	$486.63	$38.93	$7,686.72	80,000	$27.50	$725.08	$58.01	$9,727.04	0
9	Year 2	$135.00	$0.00		$1,620.00	152,000	$140.00	$0.00		$1,680.00	162,000	$115.00	$0.00		$1,380.00	132,000	$110.00	$243.32	$19.47	$4,473.43	92,000	$32.50	$405.53	$32.44	$5,645.67	12,000	$122.50	$486.63	$38.93	$7,776.72	92,000	$35.00	$725.08	$58.01	$9,817.04	12,000
10	Year 3	$140.00	$0.00		$1,680.00	164,000	$145.00	$0.00		$1,740.00	174,000	$120.00	$0.00		$1,440.00	144,000	$115.00	$243.32	$19.47	$4,533.43	104,000	$40.00	$405.53	$32.44	$5,735.67	24,000	$130.00	$486.63	$38.93	$7,866.72	104,000	$42.50	$725.08	$58.01	$9,907.04	24,000
11	Year 4	$145.00	$0.00		$1,740.00	176,000	$150.00	$0.00		$1,800.00	186,000	$125.00	$0.00		$1,500.00	156,000	$120.00	$243.32	$19.47	$4,593.43	116,000	$47.50	$405.53	$32.44	$5,825.67	36,000	$137.50	$486.63	$38.93	$7,956.72	116,000	$50.00	$725.08	$58.01	$9,997.04	36,000
12	Year 5	$150.00	$0.00		$1,800.00	188,000	$155.00	$0.00		$1,860.00	198,000	$130.00	$0.00		$1,560.00	168,000	$125.00	$243.32	$19.47	$4,653.43	128,000	$55.00	$405.53	$32.44	$5,915.67	48,000	$145.00	$486.63	$38.93	$8,046.72	128,000	$57.50	$725.08	$58.01	$10,087.04	48,000
13	Year 6	$155.00	$0.00		$1,860.00	200,000	$160.00	$0.00		$1,920.00	210,000	$135.00	$0.00		$1,620.00	180,000	$130.00		$0.00	$1,560.00	140,000	$65.00			$780.00	60,000	$152.50			$1,830.00	140,000	$67.50			$810.00	60,000
14	Year 7	$160.00	$0.00		$1,920.00	212,000	$165.00	$0.00		$1,980.00	222,000	$140.00	$0.00		$1,680.00	192,000	$135.00		$0.00	$1,620.00	152,000	$75.00			$900.00	72,000	$160.00			$1,920.00	152,000	$77.50			$930.00	72,000
15	Year 8	$165.00	$0.00		$1,980.00	224,000	$170.00	$0.00		$2,040.00	234,000	$145.00	$0.00		$1,740.00	204,000	$140.00		$0.00	$1,680.00	164,000	$85.00			$1,020.00	84,000	$167.50			$2,010.00	164,000	$87.50			$1,050.00	84,000
16	Year 9	$170.00	$0.00		$2,040.00	236,000	$175.00	$0.00		$2,100.00	246,000	$150.00	$0.00		$1,800.00	216,000	$145.00		$0.00	$1,740.00	176,000	$95.00			$1,140.00	96,000	$175.00			$2,100.00	176,000	$97.50			$1,170.00	96,000
17	Year 10	$175.00	$0.00		$2,100.00	248,000	$180.00	$0.00		$2,160.00	258,000	$155.00	$0.00		$1,860.00	228,000	$150.00		$0.00	$1,800.00	188,000	$105.00			$1,260.00	108,000	$182.50			$2,190.00	188,000	$107.50			$1,290.00	108,000
18
19	Outright Purchase Cost	$0.00					$7,000.00					$10,000.00
20	Down Payment	$0.00					$0.00					$0.00					$3,000.00					$3,000.00					$6,000.00					$6,000.00
21	Income from vehicle sale:	$0.00					$3,000.00					$3,000.00					$3,000.00					$3,000.00					$7,500.00					$7,500.00
22	Sum of Annual Costs	$18,300.00					$18,900.00					$15,900.00					$31,067.14					$33,778.34					$49,383.62					$54,785.18
23	10 Year Cost:	$18,300.00					$22,900.00					$22,900.00					$31,067.14					$33,778.34					$47,883.62					$53,285.18
24
25
26		summarize info in the guide, include chart(s) in appendix.
27		may want to show costs by given time periods: 2 yr., 5 yr., 10 yr. (etc.)
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