Question

In: Finance

If you borrow $26,000 with monthly payments of $550 over 5 years, what annual rate are...

If you borrow $26,000 with monthly payments of $550 over 5 years, what annual rate are you paying?

A. 8.18% B.

8.41%

C. 9.81%

D. 8.51%

Solutions

Expert Solution

c.9.81%

We can use the Excel function= RATE() for the computation

Loan Amount =$26,000

Number of Periods=60

Compounding Periods per year =12

Monthly Payment=$550

The interest rate can be calculated in Excel using the rate function.The formula is=RATE(B2,B4,-B1)*12

Interest rate =9.81%


Related Solutions

Assume that you borrow $15,000 for five years (annual payments) at a market rate of 5%....
Assume that you borrow $15,000 for five years (annual payments) at a market rate of 5%. Assuming that inflation is 3.5%, what would the equivalent equal annual payment be in constant dollars?
You borrow $100,000 and make annual payments for 5 years. The interest rate is 8%. How...
You borrow $100,000 and make annual payments for 5 years. The interest rate is 8%. How much interest do you pay in year 2? PLEASE EXPLAIN STEP BY STEP HOW YOU SOLVE WITH ONLY YOUR FINANCIAL CALCULATOR
A loan is amortized over five years with monthly payments at an annual nominal interest rate...
A loan is amortized over five years with monthly payments at an annual nominal interest rate of 6% compounded monthly. The first payment is 1000 and is to be paid one month from the date of the loan. Each succeeding monthly payment will be 3% lower than the prior payment. Calculate the outstanding loan balance immediately after the 40th payment is made.
You borrow $60,000; the annual loan payments are $5,840.18 for30 years. What interest rate are...
You borrow $60,000; the annual loan payments are $5,840.18 for 30 years. What interest rate are you being charged? Round your answer to the nearest whole number.
You borrow $180,000; the annual loan payments are $11,709.26 for 30 years. What interest rate are...
You borrow $180,000; the annual loan payments are $11,709.26 for 30 years. What interest rate are you being charged? Round your answer to two decimal places.
You borrow $245,000; the annual loan payments are $23,847.41 for 30 years. What interest rate are...
You borrow $245,000; the annual loan payments are $23,847.41 for 30 years. What interest rate are you being charged? Round your answer to two decimal places.
Suppose you borrow $200,000 at 5% for 30 years, monthly payments. You pay 2 discount points....
Suppose you borrow $200,000 at 5% for 30 years, monthly payments. You pay 2 discount points. A. (1 pt) Your APR on this loan is 5.375%. What amount of other financing fees did you pay? B. (1 pt) Suppose that your effective cost over a five-year holding period is 5.625%. What amount of other fees did you pay?
Suppose you borrow $200,000 at 5% for 30 years, monthly payments. You pay 2 discount points....
Suppose you borrow $200,000 at 5% for 30 years, monthly payments. You pay 2 discount points. A. (1 pt) Your APR on this loan is 5.375%. What amount of other financing fees did you pay? B. (1 pt) Suppose that your effective cost over a five-year holding period is 5.625%. What amount of other fees did you pay?
Suppose you borrow $11,000 at an annual interest rate of 7% compounded monthly over 36 months....
Suppose you borrow $11,000 at an annual interest rate of 7% compounded monthly over 36 months. At the end of the first year, after 12 payments, you want to pay off the remaining balance in 8 equal MONTHLY installments. If the interest rate and the compounding frequency remain the same, how much is each of the 8 payments.
What is the present value of annual $7,399 payments over the upcoming 5 years ,on an...
What is the present value of annual $7,399 payments over the upcoming 5 years ,on an interest rate of 10%?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT