Loan Amortization Schedule

	B	C	D	E	G	H	I	J	K
1	LOAN AMORTIZATION TABLE
2
3	Loan Amount	1000000	Frequency	12	Instalment	Total	Principal	Interest	Outstanding
4	Yearly Interest	9.00%	Monthly Interest	0.75%	0				1000000
5	Years	10	No. of payments	120	1	12667.58	5167.58	7500	994832.42
6					2	12667.58	5206.33	7461.24	989626.09
7	Monthly	-12,667.58	-ve sign indicates a debit		3	12667.58	5245.38	7422.20	984380.71
8					4	12667.58	5284.72	7382.86	979095.98
9	PMT(0.75%, 120, 1000000)			Total Interest	5	12667.58	5324.36	7343.22	973771.63
10	-$12,667.58			520109.29	6	12667.58	5364.29	7303.29	968407.34
11	IPMT(0.75%, 1, 120, 1000000)				7	12667.58	5404.52	7263.06	963002.81
12	-$7,500.00				8	12667.58	5445.06	7222.52	957557.76
13					9	12667.58	5485.89	7181.68	952071.86
14					10	12667.58	5527.04	7140.54	946544.83
15					11	12667.58	5568.49	7099.09	940976.33
16					12	12667.58	5610.25	7057.32	935366.08
17					13	12667.58	5652.33	7015.25	929713.75
18					14	12667.58	5694.72	6972.85	924019.02
19					15	12667.58	5737.43	6930.14	918281.59
20					16	12667.58	5780.47	6887.11	912501.12
21					17	12667.58	5823.82	6843.76	906677.30
22					18	12667.58	5867.50	6800.08	900809.81
23					19	12667.58	5911.50	6756.07	894898.30
24					20	12667.58	5955.84	6711.74	888942.46
25					21	12667.58	6000.51	6667.07	882941.95
26					22	12667.58	6045.51	6622.06	876896.44
27					23	12667.58	6090.85	6576.72	870805.59
28					24	12667.58	6136.54	6531.04	864669.05
29					25	12667.58	6182.56	6485.02	858486.49
30					26	12667.58	6228.93	6438.65	852257.56
31					27	12667.58	6275.65	6391.93	845981.92
32					28	12667.58	6322.71	6344.86	839659.21
33					29	12667.58	6370.13	6297.44	833289.07
34					30	12667.58	6417.91	6249.67	826871.16
35					31	12667.58	6466.04	6201.53	820405.12
36					32	12667.58	6514.54	6153.04	813890.58
37					33	12667.58	6563.40	6104.18	807327.18
38					34	12667.58	6612.62	6054.95	800714.56
39					35	12667.58	6662.22	6005.36	794052.34
40					36	12667.58	6712.18	5955.39	787340.16
41					37	12667.58	6762.53	5905.05	780577.63
42					38	12667.58	6813.25	5854.33	773764.38
43					39	12667.58	6864.34	5803.23	766900.04
44					40	12667.58	6915.83	5751.75	759984.21
45					41	12667.58	6967.70	5699.88	753016.52
46					42	12667.58	7019.95	5647.62	745996.56
47					43	12667.58	7072.60	5594.97	738923.96
48					44	12667.58	7125.65	5541.93	731798.31
49					45	12667.58	7179.09	5488.49	724619.22
50					46	12667.58	7232.93	5434.64	717386.29
51					47	12667.58	7287.18	5380.40	710099.11
52					48	12667.58	7341.83	5325.74	702757.27
53					49	12667.58	7396.90	5270.68	695360.38
54					50	12667.58	7452.37	5215.20	687908.00
55					51	12667.58	7508.27	5159.31	680399.73
56					52	12667.58	7564.58	5103.00	672835.16
57					53	12667.58	7621.31	5046.26	665213.84
58					54	12667.58	7678.47	4989.10	657535.37
59					55	12667.58	7736.06	4931.52	649799.31
60					56	12667.58	7794.08	4873.49	642005.22
61					57	12667.58	7852.54	4815.04	634152.69
62					58	12667.58	7911.43	4756.15	626241.25
63					59	12667.58	7970.77	4696.81	618270.49
64					60	12667.58	8030.55	4637.03	610239.94
65					61	12667.58	8090.78	4576.80	602149.16
66					62	12667.58	8151.46	4516.12	593997.70
67					63	12667.58	8212.59	4454.98	585785.11
68					64	12667.58	8274.19	4393.39	577510.92
69					65	12667.58	8336.25	4331.33	569174.67
70					66	12667.58	8398.77	4268.81	560775.90
71					67	12667.58	8461.76	4205.82	552314.15
72					68	12667.58	8525.22	4142.36	543788.92
73					69	12667.58	8589.16	4078.42	535199.76
74					70	12667.58	8653.58	4014.00	526546.18
75					71	12667.58	8718.48	3949.10	517827.70
76					72	12667.58	8783.87	3883.71	509043.83
77					73	12667.58	8849.75	3817.83	500194.09
78					74	12667.58	8916.12	3751.46	491277.96
79					75	12667.58	8982.99	3684.58	482294.97
80					76	12667.58	9050.37	3617.21	473244.61
81					77	12667.58	9118.24	3549.33	464126.36
82					78	12667.58	9186.63	3480.95	454939.73
83					79	12667.58	9255.53	3412.05	445684.20
84					80	12667.58	9324.95	3342.63	436359.26
85					81	12667.58	9394.88	3272.69	426964.38
86					82	12667.58	9465.34	3202.23	417499.03
87					83	12667.58	9536.33	3131.24	407962.70
88					84	12667.58	9607.86	3059.72	398354.84
89					85	12667.58	9679.92	2987.66	388674.92
90					86	12667.58	9752.52	2915.06	378922.41
91					87	12667.58	9825.66	2841.92	369096.75
92					88	12667.58	9899.35	2768.23	359197.40
93					89	12667.58	9973.60	2693.98	349223.80
94					90	12667.58	10048.40	2619.18	339175.40
95					91	12667.58	10123.76	2543.82	329051.64
96					92	12667.58	10199.69	2467.89	318851.95
97					93	12667.58	10276.19	2391.39	308575.76
98					94	12667.58	10353.26	2314.32	298222.50
99					95	12667.58	10430.91	2236.67	287791.59
100					96	12667.58	10509.14	2158.44	277282.45