Loan Spreadsheet - Car Buying Tips
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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- loan spreadsheet car buying tips
- dealer floor plan financing niada
- the basics of buying and leasing a car land rover
- consumer voices on automobile financing consumer financial
- take control of your auto loan consumer financial protection bureau
- discrimination when buying a car national fair housing alliance
- leasing vs buying quiz association of consumer vehicle lessors
- determinants of automobile loan default and prepayment
Related searches
- car salesman tips for success
- car buying tips negotiating 2019
- home buying tips for 2019
- car dealership tips and tricks
- car buying tips from a car salesman
- car buying tips negotiating
- car negotiating tips from a car salesman
- used car buying tips negotiating
- house buying tips for dummies
- car salesman tips and techniques
- car loan spreadsheet excel
- car salesman tips and tricks