Ford Options Calculator (missing since order halt)

[Pidg133]

Does anyone know how to access the Ford Options Calculator since you can no longer build and price online and test out the options calculations?

Sponsored

 

[minjaep]

There is an excel sheet or a Google sheet shared somewhere made by users. It is not 100% accurate for some reason compared to the contract I got, but just off by $100 or so in total. But there are some numbers to tweak like residuals, APR, incentives, etc. The current APR is 2.74% and residuals are found in the pinned thread on Ford Options. Incentives, I hope you already checked. For MA it is still $2500.

 

[Nklem]

Just search the forum. There are some simple ways to estimate it. You can search my username as well

 

[hybrid2bev]

Does anyone know how to access the Ford Options Calculator since you can no longer build and price online and test out the options calculations?

https://www.macheforum.com/site/threads/poll-ford-options-vs-finance.2883/post-92089

 

[minjaep]

https://www.macheforum.com/site/threads/poll-ford-options-vs-finance.2883/post-92089

This is the sheet I used. By the way, there are some things to be fixed, e.g. the incentive is deducted after sales tax, X-Plan pricing excludes optional costs, etc. These will increase the actual cost, but not by much.

 

[RickMachE]

It's pretty mind blowing that Ford doesn't have the Options calculator available standalone on the website, especially after realizing that people needed to go through the configurator to find it (when you could still buy a 2022). If nothing else, that destroyed the web statistics for anyone trying to analyze it. "Hey look, a lot of people abandoned the process at step 6!". No s_it Sherlock, it's because you made them go through the process to play with the calculator.

 

[NJ_MachE]

This is the sheet I used. By the way, there are some things to be fixed, e.g. the incentive is deducted after sales tax, X-Plan pricing excludes optional costs, etc. These will increase the actual cost, but not by much.

I knew X-Plan excludes destination and delivery but does it also exclude paint/packages? I have a minor discrepancy in my calculation vs the dealer estimate too but can't figure it out. It's only like $10 though.

 

[RickMachE]

I knew X-Plan excludes destination and delivery but does it also exclude paint/packages? I have a minor discrepancy in my calculation vs the dealer estimate too but can't figure it out. It's only like $10 though.

X-Plan price doesn't exclude ANYTHING you've listed.

