Joined
·
324 Posts
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
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