Mind Blowing LOAN EMI  - CALCULATOR in a Unique Way

 

As we all know most people purchase their Dream Home through Loan.  Most Financial Institutions provide Loans equal to 80% of the cost of Flat/House etc and the borrower manages his own fund of 20% as an Up payment to the builder.  Once the Loan starts and till it is complete its period of 10 years, 15 years, or 20 years as the case may be, the borrower just pays his EMI every month. 

 

Though the borrower pays an equal amount every month, there are two constraints involved in the payment process.  One is called Principle amount and the other is Interest on the Principle amount.  See the Mind-blowing calculation through the Special Calculator.

 

Suppose a person takes a Loan of Rs. 25 Lakhs with interest payable @ 8% for 15 years period how the borrower pays his Principle + Interest?

 

Loan Amount Rs. 25,00,000

Interest 8% pa( payable monthly basis)

EMI Rs.23,891/- pm ( Actual amount comes to 23,891.30)

Let us see the Magic of how this Rs.23, 891.30 is distributed

========================================================================

Monthly Payment: INR 23891.30

Loan Details:  

Month 1: Principal Paid: INR 7224.64, Interest Paid: INR 16666.67, Remaining Balance: INR 2492775.36

Month 2: Principal Paid: INR 7272.80, Interest Paid: INR 16618.50, Remaining Balance: INR 2485502.56

Month 3: Principal Paid: INR 7321.29, Interest Paid: INR 16570.02, Remaining Balance: INR 2478181.28

Month 4: Principal Paid: INR 7370.09, Interest Paid: INR 16521.21, Remaining Balance: INR 2470811.19

Month 5: Principal Paid: INR 7419.23, Interest Paid: INR 16472.07, Remaining Balance: INR 2463391.96

Month 6: Principal Paid: INR 7468.69, Interest Paid: INR 16422.61, Remaining Balance: INR 2455923.27

Month 7: Principal Paid: INR 7518.48, Interest Paid: INR 16372.82, Remaining Balance: INR 2448404.79

Month 8: Principal Paid: INR 7568.60, Interest Paid: INR 16322.70, Remaining Balance: INR 2440836.19

Month 9: Principal Paid: INR 7619.06, Interest Paid: INR 16272.24, Remaining Balance: INR 2433217.13

Month 10: Principal Paid: INR 7669.85, Interest Paid: INR 16221.45, Remaining Balance: INR 2425547.27

Month 11: Principal Paid: INR 7720.99, Interest Paid: INR 16170.32, Remaining Balance: INR 2417826.28

Month 12: Principal Paid: INR 7772.46, Interest Paid: INR 16118.84, Remaining Balance: INR 2410053.82

Month 13: Principal Paid: INR 7824.28, Interest Paid: INR 16067.03, Remaining Balance: INR 2402229.55

Month 14: Principal Paid: INR 7876.44, Interest Paid: INR 16014.86, Remaining Balance: INR 2394353.11

Month 15: Principal Paid: INR 7928.95, Interest Paid: INR 15962.35, Remaining Balance: INR 2386424.16

Month 16: Principal Paid: INR 7981.81, Interest Paid: INR 15909.49, Remaining Balance: INR 2378442.35

Month 17: Principal Paid: INR 8035.02, Interest Paid: INR 15856.28, Remaining Balance: INR 2370407.33

Month 18: Principal Paid: INR 8088.59, Interest Paid: INR 15802.72, Remaining Balance: INR 2362318.75

Month 19: Principal Paid: INR 8142.51, Interest Paid: INR 15748.79, Remaining Balance: INR 2354176.24

Month 20: Principal Paid: INR 8196.79, Interest Paid: INR 15694.51, Remaining Balance: INR 2345979.44

Month 21: Principal Paid: INR 8251.44, Interest Paid: INR 15639.86, Remaining Balance: INR 2337728.00

Month 22: Principal Paid: INR 8306.45, Interest Paid: INR 15584.85, Remaining Balance: INR 2329421.55

Month 23: Principal Paid: INR 8361.83, Interest Paid: INR 15529.48, Remaining Balance: INR 2321059.73

Month 24: Principal Paid: INR 8417.57, Interest Paid: INR 15473.73, Remaining Balance: INR 2312642.16

