Question

A borrower takes out a 15-year mortgage loan for $250.000 with an interest rate of 6%. What would the monthly payment be? (A)

0 0
Add a comment Improve this question Transcribed image text
Answer #1

fx =PMT(C2,C3,-C4,C5,C6) C7 ДА 1 2 RATE 3 NPER 4 PV 5 FV 6 TYPE 7 PMT 0.005 0.06/12 180 15*12 2 50000 200000-15000 1 Rate Per

Add a comment
Know the answer?
Add Answer to:
A borrower takes out a 15-year mortgage loan for $250.000 with an interest rate of 6%....
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • A B C A borrower takes out a 29-year mortgage loan for $286,819 with an interest...

    A B C A borrower takes out a 29-year mortgage loan for $286,819 with an interest rate of 9%. What would the monthly payment be? A borrower takes out a 30-year mortgage loan for $190,372 with an interest rate of 8% and monthly payments. What portion of the first month's payment would be applied to interest? A borrower has a 25-year mortgage loan for $495,186 with an interest rate of 9% and monthly payments. If she wants to pay off...

  • A borrower takes out a 30-year adjustable rate mortgage loan for $200,000 with monthly payments. The...

    A borrower takes out a 30-year adjustable rate mortgage loan for $200,000 with monthly payments. The first two years of the loan have a “teaser” rate of 4%, after that, the rate can reset with a 2% annual rate cap. On the reset date, the composite rate is 5%. What would the Year 3 monthly payment be? a. $955 b. $1,071 c. $1,067 d. $1,186 e. Because of the rate cap, the payment would not change.

  • 2. (25 Points) Suppose a borrower takes out a 30-year adjustable rate mortgage loan for $200,000...

    2. (25 Points) Suppose a borrower takes out a 30-year adjustable rate mortgage loan for $200,000 with monthly payments. The first two years of the loan have a "teaser" rate of 4%, after that, the rate can reset with a 2% annual rate cap. On the reset date, the composite rate is 7%. What would the Year 3 monthly payment be? (15 points) Step I Step2 PV= -179084.11 PV = -200 000 I= 7412=10.58) I=47212= 10.33) N= 336 N=360 130x2)...

  • show the work on a calculator A borrower takes-out a fully amortizing loan for $1,000,000. The...

    show the work on a calculator A borrower takes-out a fully amortizing loan for $1,000,000. The term of the loan is 30 years. The initial interest is 6% APR, compounded monthly. After one year, the interest rises to 8% APR, compounded monthly. After two years, the interest falls back to 6% APR, compounded monthly. After three years, the interest further falls to 4% APR, and it remains at 4% APR for the rest of the loan term Part A What...

  • A company takes out a loan of 15,000,000 at an annual effective discount rate of 5.5%....

    A company takes out a loan of 15,000,000 at an annual effective discount rate of 5.5%. You are given: (i) The loan is to be repaid with n annual payments of 1,200,000 plus a drop payment one year after the nth payment. (ii) The first payment is due three years after the loan is taken out. Calculate the amount of the drop payment. 5. On January 1, 2010 Susan took out a 30-year mortgage loan in the amount of 200,000...

  • Jeremy takes out a 30-year mortgage of 220000 dollars at an annual interest rate of 6.5...

    Jeremy takes out a 30-year mortgage of 220000 dollars at an annual interest rate of 6.5 percent compounded monthly, with the first payment due in one month. How much does he owe on the loan immediately after the 87th payment?

  • AP10-1A (Journal entries for a loan) A company takes out a five-year, $1-million mortgage on October...

    AP10-1A (Journal entries for a loan) A company takes out a five-year, $1-million mortgage on October 1. The interest rate on the loan is 6% per year, and blended payments of $19,333 (including both interest and principal) are to be made at the end of each month. The following is an extract from the loan amortization table the bank provided the company: Beginning Loan Balance Ending Loan Balance Payment Interest Principal Payment 1 $19,333 $5,000 $1,000,000 985,667 $14,333 14,405 $985,667...

  • Greg takes out a $22,000 loan to buy new motorcycle. The interest rate is 3.9% per...

    Greg takes out a $22,000 loan to buy new motorcycle. The interest rate is 3.9% per year and the term is 84 months. This works out to be a monthly payment of $300. (a) The first payment includes $71.50 of interest. How much principal is in the first payment? (b) What is the new loan balance after Greg makes the first payment? (c) Explain why it is incorrect to say that Greg will pay $71,50x84 = $6006 in total interest....

  • A borrower takes out a 10-year loan of 1000 at 8% compounded quarterly. The borrower makes...

    A borrower takes out a 10-year loan of 1000 at 8% compounded quarterly. The borrower makes quarterly payments. Calculate the amount of principal paid in the ninth payment.

  • 3, Jimmy takes out a $50,000 mortgage on a home at a 5.6% interest rate convertible...

    3, Jimmy takes out a $50,000 mortgage on a home at a 5.6% interest rate convertible monthly. He plans to pay off the mortgage with monthly payments for 20 years. Immediately following the 60h payment, he renegotiates the loan. He agrees to make a cash payment of $7500 and will pay the remaining balance with monthly payments over 10 years at a rate of 4.1% convertible monthly. Calculate his new monthly payment.

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT