Nissan Murano Forum banner

1 - 9 of 9 Posts

·
Registered
Joined
·
324 Posts
Discussion Starter #1
Spreadsheet for MSRP/Invoice

Here is EXCEL spreadsheet that I created
to help myself when I go in to the
dealer to find out what the real invoice
and what woudl be the approximate payment.

I use "Doc-to-Go" on my Treo and calculate
the cost at once, I will be able to do the calculation
probably faster than the salesman... :5:

EXCEL Spreadsheet

It's ain't perfect, but it seems to work.

Basic instructions to calculate the cost.

In cells A2 thru A6 put a "1" for the version.
In cells A8-A25 put a "1" in for the options.

Note that some options include other options, see Edmunds URL
Options listed per Edmunds Website

Then add any additional dealer fees or
extended warrenty in cells C29 thru C33

Adjust the tax rate percentage - Cell C36

Add Trade In - Cell C43

Adjust Interest Rate - Cell C44

Adjust Term - Cell C45

If you have any suggestions or
correction let me know and I will
Update the spreadsheet.

This should also work for a Pocket PC.

Mike
 

·
Registered
Joined
·
113 Posts
Very nice.

One error: Cells C27 and C28 only sum starting at row 6, they need to start at row 2.

Again, very nice :)
 

·
Registered
Joined
·
12,512 Posts
wa4qfy-

:29: Nice job!

-njjoe
 

·
Registered
Joined
·
324 Posts
Discussion Starter #4
bkburns said:
Very nice.

One error: Cells C27 and C28 only sum starting at row 6, they need to start at row 2.

Again, very nice :)
It's Corrected now!

Thanks, I figured if I could use it,
maybe someone else could take
advantage of the speadsheet.

I goofed when I added all of the models
to make the form more universal.
Forgot to update the totals...

Mike
 

·
Moderator
Joined
·
5,244 Posts
Nice job!

Look at E2 and F2. There is something wrong. The SMRP is lower than invoice....
 

·
Registered
Joined
·
324 Posts
Discussion Starter #6
Kris said:
Look at E2 and F2. There is something wrong. The SMRP is lower than invoice....
Corrected... THANKS!
Just call this government work :bonk:
 

·
Moderator
Joined
·
5,244 Posts
wa4qfy

Well done! Downloaded again and it works like a champ!
 

·
Registered
Joined
·
324 Posts
Discussion Starter #8
Updated Spreadsheet

After going to a couple of dealers on
Friday and another on Saturday, I
have added a couple of "What If" ?
questions. What if the dealers
says 3% over invoice, then what would
be the real dollars over/under invoice.
Secondly, If you ask the dealer for
Out The Door pricing, what
would be the amount over/under invoice.

I also color coded cells that are calculated
are light yellow, Fixed prices are a
light blue, totals are a light green.
I also protected the calculated cells
so you could not accidentally edit on them.
You can remove protection via,
Format --> Cells --> Protection

Also I forget to add the fixed destination
charge.

Hopefully I am days away from my MO:D
 
1 - 9 of 9 Posts
Top