Question

(1 point) A couple has decided to purchase a $100000 house using a down payment of $13000. They can amortize the balance at 5

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

1.
=PMT(5%/12,12*20,-100000+13000)=574.161493118492

2.
=PMT(5%/12,12*20,-100000+13000)*12*20-100000+13000=50798.7583484381

3.
=100000-FV(5%/12,12*5,PMT(5%/12,12*20,-100000+13000),-100000+13000)=27394.2690352328

4.
=100000-FV(5%/12,12*15,PMT(5%/12,12*20,-100000+13000),-100000+13000)=69574.7769356507

Add a comment
Know the answer?
Add Answer to:
(1 point) A couple has decided to purchase a $100000 house using a down payment of $13000. They c...
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
  • 5. A couple has decided to purchase a $250,000 house welded to purchase a $250,000 house...

    5. A couple has decided to purchase a $250,000 house welded to purchase a $250,000 house using a down payment of $40,000. They can amortize the balance at 6% for 25 years. To do that they e at 6% for 25 years. To do that they will make monthly payments of $1353.03. (a) What is the total interest paid? (b) What is their equity after 10 years?

  • Suppose you just purchase a new house for $550,000, with a 20% down payment. The mortgage...

    Suppose you just purchase a new house for $550,000, with a 20% down payment. The mortgage has a 6.1 percent stated annual interest rate, compounded monthly, and calls for equal monthly payments over the next 30 years. Your first payment will be due in 1 month. However, the mortgage has an eight-year balloon payment, meaning that the balance of the loan must be paid off at the end of Year 8. Suppose there are no other transaction costs or finance...

  • The Turners have purchased a house for $130,000. They made an initial down payment of $30,000...

    The Turners have purchased a house for $130,000. They made an initial down payment of $30,000 and secured a mortgage with interest charged at the rate of 10%/year compounded monthly on the unpaid balance. The loan is to be amortized over 30 yr. (Round your answers to the nearest cent.) (a) What monthly payment will the Turners be required to make? $   (b) How much total interest will they pay on the loan? $   (c) What will be their equity...

  • A couple wishes to borrow money using the equity in their home for collateral. A loan...

    A couple wishes to borrow money using the equity in their home for collateral. A loan company will loan them up to​ 70% of their equity. They puchased their home 13 years ago for ​60,634. The home was financed by paying 15​% down and signing a 15​-year mortgage at 8.1​% on the unpaid balance. Equal monthly payments were made to amortize the loan over the 15​-year period. The net market value of the house is now​$100,000. After making their 156th...

  • The Kaufman’s have decided to buy a house that costs $260,000. After a down payment of...

    The Kaufman’s have decided to buy a house that costs $260,000. After a down payment of $20,000, they can get an interest rate of 7.8%. Find their monthly payments if they set up a 30 year loan What is the total amount they will pay for the house? How much total interest will they wind up paying on the loan?

  • 1. A house is priced at $200,000. A down payment of $40,000 has been made. Equal payment will be installed every mo...

    1. A house is priced at $200,000. A down payment of $40,000 has been made. Equal payment will be installed every month, so that the loan can be repaid in 20 years. The annual interest rate is 12.00%, compounded monthly. What is the monthly payment for this purchase? (15 points)

  • us Econ 3.4.59 E Question Help A couple wishes to borrow money using the equity in their home for collateral. A loan...

    us Econ 3.4.59 E Question Help A couple wishes to borrow money using the equity in their home for collateral. A loan company will loan them up to 70% of their equity. They puchased their home 12 years ago for $61,384. The home was financed by paying 20% down and signing a 15-year mortgage at 8.4% on the unpaid balance. Equal monthly payments were made to amortize the loan ver the 15-year period. The net market value of the house...

  • Question 5 (5 points) Ahmad has decided to purchase a house instead of renting an apartment....

    Question 5 (5 points) Ahmad has decided to purchase a house instead of renting an apartment. He has $6000 to use as a present down payment for the house and agreed with the bank to pay monthly payments of $2000 starting one month from now. If the nominalDinterest rate of the loan is 12% peryear compounded monthly and the loan will be paid in 7 years, how much will Ahmad pay for this house in total at the end of...

  • Question Help A couple wishes to borrow money using the equity in their home for collateral....

    Question Help A couple wishes to borrow money using the equity in their home for collateral. A loan company will loan them up to 70% of their equity. They puchased their home 10 years ago for $71,374. The home was financed by paying 20% down and signing a 30-year mortgage at 8.7% on the unpaid balance. Equal monthly payments were made to amortize the loan over the 30-year period. The net market value of the house is now $100,000. After...

  • In order to accumulate enough money for a down payment on a house, a couple deposits...

    In order to accumulate enough money for a down payment on a house, a couple deposits $624 per month into an account paying 6% compounded monthly. If payments are made at the end of each period, how much money will be in the account in 3 years? What is the amount in the account after 3 years? $ (Round to the nearest cent as needed.)

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
ADVERTISEMENT