The Beta Corporation obtains a bank loan that is disbursed as follows: Shs 320 million, Shs...

The Beta Corporation obtains a bank loan that is disbursed as follows: Shs 320 million, Shs 240 million, Shs 160 million and Shs 80 million at the beginning of years one, two, three, and four respectively. The loan is repaid in five equal annual installments of Shs 300 million at the end of years four to eight, and a final amount at the beginning of year 12. Given a rate of inflation of 4.0% per annum during the period, and if Beta’s real cost of the loan is 15% per annum, what should the final repayment be?

Solutions

Expert Solution

Year	Opening balance	Loan disbursement	Interest @ 15 %	Payment	Closing Balance	Inflation @4%	Real Payment
1	0.00	320.00	48.00		368.00	1.00
2	368.00	240.00	91.20		699.20	0.96
3	699.20	160.00	128.88		988.08	0.92
4	988.08	80.00	160.21	300.00	928.29	0.89	266.70
5	928.29		139.24	300.00	767.54	0.85	256.44
6	767.54		115.13	300.00	582.67	0.82	246.58
7	582.67		87.40	300.00	370.07	0.79	237.09
8	370.07		55.51	300.00	125.58	0.76	227.98
9	125.58		18.84		144.41	0.73	0.00
10	144.41		21.66		166.07	0.70	0.00
11	166.07		24.91		190.99	0.68	0.00
12	190.99			190.99	0.00	0.65	124.06
	Total	800.00	890.99	1,690.99			1,358.85

Assumption
1	Interest has been charged on overdue interest also.
2	Final payment however made at the beginning of 12th year inflation rate of 12th year would be applicable, else final payment would be


	Payment	inflation @ 4%		Real payment
	190.99	0.68		129.02
	Total real payment would be		1358.85-124.06+129.02			=	1,363.81

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

A firm is advanced a Shs 5 million= loan by a bank to be repaid in...

A firm is advanced a Shs 5 million= loan by a bank to be repaid in equal monthly installments over five years at a rate of interest of 18% per annum. After the 24th installment, the rate of interest is adjusted to 20% per annum and the monthly installment size recomputed such that the loan is fully repaid in the remaining duration of the initially agreed term. After the 36th installment, the rate of interest is lowered by 3% per...

A loan of Shs 4,000,000/= disbursed today is repaid in four installments commencing at the end...

A loan of Shs 4,000,000/= disbursed today is repaid in four installments commencing at the end of year one. The second repayment is at the end of year two and is half as much again as the first installment and is 20% less than the third installment (due at the end of year four). The final installment is due at the end of year five and is 15% more than the first installment. The rate of interest is 13% per...

A loan of Kenya Shs 5,000,000/= disbursed today is repaid in four installments commencing at the...

A loan of Kenya Shs 5,000,000/= disbursed today is repaid in four installments commencing at the end of year one. The second repayment is at the end of year two and is half as much again as the first installment and is 15% less than the third installment (due at the end of year four). The final installment is due at the end of year five and is 25% more than the first installment. The rate of interest is 14%...

Manning Bank recently disbursed a $2 million loan, of which $1.6 million is currently outstanding. The...

Manning Bank recently disbursed a $2 million loan, of which $1.6 million is currently outstanding. The probability of default over the next year is 1%, and the recovery rate is 70%. The standard deviation of loss given default (LGD) is 20%. The expected and unexpected losses (standard deviation) for the bank are a. Expected loss = $4,800; unexpected loss = $57,489 b. Expected loss = $11,200; unexpected loss = $57,489 c. Expected loss = $4,800; unexpected loss = $115,942 d....

QUESTION 19 Manning Bank recently disbursed a $2 million loan, of which $1.6 million is currently...

QUESTION 19 Manning Bank recently disbursed a $2 million loan, of which $1.6 million is currently outstanding. The probability of default over the next year is 1%, and the recovery rate is 70%. The standard deviation of loss given default (LGD) is 20%. The expected and unexpected losses (standard deviation) for the bank are Expected loss = $4,800; unexpected loss = $57,489 Expected loss = $11,200; unexpected loss = $57,489 Expected loss = $4,800; unexpected loss = $115,942 Expected loss...

Mr. Paul Trevor Kipyegon’s bank has agreed to extend to him a personal loan of Shs....

Mr. Paul Trevor Kipyegon’s bank has agreed to extend to him a personal loan of Shs. 562,500/= over a period of 11/2 years to enable him 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 15% p.a. Required: Prepare a loan repayment schedule for Mr. Kipyegon indicating: The Model Drivers The constant payment Interest payment Principal payment, and ...

To purchase a house, Becky obtains a mortgage loan from Countywide Bank. The lender should record...

To purchase a house, Becky obtains a mortgage loan from Countywide Bank. The lender should record the mortgage to a. be officially on record as holding an interest in the property. b. secure itself in the position of an unsecured creditor. c. preserve a copy of the loan in a separate location. d. obtain reimbursement for a portion of the loan if the debtor defaults.

) Reuth Corporation plans to raise $2 million to pay off its existing short-term bank loan of...

) Reuth Corporation plans to raise $2 million to pay off its existing short-term bank loan of $600,000 and to increase total assets by $1,400,000. The bank loan bears an interest rate of 10 percent. The company's president owns 51.5% percent of the 4,000,000 shares of common stock and wishes to maintain control of the company. The company's tax rate is 20 percent. Balance sheet information is shown below. The company is considering two alternatives to raise the $2 million: (1) sell common...

If a bank follows a strategy in which it buys reserves to cover loan requests they...

If a bank follows a strategy in which it buys reserves to cover loan requests they are likely doing: a funds management. b asset management. c liability management. d asset-liability coordinated management. eNone of the options is correct. You invest in a savings instrument in which you firstly make a lump sum payment. This amount is invested (i.e. by a manager) in different assets and at a later point you receive a stream of income. This is known as: a...

A company acquired with the bank a loan of five million pesos to be paid in...

A company acquired with the bank a loan of five million pesos to be paid in 8 years, through equal quarterly payments at the end of each quarter. In the contract it is agreed to pay an interest rate of 24% compounded quarterly for the first 5 years, and 32% compounded quarterly for the remaining 3 years. How do you want to pay off the debt in the fixed date, determine: a) The value of each payment. b) The total...

Subjects