Prepare (using a spreadsheet package) an entire duration amortization schedules as follows:

Initial amount: Shs 12,000/=; rate of interest: 19% per annum; period: 10 years payable monthly in arrears. An additional amount of Shs 500,000/= is repaid with the 30^th installment, and the monthly recomputed to fully pay the loan balance in the initially agreed period. The borrower enhances his monthly repayments by Shs. 40,000/= per month from the beginning of month 76. The borrower is advanced an additional Shs. 3,000,000/= at the end of month 80 and the monthly repayment is recomputed to fully pay the loan balance in 10 months more than had initially been agreed.