Question

Mr Benard is struggling to repay his loan of $ 400,000 with payments of $ 7,200...

Mr Benard is struggling to repay his loan of $ 400,000 with payments of $ 7,200 made monthly in arrears for 6 years.

(a) Calculate the FLAT RATE OF INTEREST per annum

(b) Hence, or otherwise, calculate the APR of Mr Benard's loan

After exactly one , loan company offers to " help" Mr Benard by restructuring his loan with new monthly payments of $ 4,000 made in arrears

(c) Assuming the company charges the same APR as Mr Benard's original loan. Calculate the term of the new loan

( d) Calculate how much more interest in total Mr Benard will pay on his restructured loan than on his original loan

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

(a) Flat Rate= 4.9333% as calculated below:

B C D E Values 400,000 P P 3 Loan amount 4 Term (years) 5 Therefore, monthly repayment of principal p 6 Monthly payment total

(b) APR is arrived at using the RATE function of Excel at 8.948524% as follows:

foc =RATE(C5, C6,03*-1,0) *12 A D Cell ref Given Given Values 400,000 2 3 Loan amount 4 Term (years) 5 Number instalments 6 M

(c) It is assumed that the question refers to position 'after exactly one year'

The term of new loan is arrived at 177.88 months using the NPER function of Excel

C16 • Foc =NPER(C7/12,015,C14*-1,0,0) B 1 Cell ref Given Given Values 400,000 72 Given RATE 7,200 8.94852443% 2 3 Loan amount

(d): Total payment of new loan = Monthly payment* new term= $4,000*177.881966 = $711,527.86

Total payment for remaining period as per old plan= Monthly payment* Remaining period =$7,200*5*12 = $432,000

Increase in total payment (which is towards interest, hence increase in interest)= $711,567.86-$432,000 = $279,527.86

Add a comment
Know the answer?
Add Answer to:
Mr Benard is struggling to repay his loan of $ 400,000 with payments of $ 7,200...
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
  • please show all steps 2. You have borrowed a loan form bank for $400,000 to finance...

    please show all steps 2. You have borrowed a loan form bank for $400,000 to finance a new house. You are required to repay the loan in 360 equal monthly payments starting at the end of month 1. The bank charges an interest rate of 3% APR, compounded monthly. (i) What is the reduction in repayment time if you decide to add $400 to each payment? What is the remaining balance of the loan after 120 payments under (ii) the...

  • Problem 3 (Required, 25 marks) Recently, Mr. A has 2 outstanding loans: • Loan A -...

    Problem 3 (Required, 25 marks) Recently, Mr. A has 2 outstanding loans: • Loan A - He needs to repay $1720 at the end of every month and there are 36 repayments remaining. The loan charges interest at an annual nominal interest rate 12% compounded monthly Loan B - He needs to repay an amount X at the end of every month and there are 36 repayments remaining. The loan charges interest at an annual nominal interest rate 18% compounded...

  • 15. 10 years ago, Alan started to repay a loan by making equal month-end repayments of $3,200 for 15 years. If the inter...

    15. 10 years ago, Alan started to repay a loan by making equal month-end repayments of $3,200 for 15 years. If the interest rate charged for the loan is 12% per annum compounded monthly, the loan outstanding immediately after the 120th payment is closest to A. $125,430 B. $138,420 C. $142,440 D. $143,860 16. Andrew's monthly instalment made in arrears to repay his loan fully is $4,500. If the effective for the loan is 0.3%, calculate the amount of the...

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

  • Jose ust borrowed $3.500 to buy a used car payments. (End of Peniod) His loan is...

    Jose ust borrowed $3.500 to buy a used car payments. (End of Peniod) His loan is for 4 years with monthly payments The interest rate on the loan is 8% APR Calculate his monthly loan OA. S99 2 O B. S8545 O C. $72 92 O D. $84.88

  • ESTION 2 115 MARKS a) Mr. Azman, owner of a small business borrowed RM75,000 with an agreement to repay the loan with quarterly payments over a 5-year time period. If the interest rate is 12% per...

    ESTION 2 115 MARKS a) Mr. Azman, owner of a small business borrowed RM75,000 with an agreement to repay the loan with quarterly payments over a 5-year time period. If the interest rate is 12% per year compounded quarterly, how much is his loan payment for cach quarter? (10 Marks) b) A credit card issued by Bank Kimia Tech carries a nominal rate of 18% or 1.5% per month. What would be the total effective cost of borrowing RM6000 after...

  • Omar just took out a loan from the bank for 142,894 dollars. He plans to repay...

    Omar just took out a loan from the bank for 142,894 dollars. He plans to repay this loan by making a special payment to the bank of 26,888 dollars in 3 months and by also making equal, regular monthly payments of X. If the interest rate on the loan is 0.8 percent per month, he makes his first regular monthly payment later today, and he makes his last regular monthly payment made in 7 months from today, then what is...

  • 1. Narelle borrows $600,000 on a 25-year property loan at 4 percent per annum compounding monthly....

    1. Narelle borrows $600,000 on a 25-year property loan at 4 percent per annum compounding monthly. The loan provides for interest-only payments for 5 years and then reverts to principal and interest repayments sufficient to repay the loan within the original 25-year period. Assume rates do not change. a) Calculate the monthly repayment for the first 5 years. (CLUE: it is INTEREST ONLY) (2 marks) b) Calculate the new monthly repayment after 5 years assuming the interest rate does not...

  • Loan question. I think I can do 1a correctly but no clue on b. p.s I...

    Loan question. I think I can do 1a correctly but no clue on b. p.s I got repayment for 1a) as R=£127.67 Question 1 Kes has approached a loan company with the aim of borrowing £11,000. Kes accepts that this will be repaid in level monthly instalments (in arrears) for 10 years. The loan company has agreed with Kes that a setup fee of £500 should be added to the loan amount. This additional cost represents the extra administrative work...

  • Problem: Johnny Bravo has two loan alternatives to finance his home mortgage. The house that interests...

    Problem: Johnny Bravo has two loan alternatives to finance his home mortgage. The house that interests you is for sale for $ 180,000, but you can soon give a payment of $ 35,000. Poco Dar Bank offers you a loan for the balance of the debt at an effective annual interest rate of 3.0% (APY), which is based on monthly payments. The loan is expected to be repaid in 15 years. The SuperPeso Cooperative offers you a 3.5% annual compound...

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