[go: up one dir, main page]

0% found this document useful (0 votes)
15 views6 pages

Loan Repayment Schedule

The document outlines a loan repayment schedule over 60 months, detailing monthly principal and interest payments, along with the remaining principal balance. Each month, a consistent principal payment of 25,000 is made, while interest payments decrease over time as the remaining principal reduces. The total principal paid over the loan term amounts to 1,500,000, with total interest payments of 571,875.

Uploaded by

ROHIT
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
15 views6 pages

Loan Repayment Schedule

The document outlines a loan repayment schedule over 60 months, detailing monthly principal and interest payments, along with the remaining principal balance. Each month, a consistent principal payment of 25,000 is made, while interest payments decrease over time as the remaining principal reduces. The total principal paid over the loan term amounts to 1,500,000, with total interest payments of 571,875.

Uploaded by

ROHIT
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 6

Month Principal Payment Interest Payment EMI Remaining Principal

1 25000 18750 43750 1475000


2 25000 18437.5 43437.5 1450000
3 25000 18125 43125 1425000
4 25000 17812.5 42812.5 1400000
5 25000 17500 42500 1375000
6 25000 17187.5 42187.5 1350000
7 25000 16875 41875 1325000
8 25000 16562.5 41562.5 1300000
9 25000 16250 41250 1275000
10 25000 15937.5 40937.5 1250000
11 25000 15625 40625 1225000
12 25000 15312.5 40312.5 1200000
13 25000 15000 40000 1175000
14 25000 14687.5 39687.5 1150000
15 25000 14375 39375 1125000
16 25000 14062.5 39062.5 1100000
17 25000 13750 38750 1075000
18 25000 13437.5 38437.5 1050000
19 25000 13125 38125 1025000
20 25000 12812.5 37812.5 1000000
21 25000 12500 37500 975000
22 25000 12187.5 37187.5 950000
23 25000 11875 36875 925000
24 25000 11562.5 36562.5 900000
25 25000 11250 36250 875000
26 25000 10937.5 35937.5 850000
27 25000 10625 35625 825000
28 25000 10312.5 35312.5 800000
29 25000 10000 35000 775000
30 25000 9687.5 34687.5 750000
31 25000 9375 34375 725000
32 25000 9062.5 34062.5 700000
33 25000 8750 33750 675000
34 25000 8437.5 33437.5 650000
35 25000 8125 33125 625000
36 25000 7812.5 32812.5 600000
37 25000 7500 32500 575000
38 25000 7187.5 32187.5 550000
39 25000 6875 31875 525000
40 25000 6562.5 31562.5 500000
41 25000 6250 31250 475000
42 25000 5937.5 30937.5 450000
43 25000 5625 30625 425000
44 25000 5312.5 30312.5 400000
45 25000 5000 30000 375000
46 25000 4687.5 29687.5 350000
47 25000 4375 29375 325000
48 25000 4062.5 29062.5 300000
49 25000 3750 28750 275000
50 25000 3437.5 28437.5 250000
51 25000 3125 28125 225000
52 25000 2812.5 27812.5 200000
53 25000 2500 27500 175000
54 25000 2187.5 27187.5 150000
55 25000 1875 26875 125000
56 25000 1562.5 26562.5 100000
57 25000 1250 26250 75000
58 25000 937.5 25937.5 50000
59 25000 625 25625 25000
60 25000 312.5 25312.5 0
1500000 571875 2071875 44250000 240000
Month Principal Payment
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
Month Principal Payment Interest Payment EMI Remaining Principal
1 25000 18750 43750 1456250
2 25000 18437.5 43437.5 1412812.5
3 25000 18125 43125 1369687.5
4 25000 17812.5 42812.5 1326875
5 25000 17500 42500 1284375
6 25000 17187.5 42187.5 1242187.5
7 25000 16875 41875 1200312.5
8 25000 16562.5 41562.5 1158750
9 25000 16250 41250 1117500
10 25000 15937.5 40937.5 1076562.5
11 25000 15625 40625 1035937.5
12 25000 15312.5 40312.5 995625
13 25000 15000 40000 955625
14 25000 14687.5 39687.5 915937.5
15 25000 14375 39375 876562.5
16 25000 14062.5 39062.5 837500
17 25000 13750 38750 798750
18 25000 13437.5 38437.5 760312.5
19 25000 13125 38125 722187.5
20 25000 12812.5 37812.5 684375
21 25000 12500 37500 646875
22 25000 12187.5 37187.5 609687.5
23 25000 11875 36875 572812.5
24 25000 11562.5 36562.5 536250
25 25000 11250 36250 500000
26 25000 10937.5 35937.5 464062.5
27 25000 10625 35625 428437.5
28 25000 10312.5 35312.5 393125
29 25000 10000 35000 358125
30 25000 9687.5 34687.5 323437.5
31 25000 9375 34375 289062.5
32 25000 9062.5 34062.5 255000
33 25000 8750 33750 221250
34 25000 8437.5 33437.5 187812.5
35 25000 8125 33125 154687.5
36 25000 7812.5 32812.5 121875
37 25000 7500 32500 89375
38 25000 7187.5 32187.5 57187.5
39 25000 6875 31875 25312.5
40 25000 6562.5 31562.5 27462500
41 25000 6250 31250 27431250
42 25000 5937.5 30937.5 27400312.5
43 25000 5625 30625 27369687.5
44 25000 5312.5 30312.5 27339375
45 25000 5000 30000 27309375
46 25000 4687.5 29687.5 27279687.5
47 25000 4375 29375 27250312.5
48 25000 4062.5 29062.5 27221250
49 25000 3750 28750 27192500
50 25000 3437.5 28437.5 27164062.5
51 25000 3125 28125 27135937.5
52 25000 2812.5 27812.5 27108125
53 25000 2500 27500 27080625
54 25000 2187.5 27187.5 27053437.5
55 25000 1875 26875 27026562.5
56 25000 1562.5 26562.5 27000000
57 25000 1250 26250 26973750
58 25000 937.5 25937.5 26947812.5
59 25000 625 25625 26922187.5
60 25000 312.5 25312.5 26896875
1500000 571875
2071875 0

You might also like