Question

1. You have just purchased a house and borrowed $90,000 towards the purchase. The amount is...

1. You have just purchased a house and borrowed $90,000 towards the purchase. The amount is to be repaid over a period of 11 years in payments of $1,000 each month. What is the Annual Percentage Rate (APR) of the loan?

please explain the formula or excel func you use to solve. thanks!

Homework Answers

Answer #1
This can be solved using the Present value of annuity
Present value of Annuity = P*((1-(1+r)^-n/r)
P is Periodic payment monthly = $ 1,000 /-
r is Rate of Interest = ?
n is No of months = 132 Months
Present Value of Annuity is = $ 90,000 /-
90000=(1000*(1-(1+r)^-132)/r)
1-(1+r)^-132/r=90
Using trail and error "r" is computed as
Annual interst rate "r" is 6.5202% Approx.
Annual Percentage Rate (APR) of the loan is 6.5202%
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
purchase of your first home for $600,000. You have just purchased the house and have put...
purchase of your first home for $600,000. You have just purchased the house and have put a 20% down payment, and will borrow the remaining amount.  The 15-year fixed rate loan has an Annual Percentage Rate (APR) of 3.875%.   You will make monthly payments for the life of the loan. Question 12 related to your purchase of your first home for $600,000. You have just purchased the house and have put a 20% down payment, and will borrow the remaining amount.  The 15-year...
This morning, you borrowed $162,000 to buy a house. The mortgage rate is 4.35 percent. The...
This morning, you borrowed $162,000 to buy a house. The mortgage rate is 4.35 percent. The loan is to be repaid in equal monthly payments over 20 years with the first payment due one month from today. Assume each month is equal to 1/12 of a year and all taxes and insurance premiums are paid separately. How much of the second payment applies to the principal balance? Please do not use excel $714.43 $721.14 $658.56 $743.38 $756.70
you borrowed $500,000 to buy a house. The mortgage rate s 24% (APR, monthly). The loan...
you borrowed $500,000 to buy a house. The mortgage rate s 24% (APR, monthly). The loan is to be repaid in equal monthly payments over 30 years. 29 years has passed. How much you owe to the bank on your home (loan principal) since you have 1 year left from your mortgage? Assume that each month is equal to 1/12 of a year.
You have just purchased a new warehouse. To finance the purchase, you have arranged for a...
You have just purchased a new warehouse. To finance the purchase, you have arranged for a 30-year mortgage loan for 80% of the $3,400,000 purchase price. The monthly payment on this loan will be $17,500. What is the monthly compounded APR on this loan? What is the EAR? I need a proper solution with formula and not financial calculator.
You have just purchased a new warehouse. To finance the purchase, you’ve arranged for a 30-year...
You have just purchased a new warehouse. To finance the purchase, you’ve arranged for a 30-year mortgage loan for 80 percent of the $3,400,000 purchase price. The monthly payment on this loan will be $17,500. What is the APR on this loan? What is the EAR on this loan?
You   just   borrowed   $200,000   to   buy   a   house   amortized   over   a   period   of   25   years. &nb
You   just   borrowed   $200,000   to   buy   a   house   amortized   over   a   period   of   25   years.   You   signed   a   5-year   mortgage   deal   with   your   bank   at   a   rate   of   0.75%   effective   monthly   rate.   Your   monthly   payment   comes   out   to   $1,678.39.   How   much   of   your   20th payment   will   go   towards   payment   of   interest?   a) $1,427.25 b) $1,470.28 c) $1,471.25 d) $1,472.79 e) $1,473.67
You have just purchased a new warehouse. To finance the purchase, you’ve arranged for a 30-year...
You have just purchased a new warehouse. To finance the purchase, you’ve arranged for a 30-year mortgage for 80 percent of the $3,700,000 purchase price. The monthly payment on this loan will be $17,800. What is the APR on this loan? What is the EAR on this loan?
1. You have just purchased your dream house on Hawai’i for $500,000. You have been charged...
1. You have just purchased your dream house on Hawai’i for $500,000. You have been charged an interest rate of 9% APR, compounded monthly, and have entered into a 30-year mortgage with the bank. What are your monthly payments? 2. What are the second month's principal payment and ending balance?
You have just purchased a new warehouse. To finance the purchase, you've arranged for a 30-year...
You have just purchased a new warehouse. To finance the purchase, you've arranged for a 30-year mortgage loan for 80 percent of the $2,800,000 purchase price. The monthly payment on this loan will be $17,000. a. What is the APR on this loan? b. What is the EAR?
You have just purchased a new warehouse. To finance the purchase, you’ve arranged for a 35-year...
You have just purchased a new warehouse. To finance the purchase, you’ve arranged for a 35-year mortgage for 85 percent of the $4,100,000 purchase price. The monthly payment on this loan will be $18,200. what is the apr and ear of this loan?