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.

Solutions

Expert Solution

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

You borrow $24,000 to buy a car. The loan is to be paid off in quarterly...

You borrow $24,000 to buy a car. The loan is to be paid off in quarterly installments over four years at 10 percent interest annually. The first payment is due one quarter from today. What is the amount of each quarterly payment? a) $1,745 b) $1,794 c) $1,838 d) $1,876 I need the hand-written formula, not the calculator input.

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...

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 buy a car for $40,000. You agree to a 6 year loan with a annual...

You buy a car for $40,000. You agree to a 6 year loan with a annual interest 6 percent. a. What is your required monthly payment? b. What is the total amount interest payment over this period? C. Show the difference in the total interest payment if the payment was done yearly instead of monthly?

You borrow $149000 to buy a house. The mortgage rate is 7.5% and the loan period...

You borrow $149000 to buy a house. The mortgage rate is 7.5% and the loan period is 30 years. Payments are made monthly. What is the monthly mortgage payment.

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?

You buy a car for $40,000. You agree to a 72-month loan with a monthly interest...

You buy a car for $40,000. You agree to a 72-month loan with a monthly interest rate of 0.35 percent. a. What is your required monthly payment? b. What is the total amount interest payment over this period?

You buy a car for $38,000. You agree to a 60-month loan with a monthly interest...

You buy a car for $38,000. You agree to a 60-month loan with a monthly interest rate of 0.55 percent. What is your required monthly payment? Multiple Choice $745.29 $764.07 None of these choices are correct. $634.24 $605.54

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 took out a loan to buy a new car. The monthly interest rate on the...

You took out a loan to buy a new car. The monthly interest rate on the loan is 1%. You have to pay $270 every month for 60 months. Attempt 1/5 for 8 pts. Part 1 What is the present value of the cash flows if it's an ordinary annuity? Attempt 1/5 for 8 pts. Part 2 What is the future value of the cash flows if it's an ordinary annuity? Attempt 1/5 for 10 pts. Part 3 What is...

Subjects