Question: Prepare (using a spreadsheet package) an entire duration amortization schedule as follows: Initial amount: Shs 7,000,000/=; rate of interest: 13.5% per annum; period: 12 years

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

Initial amount: Shs 7,000,000/=; rate of interest: 13.5% per annum; period: 12 years payable monthly in arrears.

An additional amount of Shs 640,000/= is repaid with the 25^th installment, and the monthly installment recomputed to fully pay the loan balance in the initially agreed period.

The rate of interest is adjusted to 15% per annum with effect from the end of the fifth year. The monthly repayment is recomputed to fully pay the loan balance in in two years less than had initially been agreed. The borrower enhances his monthly repayments by Shs 24,000/= per month from the end of month 76.

The borrower is advanced an additional Shs 1,200,000/= at the end of month 83 and the monthly repayment is recomputed to fully pay the loan balance in one year more than the latest duration adjustment.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

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!

Prepare ( using a spreadsheet package ) an entire duration amortization schedule as follows: Initial amount: Shs 5 , 7 0 0 , 0 0 0 / = ; rate of interest: 1 2 . 5 % per annum; period: 1 0 years...

21:49 A . 06. Assignment one July 2019 - Read-only 47% Sign in to edit and save changes to this file. UNIVERSITY OF NAIROBI, SCHOOL OF BUSINESS DEPARTMENT OF FINANCE AND ACCOUNTING MSC PROGRAMME...

1. 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...

1. Discuss how executive compensation can be used to reduce agency problems between shareholders and management of a company. 2. Prepare (using a spreadsheet package) an entire duration amortization...

. Discuss how executive compensation can be used to reduce agency problems between shareholders and management of a company. 2. Prepare (using a spreadsheet package) an entire duration amortization...

Prepare (using a spreadsheet package) an entire duration amortization schedule as follows: Initial amount: Shs 4,000,000/=; rate of interest: 13.5% per annum; period: 10 years payable monthly in...

Prepare (using a spreadsheet package) an entire duration amortization schedule as follows: Initial amount: Shs 6,000,000/=; rate of interest: 12% per annum; period: 10 years payable monthly in...

1. Prepare (using a spreadsheet package) an entire duration amortization schedule as follows: Initial amount: Shs 5,000,000/=; rate of interest: 13% per annum; period: 12 years payable monthly in...

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...

Global Consumer-Products Companies Target Low-Income Consumer CASE DETAILS 11-13. Why are companies such as Siemens, GE, Nestl, and Procter & Gamble targeting the bottom of the pyramid? 11-14. Review...

How to solve The Michner Corporation is trying to choose between the foilowing two mutuaily exclusive design projects: A - 1 . If the required return is 1 2 percent. what is the profitabilisy index...

5. Develop a scenario comparing two PH programs and involving the use of a CBA.

Have you ever been asked unethical, biased, or uncivil questions? Did you ever, knowingly or unknowingly, use these types of questions yourself? How can you deal with questions like these if you find...

Particularly when dealing with your neutral and hostile audiences, what are some ways that you can bridge the gap between your beliefs and those of your audience members? How can you generate...

Is there a particular organizational pattern that would best suit you, your topic, or your audience? For example, are you comfortable with and knowledgeable enough about your hostile audiences...