Notices
S-Class (W222) 2014-2020

Lease calculator / tips

Thread Tools
 
Search this Thread
 
Rate Thread
 
Old Jul 28, 2015 | 04:25 PM
  #1  
jenz's Avatar
Thread Starter
Super Member
 
Joined: Jan 2007
Posts: 766
Likes: 47
S, GL
Lease calculator / tips

I cleaned up my lease calculator to make it user friendly

Windows Excel 2010
https://mega.nz/#!x4IwGT6D!GJsa5MA-M...d3of212iIG-8a8

Google Sheets - go to 'file' then 'download as'
https://docs.google.com/spreadsheets...it?usp=sharing

MSRP, money factor, acquisition fee and other dealer "official" fees are all variables

Your drive off should only be the 1st payment, tax/tag/license, acquisition fee (and other dealer "official" fees if you can't negotiate these to 0) ... note, some states require you to prepay your taxes at drive off

Never put a down payment on a lease; Google it

MF and acquisition fees cannot be negotiated lower than the base rate set by the manufacturer

Double check the dealer's math at drive off ... 100% of the "mistakes" I've seen have been in the dealer's favor

Good luck

Last edited by jenz; Jul 29, 2015 at 11:02 AM.
Reply
Old Jul 29, 2015 | 12:39 AM
  #2  
kath00's Avatar
Member
 
Joined: Jul 2015
Posts: 163
Likes: 4
2016 s550 White/Nut Brown
Perfect timing! Thanks for this!!

Is it common practice to have a MF that is marked up for the sale to make more money? Or is the MF supposed to be a uniform number from dealer to dealer and sale to sale?
Reply
Old Jul 29, 2015 | 09:35 AM
  #3  
jenz's Avatar
Thread Starter
Super Member
 
Joined: Jan 2007
Posts: 766
Likes: 47
S, GL
Residual is the only number that will be the same assuming the car/lease (mileage, years) is the same

Everything else is negotiable and will likely be marked up until you wheel n deal
Reply
Old Jul 29, 2015 | 10:29 AM
  #4  
equetefue's Avatar
Senior Member
 
Joined: Jan 2011
Posts: 413
Likes: 3
17' C43 Sedan
excellent tool. Thanks
Reply
Old Jul 29, 2015 | 12:18 PM
  #5  
newyorktoLA's Avatar
MBWorld Fanatic!
15 Year Member
Liked
Loved
Community Favorite
 
Joined: Jun 2009
Posts: 1,300
Likes: 127
2020 G63, 2021 E450 All-Terrain Wagon
Originally Posted by kath00
Perfect timing! Thanks for this!!

Is it common practice to have a MF that is marked up for the sale to make more money? Or is the MF supposed to be a uniform number from dealer to dealer and sale to sale?
The MF is standard depending on mileage/term of lease. My salesperson ALWAYS shows me the MF book they get from MBUSA. It's a chart with the money factors laid out in a grid for the mileage and term. Just ask to see the money factor book they get from corporate and that'll show you the MF you pay
Reply
Old Jul 29, 2015 | 01:38 PM
  #6  
jenz's Avatar
Thread Starter
Super Member
 
Joined: Jan 2007
Posts: 766
Likes: 47
S, GL
Originally Posted by amaycg
The MF is standard depending on mileage/term of lease. My salesperson ALWAYS shows me the MF book they get from MBUSA. It's a chart with the money factors laid out in a grid for the mileage and term. Just ask to see the money factor book they get from corporate and that'll show you the MF you pay
I'm being exact so as not to confuse people ... the residual is the only item that will never be marked up

MF and acquisition fees have base numbers set by MBFS ... IIRC as of today the 'top-tier or buy-rate' MF is around 0.00062 and acquisition fee is 795 for a S550 ... you cannot negotiate either of these lower than these corporate base levels

Dealers (legally) can and will mark up both MF and acquisition fees for extra profit unless you negotiate them lower ... how much lower depends on a lot of things - your relationship with the dealer, time of year, time of month, corporate incentives and credit score plays a big part, too, ie a 600 is never going to receive the top-tier/buy-rate MF
Reply
Old Jul 29, 2015 | 10:12 PM
  #7  
Wolfman's Avatar
Super Moderator
MBWorld Ambassador

20 Year Member
Loved
Community Favorite
 
Joined: May 2002
Posts: 10,537
Likes: 3,669
From: Land of 10,000 lakes
AMG GTC Roadster, E63s Ed.1, M8 Comp. Coupe
Originally Posted by amaycg
The MF is standard depending on mileage/term of lease. My salesperson ALWAYS shows me the MF book they get from MBUSA. It's a chart with the money factors laid out in a grid for the mileage and term. Just ask to see the money factor book they get from corporate and that'll show you the MF you pay
Jenz is spot on. Dealers also have no issues doubling the buy-rate to their retail rate.
By default nobody will be offered the buy rate. There will always be a mark-up. Your negotiating skills reduces that mark-up.

MB also has no issues printing (suggested) retail rates for their dealers...
Reply

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 


You have already rated this thread Rating: Thread Rating: 0 votes,  average.


All times are GMT -4. The time now is 06:49 PM.

story-0
6 Mercedes Models That Did NOT Age Well (But Are Somehow Still Cool)

Slideshow: Not every Mercedes design becomes timeless, some feel stuck in the era they came from.

By Verdad Gallardo | 2026-05-12 18:09:07


VIEW MORE
story-1
Manual Mercedes? 6 Times Sindelfingen Let Drivers Have All The Fun

Slideshow: Yes, Mercedes built manual cars, and some of them are far more interesting than you'd expect.

By Verdad Gallardo | 2026-05-02 12:36:58


VIEW MORE
story-2
Mercedes SLR McLaren 722 S Is Extremely Rare Example Modified by McLaren

Slideshow: A one-of-one U.S.-spec Mercedes-Benz SLR McLaren Roadster became even rarer after a factory-backed transformation at McLaren's headquarters.

By Verdad Gallardo | 2026-04-29 11:19:28


VIEW MORE
story-3
8 Classic Boxy Mercedes Designs That Have Aged Like Fine Wine

Slideshow: Before curves took over, Mercedes mastered the art of the straight line, and some of those shapes still look right today.

By Verdad Gallardo | 2026-04-25 12:05:49


VIEW MORE
story-4
Flawlessly Restored Mercedes 190E Evo II Heads to Auction

Slideshow: The 190E Evolution II shows how a homologation necessity became a six-figure collector icon.

By Verdad Gallardo | 2026-04-22 17:53:47


VIEW MORE
story-5
Electric Mercedes C-Class Unveiled: 11 Things You Need to Know

Slideshow: Mercedes is turning one of its core nameplates electric, and the details show just how serious this shift is.

By Verdad Gallardo | 2026-04-21 13:58:06


VIEW MORE
story-6
Mercedes EQS Gets A Major Update: Everything You Need to Know

Slideshow: Faster charging, longer range, and a controversial steer-by-wire system define the latest evolution of Mercedes-Benz EQS.

By Verdad Gallardo | 2026-04-15 10:35:34


VIEW MORE
story-7
5 Underrated Mercedes-Benz Models That Don't Get the Love They Deserve

Slideshow: These overlooked Mercedes-Benz models never got the spotlight, but they quietly delivered more than most remember.

By Verdad Gallardo | 2026-04-13 19:35:45


VIEW MORE
story-8
Mercedes 300D Has Pushed Well Past 1 Million Miles and It Ain't Stopping

Slideshow: A well-used 1991 Mercedes-Benz 300D with more than one million miles is now looking for a new owner, and it still appears ready for more.

By Verdad Gallardo | 2026-04-10 10:05:15


VIEW MORE
story-9
10 Most Reliable Mercedes-Benz Models You Can Buy Used

Slideshow: From bulletproof sedans to surprisingly tough SUVs, these Mercedes models proved that the three-pointed star can go the distance.

By Verdad Gallardo | 2026-04-08 09:55:49


VIEW MORE