Sponsored

TaiKoi

Wildtrak
Well-Known Member
Joined
Aug 22, 2020
Threads
34
Messages
370
Reaction score
851
Location
Arizona
Vehicle(s)
1999 Camaro Z28
Your Bronco Model
Wildtrak
As the title says, I made a little price estimator in Google Sheets (link below). You pick your trim, packages and add any options you want and you can see your prices/costs.

There are 2 sheets if you look at the bottom when you open it. One is the Tool itself and the other is a ReadMe that explains a couple things. Check out that ReadMe.

A few things of note. Columns are labeled as:
  • dropdown (you click the dropdown arrow to see selection options)
  • calculated (column is not meant to be edited/changed and will populate automatically)
  • user input (you are able/supposed to enter in your own values here)
I verified my loan calculations against Google's auto loan calculator and they match. So you should be getting a pretty accurate view of your cost (based on your option estimations of course)

Follow the link below. You'll be asked to make a copy so that your edits are your own

TK Build & Price Estimator

Let me know if you have any problems, requests or whatever
Sponsored

 
Last edited:

Hey19

Badlands
Well-Known Member
First Name
JJ
Joined
Jul 28, 2020
Threads
4
Messages
1,209
Reaction score
3,371
Location
Bethlehem
Vehicle(s)
2021 Badlands 2dr 7spd, 1966 A code Mustang coupe
Your Bronco Model
Badlands
Impressive! Something fun to mess around with for sure
 

Used2jeep

Banned
Black Diamond
Banned
Banned
First Name
Dave
Joined
Jul 16, 2020
Threads
46
Messages
6,191
Reaction score
12,812
Location
Massachuvian
Vehicle(s)
2007 Crown Vic P71
Your Bronco Model
Black Diamond
Clubs
 
Could this be the B&P replacement?
 
OP
OP
TaiKoi

TaiKoi

Wildtrak
Well-Known Member
Joined
Aug 22, 2020
Threads
34
Messages
370
Reaction score
851
Location
Arizona
Vehicle(s)
1999 Camaro Z28
Your Bronco Model
Wildtrak
Alright, I was given an awesome idea from @diablo0813

You'll see the change on any new copies.

The Change: added a checkbox column next to options so that you can easily select and deselect which options you'd like to see calculated into the cost
 

Sponsored

Rubisquatch

Wildtrak
Well-Known Member
Joined
Jul 24, 2020
Threads
140
Messages
2,040
Reaction score
8,863
Location
Pittsburgh, PA
Vehicle(s)
2021 Bronco Wildrak
Your Bronco Model
Wildtrak
Clubs
 
@Granger Ford I hear invoice is typically 5% to 7% below MSRP. Is that a good ballpark estimate I should have for my Bronco if I go with your deal (5%-7% below te BnP tool when it comes)? If not, what is the right ballpark to expect?
 

Granger Ford

Badlands
Well-Known Member
Base Sponsor (Level 1)
First Name
Jay
Joined
Oct 1, 2019
Threads
39
Messages
2,123
Reaction score
9,862
Location
Granger,IA
Website
www.grangerford.com
Vehicle(s)
*
Your Bronco Model
Badlands
Clubs
 
@Granger Ford I hear invoice is typically 5% to 7% below MSRP. Is that a good ballpark estimate I should have for my Bronco if I go with your deal (5%-7% below te BnP tool when it comes)?
3% for the base vehicle and 6% on the options, then the discount...that should get you a great close estimate for the vehicle...

Make sure you do not include the Destination in the computation only in the final price for the Bronco...

The Destination is MSRP and Invoice the same number...
 

Rubisquatch

Wildtrak
Well-Known Member
Joined
Jul 24, 2020
Threads
140
Messages
2,040
Reaction score
8,863
Location
Pittsburgh, PA
Vehicle(s)
2021 Bronco Wildrak
Your Bronco Model
Wildtrak
Clubs
 
3% for the base vehicle and 6% on the options, then the discount...that should get you a great close estimate for the vehicle...

Make sure you do not include the Destination in the computation only in the final price for the Bronco...

The Destination is MSRP and Invoice the same number...
Thank you for this - very clear.
 

North7

Well-Known Member
Joined
Feb 21, 2020
Threads
111
Messages
7,264
Reaction score
25,475
Location
North Texas
Vehicle(s)
SUV
Your Bronco Model
Undecided
Clubs
 

Sponsored

Hossamus Prime

Badlands
Well-Known Member
First Name
Brian
Joined
Aug 21, 2020
Threads
11
Messages
740
Reaction score
2,793
Location
Arkansas
Website
www.instagram.com
Vehicle(s)
21 BadSquatch,‘21 ExplorerST , RIP 84 & 90 Broncos
Your Bronco Model
Badlands
Clubs
 
Sasqautch is $2500 on the Badlands right?
 

North7

Well-Known Member
Joined
Feb 21, 2020
Threads
111
Messages
7,264
Reaction score
25,475
Location
North Texas
Vehicle(s)
SUV
Your Bronco Model
Undecided
Clubs
 
OP
OP
TaiKoi

TaiKoi

Wildtrak
Well-Known Member
Joined
Aug 22, 2020
Threads
34
Messages
370
Reaction score
851
Location
Arizona
Vehicle(s)
1999 Camaro Z28
Your Bronco Model
Wildtrak
Small update to the color picker on the Estimator
 

Garbone

Big Bend
Well-Known Member
First Name
Gary
Joined
Jul 16, 2020
Threads
23
Messages
925
Reaction score
2,179
Location
FL
Vehicle(s)
1962 C10, 21 Mustang, 12 Explorer
Your Bronco Model
Big Bend
I am surprised this is not a more popular thread, great tool. Thanks for making it.
Sponsored

 
 


Top