Question

A house costs $138,000. It is to be paid off in exactly ten years, with monthly...

  1. A house costs $138,000. It is to be paid off in exactly ten years, with monthly payments of $1675. What is the APR of this loan? (Hint: calculate monthly rate first; then use APR= monthly rate*12) Do this on excel.

Homework Answers

Answer #1

APR is 8%

Working:

Step-1:Calculation of monthly interest rate
Monthly interest rate = =rate(nper,pmt,-pv)
= 0.67%
Nper Number of periods = 10*12 = 120
pmt monthly payment = $             1,675
pv Cost of house = $       1,38,000
Step-2:Calculation of APR
APR = Monthly Interest rate*12
= 0.67% * 12
= 8%
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
An investor has 6 years of monthly payments of $1,400 before she has paid off her...
An investor has 6 years of monthly payments of $1,400 before she has paid off her house. If the interest rate is 6% APR, what is the remaining balance on her loan?
Suppose that you obtain a ten-year $ 100,000 loan to purchase a house and the annual...
Suppose that you obtain a ten-year $ 100,000 loan to purchase a house and the annual interest rate is 7 percent, what should be your monthly payment of principal and interest for the next ten years? (Hint: In the Excel PMT process, convert the annual interest rate and payment periods to the monthly rate and payment periods). Suppose the length of the loan is twenty years in Question 5, what should your monthly payment of principal and interest be for...
Suppose that you obtain a ten-year $100,000 loan to purchase a house and the annual interest...
Suppose that you obtain a ten-year $100,000 loan to purchase a house and the annual interest rate is 7 percent, what should be your monthly payment of principal and interest for the next ten years? (Hint: In the Excel PMT process, convert the annual interest rate and payment periods to the monthly rate and payment periods.)
Aya and Harumi would like to buy a house and their dream house costs $500,000. They...
Aya and Harumi would like to buy a house and their dream house costs $500,000. They have $50,000 saved up for a down payment but would still need to take out a mortgage loan for the remaining $450,000 and they’re not sure whether they could afford the monthly loan payments. The bank has offered them an interest rate of 4.25%, compounded monthly. How much would they have to be able to afford to pay each month in order to pay...
The mortgage on your house is five years old. It required monthly payments of ​$1,402, had...
The mortgage on your house is five years old. It required monthly payments of ​$1,402, had an original term of 30​ years, and had an interest rate of 10%​(APR). In the intervening five​ years, interest rates have fallen and so you have decided to refinancethat ​is, you will roll over the outstanding balance into a new mortgage. The new mortgage has a​ 30-year term, requires monthly​ payments, and has an interest rate of ​6.625%(APR). a. What monthly repayments will be...
The mortgage on your house is five years old. It required monthly payments of $1,390​, had...
The mortgage on your house is five years old. It required monthly payments of $1,390​, had an original term of 30​ years, and had an interest rate of 10% ​(APR). In the intervening five​ years, interest rates have fallen and so you have decided to refinance—that ​is, you will roll over the outstanding balance into a new mortgage. The new mortgage has a​ 30-year term, requires monthly​ payments, and has an interest rate of 5.625% ​(APR). a. What monthly repayments...
It’s been exactly five years since Mr. Smith bought his house with a 30-year mortgage which...
It’s been exactly five years since Mr. Smith bought his house with a 30-year mortgage which had an interest rate of 9.00% (APR, monthly compounding). The outstanding balance of the current mortgage is $178,799.01. In the intervening five years, interest rates have fallen and so Mr. Smith has decided to refinance the remaining balance on his current mortgage with a new 32-year mortgage which has monthly payments and an interest rate of 5.7% (APR, monthly compounding). How much would the...
You just found the house of your dreams. The price of the house is $200,000. You...
You just found the house of your dreams. The price of the house is $200,000. You have been qualified to get a mortgage loan with AAA Bank. The mortgage loan is for 30 years at an annual interest rate of 12%z Part (A): How much are your monthly payments for the loan? Part (B): What is the balance of the mortgage loan after 3 years of payments? Part (C): After 3 years of payments, you want to add extra money...
A truck costing $112,000 is paid off in monthly installments over four years with 7.5​% APR....
A truck costing $112,000 is paid off in monthly installments over four years with 7.5​% APR. After three years the owner wishes to sell the truck. What is the amount he needs to pay on his loan before he can sell the​ truck?
Jason bought a house ten years ago. His payments are $700 per month and the APR...
Jason bought a house ten years ago. His payments are $700 per month and the APR on the loan is 6% and the original term was 30 years. With 20 years remaining now, what is the principal component of the next payment (121st payment)?
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT