Building a Motor Vehicle Lease ... Data Collection and Calculations

Wiki
1

Here is a synopsis of the subject matter content in the below pdf…

  1. Researching and organizing data using a tabular matrix useful in creating a comprehensive professional-looking one-page lease proposal.
  2. Optimal treatment of rebates and capitalized cost reductions (CCR).
  3. Formulas for calculating payments and the CCR.
  4. Creating the lease inception fee matrix.
  5. Creating the lease proposal.
  6. Suggested strategies that dealers can’t resist.
  7. A final look… finding the least cost lease.

Building a Motor Vehicle Lease- Data Collection and Calculations.pdf (403.6 KB)

16 Likes
2

Needs be stickied !
Awesome compilation which would help a lot of members (specially newer members) on learning how to calculate deals without just throwing a dart in the air.

3 Likes
3

Many thanks for your kind comments. I hope it gets a lot of views.

2 Likes
4

Don’t forget - ???s

:joy:

1 Like
5

Great compilation, good work !

Tutuapp

1 Like
6

Thanks for your kind words and encouragement.

7

This is gold. I have my own calculator on an excel that I’ve updated over the years but this is way more structured and actually shows the calcs. :clap:

1 Like
8

Many thanks for your kind words. :smiley:

9

I took a look at this based on your suggestion. Very interesting and seems quite useful.

Looking at the CCR calculation. What is R? All the other variables are labeled throughout, but I couldn’t figure out what R was. I tried plugging in residual value (labeled as RV) but my lease inception fees didn’t quite add up as cleanly as yours did.

EDIT: I think I flipped a + for a - somewhere. I’m getting the expected numbers now!

10

Thank you for pointing that out… my bad. Yes, R is the residual value… forgot the V.

11

Hi @delta737h, thanks for sharing this. It is an interesting read and great refresher. I’m trying to recreate your CCR calculation in Excel (below) and my answer is a bit off. My formular might be wrong, but do you have an Excel formular template you could share?

image
image621×243 9.57 KB

12

Your formula is incorrect. Input the formula exactly the way it is written below with cells named appropriately…

image
image426×132 1.99 KB

I don’t have an excel spreadsheet. I use Mathematica instead. Sorry.

1 Like