If you sign up for $1.2k monthly payments …. But yeah, the money factor looks off.
Looks like they clean up their data in excel before uploading it.
I’m not well-versed on the database query stuff you’re utilizing here but really appreciate what you’re doing. I’ve thought for a while now that some sort of tool that could pinpoint leasing “sweet-spots” each month would be a great asset, and it seems like that’s possible what you’re getting at.
To be clear, I think it’s some kind of problem with my script. When you enter new numbers in the calculator, it makes 4 or 5 queries to get all the new numbers. I’m just guessing but I bet one of those failed and my script wasn’t smart enough to notice.
Yes, that’s the idea. It’s not perfect but the Edmunds calculator seems like a good starting place.
I think I may have fixed the Trailhawk bug. I think somehow one of the pages failed to update before, so it used a number from the much more expensive Trackhawk. I think it should raise an exception now if that happens.
{'Jeep, Grand Cherokee, 2021, 80th Anniversary Edition 4dr SUV (3.6L 6cyl 8A)': {'invoice': 44633.0,
'leaseparams': {'acquisitionFee': 595,
'moneyFactor': 0.00018,
'residualValue': 0.5,
'termInMonths': 39},
'monthly': 497.45,
'msrp': 46480.0,
'totalleasecost': 18284.4},
'Jeep, Grand Cherokee, 2021, 80th Anniversary Edition 4dr SUV 4WD (3.6L 6cyl 8A)': {'invoice': 46608.0,
'leaseparams': {'acquisitionFee': 595,
'moneyFactor': 0.00018,
'residualValue': 0.51,
'termInMonths': 39},
'monthly': 514.04,
'msrp': 48480.0,
'totalleasecost': 18894.75},
'Jeep, Grand Cherokee, 2021, Freedom 4dr SUV (3.6L 6cyl 8A)': {'invoice': 39968.0,
'leaseparams': {'acquisitionFee': 595,
'moneyFactor': 0.00039,
'residualValue': 0.48,
'termInMonths': 39},
'monthly': 538.86,
'msrp': 40930.0,
'totalleasecost': 19807.97},
'Jeep, Grand Cherokee, 2021, Freedom 4dr SUV 4WD (3.6L 6cyl 8A)': {'invoice': 42107.0,
'leaseparams': {'acquisitionFee': 595,
'moneyFactor': 0.00033,
'residualValue': 0.49,
'termInMonths': 39},
'monthly': 508.95,
'msrp': 43050.0,
'totalleasecost': 18707.43},
'Jeep, Grand Cherokee, 2021, High Altitude 4dr SUV (3.6L 6cyl 8A)': {'invoice': 50670.0,
'leaseparams': {'acquisitionFee': 595,
'moneyFactor': 0.0025,
'residualValue': 0.48,
'termInMonths': 39},
'monthly': 912.09,
'msrp': 52900.0,
'totalleasecost': 33538.31},
'Jeep, Grand Cherokee, 2021, High Altitude 4dr SUV 4WD (3.6L 6cyl 8A)': {'invoice': 55021.0,
'leaseparams': {'acquisitionFee': 595,
'moneyFactor': 0.0002,
'residualValue': 0.49,
'termInMonths': 39},
'monthly': 714.46,
'msrp': 57495.0,
'totalleasecost': 26268.85},
'Jeep, Grand Cherokee, 2021, Laredo E 4dr SUV (3.6L 6cyl 8A)': {'invoice': 36369.0,
'leaseparams': {'acquisitionFee': 595,
'moneyFactor': 0.00039,
'residualValue': 0.48,
'termInMonths': 39},
'monthly': 455.93,
'msrp': 37590.0,
'totalleasecost': 16756.61},
'Jeep, Grand Cherokee, 2021, Laredo E 4dr SUV 4WD (3.6L 6cyl 8A)': {'invoice': 38705.0,
'leaseparams': {'acquisitionFee': 595,
'moneyFactor': 0.00033,
'residualValue': 0.49,
'termInMonths': 39},
'monthly': 465.85,
'msrp': 39985.0,
'totalleasecost': 17121.7},
'Jeep, Grand Cherokee, 2021, Laredo X 4dr SUV (3.6L 6cyl 8A)': {'invoice': 41014.0,
'leaseparams': {'acquisitionFee': 595,
'moneyFactor': 0.00039,
'residualValue': 0.48,
'termInMonths': 39},
'monthly': 521.24,
'msrp': 42090.0,
'totalleasecost': 19159.4},
'Jeep, Grand Cherokee, 2021, Laredo X 4dr SUV 4WD (3.6L 6cyl 8A)': {'invoice': 43243.0,
'leaseparams': {'acquisitionFee': 595,
'moneyFactor': 0.00033,
'residualValue': 0.49,
'termInMonths': 39},
'monthly': 526.63,
'msrp': 44310.0,
'totalleasecost': 19357.96},
'Jeep, Grand Cherokee, 2021, Limited 4dr SUV (3.6L 6cyl 8A)': {'invoice': 43777.0,
'leaseparams': {'acquisitionFee': 595,
'moneyFactor': 8e-05,
'residualValue': 0.48,
'termInMonths': 39},
'monthly': 522.94,
'msrp': 45530.0,
'totalleasecost': 19222.42},
'Jeep, Grand Cherokee, 2021, Limited 4dr SUV 4WD (3.6L 6cyl 8A)': {'invoice': 45241.0,
'leaseparams': {'acquisitionFee': 595,
'moneyFactor': 6e-05,
'residualValue': 0.49,
'termInMonths': 39},
'monthly': 524.6,
'msrp': 46960.0,
'totalleasecost': 19283.28},
'Jeep, Grand Cherokee, 2021, Limited X 4dr SUV (3.6L 6cyl 8A)': {'invoice': 47518.0,
'leaseparams': {'acquisitionFee': 595,
'moneyFactor': 8e-05,
'residualValue': 0.48,
'termInMonths': 39},
'monthly': 581.23,
'msrp': 49685.0,
'totalleasecost': 21367.03},
'Jeep, Grand Cherokee, 2021, Limited X 4dr SUV 4WD (3.6L 6cyl 8A)': {'invoice': 49464.0,
'leaseparams': {'acquisitionFee': 595,
'moneyFactor': 6e-05,
'residualValue': 0.49,
'termInMonths': 39},
'monthly': 588.62,
'msrp': 51655.0,
'totalleasecost': 21638.87},
'Jeep, Grand Cherokee, 2021, Overland 4dr SUV (3.6L 6cyl 8A)': {'invoice': 49614.0,
'leaseparams': {'acquisitionFee': 595,
'moneyFactor': 0.0025,
'residualValue': 0.48,
'termInMonths': 39},
'monthly': 891.16,
'msrp': 51725.0,
'totalleasecost': 32768.46},
'Jeep, Grand Cherokee, 2021, Overland 4dr SUV 4WD (3.6L 6cyl 8A)': {'invoice': 52015.0,
'leaseparams': {'acquisitionFee': 595,
'moneyFactor': 0.0002,
'residualValue': 0.49,
'termInMonths': 39},
'monthly': 668.21,
'msrp': 54155.0,
'totalleasecost': 24566.89},
'Jeep, Grand Cherokee, 2021, SRT 4dr SUV 4WD (6.4L 8cyl 8A)': {'invoice': 75084.0,
'leaseparams': {'acquisitionFee': 595,
'moneyFactor': 0.0025,
'residualValue': 0.52,
'termInMonths': 39},
'monthly': 1332.58,
'msrp': 78405.0,
'totalleasecost': 49009.23},
'Jeep, Grand Cherokee, 2021, Summit 4dr SUV (3.6L 6cyl 8A)': {'invoice': 54714.0,
'leaseparams': {'acquisitionFee': 595,
'moneyFactor': 0.0025,
'residualValue': 0.46,
'termInMonths': 39},
'monthly': 995.05,
'msrp': 57120.0,
'totalleasecost': 36590.85},
'Jeep, Grand Cherokee, 2021, Summit 4dr SUV 4WD (3.6L 6cyl 8A)': {'invoice': 60237.0,
'leaseparams': {'acquisitionFee': 595,
'moneyFactor': 0.00058,
'residualValue': 0.48,
'termInMonths': 39},
'monthly': 844.54,
'msrp': 63025.0,
'totalleasecost': 31054.26},
'Jeep, Grand Cherokee, 2021, Trackhawk 4dr SUV 4WD (6.2L 8cyl S/C 8A)': {'invoice': 91038.0,
'leaseparams': {'acquisitionFee': 595,
'moneyFactor': 0.0025,
'residualValue': 0.53,
'termInMonths': 39},
'monthly': 1603.11,
'msrp': 95515.0,
'totalleasecost': 58962.8},
'Jeep, Grand Cherokee, 2021, Trailhawk 4dr SUV 4WD (3.6L 6cyl 8A)': {'invoice': 49125.0,
'leaseparams': {'acquisitionFee': 595,
'moneyFactor': 7e-05,
'residualValue': 0.49,
'termInMonths': 39},
'monthly': 614.58,
'msrp': 51135.0,
'totalleasecost': 22593.98}}
Now it creates a link to the leasehackr calculator because why not?
{'Jeep, Grand Cherokee, 2021, 80th Anniversary Edition 4dr SUV (3.6L 6cyl 8A)': {'govfees': 144.0,
'incentives': '5750',
'invoice': 44633.0,
'leaseparams': {'acquisitionFee': 595,
'moneyFactor': 0.00018,
'residualValue': 0.5,
'termInMonths': 39},
'monthly': 497.45,
'msrp': 46480.0,
'sellingprice': '46103',
'totalleasecost': 18284.4,
'url': 'https://leasehackr.com/calculator?make=Jeep&miles=10000&msrp=46480.0&sales_price=46103&months=39&mf=0.00018&msd=0&dp=0&dealer_fee=85&acq_fee=595&disp_fee=395&taxed_inc=5750&untaxed_inc=0&rebate=0&resP=50.0®_fee=144.0&sales_tax=9&demo_mileage=0&memo=&monthlyTax_radio=true&bmw_demo_25=true'},
2 Likes
I’m trying to avoid using Edmunds lease calculations so that I can easily compute lease payments for all terms. (I could also do this by making a request for each lease term, but I’m trying not to be too disruptive)
But some of the tax information is a bit suspect. So I’m just playing around on a lease and here are some numbers:
monthlyPayment: 666.4
monthlyPaymentDelta: 63.61
monthlyPaymentWithTaxes: 730.01
netCapCost: 43162
nonCapitalizedTaxesAndFees: 0
taxes: {citySalesTax: 0, combinedSalesTax: 1486.3, countySalesTax: 0, districtSalesTax: 0,…}
citySalesTax: 0
combinedSalesTax: 1486.3
countySalesTax: 0
districtSalesTax: 0
gasGuzzlerTax: 0
stateSalesTax: 1486.3
totalLeaseCost: 24771.6
totalTaxesAndFees: 2225.3
I live in Pennsylvania, and taxes are 9% on the monthly payment. 666.4 * 1.09 = 726.38, which is close to their 730.01.
But if you dive into the sales tax, it says it is 1486.3. But 666.4 * 0.09 * 36 = 2159.14, which is nowhere near that? 1486 is about 6% of the total lease cost, which is the general sales tax in PA…
The calculator prominently displays the incorrect tax number of 1486, but seems to get the monthly payment approximately right. 
Here’s the new output with monthly payments AND leasehackr calculator links for each term length.
Caveat: Assumes incentives do not change for different terms. Taxes are wrong for incentives.
'Subaru, Ascent, 2022, Onyx Edition 4dr SUV AWD (2.4L 4cyl Turbo CVT)': {'allterms': {24: {'fees': 739.0,
'mf': 0.0026,
'monthly': 591.5822933333334,
'monthlywithtax': 655.1161935097379,
'months': 24,
'rv': 0.73,
'url': 'https://leasehackr.com/calculator?make=Subaru&miles=10000&msrp=39120.0&sales_price=37828.0&months=24&mf=0.0026&msd=0&dp=0&dealer_fee=0&acq_fee=595&disp_fee=395&taxed_inc=0.0&untaxed_inc=0&rebate=0&resP=73.0®_fee=144.0&sales_tax=10.739655478600604&demo_mileage=0&memo=&monthlyTax_radio=true&bmw_demo_25=true&dealerFee_check=false&govFee_check=false'},
36: {'fees': 739.0,
'mf': 0.00165,
'monthly': 470.5639722222222,
'monthlywithtax': 521.1009216453067,
'months': 36,
'rv': 0.65,
'url': 'https://leasehackr.com/calculator?make=Subaru&miles=10000&msrp=39120.0&sales_price=37828.0&months=36&mf=0.00165&msd=0&dp=0&dealer_fee=0&acq_fee=595&disp_fee=395&taxed_inc=0.0&untaxed_inc=0&rebate=0&resP=65.0®_fee=144.0&sales_tax=10.739655478600604&demo_mileage=0&memo=&monthlyTax_radio=true&bmw_demo_25=true&dealerFee_check=false&govFee_check=false'},
39: {'fees': 739.0,
'mf': 0.00165,
'monthly': 470.64505358974355,
'monthlywithtax': 521.1907108723572,
'months': 39,
'rv': 0.62,
'url': 'https://leasehackr.com/calculator?make=Subaru&miles=10000&msrp=39120.0&sales_price=37828.0&months=39&mf=0.00165&msd=0&dp=0&dealer_fee=0&acq_fee=595&disp_fee=395&taxed_inc=0.0&untaxed_inc=0&rebate=0&resP=62.0®_fee=144.0&sales_tax=10.739655478600604&demo_mileage=0&memo=&monthlyTax_radio=true&bmw_demo_25=true&dealerFee_check=false&govFee_check=false'},
48: {'fees': 739.0,
'mf': 0.002,
'monthly': 519.6007666666667,
'monthlywithtax': 575.4040988708341,
'months': 48,
'rv': 0.49,
'url': 'https://leasehackr.com/calculator?make=Subaru&miles=10000&msrp=39120.0&sales_price=37828.0&months=48&mf=0.002&msd=0&dp=0&dealer_fee=0&acq_fee=595&disp_fee=395&taxed_inc=0.0&untaxed_inc=0&rebate=0&resP=49.0®_fee=144.0&sales_tax=10.739655478600604&demo_mileage=0&memo=&monthlyTax_radio=true&bmw_demo_25=true&dealerFee_check=false&govFee_check=false'}},
'govfees': 144.0,
'incentives': 0.0,
'invoice': 36648.0,
'leaseparams': [{'acquisitionFee': 595,
'moneyFactor': 0.0026,
'residualValue': 0.73,
'termInMonths': 24},
{'acquisitionFee': 595,
'moneyFactor': 0.00165,
'residualValue': 0.65,
'termInMonths': 36},
{'acquisitionFee': 595,
'moneyFactor': 0.002,
'residualValue': 0.49,
'termInMonths': 48},
{'acquisitionFee': 595,
'moneyFactor': 0.00165,
'residualValue': 0.62,
'termInMonths': 39}],
'monthlytaxpercent': 0.10739655478600604,
'msrp': 39120.0,
'sellingprice': 37828.0},
So here’s an example “sweet spot” I found by looking over all Jeep models and trims:
If the $5000 of incentives is accurate, this seems like a pretty good deal. Sadly, looking at the Edmunds incentives shows stacking of IDL + Chrysler lease incentives. Yet another example of the Edmunds calculator being useful but not perfect.
I ended if it’s possible to run the values through the leasehakr calc as well and then add the leasehakr score to the dataset.
Leasehackr score is insignificant and meaningless, its been discussed many times, there’s no reason to involve that at all. Same goes for the 1% rule.
In the grand scheme of things, I agree. But in this specific case it could be an easy way to find outliers.
1 Like
I already did that 
Similar in that this stuff get’s a little over my head however I do appreciate the efforts of the Techcrew and @edmcman on efforts like this to improve the forum as a whole!
Thanks!!
1 Like
If legit, here is a decent looking deal IMHO:
'Nissan, LEAF, 2022, S 4dr Hatchback (electric DD)': {24: {'fees': 743.0,
'leasehackr': 9.299126480616497,
'mf': 0.00115,
'monthly': 227.67335833333334,
'monthlywithtax': 254.28015612672584,
'months': 24,
'rv': 0.78,
'url': 'https://leasehackr.com/calculator?make=Nissan&miles=10000&msrp=28375.0&sales_price=28618.0&months=24&mf=0.00115&msd=0&dp=0&dealer_fee=0&acq_fee=650&disp_fee=395&taxed_inc=3100.0&untaxed_inc=0&rebate=0&resP=78.0®_fee=93.0&sales_tax=11.686390532544378&demo_mileage=0&memo=&monthlyTax_radio=true&bmw_demo_25=true&dealerFee_check=false&govFee_check=false&memo='},
Doh, should have paid more attention. Would it make sense to dump the results out to some kind of flat file so that we can look at the broad set without having to request the edmunds db?
Also, for me it would be interesting (though probably it would be a slightly different set) to compare the advertised residuals with expected market value residuals to see which banks and brands support their RVs more that others.
Yeah, that’s kind of what I was thinking. I’m a bit worried that if I try to query all cars Edmunds will catch on and ban me. But I was thinking of dumping information for a couple brands that people are interested in, and then sharing that.
Where can you get expected market residuals? From a third party bank?
Either that or look at 3 year old compatibles and kbb? I wonder if there is a good 3rd party calculator to “query”
1 Like
If anyone has any brands or models they want me to dump, let me know.
Edit: Oh, one problem with this is that it is dependent on location 
I guess let me know your zip too.
Let’s start with the basic ones … BMW X5 and x7 in 02468
Also maybe Audi Q7 and Lincoln Aviator in same.