ZackDanger

Badlands
Well-Known Member
First Name
Zack
Joined
Jul 8, 2020
Messages
2,400
Reaction score
9,719
Location
Massachusetts
Vehicle(s)
2014 Wrangler JKU
Clubs
 
I guess I'm just dumb. But why are there 2 MSRPs? On the second page, you have listed the various trims MSRP and that corresponding number is evident on the first page. But why is there a Granger MSRP?
The Granger amount is an estimation on what the Invoice price is going to be. (As a percentage of the published MSRP)





Advertisement

 

Beach_Bum

Outer Banks
Well-Known Member
First Name
Ken
Joined
Aug 12, 2020
Messages
1,220
Reaction score
3,155
Location
St. Augustine, FL
Vehicle(s)
2003 Jeep Liberty Limited
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.
 

ZackDanger

Badlands
Well-Known Member
First Name
Zack
Joined
Jul 8, 2020
Messages
2,400
Reaction score
9,719
Location
Massachusetts
Vehicle(s)
2014 Wrangler JKU
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
Messages
16
Reaction score
32
Location
Omaha, NE
Vehicle(s)
Ford Fusion
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
Messages
16
Reaction score
32
Location
Omaha, NE
Vehicle(s)
Ford Fusion
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

Well-Known Member
First Name
Richard
Joined
Sep 3, 2020
Messages
56
Reaction score
56
Location
DFW
Vehicle(s)
2 peronal (me and wife) 1 company
so i downloaded the spreadsheet, but i cant get it to calculate the payment correctly, it doesnt change anything
 

rdperez9411

Well-Known Member
First Name
Richard
Joined
Sep 3, 2020
Messages
56
Reaction score
56
Location
DFW
Vehicle(s)
2 peronal (me and wife) 1 company
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?
 

rdperez9411

Well-Known Member
First Name
Richard
Joined
Sep 3, 2020
Messages
56
Reaction score
56
Location
DFW
Vehicle(s)
2 peronal (me and wife) 1 company
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
Messages
140
Reaction score
201
Location
Orlando
Vehicle(s)
Bronco
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.
 

WadeWolf76

Well-Known Member
First Name
Damon
Joined
Jul 19, 2020
Messages
187
Reaction score
424
Location
Kansas
Vehicle(s)
15 Wrangler JK Willy's, 67 Ford Mustang coupe
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

Member
Joined
Oct 26, 2020
Messages
16
Reaction score
47
Location
San Diego
Vehicle(s)
'05 LJ, '11 FJ
Vehicle Showcase
1
@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
Messages
16
Reaction score
32
Location
Omaha, NE
Vehicle(s)
Ford Fusion

Advertisement





 


Advertisement
Top