TaiKoi

Wildtrak
Well-Known Member
Joined
Aug 22, 2020
Messages
102
Reaction score
174
Location
Arizona
Vehicle(s)
2007 Dodge Ram Laramie 5.9 Cummins 4x4
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





Advertisement

 
Last edited:

Hey19

Badlands
Well-Known Member
First Name
JJ
Joined
Jul 28, 2020
Messages
193
Reaction score
460
Location
Bethlehem
Vehicle(s)
2019 Mustang GT 6spd 2013 F150 4x4
Vehicle Showcase
1
Impressive! Something fun to mess around with for sure
 
OP
TaiKoi

TaiKoi

Wildtrak
Well-Known Member
Joined
Aug 22, 2020
Messages
102
Reaction score
174
Location
Arizona
Vehicle(s)
2007 Dodge Ram Laramie 5.9 Cummins 4x4
  • Thread starter
  • Thread Starter
  • #5
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
 

Rubisquatch

Well-Known Member
Joined
Jul 24, 2020
Messages
179
Reaction score
539
Location
Pittsburgh, PA
Vehicle(s)
13 10A Rubi, 14 HR Rubi, WRX, 17 GrChr, 19 Edge
@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
First Name
Albert
Joined
Oct 1, 2019
Messages
1,739
Reaction score
6,426
Location
Granger,IA
Website
www.grangerford.com
Vehicle(s)
*
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

Well-Known Member
Joined
Jul 24, 2020
Messages
179
Reaction score
539
Location
Pittsburgh, PA
Vehicle(s)
13 10A Rubi, 14 HR Rubi, WRX, 17 GrChr, 19 Edge
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

Badlands
Well-Known Member
Joined
Feb 21, 2020
Messages
2,109
Reaction score
6,024
Location
North Texas
Vehicle(s)
Bronco Badlands
OP
TaiKoi

TaiKoi

Wildtrak
Well-Known Member
Joined
Aug 22, 2020
Messages
102
Reaction score
174
Location
Arizona
Vehicle(s)
2007 Dodge Ram Laramie 5.9 Cummins 4x4
  • Thread starter
  • Thread Starter
  • #14
Small update to the color picker on the Estimator
 

Advertisement





 


Advertisement
Top