Question

2. You take out a home loan of $500 000, which will be repaid in 40 level payments at the end of each six-month period, start

0 0
Add a comment Improve this question Transcribed image text
Answer #1
Loan Amount          500,000
Number of Payments N 40 bi-annual payment
Anuual Int rate 5%
Repayment Amounts    19,918.117 =-PMT(Annual Rate/2,N,Loan Amount) Answer a
=-PMT(5%/2,40,500000)
Annual Rate 5%
Monthly rate 0.417%
Annualized Rate 5.116%
Repayment Amounts    20,113.482 =-PMT(Annual Rate/2,N,Loan Amount) Answer b
=-PMT(5.116%/2,40,500000)
Add a comment
Know the answer?
Add Answer to:
2. You take out a home loan of $500 000, which will be repaid in 40 level payments at the end of each six-month period,...
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
  • You take out a home loan of $500 000, which will be repaid in 40 level payments at the end of each six-month period, sta...

    You take out a home loan of $500 000, which will be repaid in 40 level payments at the end of each six-month period, starting in six months. The annual interest rate is 5%. (a) Compute the size of the repayments if interest is compounded every six months. (b) Suppose instead that interest is compounded monthly but repayments are still made every six months. Determine the equivalent annual interest rate for payments made every six months and find the size...

  • 2. You take out a home loan of $500 000, which will be repaid in 40...

    2. You take out a home loan of $500 000, which will be repaid in 40 level payments at the end of each six-month period, starting in six months. The annual interest rate is 5% (a) Compute the size of the repayments if interest is compounded every six months. (b) Suppose instead that interest is compounded monthly but repay- ments are still made every six months. Determine the equivalent annual interest rate for payments made every six months and find...

  • 1. You won $100 000 in a lottery and you want to set some of that...

    1. You won $100 000 in a lottery and you want to set some of that sum aside for 10 years. After 10 years, you would like to receive $2400 at the end of every 3 months for 8 years. How much of your winnings must you set aside if interest is 5.5% compounded quarterly? 2. A sum of money is deposited at the end of every month for 10 years at 7.5% compounded monthly. After the last deposit, interest...

  • A loan of $25, 000 is paid off in semi-annual payments over a four year period.  ...

    A loan of $25, 000 is paid off in semi-annual payments over a four year period.   Interest is 6.2% compounded quarterly. What is the size of the payment made at the end of every six months ? (Please use the financial calculator method (BAII) by showing inputs in the financial calculator)

  • Samuel and Sandra Sharp wish to borrow $600,000 to buya home. The loan from the Highway...

    Samuel and Sandra Sharp wish to borrow $600,000 to buya home. The loan from the Highway Bank requires equal monthly repayments over 20 years, and carries an interest rate of 5-1 % per annum, compounded monthly. The first repayment is due at the end of one month after the loan proceeds are received. You are required to calculate the following. i) The effective annual interest rate on the above loan (show as a percentage correct to 3 decimal places). li)...

  • Please post with mathematical formulas please, not an excel sheet! 1. Mr. X is repaying a loan by monthly payments of $1...

    Please post with mathematical formulas please, not an excel sheet! 1. Mr. X is repaying a loan by monthly payments of $146.75 at a nominal annual rate of 9% compounded monthly. Immediately after one of the pay- ments is made, when Mr. X has still 50 payments ahead of him, the lender lowers the interest rate to 7.8% nominal annual rate compounded monthly. Mr. X chooses to keep the same monthly payments, except the last payment that is larger than...

  • all the information are provided 2) A debt of $32 000 is repaid by payments of...

    all the information are provided 2) A debt of $32 000 is repaid by payments of $2950 made at the end of every six months. Interest is 8.28% compounded quarterly. a. What is the number of payments needed to retire the debt? b. What is the cost of the debt for the first five years? c. What is the interest paid in the 10th payment period? d. Construct a partial amortization schedule showing details of the first five payments.

  • Question 3 (1 point) A loan of $32,000 at 6% compounded annually is to be repaid...

    Question 3 (1 point) A loan of $32,000 at 6% compounded annually is to be repaid by equal payments at the end of every month for three years. How much interest will be included in the 19th payment? 4 poing A home improvement loan is to be repaid by equal monthly payments for six years. The interest rate is 5.4% compounded monthly and the amount borrowed is $33,500. How much interest will be included in the first payment?

  • Jean receives annuity payments at the end of every six months. If she deposits these payments...

    Jean receives annuity payments at the end of every six months. If she deposits these payments in an account earning interest at 9% compounded monthly, what is the equivalent semi-annually compounded rate of interest? What sum of money must be deposited at the end of every 3 months into an account paying 6% compounded monthly to accumulate to $25,000 in 10 years? Irina deposited $150 in a savings account at the end of each month for 60 months. If the...

  • Langara Woodcraft borrowed money to purchase equipment. The loan is repaid by making payments of $719.75...

    Langara Woodcraft borrowed money to purchase equipment. The loan is repaid by making payments of $719.75 at the end of every six months over ten years. If interest is 6.7% compounded monthly, what was the original loan balance? The original loan balance was $ (Round the final answer to the nearest cent as needed. Round all intermediate values to six decimal places 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