This spreadsheet is for people, like myself, who haven’t purchased an FJ Cruiser yet. It is a pricing program that lets you select the options you desire and compare to the dealer’s invoice price. Furthermore, there is a bottom section that allows the buyers willing to perform installation of options normally added at port to compare TRD prices (from trdsource.com – price includes estimated S&H) to the MSRP price in the window sticker.
FJ-Pricing-Jan07.ZIP
The spreadsheet has a
Database Section and a
Pseudo Bill of Sale section. This is how it works:
1. Database section (cells H1:N65) contains option information [code (column “I”), description (column “J”), MSRP (column “K”) and invoice (column “L”)] from Toyota and TRD information [price (column “M”) and part number/comment (column “N”)]. Prices are subject to change, so the users of the spreadsheet should verify pricing is still current at time of use. The prices in blue are correct as of April 21 to the best of my knowledge. The prices and items in red are guess and hopes for future options. I have added a couple fun things, different colors and sunroof, to let people play with this spreadsheet. Note that column “H” works best if left in ascending order, because left side of program uses these number to perform lookup function.
2. Pseudo Bill of Sale Section (cells A1:G65) is he page I intend to keep in my back pocket when negotiating the deal. This section is further segmented into the following parts:
Vehicle Selection – enter in cell “B6” a number between 1 and 3 to get the base model of your choice, enter in cell “B7” a number between 11 and 15 to select the current color offering of your choice. The dealer destination and FE are automatically listed. If at some point Toyota changes the pricing, go to the right section of the spreadsheet and update.
Factory Installed Options – enter in cell “B12” a number between 81 and 92 to select the options that are factory installed. There are five rows for factory options, so you can enter up to 5 different numbers in cells “B12” through “B16”.
Port or Dealer Installed Options – this works the same way as Factory options except the numbers to use are between 101 and 139. If you intend to install any option yourself do not enter it in this section. The are 10 rows for PIO or DIO. Remember you need only to enter the appropriate number in column “B.”
Dealer Charges and Taxes – cell “E31” is where you enter the document processing fee the dealer charges (if any), cell “E32” is where you enter the cost for extended warranty (7 year – 100K) and cell “F32” is where you enter the dealers cost for extended warranty (which I don’t know, but think it must be $800 or $900). Now row “33” is kind of important because the difference between column “E” and “F” is what the dealer stands to make on the deal. (Baldy and RoverGGM will comment on this I’m sure) Now to finish this segment add the cost of licenses in cell “E34” and the tax rate in cell “C35”. The figure in cell “E36” is the amount you are obligated to pay in order to drive it home.
Options Buyer Installed – enter the options you intend to install yourself in this segment, there are 10 rows for numbers to be entered. Column “F” shows your savings to MSRP for each item. TRDsource has changed prices a little since kickoff on March 27. The rock rail prices has increase and the roof rack is not on the list anymore.
The real cost to the buyer is found in cell “E53”. The notes in rows 56 thru 65 are things to remind yourself when making the deal.
Set your printer to print the range “A1:G65” and take this with you to bargain. If you want another option and cannot remember pricing, the typical amount of Invoice is 70% of MSRP. For example you go to the dealer with this sheet and found one you liked with a tow hitch, but it wasn’t on the Pseudo Bill of Sales sheet, just remember that the $350 option costs the dealer about 70% or $225 (actually $240 but close enough for approximation).
4/4/07 Edit - Invoice pricing for options and accessories are difficult to verify, but I think this is correct. Two base price increases ($200 each time) have occured since last summer.
Linear Mode
