Question

A loan of 620,000 is to be repaid in 30 years by month-end repayments starting in...

A loan of 620,000 is to be repaid in 30 years by month-end repayments starting in one month. The interest rate is 4.8% p.a. compounded monthly. Calculate the interest paid in Year 5. (between the end of month 48 and the end of month 60). Correct your answer to the nearest cent without any units. (Do not use "$" or "," in your answer. e.g. 12345.67) (Hint: you can use Excel to find the answer.).

Homework Answers

Answer #1

Interest paid in Year 5 is given as 27550.56

Below is the loan amortization for year 5

Payment Loan beginning balance Payment Interest payment Principal payment Loan ending balance
49 $5,79,188.28 $3,252.93 $2,316.75 $936.17 $5,78,252.11
50 $5,78,252.11 $3,252.93 $2,313.01 $939.92 $5,77,312.19
51 $5,77,312.19 $3,252.93 $2,309.25 $943.68 $5,76,368.52
52 $5,76,368.52 $3,252.93 $2,305.47 $947.45 $5,75,421.07
53 $5,75,421.07 $3,252.93 $2,301.68 $951.24 $5,74,469.82
54 $5,74,469.82 $3,252.93 $2,297.88 $955.05 $5,73,514.78
55 $5,73,514.78 $3,252.93 $2,294.06 $958.87 $5,72,555.91
56 $5,72,555.91 $3,252.93 $2,290.22 $962.70 $5,71,593.21
57 $5,71,593.21 $3,252.93 $2,286.37 $966.55 $5,70,626.66
58 $5,70,626.66 $3,252.93 $2,282.51 $970.42 $5,69,656.24
59 $5,69,656.24 $3,252.93 $2,278.62 $974.30 $5,68,681.94
60 $5,68,681.94 $3,252.93 $2,274.73 $978.20 $5,67,703.74
Know the answer?
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
Similar Questions
A loan of 189,000 is going to be repaid by month-end repayments of 4,000 starting in...
A loan of 189,000 is going to be repaid by month-end repayments of 4,000 starting in one month. The interest rate is 4.2% p.a. compounded monthly. Calculate the loan outstanding balance at the end of year 2. Correct your answer to the nearest cent without any units. (Do not use "$" or "," in your answer. e.g. 12345.67)
Martin borrowed $12795 to buy furniture for his apartment. He took out a loan with repayments...
Martin borrowed $12795 to buy furniture for his apartment. He took out a loan with repayments made at the end of each month and at an interest rate of 8.5%p.a. compounded monthly over a period of five years. After three and a half years he sold the furniture and repaid the loan in full because he was moving overseas. How much did he need to repay? (Give your answer to the nearest cent, omitting the dollar sign.)
A loan was repaid over seven years by end-of-month payments of $450. If interest was 12%...
A loan was repaid over seven years by end-of-month payments of $450. If interest was 12% compounded monthly, how much interest was paid?
A loan of $100,000 is to be repaid by two equal repayments of X. One repayment...
A loan of $100,000 is to be repaid by two equal repayments of X. One repayment is due at the end of 2 years, the second repayment is due at the end of 6 years. The interest rate is at 4% p.a. compounded quarterly for the first 3 years and then 4.4% p.a. compounded quarterly thereafter. What is the size of each repayment? a. $57,989.46 b. $56,779.19 c. $58,222.14 d. $58,762.97
A loan was repaid over seven years by end-of-month payments of $450. If interest was 12%...
A loan was repaid over seven years by end-of-month payments of $450. If interest was 12% compounded monthly, how much interest was paid? can you please do my question with TI BA calculator.
a) Based on original loan of $15,000, calculate the monthly repayments to be repaid over 5...
a) Based on original loan of $15,000, calculate the monthly repayments to be repaid over 5 years. Assume an interest rate of 25% p.a. Andrea can afford to pay $600 per month into the loan, and she has been able to negotiate a new interest rate of 8% p.a. b) How long would it take Andrea to repay the loan? c) If she cannot afford to increase her current repayments, and is unable to negotiate a better interest rate, recommend...
A loan of 10,000 is being repaid with payments of 500 starting one month after the...
A loan of 10,000 is being repaid with payments of 500 starting one month after the loan is made and lasting as long as necessary. A final smaller payment is made one month after the last regular payment of 500. What is the amount of the additional smaller payment using an interest rate of 12% compounded monthly?
Harris Machinery received a demand loan of $180,000. It repaid $70,000 at the end of the...
Harris Machinery received a demand loan of $180,000. It repaid $70,000 at the end of the first year, $90,000 at the end of the second year, and the balance at the end of the third year. The interest rate charged on the loan was 5.75% compounded semi-annually during the first year, 5.50% compounded quarterly during the second year, and 4.75% compounded monthly during the third year. a. What was the balance of the loan at the end of the first...
A loan of $6,300 is being repaid by payments of $70 at the end of each...
A loan of $6,300 is being repaid by payments of $70 at the end of each month. After the 7th payment, the payment size increases to $280 per month. If the interest rate is 6.6% compounded monthly calculate the outstanding loan balance at the end of the first year.
Andrew takes out a 30-year home-loan of $650,000. The bank charges interest at 6% p.a. compounded...
Andrew takes out a 30-year home-loan of $650,000. The bank charges interest at 6% p.a. compounded monthly. Andrew repay the same amount at the end of each month for the whole loan term. Help Andrew to prepare the loan repayment schedule for month 61 below. (Round your answer to 2 decimal places. Do not include the $ symbol. Do not use comma separators. E.g. 1234.56) Month Opening balance of the loan Interest Paid Principal Paid Ending balance of the loan...