Table of Content
- Home Loan Repayment Options: EMIs, Part-Prepayment And Foreclosure
- Does prepayment reduce your EMI or tenor?
- Benefits of Home Loan Prepayment Calculator
- Q. Can I make partial prepayment on my home loan??
- Home Loan Prepayment Calculator
- Create Home Loan Calculator in Excel Sheet with Prepayment Option
- What is the difference between the prepayment calculator and the moratorium calculator?
Paying an amount even as little as one extra EMI per year would go a long way into helping you close your loan much faster. Grihashakti provides an online home loan partial prepayment calculator to help you understand the effect of making part prepayments on your home loan. For home loan accounts closure bank would apply home loan prepayment calculator and close home loan account after deducting applicable charges. For home loan borrowers who want to reduce loan burden, banks may apply lump sum payment on the date on prepayment calculator and return fresh EMI or tenure conditions. In normal times, several banks would levy a penalty for premature closure of loan accounts, but now this condition might be relaxed.
There is usually no cap on how many personal loans a borrower can avail of simultaneously. It all depends on their creditworthiness and repayment capacity. The lenders assess the repayment capacity and credit score while approving and rejecting the loan.
Home Loan Repayment Options: EMIs, Part-Prepayment And Foreclosure
There are some lenders that do not allow prepayment as it may cause losses to them. Looking to make a partial prepayment against your home loan? Use the Home Loan Prepayment Calculator to find out how much you will save on interest and how it affects your home loan EMI. Simply enter the loan amount, tenure, rate of interest, instalments paid, and prepayment amount to see the results. 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.
The following rules will apply to borrowers who are not individuals (i.e., businesses, sole proprietorship firms or HUFs acting as co-applicants). A mortgage, however, should not be viewed as a personal loan, auto loan, etc. Here, D4 and D5 represent the cell references of Loan Amount and Prepayment respectively. I covered all the important points related to Home Loan Prepayment. You can post your queries or share your views, comments and feedback on this post through following comments section. Generally, the lending partners derive their list of fees and charges from the guidelines issued by the Reserve Bank of India.
Does prepayment reduce your EMI or tenor?
If Mr.X does not opt for any prepayment he will end up paying Rs 20 lakh principal and net interest of Rs.26.4 lakh. Home loan prepayment comes with several benefits, such as reduced outstanding, reduced tenor, and smaller EMIs. In the long run, prepayments help you become debt-free earlier, which ultimately impacts your CIBIL Score positively. You should thoroughly evaluate & compare all your savings through the SBI home loan prepayment calculator. If it’s a dual-rate loan, HFCs cannot charge a prepayment penalty if the borrower repays the loan when it is a floating-rate loan. Any individual can make full or partial prepayment against their outstanding loan, as long as the lender allows it.

It is not that prepayment of loans can resort only during emergency times like now. Banks provide the option of prepayment schedules to borrowers so that borrowers may bring down EMI load or loan tenure. Banks may levy a minor penalty rate for premature loan account closure yet not for prepayment. Whenever the borrower makes a lump-sum payment for loan prepayment, the loan amount is reduced, so is the EMI or tenure.
Benefits of Home Loan Prepayment Calculator
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. We offer unbiased advice on financial products & investment options like the stock market, mutual funds, insurance, credit cards, etc. Many borrowers may have purchased loan products from banks and financial institutions.
From the above image, we can easily understand visually that the EMI consists of the monthly Interest and the monthly paid-up Principal amount. In this step, we’ll calculate the monthly Interest that we have to pay in our EMI. If the home loan has been availed of by an individual on a fixed interest rate.
Investing your bonus in an FD will be a better option in this case. When you opt for part payment of your home loan, then the amount of principal outstanding is lowered significantly. The remaining reduced amount of principal also results in lower interest liabilities & EMI reduction subsequently. A part-payment would largely limit the liabilities when opted for at the right time. The SBI home loan part payment calculator enables a borrower to decide the overall profitability of the advance payment that they make against the housing loan liability. Home loans with fixed interest rates come with a prepayment penalty.
By default, Home Loan tenure is adjusted/reduced on Home Loan Prepayment but some borrowers opt for reduction in EMI amount. I always suggest my clients to reduce Home Loan tenure instead of EMI. Reason being, it will help to reduce total interest outflow. Financially it is more beneficial to reduce Home Loan tenure instead of EMI otherwise there is no monetary benefit of Home Loan Prepayment.
Here, F9 and E10 represent the Principal Remaining of last month and the Principal of the present month. 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. Does not take into account the effect of moratorium or loan restructuring facility, if availed.

Normally CIBIL database is updated within days from the date of payment. After 60 days, pull out your CIBIL report to check the same. Now you must be wondering why it is important at the time of prepayment. Answer is very simple, your overall credit worthiness depend on balance outstanding. Home Loan Prepayment will reduce balance outstanding and increase your credit worthiness which will improve CIBIL score.
As the name suggests, pre-payment is a facility offered by some banks to help a borrower repay their loan before their actual repayment tenure as per the loan documents. As the largest platform for buyers and sellers of property to connect in a transparent manner, Magicbricks has an active base of over 15 lakh property listings. Prepayment is the early, partial, or complete repayment of a debt by the borrower. Now you must be wondering, What about Home Loan tax benefits i am availing on Home Loan Principal and Interest. You are right but considering average Home Loan ticket size of 40 lakh. 1st year interest outflow will be approx 4.03 Lakh @ 10.15% ROI.

If allowed, you should also check if your bank is imposing any penalty for loan prepayment. Home loan prepayment usually results in either reduction in your EMI or a reduction in your home loan tenure. Either way, you save a lot on the interest when you prepay your loan. You need to pay simple interest for balance 20 days for which you need another cheque leaf. Of course, there are circumstances under which the prepayment on Housing loan penalty charge cannot be levied by lenders.
Home Loan Prepayment is financially beneficial for Home Loan Borrowers. It helps to reduce Interest burden thus overall cost of property. Any type of debt including Home Loan is not good for financial health of an individual. Average Home Loan tenure in India is 8 years which means Home Loan Prepayment is preferred by borrowers to clear off Home Loan. Normally Home Loan Prepayment is done when we receive annual bonus or any exiting investment mature. As i mentioned in my other posts also that Home Loan Interest increase the overall cost of property.
No comments:
Post a Comment