Titan Cost Finance Calculator and Model Comparisons

[MuskyHunter]

Okay, I am going to be guilty of a cross post as this tool might get lost in another thread and this might be useful to some. I put together a fairly comprehensive spreadsheet which can be used as a financial/payment calculator as well as comparing model options. I have modified it from my previous post to allow the user to specify their states sales tax.

To use the sheet, enter data in the yellow fields only. The sheet will add up the option costs, calculate sales tax, allow you to specify trade values, and list downpayment sources, rebates, etc. Then once the grand total is completed, you can plug in your loan term and interest rate and it will calculate your payments.

The original intent of this spreadsheet was to compare at what option level it would make sense for me to choose the LE over the SE. It will compare the MSRP pricing against the dealer pricing for the SE and the MSRP pricing against the dealer pricing for the LE.

You can populate the SE column with XE information so that you can calculate your costs and financing.

You will then be able to see that the SE with options added come so close to the LE price when you plug the numbers. With nearly a $5000 different in base price, once you option up an SE, the gap closes within $2000 difference or $20.00 a month +/- a few dollars.

[MuskyHunter]

Whoops, a bad cell under the LE finance rate as I did not carry over the formula. This has been corrected.