What is a car lease worksheet?

I have your KTL Leasing System. And I am getting lots of lease worksheets. But they all look different. How do I know what a real lease worksheet looks like?

As a KTL client of mine, you know we get dozens and dozens of local (and regional) dealerships to send us their lowest price…

And we use a lease worksheet so it comes to us in writing.

But:

Just about every lease worksheet is different.

Here are 24 different lease worksheets that have crossed my desk…

Let me deconstruct each one and reveal the important stuff to look for:

2017 Audi A6 2.0 Premium lease worksheet

Audi A6 2.0 Premium 2017 lease worksheet

This lease features a monthly price [A] of $497.75. The “Out Of Pocket” required down payment [B] is $1,113.80 – sign and drive.

The term on this lease is 36 months [C]. And this lease’s mileage allowance is limited to 10,000 miles per year [D].

The Retail Price (a.k.a. MSRP) [E] is $53,135.00 – which almost exactly matches the 1% rule.

Bottom line: this is an OUTSTANDING lease worksheet.

BMW 340i 2016 lease worksheet

BMW 340i 2016 lease worksheet

This lease features a monthly price [A] of $479.13. The “Due on Delivery” required down payment [B] is $3,000.00.

The term on this lease is 36 months [C]. And this lease’s mileage allowance is limited to 10,000 miles per year [D].

The Retail Price (a.k.a. MSRP) [E] is $53,395.00…

So:

When we add the down payment [B] into the monthly payment [A], it comes out to approximately $571.00 monthly.

And when we divide the total monthly payment into the MSRP [F] of $53,395, this is super close to meeting the 1% rule.

2017 BMW X5 lease worksheet

BMW X5 2017 lease worksheet

This lease features a monthly price [A] of $698.98. The “Due on Delivery” required down payment [B] is $5,500.00.

The term on this lease is 36 months [C]. And this lease’s mileage allowance is limited to 15,000 miles per year [D].

The Market Value (a.k.a. MSRP) [E] is $60,145.00…

So: when we add the down payment into the monthly payment, it comes out to approximately $851 monthly.

Bottom line: this is a HORRIBLY EXPENSIVE lease. The monthly payment is 1.41% of the MSRP – not good.

2016 BMW 340i lease worksheet

BMW X5 i35 2WD 2017 lease worksheet 2

This lease features a monthly price [A] of $693.86. The “Customer Cash” required down payment [B] is $6,187.86.00.

The term on this lease is 36 months [C]. And this lease’s mileage allowance is limited to 12,000 miles per year [D].

The Mileage reading [E] is just 10 miles. This is unusual to find on a lease worksheet. Most lease worksheets hide the mileage. At just 10 miles, we now this car is a new as it gets.

We do not know the MSRP, so we cannot figure out if this meets (or exceeds) the 1% rule.

2017 Cadillac XT5 lease worksheet

Cadillac XT5 2017 lease worksheet

This “Lease Buyers Order” doubles as a lease worksheet.

It features a monthly price [A] of $693.86. The down payment [B] (a.k.a. “Paid from Proceeds of Deal”) is $840.44.

The term on this lease is 36 months [C]. And this lease’s mileage allowance is limited to 12,000 miles per year [D].

I can tell that this is a sign and drive deal. We only pay the first monthly payment plus drive off fees.

2017 CHEVROLET TRAVERSE LT lease worksheet

CHEVROLET TRAVERSE LT 2017 lease worksheet

This lease worksheet features a monthly price [A] of $230.45. The down payment [B] (a.k.a. “Paid from Proceeds of Deal”) is $1,000.00.

The term on this lease is 24 months [C]. And this lease’s mileage allowance is limited to 12,000 miles per year [D].

If we can get the dealership to give us a true sign and drive deal on this, this would be the deal of the century ata .62% of MSRP [E].

2017 Chevy Volt lease worksheet

Chevy Volt 2017 lease worksheet

This lease worksheet features a monthly price [A] of $191.83. The down payment [B] (a.k.a. “Due on Delivery”) is $943.98.