Month 25: Principal Paid: INR 8473.69, Interest Paid: INR 15417.61, Remaining Balance: INR 2304168.47

Month 26: Principal Paid: INR 8530.18, Interest Paid: INR 15361.12, Remaining Balance: INR 2295638.29

Month 27: Principal Paid: INR 8587.05, Interest Paid: INR 15304.26, Remaining Balance: INR 2287051.24

Month 28: Principal Paid: INR 8644.29, Interest Paid: INR 15247.01, Remaining Balance: INR 2278406.95

Month 29: Principal Paid: INR 8701.92, Interest Paid: INR 15189.38, Remaining Balance: INR 2269705.03

Month 30: Principal Paid: INR 8759.94, Interest Paid: INR 15131.37, Remaining Balance: INR 2260945.09

Month 31: Principal Paid: INR 8818.33, Interest Paid: INR 15072.97, Remaining Balance: INR 2252126.76

Month 32: Principal Paid: INR 8877.12, Interest Paid: INR 15014.18, Remaining Balance: INR 2243249.63

Month 33: Principal Paid: INR 8936.30, Interest Paid: INR 14955.00, Remaining Balance: INR 2234313.33

Month 34: Principal Paid: INR 8995.88, Interest Paid: INR 14895.42, Remaining Balance: INR 2225317.45

Month 35: Principal Paid: INR 9055.85, Interest Paid: INR 14835.45, Remaining Balance: INR 2216261.60

Month 36: Principal Paid: INR 9116.22, Interest Paid: INR 14775.08, Remaining Balance: INR 2207145.37

Month 37: Principal Paid: INR 9177.00, Interest Paid: INR 14714.30, Remaining Balance: INR 2197968.37

Month 38: Principal Paid: INR 9238.18, Interest Paid: INR 14653.12, Remaining Balance: INR 2188730.19

Month 39: Principal Paid: INR 9299.77, Interest Paid: INR 14591.53, Remaining Balance: INR 2179430.43

Month 40: Principal Paid: INR 9361.77, Interest Paid: INR 14529.54, Remaining Balance: INR 2170068.66

Month 41: Principal Paid: INR 9424.18, Interest Paid: INR 14467.12, Remaining Balance: INR 2160644.48

Month 42: Principal Paid: INR 9487.01, Interest Paid: INR 14404.30, Remaining Balance: INR 2151157.48

Month 43: Principal Paid: INR 9550.25, Interest Paid: INR 14341.05, Remaining Balance: INR 2141607.22

Month 44: Principal Paid: INR 9613.92, Interest Paid: INR 14277.38, Remaining Balance: INR 2131993.30

Month 45: Principal Paid: INR 9678.01, Interest Paid: INR 14213.29, Remaining Balance: INR 2122315.29

Month 46: Principal Paid: INR 9742.53, Interest Paid: INR 14148.77, Remaining Balance: INR 2112572.76

Month 47: Principal Paid: INR 9807.48, Interest Paid: INR 14083.82, Remaining Balance: INR 2102765.27

Month 48: Principal Paid: INR 9872.87, Interest Paid: INR 14018.44, Remaining Balance: INR 2092892.41

Month 49: Principal Paid: INR 9938.69, Interest Paid: INR 13952.62, Remaining Balance: INR 2082953.72

Month 50: Principal Paid: INR 10004.94, Interest Paid: INR 13886.36, Remaining Balance: INR 2072948.78

Month 51: Principal Paid: INR 10071.64, Interest Paid: INR 13819.66, Remaining Balance: INR 2062877.13

Month 52: Principal Paid: INR 10138.79, Interest Paid: INR 13752.51, Remaining Balance: INR 2052738.34

Month 53: Principal Paid: INR 10206.38, Interest Paid: INR 13684.92, Remaining Balance: INR 2042531.97

Month 54: Principal Paid: INR 10274.42, Interest Paid: INR 13616.88, Remaining Balance: INR 2032257.54

Month 55: Principal Paid: INR 10342.92, Interest Paid: INR 13548.38, Remaining Balance: INR 2021914.62

