XLS www.carbuyingtips.com

New Car Buyer's Offer SpreadsheetVersion 4 7/15/2013This spreadsheet is a free download from:1Enter Factory Holdback % Here: (Usually American Cars=3%, Foreign Cars=2%. Not all cars have it)0.03=A6+1Enter Any Factory To Dealer Incentives Here (Can be obtained from )0=A7+1Enter Government Rebates/Vouchers Here0=A8+1Enter Consumer Rebates Here0=A9+1Enter Destination Charge (Shipping) Here0=A10+1Enter any Floorplan Fees From Dealer Invoice Here0=A11+1Enter Dealer Profit % You Wish to Offer (Suggest 3 to 5%)0.03Vehicle DescriptionModel CodeInvoice Price (Wholesale Price)MSRP (Retail Price)8Example: 2014 Toyota Camry Sedan LE V6 4-Dr (Change this to your vehicle)CODE00Tip: If there is a fee or incentive or promotion that is not shown on this spreadsheet, you can account for it by creating an option for it, and assigning the amount. You assign a positive amount if it is a fee, and put a negative dollar amount if it is a discount or incentive. It's useful for fudge factors.Installed Options on vehicle:9Option # 1: Add all your options here…..CODE+00Option # 2:CODE+00…+…+++++++++++++++Destination Charge (From above, used here to match MSRP sticker only)+=Destination_ChargeTotal Cost Of Installed Options+=SUM(F18:F35)=SUM(G18:G35)Total Base Vehicle & Option Price=SUM(F16:F36)=SUM(G16:G35)+Destination_ChargeFactory Holdback (Paid to dealer by factory after car is sold)-=(Factory_Holdback*Total_MSRP)=F6*G38Factory To Dealer Incentives (Bonus to dealer from factory)-=(Factory_To_Dealer_Incentives)Floorplan Fee (Also called "Wholesale Financial Reserves", paid by factory to the dealer to offset dealer's floorplan interest costs)-=Floorplan_InterestCalculated Dealer's Cost Of Vehicle (This does not include Destination Charges, it's just the vehicle alone)==Total_Invoice-Holdback-Factory_Incentives-Floorplan_InterestFair Profit Over Dealer's Cost+=Dealer_Profit*Dealers_Cost=Dealer_ProfitNegotiated Selling Price Of Vehicle==Dealers_Cost+Fai_ProfitDestination Charge (Cost to ship vehicle to dealer, required fee)+=Destination_Charge10Advertising Fees (Usually shown only on dealer invoice, optional fee)+011Environmental Protection Packages, and Other Fees+012Dealer Prep (optional fee)+0Total Consumer & Government Rebates-=Consumer_Rebate+Government_Rebates$Final Selling Price To Customer (Not Including Sales Tax, Tags, or Title)==Selling_Price+Destination+Ad_Fee1+Dealer_Prep+environmental_packages-RebateCopyright © 1999-2013 ConsumerNet, Inc. All Rights Reserved.Read our guides and reviews of Extended Warranties and Car Financing:What to look for when financing your car and buying extended warranties. We reveal all the pitfalls to watch out for, and how to avoid scams. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download