The term on this lease is 36 months [C]. And this lease’s mileage allowance is limited to 12,000 miles per year [D].

This lease worksheet gives us a nice surprise: we get the car’s expected residual value [E] after 36 months at $17,047.50. This helps us figure out if we can make a profit at the end of the term and “flip” the lease.

The MSRP on this car is $34,095…

And once again, this lease could be the deal of the century at .56% of the MSRP. (Most electric cars are heavily discounted these days – they are not selling well at all.)

2017 Dodge Charger SRT Hellcat lease worksheet

Dodge Charger SRT Hellcat 2017 lease worksheet 1

This lease worksheet features a monthly price [A] of $605.17. The down payment [B] is not displayed.

The term on this lease is 36 months [C]. And this lease’s mileage allowance is not displayed either…

One quick look at the Dodge special offer’s webpage shows they usually lease their cars with a 10,000 mile/year cap:

Dodge lease mileage limit

This lease worksheet gives us the car’s “Adj Res“. This is the “Adjustable Residual Value” [D] after 36 months at $47,824. This helps us figure out if we can make a profit at the end of the term and “flip” the lease.

The MSRP [E] on this car is $74,725…

So when we divide the monthly payment of $605.17 into the MSRP of $74,725, this lease smashes the 1% rule (at .81%).

2017 Genesis G90 lease worksheet

Genesis G90 2017 lease worksheet

This lease worksheet features a monthly price [A] of $737.89. The “Customer Cash Down” (i.e. down payment) [B] is $1,000.

(This looks likes a sign and drive deal.)

The term on this lease is 36 months [C]. And this lease’s mileage allowance [D] is not displayed either..

This lease worksheet gives us the car’s Residual Value [E] after 36 months at $33,934. This helps us figure out if we can make a profit at the end of the term and “flip” the lease.

The MSRP [F] on this car is $72,200…

So when we divide the monthly payment of $737.89 into the MSRP of $72,200, this lease is slightly higher than the 1% rule (at 1.02%)

2017 Hyundai Elantra Sport lease worksheet

Hyundai Elantra Sport 2017 lease worksheet

This lease worksheet features a monthly price [A] of $175.56. The “Due on Delivery” (i.e. down payment) [B] is $500…

But:

This client of mine got this car as a true sign and drive – the dealership paid all the drive off fees. He got this car without putting a penny down. And was billed a month later for his first payment.

The term on this lease is 36 months [C]. And this lease’s mileage allowance is limited to 12,000 miles per year [D].

This lease worksheet gives us the car’s Residual Amount [E] after 36 months at $13,085.80. This helps us figure out if we can make a profit at the end of the term and “flip” the lease.

The MSRP [F] on this car is $25,165…

So when we divide the monthly payment of $175.56 into the MSRP of $25,165, this lease smashes the 1% rule (at .698%)

2016 Hyundai Genesis lease worksheet

Hyundai Genesis 2016 lease worksheet
This lease features a monthly price [A] of $318.94. The “Due on Deliv” a.k.a. down payment [B] is $1,195.
The term on this lease is 36 months [C]. (But this lease’s mileage allowance is missing.)

This lease worksheet gives us the car’s Residual Amount [D] after 36 months at $24,600.70. This helps us figure out if we can make a profit at the end of the term and “flip” the lease.

We do not know the MSRP, so we cannot figure out if this meets (or exceeds) the 1% rule.

2017 INFINITI Q60 RedSport lease worksheet

INFINITI Q60 RedSport 2017 lease worksheet

This lease features a monthly price [A] of $594.

This is a $0 cash down true sign and drive lease.

The term on this lease is 39 months [C] – this is standard for most INFINITI leases. And this lease’s mileage allowance is limited to 12,000 miles per year [D].

This lease worksheet gives us the car’s Residual Amount [E] after 39 months at $31,800. This helps us figure out if we can make a profit at the end of the term and “flip” the lease.

When we divide the monthly payment of $594 into the MSRP [F] of $56,785, we are a hair above the 1% rule.

2017 INFINITI QX60 lease worksheet

INFINITI QX60 2017 lease worksheet

