|
Month |
Month Principal |
Month Interest |
Month Installment |
Balance Loan Amount |
|
Formulas |
Principal/No.Of Months |
1% of Principal Per Month |
Month Principal + Interest |
Principal – EMI |
|
10000 |
||||
|
1 |
560 |
100 |
660 |
9340 |
|
2 |
560 |
93 |
653 |
8687 |
|
3 |
560 |
87 |
647 |
8040 |
|
4 |
560 |
80 |
640 |
7399 |
|
5 |
560 |
74 |
634 |
6765 |
|
6 |
560 |
68 |
628 |
6138 |
|
7 |
560 |
61 |
621 |
5516 |
|
8 |
560 |
55 |
615 |
4901 |
|
9 |
560 |
49 |
609 |
4292 |
|
10 |
560 |
43 |
603 |
3689 |
|
11 |
560 |
37 |
597 |
3092 |
|
12 |
560 |
31 |
591 |
2501 |
|
13 |
560 |
25 |
585 |
1916 |
|
14 |
560 |
19 |
579 |
1337 |
|
15 |
560 |
13 |
573 |
764 |
|
16 |
560 |
8 |
568 |
196 |
|
17 |
560 |
2 |
562 |
-366 |
|
18 |
560 |
-4 |
556 |
-922 |
Excel Sheet:
