OP
jaspercasidino

jaspercasidino

Badlands
Well-Known Member
First Name
Andrew
Joined
Jul 18, 2020
Messages
237
Reaction score
455
Location
Everett, WA
Vehicle(s)
2016 BMW M3, 2016 Ducati 959 Panigale
Vehicle Showcase
1
  • Thread starter
  • Thread Starter
  • #46
Hi everyone,

I've been away from my computer for a bit and this has exploded. I'll try and address some of the questions.

Automatic should be $1,600 and 2.7L should be $1,900 - Correct and updated in Google Sheets link. I'll see if I can upload some new spreadsheets and update the first post.

Invoice Pricing I got from this thread. I think the info was leaked, but seemed as good as anything.

I didn't include 4-dr or FE on the sheet, because I mainly built this for me. I think some people with admin rights have updated the links and files to include this information.

Rapid Red ($395) and Cyber Orange (spreadsheet was $695 now is $595) prices I got from Bronco Sport pricing. Aux switches and Automatic On Demand 4x4 are my guesses. Hopefully they end up lower. AOD is available on all trims (comparison chart).

If you are seeing Not Available in your pricing or financing for a specific trim, that means the combination of options you have selected can't be ordered (at least to the information we have available right now).





Advertisement

 
Last edited:
OP
jaspercasidino

jaspercasidino

Badlands
Well-Known Member
First Name
Andrew
Joined
Jul 18, 2020
Messages
237
Reaction score
455
Location
Everett, WA
Vehicle(s)
2016 BMW M3, 2016 Ducati 959 Panigale
Vehicle Showcase
1
  • Thread starter
  • Thread Starter
  • #47
At the time of this post the OP file is full of errors for the 2 door.
I'm having difficulty updating the spreadsheets, but the Google sheets link should be updated. What errors are you seeing?
 

Gene Dios

Badlands
Well-Known Member
Joined
Jul 27, 2020
Messages
129
Reaction score
351
Location
California
Vehicle(s)
Ford Explorer
Clubs
 
I'm confused about the x plan discount listed vs the invoice value. X plan is automatically being factored into the out-the-door value, correct?
 

Steeler412

Member
Joined
Jun 23, 2020
Messages
20
Reaction score
43
Location
USA
Vehicle(s)
2006 F150
I'm confused about the x plan discount listed vs the invoice value. X plan is automatically being factored into the out-the-door value, correct?
Yep, set x-plan discount to 0% if you aren't planning to get it.
 

Steeler412

Member
Joined
Jun 23, 2020
Messages
20
Reaction score
43
Location
USA
Vehicle(s)
2006 F150
I'm confused about the x plan discount listed vs the invoice value. X plan is automatically being factored into the out-the-door value, correct?
Sorry, set it to 0% for options discount ( or set the cell value to 0) and set the X-Plan Vehicle discount cell to 0 if you don't plan to get X-plan
 
OP
jaspercasidino

jaspercasidino

Badlands
Well-Known Member
First Name
Andrew
Joined
Jul 18, 2020
Messages
237
Reaction score
455
Location
Everett, WA
Vehicle(s)
2016 BMW M3, 2016 Ducati 959 Panigale
Vehicle Showcase
1
  • Thread starter
  • Thread Starter
  • #52
I'm confused about the x plan discount listed vs the invoice value. X plan is automatically being factored into the out-the-door value, correct?
It is. I made it selectable now.
 

LarryZiegler

Badlands
Well-Known Member
First Name
Larry
Joined
Oct 19, 2019
Messages
210
Reaction score
193
Location
California
Vehicle(s)
Future 2021 Ford Bronco
I made a spreadsheet based on some of the factors that are important to my decisions. Maybe it will help others. All are based on 2-doors with a couple estimates on some of the options. Enjoy!

Edit:

Added Google Sheets link for those without Excel.

Google Sheets Link

Edit the yellow box prices as you see fit. Select your options with X or x next to the option selected to adjust the price.

Updated spreadsheets to account for 2.7L and auto pricing mistake, Cyber Orange color pricing from $695 -> $595, RTA tax now points to MSRP+DD instead of after X-Plan Pricing. X-Plan can be toggled now.

Download 2-Door Calculator Spreadsheet
Download 4-Door Calculator Spreadsheet
Download Calculator With Invoice Pricing
The 4 Door links I open are for the 2 Door....???
 
OP
jaspercasidino

jaspercasidino

Badlands
Well-Known Member
First Name
Andrew
Joined
Jul 18, 2020
Messages
237
Reaction score
455
Location
Everett, WA
Vehicle(s)
2016 BMW M3, 2016 Ducati 959 Panigale
Vehicle Showcase
1
  • Thread starter
  • Thread Starter
  • #54
The 4 Door links I open are for the 2 Door....???
Select 4 door option in cell I27. I just now reuploaded that file with that pre-selected. Should be good now. My initial post is being edited by some admins it seems.
 

wolfpackinva

Black Diamond
Well-Known Member
First Name
Santiago
Joined
Jul 31, 2020
Messages
215
Reaction score
669
Location
Doswell, VA
Vehicle(s)
'17 Focus, '08 E350, '13 Tundra
Thank you for this spreadsheet. It gives me the calculations I needed to wrap my head around what I can get (might be able to swing for a Badlands).
 

Used2jeep

Big Bend
Well-Known Member
First Name
Dave
Joined
Jul 16, 2020
Messages
1,620
Reaction score
2,824
Location
Massachuvian
Vehicle(s)
2007 Crown Vic P71
Clubs
 
If we are using either of the large volume dealers and are trying to get the $1300 off x-plan, how would we see that or make the spreadsheet do it?
 

RotorOver

Badlands
Well-Known Member
Joined
Jul 15, 2020
Messages
68
Reaction score
150
Location
Greater Atlanta Area
Vehicle(s)
2017 Porsche 718 Cayman S, 2017 BMW M240i, 2017 Audi Q5
Vehicle Showcase
1
@jaspercasidino Really useful Brother! Did a quick mod to incorporate Granger like pricing of $X under invoice with a discrete input cell along with input cells for Admin Fee and Doc Fee and a percentage discount to MSRP options to get to option invoice pricing (used 9.1% in this example which is 2020 Ford F150 options mark-up). Incorporate if you'd like. Thanks again!
 

Attachments


Advertisement





 


Advertisement
Top