Is the Zero Drive Off option in the Leasehackr Calculator broken?

When I select the Zero Drive off option, the Total Lease Costs goes down, which is counter intuitive, since now you are rolling the fees into the lease, paying interest on the fees, so the cost should be higher.

See the below example case (Calculator Link below):

  • Paying Drive Offs:

1544 (drive off minus 91 Government Fees) + 23 * 271 (monthly) + 350 (Disposition Fee) = 8127

This is within $24 of the calculated $8135, so I’d assume the difference is the cents on the monthly, no displayed, but taken into consideration in the Total Lease Cost.

  • With Zero Drive Offs

23 * 340 (monthly) + 350 (Disposition Fee) = 8170 - 91 Government Fees = 8179 which is what is calculated.

So in fact, it looks like the monthly, in the Zero Drive Off case, is what is broken. In my own calculator (on Excel), the monthly for this Zero Drive off case is $346.83, not $340.

Paste your particular case. It goes up for me.

Here you go.

Paying Drive offs, Total Cost is $8,135.

Zero Drive off, $8,079

I think you broke it!

Drive-off $1,635 + (23*$271) = $7,868 not $8,135

Something is off with the calc @littleviolette

Based on his calc above…

271*24 (monthly) + 1635 (drive off) =8139, not 8135.

340*24 (monthly) = 8160, not 8079

Unless I’m misinterpreting how you’re calculating

I think the calculator removes the Government Fees and Adds the Disposition Fee, which is fine.

But Zero Drive off should always cost more (interest), never less.

@mp11477. It should be x23, minus Government fees, Plus Disposition fee.

@mp11477

With Drive Offs:

1544 (drive off minus 91 Government Fees) + 23 * 271 (monthly) + 350 (Disposition Fee) = 8127

This is within $24 of the calculated $8135, so I’d assume the difference is the cents on the monthly, no displayed, but taken into consideration in the Total Lease Cost.

With Zero Drive Offs

23 * 340 (monthly) + 350 (Disposition Fee) = 8170 - 91 Government Fees = 8179 which is what is calculated.

So in fact, it looks like the monthly, in the Zero Drive Off case, is what is broken. In my own calculator (on Excel), the monthly for this Zero Drive off case is $346.83, not $340.

Makes sense. Just took a quick glance at it on my phone. Wasn’t able to drill down like that.

@trusted_hackrs

The Leasehackr Calculator is a huge resource for the community.

Can someone double check my math and confirm if we have a glitch or not?

1 Like

@leo_404 Thank you for raising the issue. We will look into it and get back to you ASAP.

The calculator erroneously assumes that the drive-off total would simply roll into the net capitalization cost when the customer elects zero drive-off, but that is not the case for leases where the tax is levied on the total lease payments.

In New York, tax is levied on the sum of the total of the monthly, down payment, incentives, acquisitions, disposition, and any other fees at the inception of the lease. When the calculator rolls in the original drive-off total, it rolls in the taxes and assumes that the tax is levied based on original monthly payment, which is wrong.

Now, a true zero drive-off means $0 upfront, including taxes. This means that the dealer is financing the sales tax. The calculation is tricky because the new monthly payment is based on the amount to be taxed which is also based on the new monthly payment. Example 9 in the document below illustrates one method of computing the taxes and monthly payment:

This gets more complicated as dealers may have different ways of re-computing the monthly charges.

What do you guys think is the best way to handle the monthly payment (and by extension the total lease cost) in the case of zero drive-off where tax is levied on the total lease payment?

Yes, that is similar to how they calculate here in GA.

My excel formulas for the Zero Drive off case are:

Tax = ROUND((((Cap_Cost-Residual)+(Cap_Cost+Residual)MFTerm)/(Term-1-Term*MF)Term)ROUND(1/(1-Tax_Rate),2)Tax_Rate(1+TermMFTax_Rate),2)

Monthly Payment = ROUND(((Cap_Cost+Tax)(1+MFTerm)-Residual*(1-MFTerm))/(Term-1-MFTerm),2)

The numbers match the dealer numbers on a recent contract.

2 Likes

The formulas below apply to a lease originating in NY with zero drive-off (i.e., $0 DAS).

The “tax finance charge” is the interest charge a dealer could assess for lending the sales tax which, quite frankly, I’ve never encountered when I negotiated zero drive-off leases in NY. See Pub 839, Example 9, P. 16-17, lines 1 thru 13.

2 Likes

We attempted to tackle the Zero Drive-off issue in our calculator update. Based on the formulas in Example 9, we recalculate the taxes on the total lease payment (with no interest charge), roll the new tax payment and other drive-off fees into the net cap cost, and recalculate the monthly payment. We hope this would resolve the issue, though the Zero Drive-off calculation has always been tricky as it varies across states.

The updated calculator is now under testing. PM me or @michael if you are interested in participating in the testing stage before the calculator is released to the public. Thank you all for your input to make this community more resourceful!

1 Like