Home Loan EMI Calculator Amortization Schedule

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 4

Home Loan EMI Calculator

Inputs Home Loan Amount 5,000,000


(Yellow Cell Loan Interest Rate 8%
Only) Loan Tenure (Years) 10 Home Loan
Amortization
EMI 60,664 Schedule
Results
Principal Repayment 5,000,000 ---->
Total Payment 7,279,656
Total Interest Payment 2,279,656
Month Monthly EMI Principal Interest Principal % Interest % Outstanding Loan % Paid
in EMI in EMI Loan Off
0 - - - - - 5,000,000 0.0%
1 60,664 27,330 33,333 45.1% 54.9% 4,972,670 0.5%
2 60,664 27,513 33,151 45.4% 54.6% 4,945,157 1.1%
3 60,664 27,696 32,968 45.7% 54.3% 4,917,461 1.7%
4 60,664 27,881 32,783 46.0% 54.0% 4,889,580 2.2%
5 60,664 28,067 32,597 46.3% 53.7% 4,861,513 2.8%
6 60,664 28,254 32,410 46.6% 53.4% 4,833,260 3.3%
7 60,664 28,442 32,222 46.9% 53.1% 4,804,818 3.9%
8 60,664 28,632 32,032 47.2% 52.8% 4,776,186 4.5%
9 60,664 28,823 31,841 47.5% 52.5% 4,747,363 5.1%
10 60,664 29,015 31,649 47.8% 52.2% 4,718,349 5.6%
11 60,664 29,208 31,456 48.1% 51.9% 4,689,141 6.2%
12 60,664 29,403 31,261 48.5% 51.5% 4,659,738 6.8%
13 60,664 29,599 31,065 48.8% 51.2% 4,630,139 7.4%
14 60,664 29,796 30,868 49.1% 50.9% 4,600,343 8.0%
15 60,664 29,995 30,669 49.4% 50.6% 4,570,348 8.6%
16 60,664 30,195 30,469 49.8% 50.2% 4,540,153 9.2%
17 60,664 30,396 30,268 50.1% 49.9% 4,509,757 9.8%
18 60,664 30,599 30,065 50.4% 49.6% 4,479,158 10.4%
19 60,664 30,803 29,861 50.8% 49.2% 4,448,355 11.0%
20 60,664 31,008 29,656 51.1% 48.9% 4,417,347 11.7%
21 60,664 31,215 29,449 51.5% 48.5% 4,386,132 12.3%
22 60,664 31,423 29,241 51.8% 48.2% 4,354,710 12.9%
23 60,664 31,632 29,031 52.1% 47.9% 4,323,077 13.5%
24 60,664 31,843 28,821 52.5% 47.5% 4,291,234 14.2%
25 60,664 32,056 28,608 52.8% 47.2% 4,259,178 14.8%
26 60,664 32,269 28,395 53.2% 46.8% 4,226,909 15.5%
27 60,664 32,484 28,179 53.5% 46.5% 4,194,425 16.1%
28 60,664 32,701 27,963 53.9% 46.1% 4,161,724 16.8%
29 60,664 32,919 27,745 54.3% 45.7% 4,128,805 17.4%
30 60,664 33,138 27,525 54.6% 45.4% 4,095,666 18.1%
31 60,664 33,359 27,304 55.0% 45.0% 4,062,307 18.8%
32 60,664 33,582 27,082 55.4% 44.6% 4,028,725 19.4%
33 60,664 33,806 26,858 55.7% 44.3% 3,994,920 20.1%
34 60,664 34,031 26,633 56.1% 43.9% 3,960,889 20.8%
35 60,664 34,258 26,406 56.5% 43.5% 3,926,631 21.5%
36 60,664 34,486 26,178 56.8% 43.2% 3,892,144 22.2%
37 60,664 34,716 25,948 57.2% 42.8% 3,857,428 22.9%
38 60,664 34,948 25,716 57.6% 42.4% 3,822,481 23.6%
39 60,664 35,181 25,483 58.0% 42.0% 3,787,300 24.3%
40 60,664 35,415 25,249 58.4% 41.6% 3,751,885 25.0%
41 60,664 35,651 25,013 58.8% 41.2% 3,716,234 25.7%
42 60,664 35,889 24,775 59.2% 40.8% 3,680,345 26.4%
43 60,664 36,128 24,536 59.6% 40.4% 3,644,217 27.1%
44 60,664 36,369 24,295 60.0% 40.0% 3,607,848 27.8%
45 60,664 36,611 24,052 60.4% 39.6% 3,571,236 28.6%
46 60,664 36,856 23,808 60.8% 39.2% 3,534,381 29.3%
47 60,664 37,101 23,563 61.2% 38.8% 3,497,279 30.1%
48 60,664 37,349 23,315 61.6% 38.4% 3,459,931 30.8%
49 60,664 37,598 23,066 62.0% 38.0% 3,422,333 31.6%
50 60,664 37,848 22,816 62.4% 37.6% 3,384,485 32.3%
51 60,664 38,101 22,563 62.8% 37.2% 3,346,384 33.1%
52 60,664 38,355 22,309 63.2% 36.8% 3,308,030 33.8%
53 60,664 38,610 22,054 63.6% 36.4% 3,269,419 34.6%
54 60,664 38,868 21,796 64.1% 35.9% 3,230,552 35.4%
55 60,664 39,127 21,537 64.5% 35.5% 3,191,425 36.2%
56 60,664 39,388 21,276 64.9% 35.1% 3,152,037 37.0%
57 60,664 39,650 21,014 65.4% 34.6% 3,112,387 37.8%
58 60,664 39,915 20,749 65.8% 34.2% 3,072,473 38.6%
59 60,664 40,181 20,483 66.2% 33.8% 3,032,292 39.4%
60 60,664 40,449 20,215 66.7% 33.3% 2,991,843 40.2%
61 60,664 40,718 19,946 67.1% 32.9% 2,951,125 41.0%
62 60,664 40,990 19,674 67.6% 32.4% 2,910,136 41.8%
63 60,664 41,263 19,401 68.0% 32.0% 2,868,873 42.6%
64 60,664 41,538 19,126 68.5% 31.5% 2,827,335 43.5%
65 60,664 41,815 18,849 68.9% 31.1% 2,785,520 44.3%
66 60,664 42,094 18,570 69.4% 30.6% 2,743,426 45.1%
67 60,664 42,374 18,290 69.9% 30.1% 2,701,052 46.0%
68 60,664 42,657 18,007 70.3% 29.7% 2,658,395 46.8%
69 60,664 42,941 17,723 70.8% 29.2% 2,615,454 47.7%
70 60,664 43,227 17,436 71.3% 28.7% 2,572,227 48.6%
71 60,664 43,516 17,148 71.7% 28.3% 2,528,711 49.4%
72 60,664 43,806 16,858 72.2% 27.8% 2,484,905 50.3%
73 60,664 44,098 16,566 72.7% 27.3% 2,440,807 51.2%
74 60,664 44,392 16,272 73.2% 26.8% 2,396,416 52.1%
75 60,664 44,688 15,976 73.7% 26.3% 2,351,728 53.0%
76 60,664 44,986 15,678 74.2% 25.8% 2,306,742 53.9%
77 60,664 45,286 15,378 74.6% 25.4% 2,261,457 54.8%
78 60,664 45,587 15,076 75.1% 24.9% 2,215,869 55.7%
79 60,664 45,891 14,772 75.6% 24.4% 2,169,978 56.6%
80 60,664 46,197 14,467 76.2% 23.8% 2,123,781 57.5%
81 60,664 46,505 14,159 76.7% 23.3% 2,077,276 58.5%
82 60,664 46,815 13,849 77.2% 22.8% 2,030,460 59.4%
83 60,664 47,127 13,536 77.7% 22.3% 1,983,333 60.3%
84 60,664 47,442 13,222 78.2% 21.8% 1,935,891 61.3%
85 60,664 47,758 12,906 78.7% 21.3% 1,888,133 62.2%
86 60,664 48,076 12,588 79.3% 20.7% 1,840,057 63.2%
87 60,664 48,397 12,267 79.8% 20.2% 1,791,660 64.2%
88 60,664 48,719 11,944 80.3% 19.7% 1,742,941 65.1%
89 60,664 49,044 11,620 80.8% 19.2% 1,693,897 66.1%
90 60,664 49,371 11,293 81.4% 18.6% 1,644,526 67.1%
91 60,664 49,700 10,964 81.9% 18.1% 1,594,825 68.1%
92 60,664 50,032 10,632 82.5% 17.5% 1,544,794 69.1%
93 60,664 50,365 10,299 83.0% 17.0% 1,494,429 70.1%
94 60,664 50,701 9,963 83.6% 16.4% 1,443,728 71.1%
95 60,664 51,039 9,625 84.1% 15.9% 1,392,689 72.1%
96 60,664 51,379 9,285 84.7% 15.3% 1,341,310 73.2%
97 60,664 51,722 8,942 85.3% 14.7% 1,289,588 74.2%
98 60,664 52,067 8,597 85.8% 14.2% 1,237,521 75.2%
99 60,664 52,414 8,250 86.4% 13.6% 1,185,108 76.3%
100 60,664 52,763 7,901 87.0% 13.0% 1,132,345 77.4%
101 60,664 53,115 7,549 87.6% 12.4% 1,079,230 78.4%
102 60,664 53,469 7,195 88.1% 11.9% 1,025,761 79.5%
103 60,664 53,825 6,838 88.7% 11.3% 971,935 80.6%
104 60,664 54,184 6,480 89.3% 10.7% 917,751 81.6%
105 60,664 54,545 6,118 89.9% 10.1% 863,206 82.7%
106 60,664 54,909 5,755 90.5% 9.5% 808,297 83.8%
107 60,664 55,275 5,389 91.1% 8.9% 753,021 84.9%
108 60,664 55,644 5,020 91.7% 8.3% 697,378 86.1%
109 60,664 56,015 4,649 92.3% 7.7% 641,363 87.2%
110 60,664 56,388 4,276 93.0% 7.0% 584,975 88.3%
111 60,664 56,764 3,900 93.6% 6.4% 528,211 89.4%
112 60,664 57,142 3,521 94.2% 5.8% 471,069 90.6%
113 60,664 57,523 3,140 94.8% 5.2% 413,545 91.7%
114 60,664 57,907 2,757 95.5% 4.5% 355,639 92.9%
115 60,664 58,293 2,371 96.1% 3.9% 297,346 94.1%
116 60,664 58,681 1,982 96.7% 3.3% 238,664 95.2%
117 60,664 59,073 1,591 97.4% 2.6% 179,592 96.4%
118 60,664 59,467 1,197 98.0% 2.0% 120,125 97.6%
119 60,664 59,863 801 98.7% 1.3% 60,262 98.8%
120 60,664 60,262 402 99.3% 0.7% 0 100.0%

You might also like