How To Prepare A Loan Amortisation Schedule

	Number of years, n	9		Enter your student number digit by digit in cells F2:M2	4	4	1	0	8	5	4	0	First/Given Name	Hannan Ashrafi
	Number of months, n*m	108											Family Name	Shera
	Nominal Interest rate per annum, compounding monthly, %	8.0%
	Effective monthly interest rate, %	0.67%
	Loan amount	$4,41,085.00
	Fixed Monthly Repayment Amount. (the amount per month)	$5,742.36	DO NOT Round any amounts in the Amortisation Schedule.Use format commands to display as currency.
Loan Amortisation Schedule
Mth	Balance beginning of month	Interest	Repayment	Balance end of month
1	$4,41,085.00	$2,940.57	-$5,742.36	$4,38,283.21
2	$4,38,283.21	$2,921.89	-$5,742.36	$4,35,462.73
3	$4,35,462.73	$2,903.08	-$5,742.36	$4,32,623.46
4	$4,32,623.46	$2,884.16	-$5,742.36	$4,29,765.26
5	$4,29,765.26	$2,865.10	-$5,742.36	$4,26,888.00
6	$4,26,888.00	$2,845.92	-$5,742.36	$4,23,991.56
7	$4,23,991.56	$2,826.61	-$5,742.36	$4,21,075.81
8	$4,21,075.81	$2,807.17	-$5,742.36	$4,18,140.62
9	$4,18,140.62	$2,787.60	-$5,742.36	$4,15,185.87
10	$4,15,185.87	$2,767.91	-$5,742.36	$4,12,211.41
11	$4,12,211.41	$2,748.08	-$5,742.36	$4,09,217.13
12	$4,09,217.13	$2,728.11	-$5,742.36	$4,06,202.88
13	$4,06,202.88	$2,708.02	-$5,742.36	$4,03,168.54
14	$4,03,168.54	$2,687.79	-$5,742.36	$4,00,113.97
15	$4,00,113.97	$2,667.43	-$5,742.36	$3,97,039.04
16	$3,97,039.04	$2,646.93	-$5,742.36	$3,93,943.61
17	$3,93,943.61	$2,626.29	-$5,742.36	$3,90,827.54
18	$3,90,827.54	$2,605.52	-$5,742.36	$3,87,690.69
19	$3,87,690.69	$2,584.60	-$5,742.36	$3,84,532.94
20	$3,84,532.94	$2,563.55	-$5,742.36	$3,81,354.13
21	$3,81,354.13	$2,542.36	-$5,742.36	$3,78,154.13
22	$3,78,154.13	$2,521.03	-$5,742.36	$3,74,932.80
23	$3,74,932.80	$2,499.55	-$5,742.36	$3,71,689.99
24	$3,71,689.99	$2,477.93	-$5,742.36	$3,68,425.57
25	$3,68,425.57	$2,456.17	-$5,742.36	$3,65,139.38
26	$3,65,139.38	$2,434.26	-$5,742.36	$3,61,831.28
27	$3,61,831.28	$2,412.21	-$5,742.36	$3,58,501.13
28	$3,58,501.13	$2,390.01	-$5,742.36	$3,55,148.78
29	$3,55,148.78	$2,367.66	-$5,742.36	$3,51,774.07
30	$3,51,774.07	$2,345.16	-$5,742.36	$3,48,376.87
31	$3,48,376.87	$2,322.51	-$5,742.36	$3,44,957.03
32	$3,44,957.03	$2,299.71	-$5,742.36	$3,41,514.38
33	$3,41,514.38	$2,276.76	-$5,742.36	$3,38,048.78
34	$3,38,048.78	$2,253.66	-$5,742.36	$3,34,560.08
35	$3,34,560.08	$2,230.40	-$5,742.36	$3,31,048.12
36	$3,31,048.12	$2,206.99	-$5,742.36	$3,27,512.75
37	$3,27,512.75	$2,183.42	-$5,742.36	$3,23,953.81
38	$3,23,953.81	$2,159.69	-$5,742.36	$3,20,371.14
39	$3,20,371.14	$2,135.81	-$5,742.36	$3,16,764.59
40	$3,16,764.59	$2,111.76	-$5,742.36	$3,13,133.99
41	$3,13,133.99	$2,087.56	-$5,742.36	$3,09,479.19
42	$3,09,479.19	$2,063.19	-$5,742.36	$3,05,800.03
43	$3,05,800.03	$2,038.67	-$5,742.36	$3,02,096.33
44	$3,02,096.33	$2,013.98	-$5,742.36	$2,98,367.95
45	$2,98,367.95	$1,989.12	-$5,742.36	$2,94,614.71
46	$2,94,614.71	$1,964.10	-$5,742.36	$2,90,836.45
47	$2,90,836.45	$1,938.91	-$5,742.36	$2,87,033.00
48	$2,87,033.00	$1,913.55	-$5,742.36	$2,83,204.19
49	$2,83,204.19	$1,888.03	-$5,742.36	$2,79,349.86
50	$2,79,349.86	$1,862.33	-$5,742.36	$2,75,469.83
51	$2,75,469.83	$1,836.47	-$5,742.36	$2,71,563.94
52	$2,71,563.94	$1,810.43	-$5,742.36	$2,67,632.00
53	$2,67,632.00	$1,784.21	-$5,742.36	$2,63,673.86
54	$2,63,673.86	$1,757.83	-$5,742.36	$2,59,689.32
55	$2,59,689.32	$1,731.26	-$5,742.36	$2,55,678.23
56	$2,55,678.23	$1,704.52	-$5,742.36	$2,51,640.39
57	$2,51,640.39	$1,677.60	-$5,742.36	$2,47,575.63
58	$2,47,575.63	$1,650.50	-$5,742.36	$2,43,483.77
59	$2,43,483.77	$1,623.23	-$5,742.36	$2,39,364.64
60	$2,39,364.64	$1,595.76	-$5,742.36	$2,35,218.04
61	$2,35,218.04	$1,568.12	-$5,742.36	$2,31,043.81
62	$2,31,043.81	$1,540.29	-$5,742.36	$2,26,841.74
63	$2,26,841.74	$1,512.28	-$5,742.36	$2,22,611.66
64	$2,22,611.66	$1,484.08	-$5,742.36	$2,18,353.37
65	$2,18,353.37	$1,455.69	-$5,742.36	$2,14,066.70
66	$2,14,066.70	$1,427.11	-$5,742.36	$2,09,751.45
67	$2,09,751.45	$1,398.34	-$5,742.36	$2,05,407.44
68	$2,05,407.44	$1,369.38	-$5,742.36	$2,01,034.46
69	$2,01,034.46	$1,340.23	-$5,742.36	$1,96,632.33
70	$1,96,632.33	$1,310.88	-$5,742.36	$1,92,200.85
71	$1,92,200.85	$1,281.34	-$5,742.36	$1,87,739.83
72	$1,87,739.83	$1,251.60	-$5,742.36	$1,83,249.07
73	$1,83,249.07	$1,221.66	-$5,742.36	$1,78,728.37
74	$1,78,728.37	$1,191.52	-$5,742.36	$1,74,177.53
75	$1,74,177.53	$1,161.18	-$5,742.36	$1,69,596.36
76	$1,69,596.36	$1,130.64	-$5,742.36	$1,64,984.64
77	$1,64,984.64	$1,099.90	-$5,742.36	$1,60,342.18
78	$1,60,342.18	$1,068.95	-$5,742.36	$1,55,668.77
79	$1,55,668.77	$1,037.79	-$5,742.36	$1,50,964.20
80	$1,50,964.20	$1,006.43	-$5,742.36	$1,46,228.27
81	$1,46,228.27	$974.86	-$5,742.36	$1,41,460.76
82	$1,41,460.76	$943.07	-$5,742.36	$1,36,661.47
83	$1,36,661.47	$911.08	-$5,742.36	$1,31,830.19
84	$1,31,830.19	$878.87	-$5,742.36	$1,26,966.70
85	$1,26,966.70	$846.44	-$5,742.36	$1,22,070.78
86	$1,22,070.78	$813.81	-$5,742.36	$1,17,142.23
87	$1,17,142.23	$780.95	-$5,742.36	$1,12,180.82
88	$1,12,180.82	$747.87	-$5,742.36	$1,07,186.33
89	$1,07,186.33	$714.58	-$5,742.36	$1,02,158.54
90	$1,02,158.54	$681.06	-$5,742.36	$97,097.24
91	$97,097.24	$647.31	-$5,742.36	$92,002.20
92	$92,002.20	$613.35	-$5,742.36	$86,873.18
93	$86,873.18	$579.15	-$5,742.36	$81,709.98
94	$81,709.98	$544.73	-$5,742.36	$76,512.35
95	$76,512.35	$510.08	-$5,742.36	$71,280.08
96	$71,280.08	$475.20	-$5,742.36	$66,012.92
97	$66,012.92	$440.09	-$5,742.36	$60,710.64
98	$60,710.64	$404.74	-$5,742.36	$55,373.02
99	$55,373.02	$369.15	-$5,742.36	$49,999.81
100	$49,999.81	$333.33	-$5,742.36	$44,590.79
101	$44,590.79	$297.27	-$5,742.36	$39,145.70
102	$39,145.70	$260.97	-$5,742.36	$33,664.31
103	$33,664.31	$224.43	-$5,742.36	$28,146.38
104	$28,146.38	$187.64	-$5,742.36	$22,591.66
105	$22,591.66	$150.61	-$5,742.36	$16,999.91
106	$16,999.91	$113.33	-$5,742.36	$11,370.88
107	$11,370.88	$75.81	-$5,742.36	$5,704.33
108	$5,704.33	$38.03	-$5,742.36	-$0.00