| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | |||||||||||||||
2 | |||||||||||||||
3 | |||||||||||||||
4 | |||||||||||||||
5 | year 0 | year 1 | year 2 | year 3 | year 4 | year 5 | year 6 | year 7 | year 8 | year 9 | year 10 | ||||
6 | |||||||||||||||
7 | Plug In Prius C | ||||||||||||||
8 | Car Cost | $ (21,000) | |||||||||||||
9 | % Trips Electric | 100.0% | 100.0% | 100.0% | 100.0% | 100.0% | 100.0% | 100.0% | 100.0% | 100.0% | 100.0% | ||||
10 | % Trips Gas | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | ||||
11 | MPG | 53.0 | 53.0 | 53.0 | 53.0 | 53.0 | 53.0 | 53.0 | 53.0 | 53.0 | 53.0 | ||||
12 | MP kWh | 4.0 | 4.0 | 4.0 | 4.0 | 4.0 | 4.0 | 4.0 | 4.0 | 4.0 | 4.0 | ||||
13 | Miles Per Year | 12,000 | 12,000 | 12,000 | 12,000 | 12,000 | 12,000 | 12,000 | 12,000 | 12,000 | 12,000 | ||||
14 | Inflation | 3.0% | 3.0% | 3.0% | 3.0% | 3.0% | 3.0% | 3.0% | 3.0% | 3.0% | |||||
15 | Electricity Price per kWh | $ 0.30 | $ 0.31 | $ 0.32 | $ 0.33 | $ 0.34 | $ 0.35 | $ 0.36 | $ 0.37 | $ 0.38 | $ 0.39 | ||||
16 | Price per Gallon | $ 4.00 | $ 4.12 | $ 4.24 | $ 4.37 | $ 4.50 | $ 4.64 | $ 4.78 | $ 4.92 | $ 5.07 | $ 5.22 | ||||
17 | Power Cost pa | $ (900) | $ (927) | $ (955) | $ (983) | $ (1,013) | $ (1,043) | $ (1,075) | $ (1,107) | $ (1,140) | $ (1,174) | ||||
18 | Fuel Cost pa | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 | ||||
19 | Cashflows | $ (21,000) | $ (900) | $ (927) | $ (955) | $ (983) | $ (1,013) | $ (1,043) | $ (1,075) | $ (1,107) | $ (1,140) | $ (1,174) | |||
20 | Cumulative Cash | $ (21,000) | $ (21,900) | $ (22,827) | $ (23,782) | $ (24,765) | $ (25,778) | $ (26,822) | $ (27,896) | $ (29,003) | $ (30,143) | $ (31,317) | |||
21 | |||||||||||||||
22 | 0.07 | $ (26,288) | -$0.075 | ||||||||||||
23 | |||||||||||||||
24 | Corolla | ||||||||||||||
25 | Car Cost | $ (18,300) | |||||||||||||
26 | MPG | 26.0 | 26.0 | 26.0 | 26.0 | 26.0 | 26.0 | 26.0 | 26.0 | 26.0 | 26.0 | ||||
27 | Miles Per Year | 12,000 | 12,000 | 12,000 | 12,000 | 12,000 | 12,000 | 12,000 | 12,000 | 12,000 | 12,000 | ||||
28 | Inflation | 3.0% | 3.0% | 3.0% | 3.0% | 3.0% | 3.0% | 3.0% | 3.0% | 3.0% | |||||
29 | Price per Gallon | $ 4.00 | $ 4.12 | $ 4.24 | $ 4.37 | $ 4.50 | $ 4.64 | $ 4.78 | $ 4.92 | $ 5.07 | $ 5.22 | ||||
30 | Fuel Cost pa | $ (1,846) | $ (1,902) | $ (1,959) | $ (2,017) | $ (2,078) | $ (2,140) | $ (2,204) | $ (2,271) | $ (2,339) | $ (2,409) | ||||
31 | Cashflows | $ (18,300) | $ (1,846) | $ (1,902) | $ (1,959) | $ (2,017) | $ (2,078) | $ (2,140) | $ (2,204) | $ (2,271) | $ (2,339) | $ (2,409) | |||
32 | Cumulative Cash | $ (18,300) | $ (20,146) | $ (22,048) | $ (24,006) | $ (26,024) | $ (28,101) | $ (30,242) | $ (32,446) | $ (34,717) | $ (37,055) | $ (39,464) | |||
33 | -$0.153846153846154 | ||||||||||||||
34 | 0.07 | $ (30,769) | Gas prices | http://www.mytravelcost.com/petrol-prices/ | |||||||||||
35 | Hybrid | ||||||||||||||
36 | |||||||||||||||
37 | Savings to Buying a Plug-in Prius vs Corolla - 12k mi per annum, 3% fuel price growth | Implied $/Gallon of Power Electric Drive | |||||||||||||
38 | Gas Price | Fuel Efficiency - Gas Only | |||||||||||||
39 | Hybrid | $ 2.0 | $ 3.0 | $ 4.0 | $ 5.0 | $ 6.0 | $ 7.0 | 20.0 | 30.0 | 40.0 | |||||
40 | $0.300 | ICE | Hybrid | Hybrid | Hybrid | Hybrid | Hybrid | $ 0.30 | $ 1.2 | $ 1.8 | $ 2.4 | ||||
41 | $0.275 | ICE | Hybrid | Hybrid | Hybrid | Hybrid | Hybrid | $ 0.25 | $ 1.0 | $ 1.5 | $ 2.0 | ||||
42 | Electricity Price | $0.250 | ICE | Hybrid | Hybrid | Hybrid | Hybrid | Hybrid | $/kWh | $ 0.20 | $ 0.8 | $ 1.2 | $ 1.6 | ||
43 | Rate | $0.225 | ICE | Hybrid | Hybrid | Hybrid | Hybrid | Hybrid | Power | $ 0.15 | $ 0.6 | $ 0.9 | $ 1.2 | ||
44 | $0.200 | Hybrid | Hybrid | Hybrid | Hybrid | Hybrid | Hybrid | $ 0.10 | $ 0.4 | $ 0.6 | $ 0.8 | ||||
45 | $0.175 | Hybrid | Hybrid | Hybrid | Hybrid | Hybrid | Hybrid | $ 0.05 | $ 0.2 | $ 0.3 | $ 0.4 | ||||
46 | National Comps | USA | Japan | Australia | UK / EU |