# Can we add mileage reductions for demo cars?

Can you add mileage reductions the calculator to help reflect the new cost and residual ?

1 Like

Good idea, and Ford MSDâ€™s

Also for us lazy folk, a separate total for drive offs without MSDâ€™s included. Dealers are always asking for this.

Also, when you focus on the input fields can you not have it auto delete the numbers already entered?

Residual % can be reduced with mileage reduction amount.

Suppose Residual % is 63. Residual % for Demo/Loaner car would be 63 - ((# of miles -500)*.25/MSRP)

For Example: MSRP is 60,000 and assume there are 5000 miles on the car. Then residual deduction is (5000-500)*.25 = 4500 * 0.25 = 1125

You new residual % will be = 63 - (1125/MSRP) = 63 - 1125/6000 = 63 - 0.1875 = 62.81

Use 62.81 instead of 63% in residual % on calculator

I think he understands how to calculate it, it would just be easier to type it into a field. Kind of the point of a calculator!

I think we should also have a way to â€śsaveâ€ť a deal in the calculator and you can link it around the forum (maybe even embed it!) â€¦ trying to avoid volunteering for this

So, you can do something like
http://leasehackr.com/calculator/1111

or something like
http://leasehackr.com/calculator/Ed_Churchward/1,
http://leasehackr.com/calculator/Ed_Churchward/2, etc.

That would be a great idea. At the moment. I use one note to store all the cars I look at and get a quote. So I can compare and contrast and store the figures.

I just add to the selling price whatever â€śpenaltyâ€ť the miles provide.

Taking SUVâ€™s example from above, if the car has 5000 miles which translates to a penalty of \$1125, I just add that to the selling priceâ€¦

You can use a spreadsheet like this:

Edit cells G3 and G4 if BMWâ€™s demo mileage adjustment formula is different from M-B

1 Like