If anyone wants it, I created a spreadsheet that looks at the cost breakdown for NGC submissions. Here's a link to a Google Sheets spreadsheet to help you decide if it's worth it to submit your coins to NGC, and if so, which tier to submit your coins into. This spreadsheet includes most costs, including the exact shipping, handling fee, etc. - it doesn't include atypical costs such as over-sized slabs and imaging services. Basically, if the cost table is not shown on the right, those services aren't included in the cost analysis. NGC's inputs are the tables on the right, your inputs are in the center table, and the cost output is on the left. All you have to do is add in the variables at the center of the sheet (i.e. # of coins, # of VarietyPlus, etc.), found under the heading, "NGC Submission Totals" (boxed below in red). Note, Google Sheets is a free spreadsheet platform for everyone! Please do not physically alter the formulas or move cells on the spreadsheet in the link, as that's the main copy (EDIT: permission level changed to "View Only"). Rather, copy and paste the cells into a new Google Sheets spreadsheet under your own free account. If you want to simply play around with the five variables, then that's fine. And obviously, grading, shipping, etc. prices can change - this sheet is up to date as of today, 30 January 2018.
Wow! Thanks for the advice and I will be sure to save that spreadsheet and the formulas to an excel sheet. Thanks again! It's awesome to share this kind of info with everyone on here!
I recommend that you make it so no one can change or alter it because someone is going to end up griefing it.
Now if someone wants to have it, click "Files" on the top right and scroll down to "Download as". You can then re upload it to your google doc/sheets or just keep the file on your computer.
I added some more variables and made the cells a little more dynamic, so be sure to save the new one! This is what it looks like now:
Good decision. Never give the internet the ability to edit something unless you want it to be an absolute mess by the end of the day
OK, I updated the Sheet again for easier viewing and maintenance. I'll work on a PCGS version if you guys want.
OK I added a PCGS version, too, so copy or download that one if you guys want! It's a nice way to easily see a cost comparison between the big two TPGs.
This is really great work, thanks. Some suggestions for future improvements: It would be nice if you added order data in a row instead of in those 2 columns, with the ability to add additional rows. You could get an automatic total for the cost of the order in that row, the per coin cost for the order in that row, and a columnar grand total for the entire submission and perhaps average cost per coin. It could be something like a block of say 10 rows to allow for up to 10 orders on the same submission to be calculated together. This would be handy, since they make you break up your submission by service type etc. I can count the number of times I've only had one order on a submission by itself on zero hands. Most of the time I have at least 5 (US, world, world gold, crossover, designation review, tokens/medals, etc.) all submitted together on one submission but broken up into different orders. The other reason for doing this is to support ship with submissions, where you have multiple orders with an instruction for them to wait to ship out together to save on shipping costs. This impacts the total cost, the actual shipping cost per order, and therefore also the cost per coin. It doesn't let you get an accurate picture of the costs if you're only looking at a single order in a vacuum. For example, if I'm creating a submission to NGC consisting of an order with 9 coins and a total value of $1500 along with a second order with 11 coins and a total value of $500, and I do a ship with instruction on the entire submission, the total shipping cost will be $38, but your spreadsheet would tell me it is $61 since I have to enter them independently of each other, which throws off the total cost and cost per coin. I could enter the aggregate info of 20 coins worth $2000 to get the correct shipping, but since they will necessarily be different services, the fees will be different and it would still be incorrect.
Excellent work - the Sheets utility is a great little tool for all sorts of applications - I use it to keep an inventory of my 90+% silver - one sheet per type, i.e. Mercury dimes, 1964 halves, war nickels, sterling spoons, ASEs, commercial bullion bars, art bars w/ Kidd ref. #s, Engelhard silver, etc. - I can track date purchased, seller, silver spot price, total cost, cost per troy ounce, premium paid, running totals and more - a few quick printouts and they're ready to file away for future reference - $20+ silver and I'll begin to cull the herd @ eBay
For the next update, I'll add (1) # of over-sized slabs (2) imaging services (3) Crossover grading (4) maybe make just one input table instead of two due to redundancy and (5) figure out how to do multi-order submissions with combined shipping.
The new and improved spreadsheet is up, with multi-order submissions! One stipulation... the cost per coin and other calculations all assume that each form is of the same submission tier. If the price of the tier is the same as another, then it makes no difference as far as results are concerned. If you're submitting to a given TPG and want all of your submissions to return in the package, then you'd likely be using the same tier anyway due to turnaround times. Of course, there are exceptions... in which case you can calculate it for one submission, write down the total, do the calculation for the next submission, write down the total, etc., then divide your total by the # of coins accordingly. Anyway, please check the math for a multi-order submission using a single submission tier, and let me know if I messed up somewhere.
OK, I updated the spreadsheet so that now you can add multiple different tiers for a given submission. For instance, if you want to submit 1 Economy tier, 1 Modern tier, and 1 Standard / Regular tier, the cost analysis will appear on the left under "Mixed Tier". Just select the tier for each submission in column H.
$129 for Premium level NGC membership right now. Comes with $150 in credit! It's like getting 1 free economy submission + submission privileges.
