Scribd
Upload
897 views2 pages

Personal Loan EMI Calculation Guide

This document provides a loan amortization schedule for a Rs. 600,000 personal loan over 54 months at 10% annual interest. It shows that the borrower will pay Rs. 13,843.44 in monthly installments, with each payment reducing the outstanding principal and interest owed. By the final payment, the full loan amount plus interest of Rs. 147,546 will be repaid, for a total payment of Rs. 747,546.

Uploaded by

gr8chandru
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
897 views2 pages

Personal Loan EMI Calculation Guide

This document provides a loan amortization schedule for a Rs. 600,000 personal loan over 54 months at 10% annual interest. It shows that the borrower will pay Rs. 13,843.44 in monthly installments, with each payment reducing the outstanding principal and interest owed. By the final payment, the full loan amount plus interest of Rs. 147,546 will be repaid, for a total payment of Rs. 747,546.

Uploaded by

gr8chandru
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd

Personal Loan EMI Calculator

Legend: Key in Areas

Loan Amount 600,000.00 rupees


Loan Duration 54 months
Interest Rate 10.00%

Outstanding
EMI No. EMI Amount Principal Interest Principal
1 13,843.44 8,843.44 5,000.00 591,156.56
2 13,843.44 8,917.14 4,926.30 582,239.42
3 13,843.44 8,991.45 4,852.00 573,247.97
4 13,843.44 9,066.38 4,777.07 564,181.59
5 13,843.44 9,141.93 4,701.51 555,039.66
6 13,843.44 9,218.11 4,625.33 545,821.54
7 13,843.44 9,294.93 4,548.51 536,526.61
8 13,843.44 9,372.39 4,471.06 527,154.22
9 13,843.44 9,450.49 4,392.95 517,703.73
10 13,843.44 9,529.25 4,314.20 508,174.48
11 13,843.44 9,608.66 4,234.79 498,565.83
12 13,843.44 9,688.73 4,154.72 488,877.10
13 13,843.44 9,769.47 4,073.98 479,107.63
14 13,843.44 9,850.88 3,992.56 469,256.75
15 13,843.44 9,932.97 3,910.47 459,323.78
16 13,843.44 10,015.75 3,827.70 449,308.03
17 13,843.44 10,099.21 3,744.23 439,208.82
18 13,843.44 10,183.37 3,660.07 429,025.45
19 13,843.44 10,268.23 3,575.21 418,757.22
20 13,843.44 10,353.80 3,489.64 408,403.41
21 13,843.44 10,440.08 3,403.36 397,963.33
22 13,843.44 10,527.08 3,316.36 387,436.25
23 13,843.44 10,614.81 3,228.64 376,821.44
24 13,843.44 10,703.27 3,140.18 366,118.17
25 13,843.44 10,792.46 3,050.98 355,325.71
26 13,843.44 10,882.40 2,961.05 344,443.32
27 13,843.44 10,973.08 2,870.36 333,470.23
28 13,843.44 11,064.53 2,778.92 322,405.71
29 13,843.44 11,156.73 2,686.71 311,248.98
30 13,843.44 11,249.70 2,593.74 299,999.27
31 13,843.44 11,343.45 2,499.99 288,655.82
32 13,843.44 11,437.98 2,405.47 277,217.84
33 13,843.44 11,533.30 2,310.15 265,684.55
34 13,843.44 11,629.41 2,214.04 254,055.14
35 13,843.44 11,726.32 2,117.13 242,328.82
36 13,843.44 11,824.04 2,019.41 230,504.79
37 13,843.44 11,922.57 1,920.87 218,582.22
38 13,843.44 12,021.93 1,821.52 206,560.29
39 13,843.44 12,122.11 1,721.34 194,438.18
40 13,843.44 12,223.13 1,620.32 182,215.05
41 13,843.44 12,324.99 1,518.46 169,890.07
42 13,843.44 12,427.69 1,415.75 157,462.38
43 13,843.44 12,531.26 1,312.19 144,931.12
44 13,843.44 12,635.69 1,207.76 132,295.43
45 13,843.44 12,740.98 1,102.46 119,554.45
46 13,843.44 12,847.16 996.29 106,707.29
47 13,843.44 12,954.22 889.23 93,753.08
48 13,843.44 13,062.17 781.28 80,690.91
49 13,843.44 13,171.02 672.42 67,519.89
50 13,843.44 13,280.78 562.67 54,239.11
51 13,843.44 13,391.45 451.99 40,847.66
52 13,843.44 13,503.05 340.40 27,344.61
53 13,843.44 13,615.57 227.87 13,729.04
54 13,843.44 13,729.04 114.41 (0.00)
55 0.00 0.00 0.00 (0.00)
56 0.00 0.00 0.00 (0.00)
57 0.00 0.00 0.00 (0.00)
58 0.00 0.00 0.00 (0.00)
59 0.00 0.00 0.00 (0.00)
60 0.00 0.00 0.00 (0.00)
61 0.00 0.00 0.00 (0.00)
62 0.00 0.00 0.00 (0.00)
63 0.00 0.00 0.00 (0.00)
64 0.00 0.00 0.00 (0.00)
65 0.00 0.00 0.00 (0.00)
66 0.00 0.00 0.00 (0.00)
67 0.00 0.00 0.00 (0.00)
68 0.00 0.00 0.00 (0.00)
69 0.00 0.00 0.00 (0.00)
70 0.00 0.00 0.00 (0.00)
71 0.00 0.00 0.00 (0.00)
72 0.00 0.00 0.00 0.00

Totals 747,546.00 600,000.00 147,546.00

You might also like