Bronco pricing & savings spreadsheet (X-Plan vs Invoice and Below Invoice)

[K9paws06]

This is a spreadsheet I made to compare X-Plan pricing at a local dealer to pricing at a dealer offering $1,000 below Invoice (such as that offered by Granger Ford) or $2,000 below MSRP (such as that offered by Laura Ford). For the $2,000 below MSRP example, the values in red show where they are more expensive then the $1,000 below Invoice example, only the Base and Big Bend models are less expensive.

Make sure you consider the total cost of the offers, the dealers that are some distance from you will require additional shipping or travel costs to get your Bronco. If the distance dealer arranges to have Ford deliver your Bronco to your nearest local dealer you will have to pay that local dealer additional fees for receiving, inspecting and delivering it to you, called PDI (Pre-Delivery Inspection), this could be $500 - $1,000. Of course if you plan to travel to that distant dealer and drive your new Bronco home you will not have all of these costs but long drives at a constant speed is not good for a new engine. There are many examples of the proper engine break-in procedure on the internet, here is one example:
https://www.theenginebuilders.com/break-in-procedure

Looking at Dealer Holdback, with the original 2% dealer holdback column there was not enough dealer profit to cover a $1,000 below invoice offer. When increased to a 3% dealer holdback based on new information from @Ghostrider454 & @JeffBrunini you can see the $1,000 below invoice offer becomes profitable to the dealer. The 3% dealer holdback includes 2% of MSRP plus 1% of MSRP based on performance goals. Further, dealers will be looking for upsells, financing or bonuses from Ford for additional profits.

DISCLAIMER: I am not a dealer, salesperson or have any affiliation with them or Ford. I'm an engineer who put this spreadsheet together for my own use, I hope you find it useful.

Information about what the Ford discount X-Plan is:
https://www.bronco6g.com/forum/thre...below-invoice-and-more.2319/page-2#post-76441

Other threads discussing Bronco pricing and discounts include:
2021 Bronco Dealers: No-ADM, X-Plans & Special Discounts Master List
Best Reservation Deal? $1000 Under Invoice

Change Log:
7/20/2020 ver5 - corrected X-Plan Admin Fee & Dealer Fee per @bdub2you
At the request of @BroncoFrog95 I've added the file attachment for you fellow Excel geeks who want to modify the spreadsheet for your own use.
7/21/2020 ver6 - added "Increase" column to show price changes between models.
7/24/2020 ver7 - updated Laura Ford fee per @tmobileguy, updated dealer holdback to 3% per @Ghostrider454 & @JeffBrunini
7/31/2020 ver8 - Update to add $1,300 off for Granger Ford X-Plan Customers

View attachment 20000

Based off the Ford Bronco Price List dated 7/13/2020 at this thread:
2021 BRONCO PRICE LIST – MSRP & Dealer Invoice Pricing
View attachment 13377

Hello!
I’ve seen a lot of feed back for Granger Ford but nothing more about Laura Ford. I placed my reservation through that dealership because of the $2000 off MSRP. But it’s looking like I may need to change dealerships because the price may end up being more due to mark-ups?

Sponsored

 

[North7]

Hello!
I’ve seen a lot of feed back for Granger Ford but nothing more about Laura Ford. I placed my reservation through that dealership because of the $2000 off MSRP. But it’s looking like I may need to change dealerships because the price may end up being more due to mark-ups?

You have to evaluate your personal needs, model, driving distance, a lot goes into everyones decision, there is no one right answer.

 

[Kuze]

I've updated the spreadsheet to ver5 to correct the X-Plan Admin Fee & Dealer Fee thanks to the feedback of user @bdub2you.

Also, at the request of user @BroncoFrog95 I've added the file attachment for you fellow Excel geeks who want to modify the spreadsheet for your own use.

@North7 The attachment is not available. Do you mind post the latest version again? Thanks!

 

[North7]

@North7 The attachment is not available. Do you mind post the latest version again? Thanks!

Please try again, it shows for me and I did a successful test download.

 

[North7]

Thanks, I'll pick that up in the next update.

 

[Kuze]

Please try again, it shows for me and I did a successful test download.

That worked! This is amazing and thank you for taking the time to get this together. Now I am going to never sleep until I figure out which trim to get!

 

[Granger Ford]

Our xplan is solid , not wanting another popcorn battle?

 

[King_Bronco0327]

This is a spreadsheet I made to compare X-Plan pricing at a local dealer to pricing at a dealer offering $1,000 below Invoice (such as that offered by Granger Ford) or $2,000 below MSRP (such as that offered by Laura Ford). For the $2,000 below MSRP example, the values in red show where they are more expensive then the $1,000 below Invoice example, only the Base and Big Bend models are less expensive.

Make sure you consider the total cost of the offers, the dealers that are some distance from you will require additional shipping or travel costs to get your Bronco. If the distance dealer arranges to have Ford deliver your Bronco to your nearest local dealer you will have to pay that local dealer additional fees for receiving, inspecting and delivering it to you, called PDI (Pre-Delivery Inspection), this could be $500 - $1,000. Of course if you plan to travel to that distant dealer and drive your new Bronco home you will not have all of these costs but long drives at a constant speed is not good for a new engine. There are many examples of the proper engine break-in procedure on the internet, here is one example:
https://www.theenginebuilders.com/break-in-procedure