This lease features a monthly price [A] of $368.64.

The “Total Drive Off” (i.e. down payment) needed is $3,469.39.

The term on this lease is 39 months [C] – again, this is standard for most INFINITI leases. And this lease’s mileage allowance [D] is not displayed… usually INFINITI leases are 10,000 miles per year:

INFINITI lease milles limit

This lease worksheet gives us the car’s Residual Amount [E] after 39 months at $27,575.40. This helps us figure out if we can make a profit at the end of the term and “flip” the lease.

I always recommend leasing with no cash down. So we can roll the Total Drive Off of $3,469.39 into the cap cost of the lease. this adds about $100 extra monthly…

When we divide the monthly payment of $468.64 ($368.64 plus $100 “rolled in”) into the MSRP [F] of $49,240, we are below the 1% rule (.95%).

2016 Lexus CT 200h lease worksheet

Lexus CT 200h 2016 lease worksheet

This lease features a monthly price [A] of $240.

The “Due on Delivery” (i.e. down payment) needed is $999.98.

(This is most likely a sign and drive lease).

The term on this lease is 36 months [C]. And this lease’s mileage allowance is limited to 12,000 miles per year [D].

This lease worksheet gives us the car’s Residual Amount [E] after 36 months at $19,673.60. This helps us figure out if we can make a profit at the end of the term and “flip” the lease.

When we divide the monthly payment of $240 into the MSRP [F] of $29,779.75, we are well below the 1% rule (.81%).

2017 Mercedes-Benz C43 lease worksheet

Mercedes Benz C43 2017 lease worksheet

This is the most fascinating lease worksheet I have ever laid eyes on…

It seems to give a ton of information.

But in reality, it is another dealership magic trick.

Because it gets us to zoom to the lowest price on the lease worksheet – $690.86. This is for 48 months with a limit of 10,000 miles per year.

But:

Leasing for 48 months is a big no no.

Why?

Because after 40 months, the car starts to get super expensive. We need to replace brakes, tires, timing belts – even cabin air filters. And maintenance can be equally expensive.

Mercedes-Benz C43 coupe lease worksheet

Mercedes Benz C43 coupe lease worksheet

This lease worksheet features a monthly price [A] of $748.48. The “Due on Delivery” (i.e. down payment) [B] is $0. Because the “Amount Due At Start” is canceled out by the “CashUse/Surplus (W) amount. So this is a true sign and drive lease.

The term on this lease is 36 months [C]. And this lease’s mileage allowance is limited to 12,000 miles per year [D].

This lease worksheet gives us the car’s Residual Amount [E] after 36 months at $35,917.75. This helps us figure out if we can make a profit at the end of the term and “flip” the lease.

When we divide the monthly payment of $748.48 into the MSRP [F] of $65,305, we are well above the 1% rule (1.15%).

This is not a great lease… but this is typical for Mercedes.

2016 Mini Countryman lease worksheet

Mini Countryman loaded 2016 lease worksheet 2

When we take a look at this lease worksheet, we see this car already logged 6,452 miles.

Is this used? Technically it is not. It is a program car. And in this case, she looked for a program car (because there was a delay in production of the 2017 Mini Countryman).

This lease worksheet features a monthly price [A] of $282. The “Due on Delivery” (i.e. down payment) [B] is $666. This was a sign and drive – my client paid the first month payment in advance ($282) plus $384 in “fees.”

The term on this lease is 36 months [C]. And this lease’s mileage allowance is limited to 10,000 miles per year [D].

2017 Nissan Pathfinder SL lease worksheet

Nissan Pathfinder SL 2017 lease worksheet

This lease worksheet features a monthly price [A] of between $388 and $398. Why the range? Because the monthly price might be up to $10 a month higher based on this person’s credit score.

The “Cash Down” (i.e. down payment) [B] is $388. (This looks like a sign and drive.)

The term on this lease is 36 months [C]. And this lease’s mileage allowance is limited to 12,000 miles per year [D].

When we divide the (worst-case scenario) monthly payment of $398 into the MSRP [E] of $39,660, we are exactly at the 1% rule (1.00%).

