2020 Rubicon Worksheet

[DownBytheRiver]

I've created an interactive Excel worksheet to make it easier (and funner) to calculate the price of a Rubicon or Rubicon Unlimited.

Just check the boxes for the options you want. No rules are enforced, use the order guide to determine legal combinations.

Sponsored

 

[quicksilvergoat]

I’m not an excel guru but I think the formula for the percentage off isn’t right. What I factor using my calculator is different.

Actually I think it’s giving the percent off before the destination fee. I think that fee should be added in before the discount is applied. That’s how the percent under invoice has been quoted to me from a dealer.

 

[DownBytheRiver]

I’m not an excel guru but I think the formula for the percentage off isn’t right. What I factor using my calculator is different.

Actually I think it’s giving the percent off before the destination fee. I think that fee should be added in before the discount is applied. That’s how the percent under invoice has been quoted to me from a dealer.

If you are talking about the FWP discount, that is based on the total vehicle price before the destination fee is added. Destination fees are not discounted.If I am wrong about this, please let me know. Maybe you got lucky.

 

[quicksilvergoat]

If you are talking about the FWP discount, that is based on the total vehicle price before the destination fee is added. Destination fees are not discounted.If I am wrong about this, please let me know. Maybe you got lucky.

I haven’t ordered yet but that’s how I was quoted. Maybe someone else will chime in. Please don’t think I’m being a jerk.

I really like your worksheet because it’s simple as can be.

 

[DownBytheRiver]

I haven’t ordered yet but that’s how I was quoted. Maybe someone else will chime in. Please don’t think I’m being a jerk.

I really like your worksheet because it’s simple as can be.

You're not being a jerk at all. I too want to get it right. AFAIK I did it right, but I''m not 100% certain.

 

[dblack]

You're not being a jerk at all. I too want to get it right. AFAIK I did it right, but I''m not 100% certain.

Depends on the dealer.
Criswell includes the destination with the invoice price before taking their percentages off.

 

[DownBytheRiver]

Depends on the dealer.
Criswell includes the destination with the invoice price before taking their percentages off.

I've added an additional section so now it shows discounts with and without the destination fee. Once you download the xlsx file, you must enable editing and disable protection for the check boxes to work.

Sponsored