EV Premium Breakeven Timeline Model
As mentioned in the previous blogpost, here is the model for computing the EV premium breakeven timeline based on monthly commute pattern. Here is how to use it: IC: Input values for Car price, Gas price and approximate mileage of the car. It will compute the cost/KM. EV: Input values for Car price, electricity charging rate, range/charge and battery pack of the car. It will compute the cost/KM. It should be smaller than IC cost/KM for all practical reasons. Note, the battery charge is non-linear especially as the charing tends to reach 80-85% (depending on the car), so, one can use 80% of range/battery-pack values if they plan to use it that way. In any case, one can get a ballpark figure. The EV premium box should be set automatically (with value = EV cost - IC cost). Click on the chart button and it will show a timeline of breaking even cost of the extra premium you paid for the EV. The X axes is the average daily commute in KMs, and Y axes is the...