Commercial loan amortization schedule excel

broken image
broken image

If you opt for a housing loan of INR 20 lakh at an interest rate of 7.99% p.a., and your tenure is 20 years i.e., 240 months, then your EMI can be calculated as:Īfter putting the correct R-value in the formula, we get an EMI of INR 16,729. R = Monthly rate of interest i.e., the percentage rate of interest divided by 12 Wondering how a home loan EMI calculator works? Here’s the formula: As the loan matures, the interest component decreases while the principal component gradually increases. In the initial years of the loan, a major portion of the EMI comprises interest payable since the principal amount is large. Home loan EMI is calculated by the financial institutions (FI) on principal, interest to be paid and tenure. What is a Home Loan EMI Calculator?Ī Home Loan EMI calculator is an online tool that helps you estimate your monthly payout towards EMIs.

broken image

Contact our customer service experts for more information and guidance on home loans. Say goodbye to manual errors and tedious calculations use our calculator to plan your home loan within seconds.

broken image

Our EMI calculator will generate an approximate amount based on your input. Simply input your selected loan amount, the provided interest rate, and the loan term and click ‘Calculate’. Calculate your EMIs with PNB Housing’s easy and intuitive Home Loan EMI Calculator.

broken image