You are buying a car and will borrow $31,837 with a 5-year loan. The interest rate...

You are buying a car and will borrow $31,837 with a 5-year loan. The interest rate is 4.46%, what is your monthly payment?

Solutions

Expert Solution

PV = 31837

Nper = 5 yr * 12 months = 60 months

Rate per month = 4.46%/12

FV = 0

The monthly payment can be calculated with the help of PMT function of Excel.

=PMT(0.0446/12,60,31837,0,0)

= $592.96

Monthly payment = 592.96

jeff jeffy answered 2 years ago

Next > < Previous

Related Solutions

If you accept a car loan of $20,000 for 5 years at an interest rate of...

If you accept a car loan of $20,000 for 5 years at an interest rate of 3%, what is the monthly payment?

You borrow a ten-year loan of $1,500,000. The annual interest rate is 13% that to be...

You borrow a ten-year loan of $1,500,000. The annual interest rate is 13% that to be repaid every 2 weeks. Assume 52 weeks a year. List the numerical answers and EXCEL formulas of payment, interest, principal paid and end balance of 115th periodic payment in the table provided. Payment Interest Principal End Balance (Period 115) (Numerical Answer) (Numerical Answer) (Numerical Answer) (Numerical Answer) (EXCEL Formula) (EXCEL Formula) (EXCEL Formula) (EXCEL Formula)

You borrow $7083 to buy a car. This is a 38-month loan with an annual rate...

You borrow $7083 to buy a car. This is a 38-month loan with an annual rate of 4.04%. What is your required monthly payment? Round to the nearest $0.01 (e.g., if your answer is $385.4789, record it as 385.48). Do this on excel and explain how to do it please.

Assume you are to borrow money, the loan amount, at an annual interest rate to be...

Assume you are to borrow money, the loan amount, at an annual interest rate to be paid in equal installments each period. Installment Loan Schedule Loan Amount $25,000 Annual Interest Rate 9.90% Periods per year 12 Years to payback 5 See Table B.3 in book. Factor 47.17454194 FACTOR = [1 - (1 / ((1 + R)^n)]/ R Equal Payments $529.95 let R = period interest rate let n = number of periods to payback loan Number of periods: 60 Reduction...

You took a loan to buy a new car. The monthly interest rate on the loan...

You took a loan to buy a new car. The monthly interest rate on the loan is 1.5% and you have to pay $240 every month for 60 months 1)What is the Present value of the Cash flows if its an ordinary annuity? 2)What is the future value of cash flows if its an ordinary annuity? 3)What is the present value of the cash flows if its an annuity due? 4)What is the future value of cash flows if its...

George bought a new car with a 4.1% interest rate for 5 years. The loan is...

George bought a new car with a 4.1% interest rate for 5 years. The loan is for $35,000. What is the interest portion of the first 12 payments?

You borrow $26,500 to purchase a brand new car. The interest rate is 6%, and the...

You borrow $26,500 to purchase a brand new car. The interest rate is 6%, and the dealer says that you can pick between a 4-year or 6-year loan. How much more interest would you have to pay on your loan if you selected the 6-year loan over the 4-year loan.

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?

George bought a new car with a 4.1% interest rate fro 5 years. The loan is...

George bought a new car with a 4.1% interest rate fro 5 years. The loan is for $35,000. What is the interest portion of the 48th payment?

You purchase a car for 10,000 The car loan is financed with a 5% per year,...

You purchase a car for 10,000 The car loan is financed with a 5% per year, 5 year loan with annyual payments starting at time 1 (1 year from today) through time 5 Each payment reduces the principal by a certain amount until the loan is completely paid off. What is the interest component of the first payment? (I am allowed to use the TI-34 and BAII Plus calculators)

Subjects