2017 Nissan Rogue SV lease worksheet

Nissan Rogue SV 2017 lease worksheet
This lease worksheet features a monthly price [A] is $272.62.

The “Amount Due At Start” (i.e. down payment) [B] is $1,200. This looks like a sign and drive lease. Because a normal downpayment is at least $1,999.99.

The term on this lease is 36 months [C]. And this lease’s mileage allowance is not displayed [D]. Nissan’s standard is 10,000 miles per year:

Nissan lease mileage limit

This lease worksheet gives us the car’s “Lease-end Value” (a.k.a. Residual Amount) [E] after 36 months at $16,959.55. This helps us figure out if we can make a profit at the end of the term and “flip” the lease.

When we divide the monthly payment of $272.62 into the MSRP [F] of $28,745, we lower than the 1% rule (.95%).

2017 Nissan Rogue S lease worksheet

Nissan Rogue S 2017 lease worksheet 2

This lease worksheet features a monthly price [A] is $241.64.

The “Security Deposit” (i.e. down payment) [B] is $0 cash down. This is a true sign and drive lease.

The term on this lease is 36 months [C]. And this lease’s mileage allowance is limited to 12,000 miles per year [D].

This lease worksheet gives us the car’s “Residual Balance” (a.k.a. Residual Amount) [E] after 36 months at $15,367.10. This helps us figure out if we can make a profit at the end of the term and “flip” the lease.

When we divide the monthly payment of $241.64 into the MSRP [F] of $26,495.00, we come in a bit lower than the 1% rule (.912%).

2017 Nissan Rogue SV heated seats lease worksheet

Nissan Rogue SV heated seats 2017 lease worksheet 2
This lease worksheet features a monthly price [A] is $288.47.
The “Security Deposit” (i.e. down payment) [B] is $0 cash down. This is a true sign and drive lease.

The term on this lease is 36 months [C]. And this lease’s mileage allowance is limited to 12,000 miles per year [D].

This lease worksheet gives us the car’s “Residual Balance” (a.k.a. Residual Amount) [E] after 36 months at $16,655.70. This helps us figure out if we can make a profit at the end of the term and “flip” the lease.

When we divide the monthly payment of $288.47 into the MSRP [F] of $28,230.00, we meet the 1% rule almost exactly.

2017 Toyota RAV4 Limited Hybrid lease worksheet

Toyota RAV 4 Limited Hybrid 2017 lease worksheet

This lease worksheet features a monthly price [A] is $364.

The “Security Deposit” (i.e. down payment) [B] is $0 cash down. This is a true sign and drive lease.

The term on this lease is 36 months [C]. And this lease’s mileage allowance is limited to 12,000 miles per year [D].

The Mileage [E] is just 6 miles. This means this car is brand new. It probably has never been test driven. (It is certainly not a program car).

Since we do not have the MSRP on the lease worksheet, we have to do a little sleuthing to find it…

We simply enter the VIN number in our favorite search engine to find it. The MSRP was $34,030..

So, when we divide the monthly payment of $364 into the MSRP of $34,030, we get close to the 1% rule (1.07%).

This lease worksheet gives us the car’s “Residual Balance” (a.k.a. Residual Amount) [E] after 36 months at $16,655.70. This helps us figure out if we can make a profit at the end of the term and “flip” the lease.

When we divide the monthly payment of $288.47 into the MSRP [F] of $28,230.00, we meet the 1% rule almost exactly.

2017 Toyota RAV4 EV lease worksheet

Toyota RAV4 EV 2017 lease worksheet

This lease worksheet features a monthly price [A] is $432.78.

The “Out of Pocket” (i.e. down payment) [B] is $0 cash down. This is a true sign and drive lease.

The term on this lease is 36 months [C]. And this lease’s mileage allowance is limited to 12,000 miles per year [D].

And when we divide the monthly payment of $432.78 into the MSRP [E] of $35,284.00, we are not even close to the 1% rule (1.23%).

This is not a good lease worksheet. The monthly price should be lower than $353 to meet theĀ 1% rule.