2005 Model Year Prius Calculator

[Kiloran]

I made this spreadsheet so I could have it with me on my laptop when I went to negotiate with the salesman so I could get numbers quickly for various configuration changes he might have tried to push on me.

He seemed content to sell me the model I had come in for so I got less use out of it than I anticipated.

Last week another PC user asked me if I could post it here.
I looked at it and decided it needed to be made more general before I would feel comfortable posting it.

So, after a bit of work, here it is.
I hope it helps some of you.

I plan on producing a 2006 MY calculator along these lines when the 2006 pricing is released.
(11-25 Kiloran - This has been done: 2006 Model Year Prius Calculator, Excel Spreadsheet)

================================================== =
11-November-2005 Kiloran replaced file in original posting with newer revision.
15-November-2005 Kiloran replaced file with Version 3.0.
2006 MY calculator also available.
16-February-2006 Edited for content. File temporarily unavailable: Version 3.0 - 216 downloads.
28-April-2006 Version 3.0 restored.

[Flivver]

WoW! That really levels the playing field. Wish I'd had it when I was negotiating.

[John in Portland]

Thank you very much Kiloran for this superb effort. Those of interested in purchasing a 2006 Prius will be waiting and hoping for your revisions.

May I make a minor suggestion for the next revision that perhaps could help in others using a printed version of this spreadsheet in dealer negotiations?

Right now, the Destination Charge is shown in cell M3. The only way to tell that this mandatory charge is included in the Total "Deal at MSRP" cell (Cell H21) is to look at the formula in that cell. If I were to show a printout of this to a dealer in negotiations, knowing how slippery many of them are, I'm sure that they would try to argue that this charge needs to be added into the "Deal at MSRP" cell.

I suggest that insteaed, you include the Destination Charge in column H, maybe right beneath the "National Base Price" number. That way, anyone eyeballing the printout of this spreadsheet would clearly see that the destination charge really is included. This might save some arm wrestling.

Thank you again for the time and effort you have put into this spreadsheet. I definitely plan on using it when I go to buy a Prius in early 2006. (Thanks also for the 2006 Federal tax credit explanation).

[Kiloran]

Originally posted by John in Portland@Nov 4 2005, 12:26 PM
Right now, the Destination Charge is shown in cell M3.  The only way to tell that this mandatory charge is included in the Total "Deal at MSRP" cell (Cell H21) is to look at the formula in that cell.  If I were to show a printout of this to a dealer in negotiations, knowing how slippery many of them are, I'm sure that they would try to argue that this charge needs to be added into the "Deal at MSRP" cell.

I suggest that insteaed, you include the Destination Charge in column H, maybe right beneath the "National Base Price" number.  That way, anyone eyeballing the printout of this spreadsheet would clearly see that the destination charge really is included.  This might save some arm wrestling.

[snapback]150525[/snapback]

I am looking forward to incorporating feedback from PC members.
I'll wait a day or two for suggestions to come in then I'll look into releasing version 2.

Already, it occurred to me that I probably didn't have to assign a password when I protected the sheet.
I'll probably remove that with the next release.

Y'all are welcome.
I've certainly got plenty of useful information for myself from this site.

[WackyOne]

For those of us in states with non integer tax rates, you probably should change the formatting of cell C31 to show at least one decimal place. Overall very nice.

[Kiloran]

Originally posted by WackyOne@Nov 4 2005, 04:05 PM
For those of us in states with non integer tax rates, you probably should change the formatting of cell C31 to show at least one decimal place. Overall very nice.

[snapback]150663[/snapback]

Can do!

[TonyPSchaefer]

Very well done!
Great job.

[Kiloran]

I incorporated the changes suggested by WackyOne and John in Portland.
Thanks for the feedback!

For MY 2006, I have MSRP for the base model and the 8 packages.
I don't yet have MSRP for the a-la-carte options.

I have the invoice price for the base model but don't yet have invoice prices for the remainder.
I have it from a reliable source that this information will be available by November 24, 2005.

Use in good health!

================================================== =
11-November-2006 Kiloran moved revised file to original posting.
================================================== =

[acousticbiker]

Wow, I am very impressed, Kiloran! The only question I have is: how many of you have actually found this useful when most dealers are charging MSRP or more? Have any of you guys actually been able to "bargain"?

[Kiloran]

Originally posted by acousticbiker@Nov 12 2005, 06:32 PM
Wow, I am very impressed, Kiloran! The only question I have is: how many of you have actually found this useful when most dealers are charging MSRP or more? Have any of you guys actually been able to "bargain"?

[snapback]154744[/snapback]

Thanks!

Sadly, I suspect it may not be much help in bargaining until dealers have 2006 MY Prii available on their lots.
It might be helpful in getting the price down on the non-package options, especially those that can be removed, i.e. mats, cargo net, first aid...

It might be a useful tool in deciding which package you can afford at MSRP.
I certainly used it this way.

I am hopeful that my 2006 MY calculator (when I have acquired invoice prices) will be useful when bargaining on Prius prices returns.