Looking at Dealer Holdback, with the original 2% dealer holdback column there was not enough dealer profit to cover a $1,000 below invoice offer. When increased to a 3% dealer holdback based on new information from @Ghostrider454 & @JeffBrunini you can see the $1,000 below invoice offer becomes profitable to the dealer. The 3% dealer holdback includes 2% of MSRP plus 1% of MSRP based on performance goals. Further, dealers will be looking for upsells, financing or bonuses from Ford for additional profits.

DISCLAIMER: I am not a dealer, salesperson or have any affiliation with them or Ford. I'm an engineer who put this spreadsheet together for my own use, I hope you find it useful.

Information about what the Ford discount X-Plan is:
https://www.bronco6g.com/forum/thre...below-invoice-and-more.2319/page-2#post-76441

Other threads discussing Bronco pricing and discounts include:
2021 Bronco Dealers: No-ADM, X-Plans & Special Discounts Master List
Best Reservation Deal? $1000 Under Invoice

Change Log:
7/20/2020 ver5 - corrected X-Plan Admin Fee & Dealer Fee per @bdub2you
At the request of @BroncoFrog95 I've added the file attachment for you fellow Excel geeks who want to modify the spreadsheet for your own use.
7/21/2020 ver6 - added "Increase" column to show price changes between models.
7/24/2020 ver7 - updated Laura Ford fee per @tmobileguy, updated dealer holdback to 3% per @Ghostrider454 & @JeffBrunini
7/31/2020 ver8 - Update to add $1,300 off for Granger Ford X-Plan Customers

View attachment 20000

Based off the Ford Bronco Price List dated 7/13/2020 at this thread:
2021 BRONCO PRICE LIST – MSRP & Dealer Invoice Pricing
View attachment 13377

Thank you for putting the comparison between Laura and Granger (without xplan). If these numbers are true, and in light of the recent news that you can only change a dealer once, than i’m still in the green of saving money for having changed my dealer to Laura Ford two weeks ago. The only thing that sucks is if I decide to jump up to black diamond, which ive been considering recently.

 

[Used2jeep]

Our xplan is solid , not wanting another popcorn battle?

Is that the popcorn throw or the unannounced sneeze with a mouthful of popcorn? #yeahThatMightBeGross

 

[Granger Ford]

Is that the popcorn throw or the unannounced sneeze with a mouthful of popcorn? #yeahThatMightBeGross

I am going with Yes only

 

[BroAD]

I love spreadsheets... they are my therapy ?

 

[wavedancer]

This is a spreadsheet I made to compare X-Plan pricing at a local dealer to pricing at a dealer offering $1,000 below Invoice (such as that offered by Granger Ford) or $2,000 below MSRP (such as that offered by Laura Ford). For the $2,000 below MSRP example, the values in red show where they are more expensive then the $1,000 below Invoice example, only the Base and Big Bend models are less expensive.

Make sure you consider the total cost of the offers, the dealers that are some distance from you will require additional shipping or travel costs to get your Bronco. If the distance dealer arranges to have Ford deliver your Bronco to your nearest local dealer you will have to pay that local dealer additional fees for receiving, inspecting and delivering it to you, called PDI (Pre-Delivery Inspection), this could be $500 - $1,000. Of course if you plan to travel to that distant dealer and drive your new Bronco home you will not have all of these costs but long drives at a constant speed is not good for a new engine. There are many examples of the proper engine break-in procedure on the internet, here is one example:
https://www.theenginebuilders.com/break-in-procedure

Looking at Dealer Holdback, with the original 2% dealer holdback column there was not enough dealer profit to cover a $1,000 below invoice offer. When increased to a 3% dealer holdback based on new information from @Ghostrider454 & @JeffBrunini you can see the $1,000 below invoice offer becomes profitable to the dealer. The 3% dealer holdback includes 2% of MSRP plus 1% of MSRP based on performance goals. Further, dealers will be looking for upsells, financing or bonuses from Ford for additional profits.

DISCLAIMER: I am not a dealer, salesperson or have any affiliation with them or Ford. I'm an engineer who put this spreadsheet together for my own use, I hope you find it useful.

Information about what the Ford discount X-Plan is:
https://www.bronco6g.com/forum/thre...below-invoice-and-more.2319/page-2#post-76441

Other threads discussing Bronco pricing and discounts include:
2021 Bronco Dealers: No-ADM, X-Plans & Special Discounts Master List
Best Reservation Deal? $1000 Under Invoice

Change Log:
7/20/2020 ver5 - corrected X-Plan Admin Fee & Dealer Fee per @bdub2you
At the request of @BroncoFrog95 I've added the file attachment for you fellow Excel geeks who want to modify the spreadsheet for your own use.
7/21/2020 ver6 - added "Increase" column to show price changes between models.
7/24/2020 ver7 - updated Laura Ford fee per @tmobileguy, updated dealer holdback to 3% per @Ghostrider454 & @JeffBrunini
7/31/2020 ver8 - Update to add $1,300 off for Granger Ford X-Plan Customers

View attachment 20000

Based off the Ford Bronco Price List dated 7/13/2020 at this thread:
2021 BRONCO PRICE LIST – MSRP & Dealer Invoice Pricing
View attachment 13377

The additional 1% you refer to is not always the truth. It has to be qualified for by the Dealership. If they are failing either Sales Training OR Customer Satisfaction they will not receive the monies which are 0.9% split into 0.5% and 0.4%. So a dealer may get nothing, 05%, 04% or 09% paid out on sales for the following month. So qualify at .05% for July and get paid the money on vehicles sold in August. Your July sales were paid out based on your June %age.

Sponsored