Poll: Ford Options vs Finance

[hybrid2bev]

Is the X-Plan calculated on base MSRP or adjusted MSRP? Footnote 1 notes that optional equipment is extra and the Mach-E builder lists the AWD Extended Battery as an option. I've seen many calculations in this thread that seem to use the adjusted MSRP but I don't think that is correct.

X-Plan on Premium AWD ER should be $55,723 ($677 savings). I've seen other posts that list the X-Plan Pricing for the same model at $55,547 (adjusted MSRP of $55,300 *.98 + 275+1100). Which is correct?

Also in CA, is sales tax based on X-Plan price or MSRP?

X Plan: 2% discount from MSRP (less D&D $1,100) + $275 customer admin fee

Sponsored

 

[HuntingPudel]

<snip>
Also in CA, is sales tax based on X-Plan price or MSRP?

In CA, sales tax is based on the sale price of an item. Rebates do not factor into the sale price of an item. X-plan is a discount that decreases the sale price. So the amount of sales tax you pay is based off of X-plan pricing, not on the MSRP.

 

[Logal727]

Reading so many horror stories of dealers who have no idea about Ford Options or refusing to let you buy your car with it. What should I do if this happens? I’ve got some time of course, unless one falls in my lap in the next couple months. But this is what keeps me up at night haha. Thanks for any help.

 

[macchiaz-o]

Is the X-Plan calculated on base MSRP or adjusted MSRP? Footnote 1 notes that optional equipment is extra and the Mach-E builder lists the AWD Extended Battery as an option. I've seen many calculations in this thread that seem to use the adjusted MSRP but I don't think that is correct.

X-Plan on Premium AWD ER should be $55,723 ($677 savings). I've seen other posts that list the X-Plan Pricing for the same model at $55,547 (adjusted MSRP of $55,300 *.98 + 275+1100). Which is correct?

Also in CA, is sales tax based on X-Plan price or MSRP?

As @hybrid2bev mentioned, the discount is calculated from "MSRP." Specifically, it's the "TOTAL MSRP" value listed on the manufacturer's portion of the window sticker. Some dealers add on their own stuff such as window tinting or wheel locks. Those are not discounted on X-plan because they are outside of what Ford has provided as built from the factory.

But in your example, the extended range battery is discounted by X-plan because that's a manufacturer option included in TOTAL MSRP.

Like @hybrid2bev said, X-plan on this vehicle is MSRP - 2%, plus $275. So a $5,000 battery upgrade is discounted by 2%, or $100.

That chart that you screen captured from fordpartner.com is VERY confusing and I think it's actually wrong by several bucks. You can get accurate X-plan pricing from your dealer. In fact when you use plan pricing, they're required to show you figures from Ford's printout, showing your VIN, MSRP, and X-plan prices, when you go through the purchase process with them.

 

[macchiaz-o]

off-topic: How did you bake in the fixed fee into the Vlookup? If I replicate your vlookup, I come up $275 short and it's the exact same formula in the formula bar.

I think the formula you're looking at is this one?

=VLOOKUP(pricing_plan_name, pricing_plans, 2, FALSE)*(E6+E7)
+VLOOKUP($C10, pricing_plans, 3, FALSE)

Breaking that down, we have these variables in the equation:

• pricing_plan_name: this is also referred to as cell C10, which you'd set to the value "X-plan" if you're modelling X-plan pricing.
• pricing_plans: this is the "Pricing Plans" column of the first table found at the very top of the second worksheet; the worksheet is called "(supporting lookup tables)" and "pricing plans" is cells A2 through A5.
• E6: this is your MSRP including all factory options, but excluding destination and delivery
• E7: this is the destination/delivery fee ($1,100); if you add this to E6 you get the TOTAL MSRP that should match your factory window sticker

OK, so now the first VLOOKUP is looking up the value 0.98, found in B5 of the first table on the supporting tables worksheet. It finds this by looking for the row that has "X-plan" and getting the value from the second column in that row. This is the percentage of MSRP that is used to determine the X-plan price.

Then we multiply 0.98 by your TOTAL MSRP (the MSRP found in large text on your window sticker).

Finally we add in the result of the second VLOOKUP. This one looks up the "X-plan" row again, from the supporting table, and gets the value from the third column: $275. This is the fee you were asking about, I think. It's a fixed amount added to your agreed upon vehicle price per the plan's pricing rules.

Hopefully this clears it up. If not, try experimenting with the formulas on a spare copy of the spreadsheet so you can some more idea of how it works.

The whole thing started because I didn't understand how Options monthly payments were calculated... By going through this process, it finally clicked for me and I now understand leases better, too, since they are calculated in an extremely similar way.

 

[nathan624]

I think the formula you're looking at is this one?

=VLOOKUP(pricing_plan_name, pricing_plans, 2, FALSE)*(E6+E7)
+VLOOKUP($C10, pricing_plans, 3, FALSE)

