Question

Elaine takes out a $100,000 mortgage on December 1, 1997. Elaine will repay the mortgage over 20 years with level monthly pay

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

=PMT(8%/12,120,-FV(8%/12,120,PMT(8%/12,12*20,-100000),-100000))
=$836.44007

Option A Less than $900

Add a comment
Know the answer?
Add Answer to:
Elaine takes out a $100,000 mortgage on December 1, 1997. Elaine will repay the mortgage over...
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
  • John takes out a 50 000 mortgage on a home at 12 72 % convertible semiannually....

    John takes out a 50 000 mortgage on a home at 12 72 % convertible semiannually. He pays off the mortgage with monthly payments for 20 years, the first one due one month after the mortgage is taken out. Immediately after his 60th payment, John renegotiates the loan. He agrees to repay the remainder of the mortgage by making immediate cash payments of 10 000 and repaying the balance by means of monthly payments for ten years at 11% convertible...

  • Dave takes out a 23-year mortgage of 290000 dollars for his new house. Dave gets an...

    Dave takes out a 23-year mortgage of 290000 dollars for his new house. Dave gets an interest rate of 14.4 percent compounded monthly. He agrees to make equal monthly payments, the first coming in one month. After making the 70th payment, Dave wants to buy a boat, so he wants to refinance his house to reduce his monthly payment by 400 dollars, and to get a better interest rate. In particular, he negotiates a new rate of 7.2 percent compounded...

  • answer those 4 please Fatima just borrowed 83,364 dollars. She plans to repay this loan by...

    answer those 4 please Fatima just borrowed 83,364 dollars. She plans to repay this loan by making a special payment of 29,387 dollars in 7 years and by making regular annual payments of 13,147 dollars per year until the loan is paid off. If the interest rate on the loan is 17.93 percent per year and she makes her first regular annual payment of 13,147 dollars immediately, then how many regular annual payments of 13,147 dollars must Fatima make? Round...

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

  • On December 1, 2018, Driscoll, Inc. signed a 20 year mortgage in the amount of $300,000...

    On December 1, 2018, Driscoll, Inc. signed a 20 year mortgage in the amount of $300,000 in conjunction with the purchase of an office building. This note is payable in equal monthly installments of $1,980 which include interest computed at an annual rate of 5%. The first annual payment is made on December 31, 2018. Prepare an amortization table for the first two payments. How much of the first payment made on December 31, 2018, is allocated to repayment of...

  • 31.  (14 points) On December 1, 2019, Driscoll, Inc. signed a 10 year mortgage in the amount...

    31.  (14 points) On December 1, 2019, Driscoll, Inc. signed a 10 year mortgage in the amount of $275,000 in conjunction with the purchase of an office building.  This note is payable in equal monthly installmentsof $2,784 which include interest computed at an annual rate of 4%. The first monthly payment is made on December 31, 2019. Prepare an amortization table for the first two payments. How much of the first payment made on December 31, 2019, is allocated to         repayment of...

  • On January 1, 2020 a company takes out a 5-year mortgage on a new property in...

    On January 1, 2020 a company takes out a 5-year mortgage on a new property in the amount of $511,000 at an annual interest rate of 6%. There will be a fixed monthly payment payable at the end of each month that will include both interest and principal. The fixed monthly payment payable is $9,879.06. We were unable to transcribe this imageWe were unable to transcribe this image(b) Record the journal entries for the first 2 months' payments. (Round answers...

  • Part (b) only On January 1, 2020 a company takes out a 5-year mortgage on a...

    Part (b) only On January 1, 2020 a company takes out a 5-year mortgage on a new property in the amount of $503,000 at an annual interest rate of 6%. There will be a fixed monthly payment payable at the end of each month that will include both interest and principal. The fixed monthly payment payable is $9,724.40. *(a) Your answer is correct. Calculate the amount of interest and principal for the first month's payment. (Round answers to 2 decimal...

  • 164 PART 3 Valuation of Future Cash Flows CHAPTER CASE S&S Air's Mortgage M ark Sexton...

    164 PART 3 Valuation of Future Cash Flows CHAPTER CASE S&S Air's Mortgage M ark Sexton and Todd Story, the owners of S&S Air, Inc., IV Iwere impressed by the work Chris had done on finan- cial planning. Using Chris's analysis, and looking at the de- mand for light aircraft, they have decided that their existing fabrication equipment is sufficient, but it is time to acquire a bigger manufacturing facility. Mark and Todd have identi- fied a suitable structure that...

  • %%Python Question%% get_min_payment() • Parameters ◦ the total amount of the mortgage (called the principal; should...

    %%Python Question%% get_min_payment() • Parameters ◦ the total amount of the mortgage (called the principal; should be a positive number) ◦ the annual interest rate (should be a float between 0 and 1) ◦ the term of the mortgage, in years (should be a positive integer; default value: 30) ◦ the number of payments per year (should be a positive integer; default value: 12) • Functionality ◦ Compute the minimum mortgage payment. Should use the formula A= Pr(1+r) n (1+r)...

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