MKenM

Another year a new spreadsheet. This one is for the 2013 model year. It has many of the same features that I had last year and this year I added a little extra. 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 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.

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

This is how it works; to start there is an example of a Grand Sport. In column G you will see a Yellow ribbon running from cell G2 to cell G122. To start delete all the x’s. Next select the model of the car you want to price out by putting an x in column G next to the model. Next select the trim 1LT, 2LT etc. by using the same x process. Once you select the trim level a column will appear to the right of all the options. If you are not familiar with what the options are for each model this will help. In the Yellow column start putting x’s next to the options that you want. Keep in mind the chart on the right and note the following:

A = Available option for that model and trim level
- = Not available for that model and trim level.
S = Standard for that model and trim level and should NOT be selected

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 D125 will give you the MSRP for the vehicle. If you have a trade in cell D126 is the place to put it. At this point in cell D128 you can put in any number you want to indicate the discount you think is fair and reasonable. Cell D127 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 130) 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 “E” 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 “F” 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.

Make you best deal and Happy Car Hunting

Mike M.

Gary '09 C6

thx !

okc329

Nice tool. Do you happen to have one for the 2010 model year. I would like to run my 2010 thru it as I think I got a super deal.

Thanks.

Speedforhire

I don't thank yur plyin' yself Smoky...............LOL!

MKenM

These sheets only apply to new vehicles as it does not take into account depreciation. Unless you're looking to see if you got a good deal in 2010?

MKenM

???

okc329

That is exactly what I want to know. I have a 2010 C6 convertible purchased new in Aprill 2011.

Thanks.

Gary '09 C6

^ aren't you just going to aggravate yourself at this point ? It's water over the dam already...?

ThrottleUp

MKenM,

Thanks for going through all the hard work this must have been. It works a lot easier than the build function on Chevy, that's for sure

Question, wasn't the MSRP on the 427 Convertible 1YG67 $75,925? Your sheet shows $76,900. But since you asked we point out any possible errors I thought I'd mention it.

Again thanks for doing this on your own.

RAVEN007

Thanks for helping us out with the spread sheet.
I usually start out with USAA's figures and got my custom 2010 for $1,500 over invoice.
Go to my Garage for specific figures.

Z06-1

Kool spread sheet.

MKenM

Thanks for pointing that out. I was off on the other base models by $75 plus the 427. Must have been bleary eyed.

SEE THE NEW VERSION OF THE SPREADSHEET ABOVE

maxp

thanks - are the numbers the same for 2012's? I would think so with no price increase.

MKenM

Most base prices are up $75. LT2 pkg is up $50 plus other minor adjustments. My 2012 GS with options for 2013 is about $400+ more.

So, a small increase none the less.

maxp

OK, thanks. I'm looking at some 2012's in inventory and was checking dealer cost

LooseScrew

Nice job again, Mike. Last years was great. This years is even better. Thanks.

MKenM

If you want I have the 2012 version of the spreadsheet.

NOMRW8NG

Even nicer than last year's! Super job.

Thanks, Mike!

Larry

MKenM

Thanks Larry, just a little side job to amuse myself. Hoping one of these days we can meet up for a run.

MM

MKenM

Just want to give everyone a chance to look at this if they are interested.