Bimmerfest - BMW Forums - View Single Post - Pen and Pencil Lease Payment Calculation
View Single Post
Old 09-03-2006, 02:31 AM
SwampDaddy SwampDaddy is offline
Officially Welcomed to the 'Fest
Location: Houston, TX
Join Date: Jun 2006
Posts: 294
Mein Auto: 2011 335is (for sale)
Smile HELP! I need help with lease calculations!!!

I'm trying to get a good handle on a previous Texas-based lease deal so that I can apply that knowledge to a 335 (ED) deal that I will negotiate this month.

The previous deal (X3) has the following numbers from the lease agreement that I'd like to be able to plug into a spreadsheet or be able to compute via pencil and paper. Yet, my efforts so far do not yield the same numbers that the BMW dealer generated originally or the corrected numbers that BMWFS provided.

Please show me how to calculate such a lease--THANKS!

Trade Val. 6000.00
Due at Signing 8500.00
Monthly Payment 447.11 (Later changed to 437.38 via BMWFS).
Cont. Tot. Pmts. 17,457.25 (Later changed to 17,057.82 via BMWFS).
Disposition Fee 350.00
Cont. Total Pmts 23340.18 (total of all payments at lease end...)

Cap. Cost Red. 5370.84
Sec. Deposit 2500.00
Title Fees 34.00
License Fees 98.05
Doc. Fee 50.00

Gross Cap Cost. 43,482.13 (39,842 (Agreed Val.) + Other stuff)
Adj. Cap. Cost 38,111.29
Residual Val. 26,744.25 (should be 65%)
Depreciation, etc. 11,367.04
Rent Charge 6070.25 (Later changed to 5,690.78 via BMWFS).
Tot. Base M. Pmts. 17,437.29
Lease Term 39 Months

Agreed Value 39,842.00
Sales Tax 2115.13 (Remember this is TEXAS--So calc. accordingly)
MBP Contract 700.00 (Mechanical Breakdown Protection, err wheel thingy)
Aquisition Fee 825.00
Total 43,482.13

BTW: the MF should be .0024 or .0028.

I will attempt to attach my current Excel SS efforts... Please change the file ending from ".pdf" to ".zip".

Anyway, Many thanks!!!

Attached Files
File Type: pdf Lease_WS_RJB.pdf (10.3 KB, 593 views)
Reply With Quote