2017 Excel Pricing Tool

[SOAKINRED]

Super Confused

I created an excel sheet that will help price out your options.

Download link: https://drive.google.com/open?id=0B9egqwzTk4PRSXI4U0FrUVF4dnc

Select from the drop down in the yellow column. Let me know if you find any errors.

Happy shopping!

Keith

Very nice of you to put the spread sheet together. http://www.fordraptorforum.com/images/smilies/party36.gif

OK so we get the build sheets and the price sheets, theirs a problem!

I have called ten dealers in California and all ten say that they can not order this truck because they only can get so many allocations. Now the truck they are getting have a mark up of 5 to 20k over MSRP. Really?

So a F150 Raptor MSRP is about 65k plus 10% tax & lic plus 5 to 20k?

Really? What am i missing here?

 

[BearLeeAsian]

Very nice of you to put the spread sheet together. http://www.fordraptorforum.com/images/smilies/party36.gif



OK so we get the build sheets and the price sheets, theirs a problem!



I have called ten dealers in California and all ten say that they can not order this truck because they only can get so many allocations. Now the truck they are getting have a mark up of 5 to 20k over MSRP. Really?



So a F150 Raptor MSRP is about 65k plus 10% tax & lic plus 5 to 20k?



Really? What am i missing here?

Yup.

$15k-$20k dealer markup lol


Sent from my iPhone using Tapatalk

 

[bruce7105]

Thanks for doing this great job

 

[FordFanStan]

SYNC 3 is series code 52L and appears you can add as a separate option on the option sheet, but you don't have it in your spreadsheet I think?

 

[RaptorScrew]

Yup.

$15k-$20k dealer markup lol


Sent from my iPhone using Tapatalk

And this is going to be the reason our GEN1 rigs will retain their exceptional value!

Only a select few would ever spend $80k - $95 on an new truck and be ok with it I would think... but I could be wrong...

 

[noblesramair]

Wow very nice thanks!

Edit: Just noticed the tax calculator doesn't add additional tax when you put on the dealer additional cost. I assume whatever the dealer additional cost is you'd still have to pay tax on, is that incorrect?

 

[chiefy]

how about doing it including finance percentages, down payments and term of loans....lol

 

[hamster]

I created an excel sheet that will help price out your options.

Download link: https://drive.google.com/open?id=0B9egqwzTk4PRSXI4U0FrUVF4dnc

Select from the drop down in the yellow column. Let me know if you find any errors.

Happy shopping!

Keith

Very nice job. Matches the one I built as for $, but much more user friendly.

 

[Toadster]

Great spreadsheet [emoji106] Henry ford would have never guessed that the F150 would sell for over $70k someday...