XLS www.carbuyingtips.com

Compare 4 Loan Scenarios at OnceVersion 2 7/12/2013This spreadsheet is a free download from:Scenario #1Scenario #2● Numbers in BLUE can be modified by the userState Sales Tax Rate (%):0State Sales Tax Rate (%):0● Numbers in BLACK are calculated by spreadsheet and are password protectedSelling Price of car:0Selling Price of car:0Total Sales Tax:=Selling_Price1*tax_rate1Total Sales Tax:=Selling_Price2*tax_rate2Rebate:0Rebate:0Down Payment:0Down Payment:0Trade in OR Adjustment (+/-):0Trade in OR Adjustment (+/-):0Amount Borrowed (Principal):=Selling_Price1+Sales_Tax1-Rebate1-Down_Payment1-Trade_in1Amount Borrowed (Principal):=Selling_Price2+Sales_Tax2-Rebate2-Down_Payment2-Trade_in2Number of Months in Loan:36Number of Months in Loan:48Interest Rate (APR):0Interest Rate (APR):0Total Loan Interest:=Total_loan1-Principal1Total Loan Interest:=Total_loan2-Principal2Your Monthly Payment Is:=-PMT(Interest_Rate1/12,Months1,Principal1,0,0)Your Monthly Payment Is:=-PMT(Interest_Rate2/12,Months2,Principal2,0,0)Total Cost of The Loan: (including interest)=(Total_Monthly1*Months1)Total Cost of The Loan: (including interest)=(Total_Monthly2*Months2)Total Cost of The Car: (Includes taxes, rebate, interest)=Selling_Price1+Sales_Tax1-Rebate1+Total_Interest1Total Cost of The Car: (Includes taxes, rebate, interest)=Selling_Price2+Sales_Tax2-Rebate2+Total_Interest2Scenario #3Scenario #4State Sales Tax Rate (%):0State Sales Tax Rate (%):0Selling Price of car:0Selling Price of car:0Sales Tax:=Selling_Price3*tax_rate3Total Sales Tax:=Selling_Price4*tax_rate4Rebate:0Rebate:0Down Payment:0Down Payment:0Trade in OR Adjustment (+/-):0Trade in OR Adjustment (+/-):0Amount Borrowed (Principal):=Selling_Price3+Sales_Tax3-Rebate3-Down_Payment3-Trade_in3Amount Borrowed (Principal):=Selling_Price4+Sales_Tax4-Rebate4-Down_Payment4-Trade_in4Number of Months in Loan:60Number of Months in Loan:72Interest Rate (APR):0Interest Rate (APR):0Total Loan Interest:=Total_loan3-Principal3Total Loan Interest:=Total_loan4-Principal4Your Monthly Payment Is:=-PMT(Interest_Rate3/12,Months3,Principal3, 0, 0)Your Monthly Payment Is:=-PMT(Interest_Rate4/12,Months4,Principal4,0,0)Total Cost of The Loan: (including interest)=(Total_Monthly3*Months3)Total Cost of The Loan: (including interest)=(Total_Monthly4*Months4)Total Cost of The Car: (Includes taxes, rebate, interest)=Selling_Price3+Sales_Tax3-Rebate3+Total_Interest3Total Cost of The Car: (Includes taxes, rebate, interest)=Selling_Price4+Sales_Tax4-Rebate4+Total_Interest4Copyright © 1999-2013 ConsumerNet, Inc. All Rights Reserved.* These calculations assume that all loan payments are paid at the end of the month.* Luxury Tax not included. ................
................

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

Google Online Preview   Download