Granger Ford - Using Build & Price for invoice price calculations

[Beach_Bum]

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]

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]

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]

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]

so i downloaded the spreadsheet, but i cant get it to calculate the payment correctly, it doesnt change anything

 

[Bemcnamara]

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]

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]

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]

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]

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]

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?

 

[awall987]

@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.

 

[Bauer]

@new2offroad

There's an error in cell J15. Should be " =K11+K11*E9" not "=K11+K11*E10"

Edit: wasn't fast enough.. @awall987 beat me to it!

 

[new2offroad]

@new2offroad

There's an error in cell J15. Should be " =K11+K11*E9" not "=K11+K11*E10"

Edit: wasn't fast enough.. @awall987 beat me to it!

Thank you for that! It is fixed now!