Rental car excess is one of those decisions people make tired, at a counter, after a flight. It's also a very small data problem: a daily price, the excess you still owe, and the number of days. You can reason about it in ten lines of Python.
The hard part isn't the maths. It's getting numbers you can trust. Most hire companies in Tasmania don't publish their counter cover prices at all; they quote them when you book. One that does is Bargain Car Rentals, so I'll use its published terms as the worked example.
The inputs
For a standard car, Bargain publishes:
Option Price Excess you still owe
Standard excess included A$5,500
Gold Package A$34.99 a day A$2,500
Platinum Package A$44.99 a day A$0
For context, the standard excess at other Hobart and Launceston companies that publish it sits in the same band: A$5,200 at Redspot, A$5,400 at YesDrive, A$5,500 at East Coast Car Rentals (A$6,600 for its larger vehicles).
The model
Two numbers per option: what you pay for the cover, and your worst case if the…