Month 56: Principal Paid: INR 10411.87, Interest Paid: INR 13479.43, Remaining Balance: INR 2011502.75

Month 57: Principal Paid: INR 10481.28, Interest Paid: INR 13410.02, Remaining Balance: INR 2001021.47

Month 58: Principal Paid: INR 10551.16, Interest Paid: INR 13340.14, Remaining Balance: INR 1990470.31

Month 59: Principal Paid: INR 10621.50, Interest Paid: INR 13269.80, Remaining Balance: INR 1979848.81

Month 60: Principal Paid: INR 10692.31, Interest Paid: INR 13198.99, Remaining Balance: INR 1969156.50

Month 61: Principal Paid: INR 10763.59, Interest Paid: INR 13127.71, Remaining Balance: INR 1958392.91

Month 62: Principal Paid: INR 10835.35, Interest Paid: INR 13055.95, Remaining Balance: INR 1947557.56

Month 63: Principal Paid: INR 10907.59, Interest Paid: INR 12983.72, Remaining Balance: INR 1936649.97

Month 64: Principal Paid: INR 10980.30, Interest Paid: INR 12911.00, Remaining Balance: INR 1925669.67

Month 65: Principal Paid: INR 11053.50, Interest Paid: INR 12837.80, Remaining Balance: INR 1914616.17

Month 66: Principal Paid: INR 11127.19, Interest Paid: INR 12764.11, Remaining Balance: INR 1903488.97

Month 67: Principal Paid: INR 11201.38, Interest Paid: INR 12689.93, Remaining Balance: INR 1892287.60

Month 68: Principal Paid: INR 11276.05, Interest Paid: INR 12615.25, Remaining Balance: INR 1881011.55

Month 69: Principal Paid: INR 11351.23, Interest Paid: INR 12540.08, Remaining Balance: INR 1869660.32

Month 70: Principal Paid: INR 11426.90, Interest Paid: INR 12464.40, Remaining Balance: INR 1858233.42

Month 71: Principal Paid: INR 11503.08, Interest Paid: INR 12388.22, Remaining Balance: INR 1846730.34

Month 72: Principal Paid: INR 11579.77, Interest Paid: INR 12311.54, Remaining Balance: INR 1835150.57

Month 73: Principal Paid: INR 11656.96, Interest Paid: INR 12234.34, Remaining Balance: INR 1823493.61

Month 74: Principal Paid: INR 11734.68, Interest Paid: INR 12156.62, Remaining Balance: INR 1811758.93

Month 75: Principal Paid: INR 11812.91, Interest Paid: INR 12078.39, Remaining Balance: INR 1799946.02

Month 76: Principal Paid: INR 11891.66, Interest Paid: INR 11999.64, Remaining Balance: INR 1788054.36

Month 77: Principal Paid: INR 11970.94, Interest Paid: INR 11920.36, Remaining Balance: INR 1776083.42

Month 78: Principal Paid: INR 12050.75, Interest Paid: INR 11840.56, Remaining Balance: INR 1764032.67

Month 79: Principal Paid: INR 12131.08, Interest Paid: INR 11760.22, Remaining Balance: INR 1751901.59

Month 80: Principal Paid: INR 12211.96, Interest Paid: INR 11679.34, Remaining Balance: INR 1739689.63

Month 81: Principal Paid: INR 12293.37, Interest Paid: INR 11597.93, Remaining Balance: INR 1727396.26

Month 82: Principal Paid: INR 12375.33, Interest Paid: INR 11515.98, Remaining Balance: INR 1715020.93

Month 83: Principal Paid: INR 12457.83, Interest Paid: INR 11433.47, Remaining Balance: INR 1702563.11

Month 84: Principal Paid: INR 12540.88, Interest Paid: INR 11350.42, Remaining Balance: INR 1690022.22

Month 85: Principal Paid: INR 12624.49, Interest Paid: INR 11266.81, Remaining Balance: INR 1677397.74

Month 86: Principal Paid: INR 12708.65, Interest Paid: INR 11182.65, Remaining Balance: INR 1664689.09

Month 87: Principal Paid: INR 12793.37, Interest Paid: INR 11097.93, Remaining Balance: INR 1651895.71

