Amount due is Capitalized Cost Reduction (i.e. down payment to reduce the Capitalized Cost). Also the acquisition fee can either be rolled into the lease (capitalized) or paid upfront. You can put it in one place or the other, but obviously not both. Decide what works best for you.
Originally Posted by perlman007
So, I really like the paper form, and have been rebuilding it in Excel for my own exercise (I can post if anyone wants). I am confused by section 4 "Amount Due Dealer" -- why is this so high, am I doing something wrong? The way I read it, the whole adjusted capitalized cost (1K) is due to the dealer upfront, this cannot be correct. Also, why does the BMWFS (on the sheet as "LRFS") assignment fee show up down here as well as the first section?
4. AMOUNT DUE DEALER
A. Adjusted Capitalized Cost (Line 1K) $ $46,111
B. First Monthly Payment/Advance Payment $ - $537.14
C. Security Deposit/Last Monthly Payment $ - $3,850.00
D. Tax on Capitalized Cost Reduction $ -
E. BMWFS Assignment Fee $ - $725
G. Other_________________ $ $342.50
H. Dealer Reserve (see reverse) $
I. Net Amount Due to Dealer (Sum of 4A through 4H) $ $51,565
2013 BMW 335xi Sedan
Estoril Blue / Black Leather
6MT, M-Sport, Premium Pkg, Cold Weather Pkg, Dynamic Handling Pkg, Tech Pkg, HK Sound, M Performance Exhaust, M Performance Power Kit
Former: 2011 335xi Coupe -- 2009 MCS JCW -- 2006 MZ4 -- 2002 325i -- 1997 318ti -- 1991 318i