Loan
Compare 4 Loans At Once
Instructions are in "Loan" tab at bottom
Set View > Zoom > Custom > 60% Now!
Scenario #1
State Sales Tax Rate (%) Selling Price of car Sales Tax Rebate Down Payment Trade in OR Adjustment (+/-) Amount Borrowed (Principal) Number of Months in Loan Interest Rate (APR) Total Interest on the loan is: Your Monthly Payment will be: Total Cost Of Loan Total Cost of The Car 0.00% $0.00 $0.00 $0.00 $0.00 $0.00
Scenario #2
State Sales Tax Rate (%) Selling Price of car Sales Tax Rebate Down Payment Trade in OR Adjustment (+/-) Amount Borrowed (Principal) Number of Months in Loan Interest Rate (APR) Total Interest on the loan is: Your Monthly Payment will be: Total Cost Of Loan Total Cost of The Car
$0.00
48 8.00% $0.00
$0.00 $0.00 $0.00
Scenario #3
State Sales Tax Rate (%) Selling Price of car Sales Tax Rebate Down Payment Trade in OR Adjustment (+/-) Amount Borrowed (Principal) Number of Months in Loan Interest Rate (APR) Total Interest on the loan is: Your Monthly Payment will be: Total Cost Of Loan 0.00% $0.00 $0.00 $0.00 $0.00 $0.00
Scenario #4
State Sales Tax Rate (%) Selling Price of car Sales Tax Rebate Down Payment Trade in OR Adjustment (+/-) Amount Borrowed (Principal) Number of Months in Loan Interest Rate (APR) Total Interest on the loan is: Your Monthly Payment will be: Total Cost Of Loan
$0.00
36 8.00% $0.00
$0.00 $0.00
Page 1
Loan
Total Cost of The Car
$0.00
Total Cost of The Car
Page 2
Loan
Page 3
Loan
Copyright 2000 Jeff Ostroff, ConsumerNet, Inc., & CarBuyingTips.com
Page 4
Loan
0.00% $0.00 $0.00 $0.00 $0.00 $0.00
$0.00
36 8.00% $0.00
$0.00 $0.00 $0.00
0.00% $0.00 $0.00 $0.00 $0.00 $0.00
$0.00
36 8.00% $0.00
$0.00 $0.00
Page 5
Loan
$0.00
Page 6
Instructions
Compare 4 Loans At Once Instructions
There are no guarantees of any kind. ***The first thing you must do is set the view to 60%. To do this, click on View > Zoom > Custom > 60%. Once you set the zoom, go to full screen mode: Click on View > Full Screen.
All the items that need to be entered by you have a thick blue underline. The numbers calculated by the spreadsheet are underlined in black. Enter data only where you are supposed to. Don't enter data where the numbers are black. 1) Enter state sales tax rate % into the "State Sales Tax Rate" field if you want tax figured into the loan. 2) Enter the selling price of the vehicle, including options, extras, etc. under "Selling Price". 3) If there is a rebate, enter it under "Rebate". 4) If you are putting any cash down, enter the amount under "Down Payment". 5) If you have a trade-in or need to adjust your total to match the dealer's total, enter it under "Trade in OR Adjustment (+/-)". You can enter negative numbers to adjust the total if needed. 6) Enter the # of months of the loan into the "Number of Months in Loan" field. 7) Enter the interest rate of the loan into the "Interest Rate (APR)" field. Do steps 1-7 for the other 3 loan scenarios if desired. That's it! The spreadsheet calculates the sales tax, monthly payment, total interest on the loan, total cost of the loan, and the total cost of the car with all the loan payments, interest, tax, etc. Special Notes:
Page 7
Instructions
* These calculations assume that all loan payments are paid at the end of the month. Most internet calculators are like that as well.
* Luxury Tax is not included in the calculations, so if your vehicle is subject to it, you can account for it in the selling price field or in the "Selling Price" field or in the "Trade in OR Adjustment (+/-)" field.
* As you move from cell to cell, you will see the formula for each calculated amount in the formula bar located up in the status window. This makes it easier for you to determine how the numbers were generated. The cells are also named so the formulas a
* I spent many hours creating this free spreadsheet to give out at no cost to readers of my free consumer tips articles. Please don't attempt to sell this or incorporate it into a product, it was meant to be given out for free, by me, no resold. * Feel free to make as many copies of this spreadsheet as you wish and give them to anyone for free, but don't resell it or try to take credit for it. It's my gift to the world.
Page 8
Instructions
Page 9
Instructions
Page 10
Instructions
Page 11
Instructions
Page 12
Instructions
Page 13
Instructions
Page 14