Spreadsheet looks good with a couple of exceptions:
1. The higher MSRP is also likely to lead to a higher resale value. i.e. - you’ll recapture some of the premium when you sell the vehicle.
2. There is a tangible reduction in other maintenance and wear costs, such as brakes. The hybrids use “regenerative” braking whereby the braking power is actually the generator load recharging the battery, until you’re below about 5 mph, when the brake pads then contact the rotors.
I have a Lexus RX400h, and it came with an 8-year full warranty on the batteries, so I don’t care if they fail or corrode - I don’t plan on keeping it 8 full years and, until then, it’s their problem.
My expectation is that I’ll either break even on the premium, or come out somewhat ahead due to the resale premium.
If failure occurs at 4 years, are you entitled to a replacement of a NEW battery system at ZERO cost to you, or:
1- a charge of 50% of replacement cost for a new system.
2- a replacement that is a "factory refurbished" system at ?? cost?
Option #1 could be expensive if the MSRP for a new system is $9,000.
Option #2 could be as satisfactory as them giving you the sleeves out of their vest.