Don't forget the Destination Charge of $1495. I missed that when using the spreadsheet earlier this week....how accurate are these invoice prices
i used the spread sheet and my build came to MSRP price of 55750 then inputted invoice prices it came to 51025 with my affiliate code -1% it came to 50514 just heard back from my first dealer they gave me a price of 52004.70 that was with my affiliate code
There is a little bug with the spreadsheet. The Rubicon 6% and 7% are not included in the total if you copy the amount onto the same row. If you know Excel it's not a hard fix ... Just wanted to make sure to mention it in case you see the same issue.
Wonderful spreadsheet though. Excellent work.
Yes, I just downloaded it yesterday.Appreciate the kind words! Are you using the most recent version? I typically edit the first post with a date/description then upload a new copy of the spreadsheet.
The newest version now includes a payment calculator for each trim. I can’t seem to replicate the bug you’re seeing.
THIS. IS. AWESOME! Thank you.Edit 4.23.19: Added a finance/monthly payment calculator to the bottom of each sheet.
Edit 4.9.19: Added 6% and 7% off invoice. The FOUR (4) trims are on separate sheets.
Edit 4.9.19: Formatting.
Edit 4.8.19: Updated spreadsheet with invoice pricing provided by @Travis@TriCityJeep
Edit 3.30.19: This is an update to my 'SWAG Gladiator Pricing' worksheet I posted in February. Invoice pricing is still a guess at this point.
As with the first version, feel free to edit as you see fit. The estimated invoice is a basic calculation which you can adjust with a new formula percentage. Let me know if you find any errors or pricing issues and I'll re-upload to this first post.
Enjoy!
I can only speak for my Google Sheets version, but it's based on Excel. It's $995 for Active Safety by default, but if you have the LED lighting package then it drops the price to $895 (it says it in the red comment box in Excel, my version throws a message up in the box if you select Active Safety and adjusts the price automatically if you have LED lighting already selected.This was very helpful when I went in to the dealership.
That being said, Active Safety Group pricing is a bit off from the website. It says 995 on the excel sheet but it's 895.
Also, it seems to be calculated this way, but do you pay sales tax on the destination fee? If so, then it's fine. If not, then that calculation is off.
Thank you for the creation though!