Question: 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

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.

Step by Step Solution

★★★★★

3.45 Rating (161 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

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

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

You need to do a survey in "survey monkey"

You need to do Financial analysis on the Merck & co. Inc

You need to do SWOT analysis of a case study "Hillside beach club"

a. What would be the annual payments on an 8% per annum installment loan of $1,000 from a credit union with repayment over three years? b. Write out the amortization schedule for the loan. c. Now...

Irma Watts and John Lyon are forming a partnership to which Watts will devote one-half time and Lyon will devote full time. They have discussed the following alternative plans for sharing income and...

A laboratory screen analysis for a batch of crystals of hypo (sodium thiosulfate) is as follows. Prepare both differential and cumulative-undersize plots of the data, using a spreadsheet. In...

The bank portion of the bank reconciliation for Williams Company at October 31, 2012, was as follows. The adjusted cash balance per bank agreed with the cash balance per books at October 31. The...

Which of the following responses to an accounts receivable confirmation at December 31 would cause an audit team the most concern? a. This amount was paid on December 30. b. We received this...

This problem is a continuation of Problem but requires use of a spreadsheet package that is capable of reading data from your database package (e. g., Excel can import data from an Access database)....

Julia Vanfleet is professor of mathematics. She has received a $225,000 inheritance from her fathers estate, and she is anxious to invest it between now and the time she retires in 12 years....

A system that allows managers to specify goals, measure progress, and provide performance feedback by ensuring that the incentives of shareholders and employees are aligned is called a Blank______...

The weights of 5 squash (in pounds) are 10,17,17.5,18.5, and 19.5. The sample weights have a mean of = 16.5. The accepted population standard deviation for this type of squash is = 1.25. 1) What is...

2.2 The Ministry of Works and Transport approaches you and wants your professional advice regarding the Memorandum of Understanding on the Development and Management of the TransKalahari Corridor....

A member tells you that she was recently hospitalized. She received a bill from a collection agency, even though she did not receive a bill from the hospital. She is worried this will affect her...

Boeing's recent results highlighted the case for the stock but perhaps not in the way many investors might think. In truth, they were mixed. However, Boeing's management has conservatively guided...

Two dietary drinks are used to supply protein, carbohydrates, and vitamin C. The first drink provides 2 units of protein, 5 units of carbohydrates, and 7 units of vitamin C in each liter. The second...

The following balances in selected accounts on December 31, 2017. Accounts Receivable 0 Accumulated Depreciation - Equipment 0 Equipment 6,650 Interest Payable 0 Notes Payable 20,000 Prepaid...

Classify each of the following activities as proper or prohibited under the various consumer statutes you have studied. a. Calling a hospital room to talk to a debtor who is a patient there. b....

Jan has two jobs during 2012. One employer withheld and paid FICA taxes on $66,600 of Jan's salary, and the other employer withheld and paid FICA taxes on $44,400 in salary paid to Jan. Calculate the...

Please answer the following questions regarding the taxability of Social Security: a. A 68-year-old taxpayer has $20,000 in Social Security income and $100,000 in tax-free municipal bond income. Does...

The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-7. Ivan sold the following securities during the year and received a Form 1099-B that...

What sorts of conflicts does the character use Submission for?

How can the difference in conflict styles between characters clash and increase the tension and conflict in the story?

What events serve to escalate each characters conflict? I.e. How do the events of the story force each character to move from their 1st option, to the 2nd, to the 3rd?