My MSRP / Invoice is $57,405 including destination and delivery. $57,405 * .98 + $275 = $56,531.90. X-Plan is shown as $56,531.90, exactly the same (I have A plan, it's $55,428).

There is a $10 fee on my latest DORA, created in October with the conversion from 2021 to 2022, called "CV Lot Management". That would raise the price $8 ($10 x .98).

 

[NJ_MachE]

X-Plan price doesn't exclude ANYTHING you've listed.

My MSRP / Invoice is $57,405 including destination and delivery. $57,405 * .98 + $275 = $56,531.90. X-Plan is shown as $56,531.90, exactly the same (I have A plan, it's $55,428).

There is a $10 fee on my latest DORA, created in October with the conversion from 2021 to 2022, called "CV Lot Management". That would raise the price $8 ($10 x .98).

That fee might explain the discrepancy.

This is where I got the idea that destination and delivery was excluded-- from the Ford Partner Plan site-- note the net plan price includes the 1,100 (applied AFTER the discount) and the footnote below it saying the same thing.

 

[RickMachE]

That site is crap. It never shows the actual incentives correctly (always missing some). I gave you numbers right off my DORA.

Log in and go find a Mach-E and see what it shows you as X-Plan, vs. the MSRP. Take MSRP (which includes delivery) x .98 + 275 and see.

 

[NJ_MachE]

That site is crap. It never shows the actual incentives correctly (always missing some). I gave you numbers right off my DORA.

Log in and go find a Mach-E and see what it shows you as X-Plan, vs. the MSRP. Take MSRP (which includes delivery) x .98 + 275 and see.

No identical cars to mine in inventory but did get close enough to be able to confirm pricing looks good. The $10 discrepancy I still see vs the simple x .98 + 275 calculation must be the CV Lot Management Fee (which btw would be $9.80-- not $8)

 

[minjaep]

X-Plan price doesn't exclude ANYTHING you've listed.

My MSRP / Invoice is $57,405 including destination and delivery. $57,405 * .98 + $275 = $56,531.90. X-Plan is shown as $56,531.90, exactly the same (I have A plan, it's $55,428).

There is a $10 fee on my latest DORA, created in October with the conversion from 2021 to 2022, called "CV Lot Management". That would raise the price $8 ($10 x .98).

That is very interesting. Actually, my dealer eventually couldn't pull up the DORA at the time of order to check the original price, so they manually adjusted the price, and it does not even match with any combinations. I have no idea how the number is calculated, but I took it as it is probably cheaper than the correct one.

 

[macchiaz-o]

There is an excel sheet or a Google sheet shared somewhere made by users. It is not 100% accurate for some reason compared to the contract I got, but just off by $100 or so in total. But there are some numbers to tweak like residuals, APR, incentives, etc. The current APR is 2.74% and residuals are found in the pinned thread on Ford Options. Incentives, I hope you already checked. For MA it is still $2500.

I occasionally go in and update residuals and rates and so on based on the latest facts posted on the forum. This is tricky though, and will often be wrong for people finding the spreadsheet, because rates depend on model year, what's locked in on your specific order, etc.

You definitely need to verify all numbers in the spreadsheet.

This is the sheet I used. By the way, there are some things to be fixed, e.g. the incentive is deducted after sales tax, X-Plan pricing excludes optional costs, etc. These will increase the actual cost, but not by much.

X-plan discounts against the total MSRP, which includes manufacturer options such as premium paint and floor mats. Only dealer or third party options (e.g. window tint, separately ordered floor mats) are kept separate from x-plan.

The formulas are pretty much correct for my purchase which took place at a dealer in Scottsdale, Arizona. I verified everything against the actual purchase contract that the dealer printed and provided to me. The tax rules and so forth may vary by location, you may need to adjust accordingly.

As far as the monthly Options payment, my calculation is off by about a dollar from Ford's calculation. I'm not sure why, but it's insignificant enough that I didn't care.

I knew X-Plan excludes destination and delivery but does it also exclude paint/packages? I have a minor discrepancy in my calculation vs the dealer estimate too but can't figure it out. It's only like $10 though.

My dealer used a rough, overestimate for the state's vehicle registration fees, and they charged me for tire waste fees for five tires instead of four (Mach-E has no spare). Stuff like that will cause minor impacts to the monthly loan calculations. You'll need to fix those numbers in the spreadsheet if you had figured out actually costs while the dealer didn't bother to.

About a month or two after my sale, I got a check in the mail for the refund of the excessive state registration fees... I didn't ask for it, it's just the way the dealers here handle this. But it means I'm paying interest on this in my loan. It still impacts the finance charges I agreed to pay.

 

[minjaep]

I occasionally go in and update residuals and rates and so on based on the latest facts posted on the forum. This is tricky though, and will often be wrong for people finding the spreadsheet, because rates depend on model year, what's locked in on your specific order, etc.

You definitely need to verify all numbers in the spreadsheet.

Thanks for sharing your sheet! It saved my time making it my own, as I just need to tweak a few numbers. But in the end, it didn't matter much as my dealer used wrong numbers everywhere.

For example, they gave me the x-plan price as $53,963.50. I had no other third-party purchase. According to the X-plan formula, that means the MSRP they used is $54,784.18 = (above-$275)/0.98. Which is already so weird :| And it is less than the correct one, which is supposed to be $50,775(base)+$2700(AWD)+$240(weather matt)+$1100(delivery) = $54,815.

But this was not the only place the math went wrong. For example, I used Ford Options 36 and the final balloon payment is $26,703. This is like 49% of the after-tax-minus-incentive price. I have never seen such a high percentage for the residual. But this is actually good for me as I pay less if I decide to return.

 

[macchiaz-o]

For example, they gave me the x-plan price as $53,963.50. I had no other third-party purchase. According to the X-plan formula, that means the MSRP they used is $54,784.18 = (above-$275)/0.98. Which is already so weird :| And it is less than the correct one, which is supposed to be $50,775(base)+$2700(AWD)+$240(weather matt)+$1100(delivery) = $54,815.

Yeah that is super weird. X-plan is printed on Ford's invoice to the dealer (and the dealer is supposed to show you that on the actual invoice), so it's strange that they could mess up something so incredibly basic. But if they gave you a price lower than x-plan, then that's great.

Sponsored