| A | B | C | D | |
|---|---|---|---|---|
1 | FUEL-EFFICIENCY UPGRADE PAY-OFF SCHEDULE | |||
2 | ||||
3 | ||||
4 | ||||
5 | ENTER VALUES | |||
6 | Dollars/Gallon (Fuel) | $2.230 | ||
7 | Miles/Gallon (Current): | 34.000 | ||
8 | Miles/Gallon (Upgraded): | 39.000 | ||
9 | Miles/Year: | 30,000 | ||
10 | Cost of Upgrade: | $500.00 | ||
11 | ||||
12 | FUEL CONSUMPTION | |||
13 | Miles/Gallon | Dollars/Gallon | Miles/Dollar | Dollars/Mile |
14 | 34.000 | $2.230 | 15.24663677 | $0.066 |
15 | 39.000 | $2.230 | 17.48878924 | $0.057 |
16 | ||||
17 | IMPROVEMENTS | |||
18 | Miles/Gallon: | 5.000 | (14.71%) | |
19 | Dollars/Mile: | $0.01 | ||
20 | Savings/Year: | $252.26 | ||
21 | ||||
22 | ||||
23 | Cost of Upgrade: | $500.00 | ||
24 | Miles To Pay Off: | 59,462 | ||
25 | Years To Pay Off: | 2.0 | ||