Question

Excel Spreadsheet Assignment Assumptions Sp19 Principal S100,000.05 Interest Rate 1.4% (0.014) Number of Periods 19 Please complete the template found in the "Content" area using the above assumptions. Th

Answer 1

Amortizaion Schedule - Company A
Interest period	Cash Payment	Bond Intt Exp [ Principle balancce of previous period * 4%]	Reduction of Principle[intt exp - cash payment]	Principle Balance [previous principle balance -reduction of principle]
	[A]	[B] = [D]*1.4%	[A]-[B]	[D]-[C]
Issue Date				$100,000.05
1.00	6030.7	1,400	4,631	95,369
2.00	6030.7	1,335	4,696	90,674
3.00	6030.7	1,269	4,761	85,913
4.00	6030.7	1,203	4,828	81,085
5.00	6030.7	1,135	4,896	76,189
6.00	6030.7	1,067	4,964	71,225
7.00	6030.7	997	5,034	66,192
8.00	6030.7	927	5,104	61,087
9.00	6030.7	855	5,175	55,912
10.00	6030.7	783	5,248	50,664
11.00	6030.7	709	5,321	45,343
12.00	6030.7	635	5,396	39,947
13.00	6030.7	559	5,471	34,475
14.00	6030.7	483	5,548	28,927
15.00	6030.7	405	5,626	23,302
16.00	6030.7	326	5,704	17,597
17.00	6030.7	246	5,784	11,813
18.00	6030.7	165	5,865	5,947
19.00	6030.7	83	5,947	(0)