Table of Content
Your access to this site was blocked by Wordfence, a security provider, who protects sites from malicious activity. You can also use the online calculator for Home Loan Calculator to find the details online instead of using the Home Loan Excel Calculator. After filling all this, the Excel Calculator will automatically calculate the Monthly EMI, Principle Amount payable and interest payable. Here, F9 and E10 represent the Principal Remaining of last month and the Principal of the present month. Hence, easily we can get the EMI amount of our loan.
We use the excel formula PMT to calculate home loan EMI. We also want to calculate the remaining principal amount for each month. Loan amount - the amount borrowed, or the value of the home after your down payment. If the interest rates are hiked and the lender passes on the hike to borrowers, then your home loan rate will increase. The calculator will also give you the EMI principal and interest calculator breakup in excel.
How to Use Home Loan Excel Calculator?
It’s a monthly payment that the borrower makes towards repayment of the home loan. The best part about EMI is that you get to repay back the loan in small parts which are easier for most salaried individuals. If something is unaffordable for you as of now, you can purchase it by taking a loan and repaying back in smaller EMIs over a period of time. A home loan is probably the biggest loan you will ever take in your life.
If you add an extra payment the calculator will show how many payments you saved off the original loan term and how many years that saved. It depends on the type of home loan interest rate. For example, Individuals with a floating interest rate home loan pay no extra charges on prepayment or foreclosure. On the other hand, fixed interest rate home loans attract a nominal fee on prepayment or foreclosure. Before that, we all should know what EMI actually is. Don’t be panicked if you didn’t know about it earlier.
Home Loan - Fees and charges
Using our Home Loan EMI Calculator, you can calculate how much monthly and total expenditure you really incur by purchasing a home using your bank home loan. You just need to provide inputs like the loan amount, loan tenure and interest rate. And this continues for one by one for all the months in the loan tenure. In this step, we’ll calculate the monthly Interest that we have to pay in our EMI. Since most home loans are floating rate loans, the actual loan rate changes over the course of the loan depending on whether RBI policy rates are being hiked or cut. Every month, the Interest payment for the month goes down while the principal repayment goes up.
These are a few of the difference that a customer can experience when taking the loan from the private bank or Government Bank. Also, read why taking personal loan for downpayment is not advisable. Without making any kind of prepayment, our loan status would like the image below. Right click on any of the above images to save a copy of our Excel loan calculator spreadsheet, or click on them to directly open it.
Step 1: Calculate the EMI Amount of Home Loan Calculator with Prepayment Option in Excel Sheet
Extra income coming from annual bonuses or windfall gains can save you a lot of money if you use it wisely. If you have extra money, then prepaying your home loan can be a great option for reducing your financial burden. However, make sure that you keep aside some funds for unexpected expenses. You don't want to find yourself in an emergency without access to any funds.
If you want to guesstimate this amount, use the LIC premium calculator to calculate yearly premium for eTerm plan using your age, loan term and loan amount for Sum Assured. You then multiply this number by your loan tenure. So, before calculating the EMI, we’ve to make a change in our principal amount. Therefore we don’t wanna apply the EMI over the whole amount of loan we’ve taken. Because we already have made a prepayment to the bank. So, we’ll subtract this prepayment amount from the total loan amount and will apply EMI on this.
Service Guides
Divide this number by 12 to arrive at monthly maintenance amount. Down Payment, aka Margin, is the total money you paid to the seller or builder from your own pocket, entered either in Rupees or as a percentage of Home Value. Many people are looking to maximize the tax benefits of home loans. But if you wish to manage your home loans wisely without compromising other goals, do read this detailed post on managing home loans.
To make it easy for you, here is a free excel based Home Loan EMI Calculator that also shows you the loan amortization schedule. But the initial EMIs contribute more towards the interest component of the loan. And in the later years of the loan tenure, the EMIs contribute more towards repayment of the loan principal. Here, we have created a home loan calculator format. Suppose, we’ve taken a Loan Amount of $1,00,000 for 1-year Tenure at 8% of Interest Rate.
Planning before applying for the loan will help you in running the loan and other expenditure smoothly. Home Loan Excel Calculator offers you a wide variety of options that can be changed according to your loan scheme. Optional extra payment - if you want to add an extra amount to each monthly payment then add that amount here & your loan will amortize quicker.
From the image above, we can definitely observe that the monthly Interest is gradually decreasing. As a result, the monthly paid-up Principal is increasing continuously. Because our EMI is constant over the period of 12 months. So, if we can make a handsome amount of prepayment in the beginning, the burden of interest will be lesser upon us. While taking out the loan, we made a prepayment of $5,000. So, we are bound to pay the EMI of $95,000 in a time period of 12 months.
Therefore, it's a much better idea to prepay the car loan before the home loan in spite of the prepayment penalty charged on the car loan. So that was how you can use the Home Loan EMI calculator India to calculate the EMI on your home loan. You can easily use this loan EMI calculator excel sheet download to calculate your home loan EMIs and create a loan amortization schedule. This article shows you how to create a home loan calculator with a prepayment option in an Excel sheet. Using a home loan Excel calculator, you can easily calculate the EMI, monthly interest, remaining principal amount, etc.
If you have a home loan, just ask your lender for the home loan amortization table. It will indicate exactly your outstanding home loan amount at any point in time. Or you can easily get a quick idea of the same using online loan amortization table calculators.
From the above image, we can easily understand visually that the EMI consists of the monthly Interest and the monthly paid-up Principal amount. Here, D4 and D5 represent the cell references of Loan Amount and Prepayment respectively. The Federal Reserve has started to taper their bond buying program. For your convenience, we publish local Los Angeles mortgage rates below to help you see currently available rates. Capture your best moments with our premium photo album templates.
Finally, select cell D6 and type the formula below. Firstly, select cell E10 and write down the formula below. Here we used the same arguments and cell references as in Step 1. The new thing which hasn’t been used before is the cell reference B10. After that, use the Fill Handle tool and drag it down to cell C21 in order to get the same EMI amount of other months.
