| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Car Purchase Model | |||||||||||||||||||||||
2 | Fuel Assumption | 1.3 | Input Cells | |||||||||||||||||||||
3 | Risk Free Interest Rate | 1.400% | ||||||||||||||||||||||
4 | ||||||||||||||||||||||||
5 | Model | 2012 Volkwagen Jetta Tredline+ | 2013 Toyota Corolla CE 4A | 2012 Toyota Prius | 2012 Toyota Prius C | 2012 Toyota Yaris 4-DR 4A | 2012 Toyota Yaris 5DR LE 4A | 2012 Toyota Matrix 4A | 2012 Mazda3 GX W/AC | 2012 Honda Civic Sedan LX | 2012 Honda Fit DX | 2013 Hyundai Accent Sedan GL | 2013 Hyundai Elentra GL | |||||||||||
6 | MSRP | 21,633 | 23,281 | 30,738 | 25,088 | 21,090 | 20,496 | 24,864 | 22,796 | 23,024 | 21,147 | 20,430 | 23,846 | |||||||||||
7 | Cash Price | 21,633 | 21,781 | 30,738 | 25,088 | 19,090 | 18,247 | 22,864 | 20,796 | 18,935 | 17,758 | 20,430 | 23,846 | |||||||||||
8 | Fuel Economy (l/100km) | 8.10 | 6.80 | 3.80 | 3.70 | 6.40 | 6.20 | 7.40 | 7.50 | 6.40 | 6.30 | 5.90 | 5.90 | |||||||||||
9 | Interest Rate | 0.90% | 0.90% | 2.70% | 4.80% | 0.70% | 0.70% | 0.00% | 0.00% | 1.99% | 3.49% | 1.49% | 0.99% | |||||||||||
10 | Finance Term (months) | 72 | 72 | 72 | 72 | 72 | 72 | 72 | 72 | 72 | 72 | 72 | 72 | |||||||||||
11 | Downpayment Required | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||
12 | Monthly Payment | 308.75 | 332.28 | 462.92 | 405.21 | 299.19 | 290.77 | 345.33 | 322.63 | 340 | 326 | 296.8 | 341.27 | |||||||||||
13 | 8 Year Maintenance | 3300 | 3300 | 3600 | 3600 | 3000 | 3000 | 3600 | 3900 | 3300 | 3300 | 3900 | 3600 | |||||||||||
14 | Insurance Cost | 1430 | 1430 | 1422 | 1383 | 1430 | 1445 | 1320 | 1422 | 1430 | 1438 | 1410 | 1341 | |||||||||||
15 | Finance Information | |||||||||||||||||||||||
16 | Residual Value (9% Dep.) | 6,224 | 6,699 | 9,332 | 8,169 | 6,032 | 5,862 | 6,962 | 6,504 | 6,854 | 6,572 | 5,983 | 6,880 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
17 | Total Purchase Price | 22,230.00 | 23,924.16 | 33,330.24 | 29,175.12 | 21,541.68 | 20,935.44 | 24,863.76 | 23,229.36 | 24,480.00 | 23,472.00 | 21,369.60 | 24,571.44 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
18 | Interest Expense | 597.20 | 2,143.28 | 2,591.76 | 4,087.04 | 2,452.00 | 2,688.94 | 1,999.68 | 2,432.88 | 5,545.00 | 5,714.00 | 939.18 | 725.02 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
19 | Annual Car Payment | 3,705.00 | 3,987.36 | 5,555.04 | 4,862.52 | 3,590.28 | 3,489.24 | 4,143.96 | 3,871.56 | 4,080.00 | 3,912.00 | 3,561.60 | 4,095.24 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
20 | 8 Year Depreciation | 16,005.60 | 17,225.40 | 23,997.77 | 21,006.09 | 15,510.01 | 15,073.52 | 17,901.91 | 16,725.14 | 17,625.60 | 16,899.84 | 15,386.11 | 17,691.44 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
21 | Annual Depreciation | 2,000.70 | 2,153.17 | 2,999.72 | 2,625.76 | 1,938.75 | 1,884.19 | 2,237.74 | 2,090.64 | 2,203.20 | 2,112.48 | 1,923.26 | 2,211.43 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
22 | Annual Depreciation Rate | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! |
23 | Annual Maintenance | 412.50 | 412.50 | 450.00 | 450.00 | 375.00 | 375.00 | 450.00 | 487.50 | 412.50 | 412.50 | 487.50 | 450.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
24 | Annual Fuel Cost (15000km) | 1,579.50 | 1,326.00 | 741.00 | 721.50 | 1,248.00 | 1,209.00 | 1,443.00 | 1,462.50 | 1,248.00 | 1,228.50 | 1,150.50 | 1,150.50 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
25 | Monthly Fuel Cost | 131.63 | 110.50 | 61.75 | 60.13 | 104.00 | 100.75 | 120.25 | 121.88 | 104.00 | 102.38 | 95.88 | 95.88 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
26 | 8 Year Fuel Cost | 12,636.00 | 10,608.00 | 5,928.00 | 5,772.00 | 9,984.00 | 9,672.00 | 11,544.00 | 11,700.00 | 9,984.00 | 9,828.00 | 9,204.00 | 9,204.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
27 | ||||||||||||||||||||||||
28 | Annual Car Expense | 5,422.70 | 5,321.67 | 5,612.72 | 5,180.26 | 4,991.75 | 4,913.19 | 5,450.74 | 5,462.64 | 5,293.70 | 5,191.48 | 4,971.26 | 5,152.93 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
29 | Monthly Car Expense | 451.89 | 443.47 | 467.73 | 431.69 | 415.98 | 409.43 | 454.23 | 455.22 | 441.14 | 432.62 | 414.27 | 429.41 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
30 | 8 Year Cost | 43,381.60 | 42,573.40 | 44,901.77 | 41,442.09 | 39,934.01 | 39,305.52 | 43,605.91 | 43,701.14 | 42,349.60 | 41,531.84 | 39,770.11 | 41,223.44 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
31 | ||||||||||||||||||||||||
32 | ||||||||||||||||||||||||
33 | ||||||||||||||||||||||||
34 | ||||||||||||||||||||||||
35 | ||||||||||||||||||||||||
36 | ||||||||||||||||||||||||
37 | ||||||||||||||||||||||||
38 | ||||||||||||||||||||||||
39 | ||||||||||||||||||||||||
40 | ||||||||||||||||||||||||
41 |