No of years to repay loan = 36 Number of quarters to repay loan = 144 Nominal interest rate compounded quarterly = 9% Effective quarterly interest rate = 2.25% Original loan amount = $947,742 Use excel for all questions No.5) From the beginning of the loan term, you repay $8000 more each quarter-end in order to pay off the loan earlier than the original date. The interest rate does not change. Calculate in which quarter you will be able to fully repay the loan. No. 6) New Scenario (Independent): Suppose you only repay the interest amount of the loan each quarter end for the first 17 quarters. To be able to pay off the loan by the original date, you will need to repay higher equal quarter-end repayments when the interest-only period expires. Calculate the principal paid in the quarter 34 of the whole loan term. No.7) New Scenario (Independent): Right after you have repaid 36 times, the interest rate increases. To pay off the loan by the original date, you need to increase the original quarter-end repayment amount by $800. Calculate the increased nominal interest rate p.a. compounded quarterly. No. 8) New Scenario (Independent): You lose your job because of COVID-19 and the bank agrees that you do not make any repayment from the beginning of the loan term until the end of quarter 37. The interest keeps accumulating during this period. From quarter 38, you will need to repay higher equal quarter-end repayments to pay off the loan by the original date. Calculate the increased quarter-end repayment amount.