Question

In: Finance

Loan 1: Amortize a $35,000 car loan at 4.5% over 5 years. How much is the...

Loan 1: Amortize a $35,000 car loan at 4.5% over 5 years. How much is the monthly payment? How much will the borrower pay in total interest?

Solutions

Expert Solution

I HAVE CALCULATED MONTHLY PAYMENT USING EXCEL AND FORMULA, BOTH WAYS.


Related Solutions

Amortize a $35,000 car loan with a 5% annual interest rate and payments for 60 months...
Amortize a $35,000 car loan with a 5% annual interest rate and payments for 60 months (4) What is the monthly payment? (5) What will the balance on the loan be after 2 years of payments? (Assume that you just took out the loan) (6) How many months will it be before the car is halfway paid off?
How much should each payment be for a 22-years term loan of $250,000 that charges 4.5%...
How much should each payment be for a 22-years term loan of $250,000 that charges 4.5% APR (compounded quarterly) if the payments are a) Monthly, b) Semi-annual, c) Quarterly, d) Annual.
Find the periodic payment R required to amortize a loan of P dollars over t years...
Find the periodic payment R required to amortize a loan of P dollars over t years with interest charged at the rate of r%/year compounded m times a year. (Round your answer to the nearest cent.) a. P = 50,000, r = 4, t = 15, m = 4 b. P = 90,000, r = 3.5, t = 17, m = 12' c. P = 120,000, r = 5.5, t = 29, m = 4
A person amortizes a loan of $17000 for a car with a 5 years loan at...
A person amortizes a loan of $17000 for a car with a 5 years loan at the rate of 6.5% compounded monthly. (a) Find the montly payments. The payments are of $ . (b) Find the total interest charges. The interest is $ . (c) Find the principal remaining after 2 years. The principal remaining is of $ .
1a. If you take out a car loan for $30,000 for 6 years at 4.5% Simple...
1a. If you take out a car loan for $30,000 for 6 years at 4.5% Simple interest what is the monthly payment? and How much will you pay in total for interest at the end of the 6 years? 1b. If you take out a car loan for $30,000 for 6 years at 4.5% Compound Interest what is the monthly payment? and How much will you pay in total for interest at the end of the 6 years?
You buy a house for $500,000 with 5% down and amortize over 30 years. i. Including...
You buy a house for $500,000 with 5% down and amortize over 30 years. i. Including CMHC insurance, how much will your outstanding mortgage be when the mortgage is issued? ii. If house prices drop by 20% over 3 years and the interest rate on the mortgage is 3.59%, how much larger is the outstanding mortgage than the value of the house? (This situation is often called ‘underwater’ and can lead to a number of problems – e.g. one needs...
On a 5-year, $20K car loan at 4% APR, how much money will you still owe...
On a 5-year, $20K car loan at 4% APR, how much money will you still owe after 3 years? (round to the nearest dollar, no pennies!) Numeric Response
1. What would be the monthly payment on a 5 year loan of $35,000 if the...
1. What would be the monthly payment on a 5 year loan of $35,000 if the interest rate is 6.0% compounded monthly? 2. Sarah bought a raft for $664 using her credit card. The interst rate is 0.186 compounded monthly. If she pays $23 a month, how long will it take her to pay off the credit card? 3. What would be the monthly payment on a 5 year loan of $24,000 if the interest rate is 5.0% compounded monthly?
You have just purchased a car and taken out a $35,000 loan. The loan has a​...
You have just purchased a car and taken out a $35,000 loan. The loan has a​ five-year term with monthly payments and an APR of 5.7%. a. How much will you pay in​ interest, and how much will you pay in​ principal, during the first​ month, second​ month, and first​ year? (Hint: Compute the loan balance after one​ month, two​ months, and one​ year.) b. How much will you pay in​ interest, and how much will you pay in​ principal,...
You have just purchased a car and taken out a $35,000 loan. The loan has a​...
You have just purchased a car and taken out a $35,000 loan. The loan has a​ five-year term with monthly payments and an APR of 6.1%. a. How much will you pay in​ interest, and how much will you pay in​ principal, during the first​ month, second​ month, and first​ year? (Hint: Compute the loan balance after one​ month, two​ months, and one​ year.) b. How much will you pay in​ interest, and how much will you pay in​ principal,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT