OP
North7

North7

Badlands
Well-Known Member
Joined
Feb 21, 2020
Messages
2,524
Reaction score
7,217
Location
North Texas
Vehicle(s)
Bronco Badlands
  • Thread starter
  • Thread Starter
  • #316
Working with one of the spreadsheets on the site, this is what I came up with for my OBX build. Would this be accurate for estimating the x-plan honored price? Seems a bit high.

Pricing Example.png
I had to recreate your spreadsheet, It looks like you have an error in your X-Plan discount. If you want, send me your spreadsheet by PM and I will look at it.

1605361949916.png





Advertisement

 

Daytona_Bronco

Black Diamond
Well-Known Member
First Name
Jay
Joined
Sep 6, 2020
Messages
546
Reaction score
1,594
Location
Daytona FL
Vehicle(s)
2007 Mustang GT
Clubs
 
I had to recreate your spreadsheet, It looks like you have an error in your X-Plan discount. If you want, send me your spreadsheet by PM and I will look at it.

1605361949916.png

Screen Shot 2020-10-10 at 7.15.22 PM.png

[/QUOTE]

This is great OP, much appreciated! ... Xplan will be honored at my dealer in FL if I choose to stay with them .. What is the increase column represent ?
 
OP
North7

North7

Badlands
Well-Known Member
Joined
Feb 21, 2020
Messages
2,524
Reaction score
7,217
Location
North Texas
Vehicle(s)
Bronco Badlands
  • Thread starter
  • Thread Starter
  • #319
This is great OP, much appreciated! ... Xplan will be honored at my dealer in FL if I choose to stay with them .. What is the increase column represent ?
It is the difference from trim to trim showing the step increase in cost to move between different trim levels.
 

BadSquatch

Badlands
Member
First Name
Mark
Joined
Jul 14, 2020
Messages
22
Reaction score
18
Location
Bucks County, PA
Vehicle(s)
72 Bronco
Is this correct? Seems like there's not much mark-up on these? I was figuring $3k-$4k difference between Invoice and MSRP. According to this, only $1670. About 3%.

InvoiceMSRP
Bandlands 2Dr$40,621$42,095
17" wheels$935$995
Mid Package$1,405$1,495
Tow Package$559$595
Floor liners$150$160
Destination$1495$1495
TOTAL$45,165$46,835
Markup$1,670
 
OP
North7

North7

Badlands
Well-Known Member
Joined
Feb 21, 2020
Messages
2,524
Reaction score
7,217
Location
North Texas
Vehicle(s)
Bronco Badlands
  • Thread starter
  • Thread Starter
  • #323
  • Like
Reactions: JAM
OP
North7

North7

Badlands
Well-Known Member
Joined
Feb 21, 2020
Messages
2,524
Reaction score
7,217
Location
North Texas
Vehicle(s)
Bronco Badlands
  • Thread starter
  • Thread Starter
  • #324
Is this correct? Seems like there's not much mark-up on these? I was figuring $3k-$4k difference between Invoice and MSRP. According to this, only $1670. About 3%.

InvoiceMSRP
Bandlands 2Dr$40,621$42,095
17" wheels$935$995
Mid Package$1,405$1,495
Tow Package$559$595
Floor liners$150$160
Destination$1495$1495
TOTAL$45,165$46,835
Markup$1,670
For the 2 door Badlands example the difference between the MSRP price of $42,095 of and the Invoice price of $40,621 is $1,474 with no additional options, this is shown in the column titled "M/I Spread"

You're correct the spread is thin but it seems like auto manufacturers have been lowering the spread more and more over the last 20 years as with most consumers only feel they got a great deal if they got close to invoice pricing. To work around this "problem" for the industry, manufacturers moved more of the profit into the holdback and monthly performance bonuses so the dealers still see profit.

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.

Pricing Spreadsheet Nov 2020.png
 

Advertisement





 


Advertisement
Top