Ms. Caterina Weldon has applied for a loan from a local bank and the bank has...

Ms. Caterina Weldon has applied for a loan from a local bank and the bank has agreed to extend to her a personal loan of $ 1,500,000/= over a period of 2¹/₂ years. This loan will be repaid in monthly installments at the end of each month over the loan period. The proposed interest rate is 14.5% p.a.

Required:

Prepare a loan repayments schedule for Ms. Matemo’s loan indicating:

The Model Drivers
The constant payment
Interest payment
Principal payment, and
The principal balance
Compute the total interest payable by the end of the loan period?

Expert Solution

Given proposed interest rate is 14.5% per annum.

The formula for calculating the monthly equalised installments is.

[P x R x (1+R)^N]/[(1+R)^N-1], where P stands for the loan amount or principal, R is the interest rate per month

Now the monthly interest rate is 14.5/12 = 1.208333%

Accordingly the monthly equalised installment amount as per the above formula is .

(15,00,000 * 0.01208333 * (1.01208333)^2.5*12)/((1.01208333)^2.5*12-1)

= 15,00,000 * 0.03993802 = 59907.

Hence monthly installment is 59907.

The amortization schdeule is as below

Months	Opening Balance	Interest monthly @1.208333%	Equalised Payment monthly	Principal amount in equalised payment	Balance Principal
1	15,00,000	18125.00	59907.00	41782.01	14,58,218
2	14,58,218	17620.13	59907.00	42286.87	14,15,931
3	14,15,931	17109.16	59907.00	42797.84	13,73,133
4	13,73,133	16592.02	59907.00	43314.98	13,29,818
5	13,29,818	16068.63	59907.00	43838.37	12,85,980
6	12,85,980	15538.92	59907.00	44368.08	12,41,612
7	12,41,612	15002.81	59907.00	44904.19	11,96,708
8	11,96,708	14460.21	59907.00	45446.79	11,51,261
9	11,51,261	13911.07	59907.00	45995.93	11,05,265
10	11,05,265	13355.28	59907.00	46551.72	10,58,713
11	10,58,713	12792.78	59907.00	47114.22	10,11,599
12	10,11,599	12223.48	59907.00	47683.52	9,63,915
13	9,63,915	11647.31	59907.00	48259.69	9,15,656
14	9,15,656	11064.17	59907.00	48842.83	8,66,813
15	8,66,813	10473.99	59907.00	49433.01	8,17,380
16	8,17,380	9876.67	59907.00	50030.33	7,67,350
17	7,67,350	9272.14	59907.00	50634.86	7,16,715
18	7,16,715	8660.30	59907.00	51246.70	6,65,468
19	6,65,468	8041.07	59907.00	51865.93	6,13,602
20	6,13,602	7414.36	59907.00	52492.64	5,61,110
21	5,61,110	6780.07	59907.00	53126.93	5,07,983
22	5,07,983	6138.12	59907.00	53768.88	4,54,214
23	4,54,214	5488.41	59907.00	54418.59	3,99,795
24	3,99,795	4830.86	59907.00	55076.14	3,44,719
25	3,44,719	4165.35	59907.00	55741.65	2,88,977
26	2,88,977	3491.81	59907.00	56415.19	2,32,562
27	2,32,562	2810.12	59907.00	57096.88	1,75,465
28	1,75,465	2120.20	59907.00	57786.80	1,17,678
29	1,17,678	1421.95	59907.00	58485.05	59,193
30	59,193	715.25	59907.00	59191.75	0

Now the total interest paid = 297211.66

jeff jeffy answered 1 year ago

. Baker & Co. has applied for a loan from Trust Bank in order to invest...

. Baker & Co. has applied for a loan from Trust Bank in order to invest in several potential opportunities. In order to evaluate the firm as a potential debtor, the bank would like to compare Baker & Co. to the industry. An analyst from the Bank had complied the following ratios for two consecutive years 2008 and 2009 for Baker & Co. The results are given below. 2009 2008 Industry Avg 2009 Current Ratio 4.3 x 5.7x 5.0x Acid...

Gale & Co. has applied for a loan from the Trust Us Bank in order to...

