MKenM

Ladies and Gentlemen

11/23/14

This is the 5th model year that I am posting an Excel spreadsheet that will let you figure out what your new car will set you back. It has many of the same features that I had last year. You can download the spreadsheet below. If you need help you can PM me. Anyone who finds any errors can let me know and I will fix and update the spreadsheet and this page. It would be a good idea to subscribe to this thread just in case there are any changes and this way you will be notified.

First a big shout out to Bill S who has been my extra set of eyes through this whole process. Bill caught one minor issue on some optional wheels. Thanks! 11/23/14

Please remember that any discounts shown will probably not be available at most dealerships especially for the Z06.

A new feature - for most selections in column "H" you can select an item and by putting an "x" in the column but if the option is not available or blank pricing won't show up. When selecting a model and trim package you will have to go to the seating chart area and select your seating color and seat type before you see AQ9 GT Buckets or AE4 Competition Seat come up with "Standard" or the additional costs.

The Atlantic and Pacific packages are not available yet so I did not put in the details. Pricing is not available for those two packages.

3/12/15

For those interested I have added an amortization or loan calculator. It may not be exact but it will give you a good idea of your monthly payments if you so choose.

If you are not familiar with Excel or this spreadsheet please read the following:


In column H you will see a Yellow ribbon running from cell H2 to cell H236. To start select the model of the car you want to price out by putting an "x" in column H next to the model. Next select the trim 1LT, 1LZ, 2LT, 2LZ or 3LT, 3LZ by using the same "x" process. Once you select the trim level some of the yellow column will automatically have x's in them to indicate that the option or feature is included in your vehicle selection. In the Yellow column continue putting x’s next to the options that you want. Keep in mind the following:

You must select a model and trim before you will see the seating options.

Once you have selected all your options you can now proceed to the bottom of the page. Column “D” is where you will be working. Cell D239 will give you the MSRP for the vehicle. If you have a trade in cell D240 is the place to put it. At this point in cell D241 you can put in any number you want to indicate the discount you think is fair and reasonable. Cell D242 is where you can show any dealer or GM incentives. You can figure sales tax if you like (you need to change the percentage in column C cell 244) by putting in the percentage for your state. You can then enter Motor Vehicle charges if any.

At this point you need to compare column “D” with Column “F” which represents what is referred to as Dealer Invoice and see where your number is with and without trades and adjusted discounts you are looking for. Column “G” represents something closer to true cost.

Some people say that you can do this online. That maybe true but you can do so much more that I think you will find this tool worthwhile.

Please remember you can only work in the Yellow and Green cells except as noted above (and yes some of the yellow cells are no longer available as they will be selected automatically when you select your trim) you cannot click on any other cells.

This spreadsheet will be added to as new pricing becomes available.

Thank you and enjoy!!!

Gary '09 C6

attachment missing ?

(and yes, Mike, you do great work with these tools !)

zbrett

Download link?

MKenM

Sorry try again.

zbrett

Gary '09 C6

MKenM

ttt

Zymurgy

Link to this thread added to the Manuals, Reference Material, Online Order Guide, Order Tracking, etc. sticky thread.

MKenM

Thank you

Vetteman Jack

Thanks for doing this - nice job.

vette-oholic

so the base z06 has gone up about 2K from 2012... not too bad. why were people freaking out thinking it was going to cost 100K?

arturox2

Thank you!

Suggestion: please change trim codes for Z06 to "1LZ", etc. vs. "1LT", etc.

TeamOGI

Thanks for putting this together; it helped me a lot as I prepared for placing my "Workbench Build" earlier today. I am reviewing the order and for some reason cannot bring up the ZO7 performance package - Can you clue me in on what I am doing wrong?

Jontall

Wow... A loaded Z06 coupe is ~$140,000. That's a lot of money.

MKenM

Thanks that was a cut and paste error.

MKenM

Sounds like you are not using the spreadsheet properly. You are either picking options that are not available or you just picked everything to come up with your cost. In a future release you will not be able to pick options that are not available on the vehicle of your choice.

Sorry the most expensive vehicle ~$100K+-

Bucknut2006

Looks like the base price of the car does not include the $1000 increase. Maybe I'm wrong but I see the Z51 coupe starting at $59k.

MKenM

That is the correct MSRP at this time.

MKenM

The Z07 package is below. Based on what I see the Aero package is only available on a 3LZ package. Hope this helps.

Z07 Performance Package, includes (J57) 4-wheel antilock, 4-wheel disc, carbon ceramic brakes, (FE7) Z07 suspension with Magnetic Selective Ride Control, (XFM) front P285/30ZR19 and rear P335/25ZR20 Michelin Pilot Super Sport Cup 2 summer-only run flat tires, and level 3 Aero Package (splitter end plates and clear adjustable wicker bill)

1 - Requires (CFZ) Carbon Fiber Package or (CFV) Carbon Fiber Visible Package.

Zymurgy

Z06 section does not work correctly. If you select the Z06, it still says Your vehicle Selection Is Invalid. Likewise, picking any trim level in the Z06 section still leaves the Please Select Your Equipment Group.