Month 88: Principal Paid: INR 12878.66, Interest Paid: INR 11012.64, Remaining Balance: INR 1639017.05

Month 89: Principal Paid: INR 12964.52, Interest Paid: INR 10926.78, Remaining Balance: INR 1626052.53

Month 90: Principal Paid: INR 13050.95, Interest Paid: INR 10840.35, Remaining Balance: INR 1613001.57

Month 91: Principal Paid: INR 13137.96, Interest Paid: INR 10753.34, Remaining Balance: INR 1599863.61

Month 92: Principal Paid: INR 13225.54, Interest Paid: INR 10665.76, Remaining Balance: INR 1586638.07

Month 93: Principal Paid: INR 13313.71, Interest Paid: INR 10577.59, Remaining Balance: INR 1573324.36

Month 94: Principal Paid: INR 13402.47, Interest Paid: INR 10488.83, Remaining Balance: INR 1559921.88

Month 95: Principal Paid: INR 13491.82, Interest Paid: INR 10399.48, Remaining Balance: INR 1546430.06

Month 96: Principal Paid: INR 13581.77, Interest Paid: INR 10309.53, Remaining Balance: INR 1532848.29

Month 97: Principal Paid: INR 13672.31, Interest Paid: INR 10218.99, Remaining Balance: INR 1519175.98

Month 98: Principal Paid: INR 13763.46, Interest Paid: INR 10127.84, Remaining Balance: INR 1505412.52

Month 99: Principal Paid: INR 13855.22, Interest Paid: INR 10036.08, Remaining Balance: INR 1491557.30

Month 100: Principal Paid: INR 13947.59, Interest Paid: INR 9943.72, Remaining Balance: INR 1477609.71

Month 101: Principal Paid: INR 14040.57, Interest Paid: INR 9850.73, Remaining Balance: INR 1463569.14

Month 102: Principal Paid: INR 14134.17, Interest Paid: INR 9757.13, Remaining Balance: INR 1449434.96

Month 103: Principal Paid: INR 14228.40, Interest Paid: INR 9662.90, Remaining Balance: INR 1435206.56

Month 104: Principal Paid: INR 14323.26, Interest Paid: INR 9568.04, Remaining Balance: INR 1420883.30

Month 105: Principal Paid: INR 14418.75, Interest Paid: INR 9472.56, Remaining Balance: INR 1406464.56

Month 106: Principal Paid: INR 14514.87, Interest Paid: INR 9376.43, Remaining Balance: INR 1391949.69

Month 107: Principal Paid: INR 14611.64, Interest Paid: INR 9279.66, Remaining Balance: INR 1377338.05

Month 108: Principal Paid: INR 14709.05, Interest Paid: INR 9182.25, Remaining Balance: INR 1362629.00

Month 109: Principal Paid: INR 14807.11, Interest Paid: INR 9084.19, Remaining Balance: INR 1347821.89

Month 110: Principal Paid: INR 14905.82, Interest Paid: INR 8985.48, Remaining Balance: INR 1332916.07

Month 111: Principal Paid: INR 15005.19, Interest Paid: INR 8886.11, Remaining Balance: INR 1317910.87

Month 112: Principal Paid: INR 15105.23, Interest Paid: INR 8786.07, Remaining Balance: INR 1302805.64

Month 113: Principal Paid: INR 15205.93, Interest Paid: INR 8685.37, Remaining Balance: INR 1287599.71

Month 114: Principal Paid: INR 15307.30, Interest Paid: INR 8584.00, Remaining Balance: INR 1272292.41

Month 115: Principal Paid: INR 15409.35, Interest Paid: INR 8481.95, Remaining Balance: INR 1256883.06

Month 116: Principal Paid: INR 15512.08, Interest Paid: INR 8379.22, Remaining Balance: INR 1241370.97

Month 117: Principal Paid: INR 15615.50, Interest Paid: INR 8275.81, Remaining Balance: INR 1225755.48

Month 118: Principal Paid: INR 15719.60, Interest Paid: INR 8171.70, Remaining Balance: INR 1210035.88

Month 119: Principal Paid: INR 15824.40, Interest Paid: INR 8066.91, Remaining Balance: INR 1194211.48