Gale & Co. has applied for a loan from the Trust Us Bank in order to invest in several potential opportunities. In order to evaluate the firm as a potential debtor, the bank would like to compare Gale & Co. to the industry. The following are some key financial ratios 2016 2017 Industry Norm(2017) Current Ratio 4.3X 5.7X 5.0X Quick Ratio 2.1X 2.8X 3.0X Inventory Turnover 1.0X 1.3X 2.2X Average Collection Period 90days 78.3days 90days Debt Ratio 33% 28% ...

Baker & Co. has applied for a loan from the Trust Us Bank to invest in...

Baker & Co. has applied for a loan from the Trust Us Bank to invest in several potential opportunities. To evaluate the firm as a potential debtor, the bank would like to compare Baker & Co. to the industry. The following are the financial statements given to Trust Us Bank: Balance Sheet 12/31/13 12/31/14 Cash $305 270 Accounts receivable 275 290 Inventory 600 580 Current assets 1,180 1,140 Plant and equipment 1,700 1,940 Less:...

Repay an existing bank loan outstanding. The company has a $200,000 loan outstanding from a local...

Repay an existing bank loan outstanding. The company has a $200,000 loan outstanding from a local community bank. The interest rate on the loan is 11.5 percent (fixed). Interest payments on the loan are due at the end of each year and the loan balance matures in full in five years. Repay Loan Investment (Outflow) = $200,000 Discount Rate = 10% Annual Interest On The Loan = $200,000 X 11.5% =$23,000 NPV=

Your company is considering to take a loan from the local bank. Bank charges a 1.25%...

Your company is considering to take a loan from the local bank. Bank charges a 1.25% interest rate per quarter. Then the rate 1.25*4 =5% is called ____ annual percentage rate discount rate compound interest rate effective annual rate

Medical Supply has applied for a loan. America's Bank has requested a budgeted balance sheet as...

Medical Supply has applied for a loan. America's Bank has requested a budgeted balance sheet as of April 30, and a combined cash budget for April. As Instrument Medical Supply's controller, you have assembled the followinginformation: Data Table: a March 31 equipment balance,$52,200; accumulateddepreciation,$41,000. b. April capital expenditures of $42,900 budgeted for cash purchase of equipment. c. April depreciation expense,$900. d. Cost of goods sold, 55% of sales. e. Other April operating expenses, including income tax, total $13,000, 30% of...

Hugo Medical Supply has applied for a loan. Pacific Commerce Bank has requested a budgeted balance...

Hugo Medical Supply has applied for a loan. Pacific Commerce Bank has requested a budgeted balance sheet as of April 30 and a combined cash budget for April. As Hugo Medical Supply's controller, you have assembled the following information: (a) March 31 equipment balance, $52,600; accumulated depreciation, $41,300 (b) April capital expenditures of $42,400 budgeted for cash purchase of equipment (c) April depreciation expense, $700 (d) Cost of goods sold, 60% of sales (e) Other April operating expenses, including income...

Box Medical Supply has applied for a loan. City's First Bank has requested a budgeted balance...

Box Medical Supply has applied for a loan. City's First Bank has requested a budgeted balance sheet as of April 30, and a combined cash budget for April. As Box Medical Supply's controller, you have assembled the following information: a. March 31 equipment balance $52,200;accumulated depreciation, $41,400. b. April capital expenditures of $42,300 budgeted for cash purchase of equipment. c. April depreciation expense, $800. d. Cost of goods sold, 60% of sales. e. Other April operating expenses, including income tax,...

Suppose you secure a home improvement loan in the amount of $7,000 from a local bank...

Suppose you secure a home improvement loan in the amount of $7,000 from a local bank with an add-on rate of 15% for two years. You will make 24 equal monthly payments. (a) Determine the amount of the monthly installment. (b) Compute the nominal and the effective annual interest rate on the loan

Tim Company borrowed $150,000 from a local bank on January 1, 2019.The loan is a...

Tim Company borrowed $150,000 from a local bank on January 1, 2019. The loan is a 5-year note payable that requires semi-annual payments of $24,000 every June 30 and December 31, beginning June 30, 2019. Assume the loan has a 20% interest rate, compounded semi-annually. Calculate the amount of the note payable at December 31, 2019 that would be classified as a long-term liability.

Question