Bimmerfest - BMW Forums - View Single Post - Pen and Pencil Lease Payment Calculation
View Single Post
Old 12-06-2012, 04:38 AM
perlman007 perlman007 is offline
Registered User
Location: Arlington, VA
Join Date: Dec 2012
Posts: 51
Mein Auto: 2015 535xi; 2015 X5
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?

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
Reply With Quote