Lease mileage overage versus buying extra miles · Calculation guide

Calculate saving from buying extra miles.

Calculation guide

Use all distances in miles over the full contract. Purchased extra miles are nonrefundable; excess beyond the expanded allowance is charged at the regular overage rate.

saving = max(0,forecast-allow)*over-extra*prepaid-max(0,forecast-allow-extra)*over; normal = max(0,forecast-allow)*over; with_extra = normal-saving

Inputs

Expected total miles

Example entry 38000.

Included miles

Example entry 36000.

End-of-lease fee per excess mile

Example entry 0.25 (in the selected currency).

Extra miles to buy

Example entry 3000.

Prepaid cost per extra mile

Example entry 0.12 (in the selected currency).

Worked example

InputValue
Expected total miles38,000
Included miles36,000
End-of-lease fee per excess mile0.25
Extra miles to buy3,000
Prepaid cost per extra mile0.12
ResultValue
Saving from buying extra miles140
Overage without purchase500
Cost with prepaid miles360

Calculation steps

Saving from buying extra miles = (((max(0, (Expected total miles − Included miles)) × End-of-lease fee per excess mile) − (Extra miles to buy × Prepaid cost per extra mile)) − (max(0, ((Expected total miles − Included miles) − Extra miles to buy)) × End-of-lease fee per excess mile))

(((max(0, (38,000 − 36,000)) × 0.25) − (3,000 × 0.12)) − (max(0, ((38,000 − 36,000) − 3,000)) × 0.25)) = 140

Overage without purchase = (max(0, (Expected total miles − Included miles)) × End-of-lease fee per excess mile)

(max(0, (38,000 − 36,000)) × 0.25) = 500

Cost with prepaid miles = (Overage without purchase − Saving from buying extra miles)

(500 − 140) = 360

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Expected total miles38,00041,800Saving from buying extra miles140390
Included miles36,00039,600Saving from buying extra miles140-360
End-of-lease fee per excess mile0.251.25Saving from buying extra miles1402,140
Extra miles to buy3,0003,300Saving from buying extra miles140104
Prepaid cost per extra mile0.121.12Saving from buying extra miles140-2,860
Lease mileage overage versus buying extra miles →