EMI for 20 lakhs home loan - SBI, HDFC Ltd, ICICI Bank, Axis Bank

Iskandar Blogger 3:27 AM
20 lakh of home loan emi details per lac loan amount. Interest rates of HDFC ltd, SBI, ICICI Bank, Kotak, Axis Bank, INg Vysya Bank, DHFL, Bank of Baroda, Bank of India, LIC Housing.

Calculated Monthly EMI for 20 lac of loan amount for 20 years:

SBI - 10.15% = Monthly EMI - Rs.24375, Total Interest - Rs.3349885 and Total Amount paid after 20 Years - Rs.5849885
HDFC Ltd - 10.15% = Monthly EMI - Rs.24375, Total Interest - Rs.3349885 and Total Amount paid after 20 Years - Rs.5849885
ICICI Bank - 10.10% = Monthly EMI - Rs.24291, Total Interest - Rs.3329939 and Total Amount paid after 20 Years - Rs.5829939
Axis Bank - 10.25% = Monthly EMI - Rs.24541, Total Interest - Rs.3389860 and Total Amount paid after 20 Years - Rs.5889860

Year Wise Calculation - For 20 Lac home loan


YearPrincipal
(A)		Interest
(B)		Total Payment
(A + B)		BalanceLoan Paid To Date
2014 19,786 1,26,461 1,46,247 24,80,2140.79%
2015 42,703 2,49,791 2,92,494 24,37,5112.50%
2016 47,245 2,45,250 2,92,494 23,90,2664.39%
2017 52,269 2,40,225 2,92,494 23,37,9976.48%
2018 57,829 2,34,665 2,92,494 22,80,1688.79%
2019 63,979 2,28,515 2,92,494 22,16,18911.35%
2020 70,784 2,21,710 2,92,494 21,45,40514.18%
202178,312 2,14,182 2,92,494 20,67,09217.32%
2022 86,641 2,05,853 2,92,494 19,80,45120.78%
2023 95,856 1,96,638 2,92,494 18,84,59424.62%
2024 1,06,051 1,86,443 2,92,494 17,78,54328.86%
2025 1,17,331 1,75,163 2,92,494 16,61,21233.55%
2026 1,29,810 1,62,684 2,92,494 15,31,40238.74%
2027 1,43,616 1,48,878 2,92,494 13,87,78644.49%
2028 1,58,891 1,33,603 2,92,494 12,28,89550.84%
2029 1,75,790 1,16,704 2,92,494 10,53,10557.88%
2030 1,94,487 98,008 2,92,494 8,58,61865.66%
2031 2,15,172 77,322 2,92,494 6,43,44674.26%
2032 2,38,057 54,437 2,92,494 4,05,39083.78%
2033 2,63,376 29,118 2,92,494 1,42,01394.32%
2034 1,42,013 4,234 1,46,247 0100.00%