The formulas used in the calculations are:
\[ \text{excess miles} = s + \left( \frac{s \times t}{T - t} \right) - \left( \frac{A \times T}{12} \right) \]
\[ \text{charge} = \text{excess miles} \times \text{fee} \]
\[ \text{monthly savings} = \frac{\text{charge}}{t} \]
This calculator computes the predicted excess miles, lease-end charge, and monthly savings required based on the input values of total lease term, remaining lease time, current miles driven, annual mileage allowance, and excess distance fee.
Let's assume the following:
First, calculate the excess miles:
\[ \text{excess miles} = 15000 + \left( \frac{15000 \times 6}{24 - 6} \right) - \left( \frac{8000 \times 24}{12} \right) = 4000 \]
Calculate the lease-end charge:
\[ \text{charge} = 4000 \times 0.20 = 800 \]
Calculate the monthly savings required:
\[ \text{monthly savings} = \frac{800}{6} = 133.33 \]
Therefore, the predicted excess miles are 4,000 miles, the lease-end charge is $800, and the monthly savings required are $133.33.