ICE car Cost per Mile Rev 2
Current Gas Cost including externalities = 18 = 18 $
cost per mile= $(R14/R3)+R30 = 1.16 $
average miles per year=12000 = 12,000
miles per day=$R3/365 = 32.88 Miles
miles per gallon=25 = 25 Miles
cost per mile gasoline=R1/R5 = 0.72 $
Cost Per Year Gasoline=R6*R3 = 8,640 $
Time between oil changes=7500 = 7,500
Number of oil changes per year=R3/R8 = 1.6
Cost per Oil Change=50 = 50
Cost per year oil changes=R9*R10 = 80 $
Cost per mile oil=R11/R3 = 0.00666666667
Sub Total cost per year=$R11+R7 = 8,720.00 $
Addional Costs
Yearly Additional Costs=$R22+R28+(R29*365) = 5,398.00 $
Total Yearly Costs=R14+ R16 = 14,118 $
Cost per Mile Yearly=$R17/R3 = 1.18 $
____________________
Engine Tune Ups Miles Between=25000 = 25,000
Engine Tune Up cost=$100 = 100.00 $
Engine Tune up cost per Year=$R3/R20*R21 = 48.00 $
Coolant Replaced Miles=30000 = 30,000 Miles
Coolant flush Cost=$75 = 75.00
Cost per year=$(R3/R23)*R24 = 30.00 $
Tire cost each=$150 = 150.00
Tires miles before replacement=30000 = 30,000
Cost of tire replacement per year=$R26*4*(R3/R27) = 240.00 $
depreciation=$(35000*.73)/(365*5) = 14.00 per day
depreciation per mile=$R29/(R3/365) = 0.43
---
https://instacalc.com/55363