Month 120: Principal Paid: INR 15929.89, Interest Paid: INR 7961.41, Remaining Balance: INR 1178281.59

Month 121: Principal Paid: INR 16036.09, Interest Paid: INR 7855.21, Remaining Balance: INR 1162245.50

Month 122: Principal Paid: INR 16143.00, Interest Paid: INR 7748.30, Remaining Balance: INR 1146102.50

Month 123: Principal Paid: INR 16250.62, Interest Paid: INR 7640.68, Remaining Balance: INR 1129851.88

Month 124: Principal Paid: INR 16358.96, Interest Paid: INR 7532.35, Remaining Balance: INR 1113492.93

Month 125: Principal Paid: INR 16468.02, Interest Paid: INR 7423.29, Remaining Balance: INR 1097024.91

Month 126: Principal Paid: INR 16577.80, Interest Paid: INR 7313.50, Remaining Balance: INR 1080447.11

Month 127: Principal Paid: INR 16688.32, Interest Paid: INR 7202.98, Remaining Balance: INR 1063758.78

Month 128: Principal Paid: INR 16799.58, Interest Paid: INR 7091.73, Remaining Balance: INR 1046959.21

Month 129: Principal Paid: INR 16911.57, Interest Paid: INR 6979.73, Remaining Balance: INR 1030047.63

Month 130: Principal Paid: INR 17024.32, Interest Paid: INR 6866.98, Remaining Balance: INR 1013023.32

Month 131: Principal Paid: INR 17137.81, Interest Paid: INR 6753.49, Remaining Balance: INR 995885.50

Month 132: Principal Paid: INR 17252.07, Interest Paid: INR 6639.24, Remaining Balance: INR 978633.44

Month 133: Principal Paid: INR 17367.08, Interest Paid: INR 6524.22, Remaining Balance: INR 961266.36

Month 134: Principal Paid: INR 17482.86, Interest Paid: INR 6408.44, Remaining Balance: INR 943783.50

Month 135: Principal Paid: INR 17599.41, Interest Paid: INR 6291.89, Remaining Balance: INR 926184.09

Month 136: Principal Paid: INR 17716.74, Interest Paid: INR 6174.56, Remaining Balance: INR 908467.34

Month 137: Principal Paid: INR 17834.85, Interest Paid: INR 6056.45, Remaining Balance: INR 890632.49

Month 138: Principal Paid: INR 17953.75, Interest Paid: INR 5937.55, Remaining Balance: INR 872678.74

Month 139: Principal Paid: INR 18073.44, Interest Paid: INR 5817.86, Remaining Balance: INR 854605.30

Month 140: Principal Paid: INR 18193.93, Interest Paid: INR 5697.37, Remaining Balance: INR 836411.36

Month 141: Principal Paid: INR 18315.23, Interest Paid: INR 5576.08, Remaining Balance: INR 818096.14

Month 142: Principal Paid: INR 18437.33, Interest Paid: INR 5453.97, Remaining Balance: INR 799658.81

Month 143: Principal Paid: INR 18560.24, Interest Paid: INR 5331.06, Remaining Balance: INR 781098.56

Month 144: Principal Paid: INR 18683.98, Interest Paid: INR 5207.32, Remaining Balance: INR 762414.59

Month 145: Principal Paid: INR 18808.54, Interest Paid: INR 5082.76, Remaining Balance: INR 743606.05

Month 146: Principal Paid: INR 18933.93, Interest Paid: INR 4957.37, Remaining Balance: INR 724672.12

Month 147: Principal Paid: INR 19060.15, Interest Paid: INR 4831.15, Remaining Balance: INR 705611.96

Month 148: Principal Paid: INR 19187.22, Interest Paid: INR 4704.08, Remaining Balance: INR 686424.74

Month 149: Principal Paid: INR 19315.14, Interest Paid: INR 4576.16, Remaining Balance: INR 667109.61

Month 150: Principal Paid: INR 19443.90, Interest Paid: INR 4447.40, Remaining Balance: INR 647665.70

Month 151: Principal Paid: INR 19573.53, Interest Paid: INR 4317.77, Remaining Balance: INR 628092.17

