I must be doing something wrong with the spreadsheet.
A 2015 335xi has a base of $45,750. Options total $6800, so that's 53.5K plus the usual fees, most of which are taxable at 8.875%, including up front sales tax.
With no cap cost, and no trade-in, the spreadsheet gives me a lease payment of $663.78. My contract for 36months/12K miiles, which has no security deposit mentioned, has a payment of $572.40.
Note that I haven't paid a security deposit on any of the BMWs I've purchased or leased since the very first one, in December 1996. Perhaps that field should be modifiable?
In any case, with such a big payment difference, should I be worried about being blindsided at closing? I assume the residual to be 70% tomake my nymbers work. Is that out of line??
Last edited by alocksley; 06-21-2015 at 03:33 PM.