Don’t waste time trying to decipher a dealer’s worksheet. Otherwise, you’re allowing them to control the deal. They often omit a lot of relevant detail such as the money factor; don’t itemize fees and occasionally make mistakes. Rely on credible outside sources (e.g., LH marketplace, LH signed deals and tips, Edmunds, etc.).
Yes, dealer worksheet input data can be useful. However, all dealer-provided data must be vetted such as acquisition fee, doc fee (regulated by some states), money factor, gov fees, residual, rebates, sales tax rate, etc.). Make sure the residual matches the term and annual mileage requirement. Check available tax credits/incentives via the dealer who may issue tax credits or assess a lower sales tax rate to energize sales for some models (e.g., Texas).
Research selling prices in your market coupled with reasonable expectations. Sometimes, dealers embed rebates in their discount. Keep them separate. Get a list of customer rebates, incentives, and credits (e.g., electric chargers) including VIN-specific discounts, if any. The dealer has such a list. GM calls their list the Customer Incentive Acknowledgement form which includes manufacturer rebate and incentive disclosures. Restrictions may apply to the extent that some rebates may not be disclosed such as college grad, military, educators, AMEX, Costco, etc.
Secure a copy of the factory window sticker. Check for non-factory add-ons or dealer-installed options. If possible, eliminate those you don’t want or need.
Organize all researched and vetted data, example tabled below, with the goal of creating a one-page professional-looking lease proposal that reflects your target deal. The idea is to create your own deal, not replicate or reverse engineer the dealer’s deal.
Using the tabled data, calculate the base payment followed by the One-Pay amount…
.00200 x (31669.00 + 26494.70) + (31669.00 - 26494.70) / 24 = 331.92
One Pay = 24 x 331.92 = 7966.08
Note that the One-Pay amount is 7966.08, not 9637.21. Structuring the lease by paying all fees upfront and using the 6350 rebate as a CCR saves you 362.63. Structure means everything.
??? Let me know.