Services
Finance Tools
Finance Tools
YEAR | OPENING BALANCE | AMOUNT PAID BY CUSTOMER(EMI*12) | INTEREST PAID DURING THE YEAR | PRINCIPAL PAID DURING THE YEAR | PRINCIPAL PAID THE YEAR |
---|---|---|---|---|---|
1 | ₹ 50,00,000 | ₹ 5,49,109 | ₹ 4,78,202 | ₹ 70,907 | ₹ 49,29,093 |
2 | ₹ 49,29,093 | ₹ 5,99,028 | ₹ 5,13,517 | ₹ 85,511 | ₹ 48,43,582 |
3 | ₹ 48,43,582 | ₹ 5,99,028 | ₹ 5,04,094 | ₹ 94,934 | ₹ 47,48,648 |
4 | ₹ 47,48,648 | ₹ 5,99,028 | ₹ 4,93,632 | ₹ 1,05,396 | ₹ 46,43,252 |
5 | ₹ 46,43,252 | ₹ 5,99,028 | ₹ 4,82,017 | ₹ 1,17,011 | ₹ 45,26,240 |
6 | ₹ 45,26,240 | ₹ 5,99,028 | ₹ 4,69,121 | ₹ 1,29,906 | ₹ 43,96,334 |
7 | ₹ 43,96,334 | ₹ 5,99,028 | ₹ 4,54,805 | ₹ 1,44,223 | ₹ 42,52,111 |
8 | ₹ 42,52,111 | ₹ 5,99,028 | ₹ 4,38,911 | ₹ 1,60,116 | ₹ 40,91,995 |
9 | ₹ 40,91,995 | ₹ 5,99,028 | ₹ 4,21,266 | ₹ 1,77,762 | ₹ 39,14,233 |
10 | ₹ 39,14,233 | ₹ 5,99,028 | ₹ 4,01,676 | ₹ 1,97,352 | ₹ 37,16,881 |
11 | ₹ 37,16,881 | ₹ 5,99,028 | ₹ 3,79,927 | ₹ 2,19,101 | ₹ 34,97,780 |
12 | ₹ 34,97,780 | ₹ 5,99,028 | ₹ 3,55,782 | ₹ 2,43,246 | ₹ 32,54,534 |
13 | ₹ 32,54,534 | ₹ 5,99,028 | ₹ 3,28,975 | ₹ 2,70,053 | ₹ 29,84,481 |
14 | ₹ 29,84,481 | ₹ 5,99,028 | ₹ 2,99,214 | ₹ 2,99,814 | ₹ 26,84,667 |
15 | ₹ 26,84,667 | ₹ 5,99,028 | ₹ 2,66,174 | ₹ 3,32,854 | ₹ 23,51,813 |
16 | ₹ 23,51,813 | ₹ 5,99,028 | ₹ 2,29,492 | ₹ 3,69,536 | ₹ 19,82,277 |
17 | ₹ 19,82,277 | ₹ 5,99,028 | ₹ 1,88,768 | ₹ 4,10,260 | ₹ 15,72,017 |
18 | ₹ 15,72,017 | ₹ 5,99,028 | ₹ 1,43,556 | ₹ 4,55,472 | ₹ 11,16,545 |
19 | ₹ 11,16,545 | ₹ 5,99,028 | ₹ 93,361 | ₹ 5,05,667 | ₹ 6,10,879 |
20 | ₹ 6,10,879 | ₹ 5,99,028 | ₹ 37,635 | ₹ 5,61,393 | ₹ 49,486 |
21 | ₹ 49,486 | ₹ 49,919 | ₹ 433 | ₹ 49,486 | ₹ 0 |