Sponsored

Beach_Bum

Black Diamond
Well-Known Member
First Name
Ken
Joined
Aug 12, 2020
Threads
28
Messages
6,143
Reaction score
19,260
Location
St. Augustine, FL
Vehicle(s)
2022 Black Diamond Bronco, 2023 Outerbanks Bronco
Your Bronco Model
Black Diamond
Clubs
 
The Granger amount is an estimation on what the Invoice price is going to be. (As a percentage of the published MSRP)
So the column title shouldn't be labeled Granger MSRP, but rather Granger Invoice. I presume the Invoice price is sourced from @North7 spreadsheet.
Sponsored

 

ZackDanger

Badlands
Well-Known Member
First Name
Z
Joined
Jul 8, 2020
Threads
23
Messages
6,451
Reaction score
28,975
Location
Massachusetts
Vehicle(s)
2021 Toyota 4Runner
Your Bronco Model
Badlands
Clubs
 
So the column title shouldn't be labeled Granger MSRP, but rather Granger Invoice. I presume the Invoice price is sourced from @North7 spreadsheet.
Yeah, it’s labeled weird....

...but the Invoice price isn’t sourced, it’s calculated as a percentage of MSRP. (You can see it in the formula)
 

new2offroad

Black Diamond
Member
First Name
Levi
Joined
Oct 23, 2020
Threads
4
Messages
16
Reaction score
32
Location
Omaha, NE
Vehicle(s)
Ford Fusion
Your Bronco Model
Black Diamond
So the column title shouldn't be labeled Granger MSRP, but rather Granger Invoice. I presume the Invoice price is sourced from @North7 spreadsheet.
I re-labeled with "Granger Invoice" and "Standard MSRP" I also made a second page for simple steps that allow you to plug in numbers and get the totals at the end!
 

new2offroad

Black Diamond
Member
First Name
Levi
Joined
Oct 23, 2020
Threads
4
Messages
16
Reaction score
32
Location
Omaha, NE
Vehicle(s)
Ford Fusion
Your Bronco Model
Black Diamond
Yeah, it’s labeled weird....

...but the Invoice price isn’t sourced, it’s calculated as a percentage of MSRP. (You can see it in the formula)
Fixed it by changing Granger to "Granger Invoice" and MSRP to "Standard MSRP"
 

rdperez9411

Banned
Banned
Banned
Joined
Sep 3, 2020
Threads
14
Messages
81
Reaction score
77
Location
Kentucky
Vehicle(s)
2 peronal (me and wife) 1 company
Your Bronco Model
Undecided
Clubs
 
so i downloaded the spreadsheet, but i cant get it to calculate the payment correctly, it doesnt change anything
 

Sponsored

Bemcnamara

Outer Banks
Well-Known Member
First Name
Brad
Joined
Jul 15, 2020
Threads
3
Messages
309
Reaction score
577
Location
Coeur d'Alene Idaho
Vehicle(s)
2015 F56S MINI
Your Bronco Model
Outer Banks
Clubs
 
so i downloaded the spreadsheet, but i cant get it to calculate the payment correctly, it doesnt change anything
Save it to your desktop and when you open you should be able to edit.
 

rdperez9411

Banned
Banned
Banned
Joined
Sep 3, 2020
Threads
14
Messages
81
Reaction score
77
Location
Kentucky
Vehicle(s)
2 peronal (me and wife) 1 company
Your Bronco Model
Undecided
Clubs
 
Save it to your desktop and when you open you should be able to edit.
I did, when I edit it, none of the calculations work, it updates the value of the vehicle, when I change it tk 72 months no matter what I add the payment is still under $500, that can't be right?
 

Bemcnamara

Outer Banks
Well-Known Member
First Name
Brad
Joined
Jul 15, 2020
Threads
3
Messages
309
Reaction score
577
Location
Coeur d'Alene Idaho
Vehicle(s)
2015 F56S MINI
Your Bronco Model
Outer Banks
Clubs
 
I did, when I edit it, none of the calculations work, it updates the value of the vehicle, when I change it tk 72 months no matter what I add the payment is still under $500, that can't be right?
Well good catch! It does the same for me.
 

rdperez9411

Banned
Banned
Banned
Joined
Sep 3, 2020
Threads
14
Messages
81
Reaction score
77
Location
Kentucky
Vehicle(s)
2 peronal (me and wife) 1 company
Your Bronco Model
Undecided
Clubs
 
Well good catch! It does the same for me.
sw
Well good catch! It does the same for me.
Sweet, at least I know I'm not crazy, I'm expecting my payment to be high 600s-low700s but want to get as exact a payment as possible so I can account for the gap insurance as well.
 

King_Bronco0327

Big Bend
Well-Known Member
Joined
Jul 23, 2020
Threads
4
Messages
271
Reaction score
315
Location
Orlando
Vehicle(s)
Bronco
Your Bronco Model
Big Bend
Clubs
 
I made a dynamic google sheet to estimate your Bronco cost through Granger! Go ahead and copy it over if you'd like to price out your new Bronco. The link will be below!

Granger Pricing Calculator for the new Bronco

I am so glad I am able to work with @Granger Ford and receive the $2000 off for the October promotion! Thank you, Albert and Bronco6G community for making this process simple and easy!

Let me know if you have any questions in regard to the google sheet!
Coping the link doesn't work. I copied both sheets but I get an error on the main calculator.
 

Sponsored

WadeWolf76

Well-Known Member
First Name
Damon
Joined
Jul 19, 2020
Threads
4
Messages
298
Reaction score
658
Location
Kansas
Vehicle(s)
15 Wrangler JK Willy's, 67 Ford Mustang coupe
Your Bronco Model
Undecided
Clubs
 
I may have missed something in the pages of posts. But on this discount calculator it shows Doc and Transit tag of $225 is that correct?
 
Last edited:

awall987

Base
Well-Known Member
Joined
Oct 26, 2020
Threads
0
Messages
125
Reaction score
386
Location
San Diego
Vehicle(s)
'05 LJ, '23 2dr BaseSquatch
Your Bronco Model
Base
Clubs
 
@new2offroad I just downloaded this spreadsheet to see how much my Grangtober deal would save me and something seemed off, the totals savings was too low compared to the estimated selling subtotals. Looks like the equation in cell J15 is using the APR in E10 and not the state tax in E9 like it should.
 
Last edited:

new2offroad

Black Diamond
Member
First Name
Levi
Joined
Oct 23, 2020
Threads
4
Messages
16
Reaction score
32
Location
Omaha, NE
Vehicle(s)
Ford Fusion
Your Bronco Model
Black Diamond
 


Top