1. Attachments are working again! Check out this thread for more details and to report any other bugs.

2005 Model Year Prius Calculator

Discussion in 'The File Library' started by Kiloran, Nov 4, 2005.

  1. Kiloran

    Kiloran New Member

    Joined:
    Aug 31, 2005
    1,225
    3
    0
    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. B)
    (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.
     
  2. Flivver

    Flivver Junior Member

    Joined:
    Aug 10, 2005
    10
    0
    0
    Location:
    Oregon
    WoW! That really levels the playing field. Wish I'd had it when I was negotiating.
     
  3. John in Portland

    John in Portland New Member

    Joined:
    Oct 22, 2005
    39
    0
    0
    Location:
    Portland Oregon USA
    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).
     
  4. Kiloran

    Kiloran New Member

    Joined:
    Aug 31, 2005
    1,225
    3
    0
    :D
    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.
    :D
     
  5. WackyOne

    WackyOne New Member

    Joined:
    Jul 28, 2005
    28
    0
    0
    Location:
    Mpls, MN
    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.
     
  6. Kiloran

    Kiloran New Member

    Joined:
    Aug 31, 2005
    1,225
    3
    0
    Can do!
     
  7. TonyPSchaefer

    TonyPSchaefer Your Friendly Moderator
    Staff Member

    Joined:
    May 11, 2004
    14,816
    2,498
    66
    Location:
    Far-North Chicagoland
    Vehicle:
    2017 Prius Prime
    Model:
    Prime Advanced
    Very well done!
    Great job.
     
  8. Kiloran

    Kiloran New Member

    Joined:
    Aug 31, 2005
    1,225
    3
    0
    B) 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! B)

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

    acousticbiker New Member

    Joined:
    Sep 12, 2005
    119
    0
    0
    Location:
    Evergreen, CO
    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"?
     
  10. Kiloran

    Kiloran New Member

    Joined:
    Aug 31, 2005
    1,225
    3
    0
    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.
     
  11. Kiloran

    Kiloran New Member

    Joined:
    Aug 31, 2005
    1,225
    3
    0
    15-November-2006 Kiloran replaced file with Version 3.0.
    2006 MY calculator also available.
     
  12. Bionic

    Bionic New Member

    Joined:
    Oct 2, 2005
    129
    0
    0
    Location:
    Delaware
    I placed an order for a 2006MY and took delivery of a 2005MY last friday. The dealer took a little bit off of MSRP for me for taking the earlier model year. He asked me not to advertise this fact, so I'd rather not give out the dealer name, but it's something to keep in mind if you go this route.
     
  13. Kiloran

    Kiloran New Member

    Joined:
    Aug 31, 2005
    1,225
    3
    0
    Edit: Edited for content
     
  14. benandersen

    benandersen New Member

    Joined:
    Feb 26, 2006
    12
    0
    0
    is this a good spot to post the awesome pic I have of my 2005?
     
  15. hycamguy07

    hycamguy07 New Member

    Joined:
    Feb 18, 2006
    2,707
    3
    0
    Location:
    Central Florida
    Vehicle:
    2007 Prius
    Bargaining? Whats that?

    I walked in and insted of waiting on a list I took what ever came in, I just stated I did not want the JBL or leather.. it came into J-ville with everything and when it got to the dealer it had everthing except those 2 items.. it dropped 3k off of the price...

    Here in Fla. a 97'-05' Prius goes from 17.5k to 24k (USED)..

    Good Luck! B)
     
  16. Penguino

    Penguino New Member

    Joined:
    Apr 26, 2006
    1
    0
    0
    Am I still able to download the .xls calculator? Can't find it...