Month 152: Principal Paid: INR 19704.02, Interest Paid: INR 4187.28, Remaining Balance: INR 608388.15

Month 153: Principal Paid: INR 19835.38, Interest Paid: INR 4055.92, Remaining Balance: INR 588552.77

Month 154: Principal Paid: INR 19967.62, Interest Paid: INR 3923.69, Remaining Balance: INR 568585.15

Month 155: Principal Paid: INR 20100.73, Interest Paid: INR 3790.57, Remaining Balance: INR 548484.42

Month 156: Principal Paid: INR 20234.74, Interest Paid: INR 3656.56, Remaining Balance: INR 528249.68

Month 157: Principal Paid: INR 20369.64, Interest Paid: INR 3521.66, Remaining Balance: INR 507880.04

Month 158: Principal Paid: INR 20505.44, Interest Paid: INR 3385.87, Remaining Balance: INR 487374.60

Month 159: Principal Paid: INR 20642.14, Interest Paid: INR 3249.16, Remaining Balance: INR 466732.47

Month 160: Principal Paid: INR 20779.75, Interest Paid: INR 3111.55, Remaining Balance: INR 445952.71

Month 161: Principal Paid: INR 20918.28, Interest Paid: INR 2973.02, Remaining Balance: INR 425034.43

Month 162: Principal Paid: INR 21057.74, Interest Paid: INR 2833.56, Remaining Balance: INR 403976.69

Month 163: Principal Paid: INR 21198.12, Interest Paid: INR 2693.18, Remaining Balance: INR 382778.57

Month 164: Principal Paid: INR 21339.44, Interest Paid: INR 2551.86, Remaining Balance: INR 361439.12

Month 165: Principal Paid: INR 21481.71, Interest Paid: INR 2409.59, Remaining Balance: INR 339957.41

Month 166: Principal Paid: INR 21624.92, Interest Paid: INR 2266.38, Remaining Balance: INR 318332.49

Month 167: Principal Paid: INR 21769.09, Interest Paid: INR 2122.22, Remaining Balance: INR 296563.41

Month 168: Principal Paid: INR 21914.21, Interest Paid: INR 1977.09, Remaining Balance: INR 274649.20

Month 169: Principal Paid: INR 22060.31, Interest Paid: INR 1830.99, Remaining Balance: INR 252588.89

Month 170: Principal Paid: INR 22207.38, Interest Paid: INR 1683.93, Remaining Balance: INR 230381.51

Month 171: Principal Paid: INR 22355.43, Interest Paid: INR 1535.88, Remaining Balance: INR 208026.09

Month 172: Principal Paid: INR 22504.46, Interest Paid: INR 1386.84, Remaining Balance: INR 185521.63

Month 173: Principal Paid: INR 22654.49, Interest Paid: INR 1236.81, Remaining Balance: INR 162867.13

Month 174: Principal Paid: INR 22805.52, Interest Paid: INR 1085.78, Remaining Balance: INR 140061.61

Month 175: Principal Paid: INR 22957.56, Interest Paid: INR 933.74, Remaining Balance: INR 117104.05

Month 176: Principal Paid: INR 23110.61, Interest Paid: INR 780.69, Remaining Balance: INR 93993.45

Month 177: Principal Paid: INR 23264.68, Interest Paid: INR 626.62, Remaining Balance: INR 70728.77

Month 178: Principal Paid: INR 23419.78, Interest Paid: INR 471.53, Remaining Balance: INR 47308.99

Month 179: Principal Paid: INR 23575.91, Interest Paid: INR 315.39, Remaining Balance: INR 23733.08

Month 180: Principal Paid: INR 23733.08, Interest Paid: INR 158.22, Remaining Balance: INR -0.00

Loan Summary:

Total Principal Paid: INR 2500000.00               Total Interest Paid: INR 1800434.38

Total amount paid to Financial Institution:  43,00,434,38

We can see in the first month  Principal Paid: Rs.  7224.64,  

 Interest was Paid: Rs. 16666.67, Remaining Balance: INR 2492775.36

In the last month, the Principle was Rs. 23, 733.08  Intereest Rs.158.22

Balance = ZERO

Tag:  Calculator, Financial, EMI, Loan, Interest, Home Loan