ALJLSahara
Member
Ok, here you go - be sure to read the notes in the spreadsheet.
Also, I recommend checking out Edmunds.com for an article they have on calculating your payment yourself, by hand (also included in the Notes section of my attached spreadsheet. This is the article I used to build the spreadsheet. It's helpful to work through the exercise once by hand (using the Edmunds guide) - this gave me a much better understanding of what is going into my payment and how the lease deal works.
I would not expect the numbers to match your deal to the penny, or even to the dollar - these should be directionally accurate estimates, though. I tried multiple lease calculators online, and nothing will match 100% of what your dealer comes up with - which at the end of the day (right or wrong) is what matters. Everything else is just a tool to help you and the dealer agree on the terms.
Some dealers calculate residual off of MRM, some do not. Fees will vary from dealer to dealer, state to state, and lease to lease. Tax of course varies, as does MSRP, negotiated purchase price, etc.
If any mistakes are found in the spreadsheet, please report them to me.
Sponsored