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

Initial amount: Shs 8,000,000/=; rate of interest: 14% per annum; period: 12 years payable monthly in arrears. An additional amount of Shs 350,000/= is repaid with the 30^th installment, and the monthly installment recomputed to fully pay the loan balance in the 8 months less than the initially agreed period. The rate of interest is adjusted to 15% per annum with effect from the end of the fifth year and the monthly repayment is recomputed to fully pay the loan balance in the initially agreed period. The borrower enhances his monthly repayments by Shs 17,000/= per month from the end of month 86. The borrower is advanced an additional Shs 600,000/= at the end of month 92 and the monthly repayment is recomputed to fully pay the loan balance in 9 months more than had initially been agreed.

Answer rating: 100% (QA)

Spreadsheet Month Principal ShsInterest ShsMonthly Payment ShsCumulative Payment ShsLoan Balance Shs 1800000010666671116666711166667799988833 27999888... View the full answer