Breaking that down, we have these variables in the equation:

• pricing_plan_name: this is also referred to as cell C10, which you'd set to the value "X-plan" if you're modelling X-plan pricing.
• pricing_plans: this is the "Pricing Plans" column of the first table found at the very top of the second worksheet; the worksheet is called "(supporting lookup tables)" and "pricing plans" is cells A2 through A5.
• E6: this is your MSRP including all factory options, but excluding destination and delivery
• E7: this is the destination/delivery fee ($1,100); if you add this to E6 you get the TOTAL MSRP that should match your factory window sticker

OK, so now the first VLOOKUP is looking up the value 0.98, found in B5 of the first table on the supporting tables worksheet. It finds this by looking for the row that has "X-plan" and getting the value from the second column in that row. This is the percentage of MSRP that is used to determine the X-plan price.

Then we multiply 0.98 by your TOTAL MSRP (the MSRP found in large text on your window sticker).

Finally we add in the result of the second VLOOKUP. This one looks up the "X-plan" row again, from the supporting table, and gets the value from the third column: $275. This is the fee you were asking about, I think. It's a fixed amount added to your agreed upon vehicle price per the plan's pricing rules.

Hopefully this clears it up. If not, try experimenting with the formulas on a spare copy of the spreadsheet so you can some more idea of how it works.

The whole thing started because I didn't understand how Options monthly payments were calculated... By going through this process, it finally clicked for me and I now understand leases better, too, since they are calculated in an extremely similar way.

ha, forgot to scroll down in the formula bar to see the rest of the formula that adds in the 275. duh. thanks!

 

[MachTee]

Reading so many horror stories of dealers who have no idea about Ford Options or refusing to let you buy your car with it. What should I do if this happens? I’ve got some time of course, unless one falls in my lap in the next couple months. But this is what keeps me up at night haha. Thanks for any help.

It was the same with my dealer. I was actually driving around visiting other dealers when one of the dealer reps called. I told him straight up, educate yourselves on Ford Options and I will buy the car. They did and I bought the car later on that day. That's really all that you can do. Really depends on how quickly they want to move the car.

Funny thing was, even as I was signing the deal, they didn't have the whole picture of how Ford Options works. They warned me that I'm not getting the $7500 federal tax credit. I told them they're wrong and let me worry about getting the $7500. You just have to make absolutely sure that your contract is drafted correctly, that you're not signing a regular lease, and make sure you are getting that $2500 from Ford Options applied.

 

[Logal727]

It was the same with my dealer. I was actually driving around visiting other dealers when one of the dealer reps called. I told him straight up, educate yourselves on Ford Options and I will buy the car. They did and I bought the car later on that day. That's really all that you can do. Really depends on how quickly they want to move the car.

Funny thing was, even as I was signing the deal, they didn't have the whole picture of how Ford Options works. They warned me that I'm not getting the $7500 federal tax credit. I told them they're wrong and let me worry about getting the $7500. You just have to make absolutely sure that your contract is drafted correctly, that you're not signing a regular lease, and make sure you are getting that $2500 from Ford Options applied.

I’m in Florida so it’s only $1k, but yes to all of that.

 

[Davedough]

Has anyone that has received a GT seen what the finance rates are for buying it? I don’t plan on using Options but I was going to use Ford Credit to finance. What percentages are available? I thought I read they may be different than Premiums

 

[BMT1071]

Has anyone that has received a GT seen what the finance rates are for buying it? I don’t plan on using Options but I was going to use Ford Credit to finance. What percentages are available? I thought I read they may be different than Premiums

I remember seeing a .25% drop on the Options rate. I don't recall seeing any decrease on the traditional finance rates. Always a chance that will change for Q4.
You're leaving at least $1k on the table by not going with Options.

 

[Logal727]

I remember seeing a .25% drop on the Options rate. I don't recall seeing any decrease on the traditional finance rates. Always a chance that will change for Q4.

Is there an official sheet where we can see current financing/options incentives on MME? It doesn’t even show up under incentives on the Ford site.

 

[BMT1071]

Is there an official sheet where we can see current financing/options incentives on MME? It doesn’t even show up under incentives on the Ford site.

The best way used to be to build the car you have on order and go to the finance page during that process. I haven't looked in quite a while.

 

[Logal727]

The best way used to be to build the car you have on order and go to the finance page during that process. I haven't looked in quite a while.

Yeah just want something I can show a dealer when they act like they don’t know about them lol

 

[BMT1071]

Yeah just want something I can show a dealer when they act like they don’t know about them lol

There's a whole page on ford.com just for Options. Seems like the 'we've never heard of that' excuse should be worn out soon. ????

 

[hybrid2bev]

Yeah just want something I can show a dealer when they act like they don’t know about them lol

Use the information off of the calculator on build and price. It’s got the financing program numbers listed right there.

Sponsored