Ms. Ursula has applied for a loan from a local bank and the bank has agreed to extend to her a personal loan of $ 575,000/= over a period of one and half years to enable her sort out some urgent domestic problems. This loan will be repaid in monthly installments at the end of each month over the loan period. The proposed interest rate is 13.5% p.a.

Required:

Prepare a loan repayments schedule for Ms. Ursula's loan. Using excel