Sample Amortisation Schedule

	A	B	C	D	E	F	G	H
1	Amount of Loan	₹100,000.00
2	Interest Rate	18%
3	Months	36
4	EMI	₹3,615.24
5
6
7	Period	Beginning Balance	EMI	Principal	Interest	Cumulative Principle Paid	Cumulative Interest Paid	Ending Balance
8	1	₹100,000.00	3,615.24	2,115.24	1,500.00	2,115.24	1,500.00	97,884.76
9	2	97,884.76	3,615.24	2,146.97	1,468.27	4,262.21	2,968.27	95,737.79
10	3	95,737.79	3,615.24	2,179.17	1,436.07	6,441.38	4,404.34	93,558.62
11	4	93,558.62	3,615.24	2,211.86	1,403.38	8,653.24	5,807.72	91,346.76
12	5	91,346.76	3,615.24	2,245.04	1,370.20	10,898.28	7,177.92	89,101.72
13	6	89,101.72	3,615.24	2,278.71	1,336.53	13,176.99	8,514.44	86,823.01
14	7	86,823.01	3,615.24	2,312.89	1,302.35	15,489.89	9,816.79	84,510.11
15	8	84,510.11	3,615.24	2,347.59	1,267.65	17,837.47	11,084.44	82,162.53
16	9	82,162.53	3,615.24	2,382.80	1,232.44	20,220.28	12,316.88	79,779.72
17	10	79,779.72	3,615.24	2,418.54	1,196.70	22,638.82	13,513.58	77,361.18
18	11	77,361.18	3,615.24	2,454.82	1,160.42	25,093.64	14,673.99	74,906.36
19	12	74,906.36	3,615.24	2,491.64	1,123.60	27,585.29	15,797.59	72,414.71
20	13	72,414.71	3,615.24	2,529.02	1,086.22	30,114.31	16,883.81	69,885.69
21	14	69,885.69	3,615.24	2,566.95	1,048.29	32,681.26	17,932.09	67,318.74
22	15	67,318.74	3,615.24	2,605.46	1,009.78	35,286.72	18,941.88	64,713.28
23	16	64,713.28	3,615.24	2,644.54	970.70	37,931.26	19,912.57	62,068.74
24	17	62,068.74	3,615.24	2,684.21	931.03	40,615.47	20,843.61	59,384.53
25	18	59,384.53	3,615.24	2,724.47	890.77	43,339.94	21,734.37	56,660.06
26	19	56,660.06	3,615.24	2,765.34	849.90	46,105.28	22,584.27	53,894.72
27	20	53,894.72	3,615.24	2,806.82	808.42	48,912.10	23,392.70	51,087.90
28	21	51,087.90	3,615.24	2,848.92	766.32	51,761.02	24,159.01	48,238.98
29	22	48,238.98	3,615.24	2,891.65	723.58	54,652.67	24,882.60	45,347.33
30	23	45,347.33	3,615.24	2,935.03	680.21	57,587.70	25,562.81	42,412.30
31	24	42,412.30	3,615.24	2,979.06	636.18	60,566.76	26,198.99	39,433.24
32	25	39,433.24	3,615.24	3,023.74	591.50	63,590.50	26,790.49	36,409.50
33	26	36,409.50	3,615.24	3,069.10	546.14	66,659.59	27,336.63	33,340.41
34	27	33,340.41	3,615.24	3,115.13	500.11	69,774.73	27,836.74	30,225.27
35	28	30,225.27	3,615.24	3,161.86	453.38	72,936.59	28,290.12	27,063.41
36	29	27,063.41	3,615.24	3,209.29	405.95	76,145.88	28,696.07	23,854.12
37	30	23,854.12	3,615.24	3,257.43	357.81	79,403.30	29,053.88	20,596.70
38	31	20,596.70	3,615.24	3,306.29	308.95	82,709.59	29,362.83	17,290.41
39	32	17,290.41	3,615.24	3,355.88	259.36	86,065.48	29,622.19	13,934.52
40	33	13,934.52	3,615.24	3,406.22	209.02	89,471.70	29,831.21	10,528.30
41	34	10,528.30	3,615.24	3,457.32	157.92	92,929.01	29,989.13	7,070.99
42	35	7,070.99	3,615.24	3,509.17	106.06	96,438.19	30,095.20	3,561.81
43	36	3,561.81	3,615.24	3,561.81	53.43	100,000.00	30,148.62	0.00
44	37	0.00	0.00	0.00	0.00	0.00	0.00	0.00
45	38	0.00	0.00	0.00	0.00	0.00	0.00	0.00
46	39	0.00	0.00	0.00	0.00	0.00	0.00	0.00
47	40	0.00	0.00	0.00	0.00	0.00	0.00	0.00
48	41	0.00	0.00	0.00	0.00	0.00	0.00	0.00
49	42	0.00	0.00	0.00	0.00	0.00	0.00	0.00
50	43	0.00	0.00	0.00	0.00	0.00	0.00	0.00
51	44	0.00	0.00	0.00	0.00	0.00	0.00	0.00
52	45	0.00	0.00	0.00	0.00	0.00	0.00	0.00
53	46	0.00	0.00	0.00	0.00	0.00	0.00	0.00
54	47	0.00	0.00	0.00	0.00	0.00	0.00	0.00
55	48	0.00	0.00	0.00	0.00	0.00	0.00	0.00
56	49	0.00	0.00	0.00	0.00	0.00	0.00	0.00
57	50	0.00	0.00	0.00	0.00	0.00	0.00	0.00
58	51	0.00	0.00	0.00	0.00	0.00	0.00	0.00
59	52	0.00	0.00	0.00	0.00	0.00	0.00	0.00
60	53	0.00	0.00	0.00	0.00	0.00	0.00	0.00
61	54	0.00	0.00	0.00	0.00	0.00	0.00	0.00
62	55	0.00	0.00	0.00	0.00	0.00	0.00	0.00
63	56	0.00	0.00	0.00	0.00	0.00	0.00	0.00
64	57	0.00	0.00	0.00	0.00	0.00	0.00	0.00
65	58	0.00	0.00	0.00	0.00	0.00	0.00	0.00
66	59	0.00	0.00	0.00	0.00	0.00	0.00	0.00
67	60	0.00	0.00	0.00	0.00	0.00	0.00	0.00
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100