Home Loan Repayment Calculator India Excel
So below is the screen shot for the emi calculator in excel sheet.
Home loan repayment calculator india excel. Hdfc offers home loans with emis starting from 734 per lac and interest rates starting from 8 p a. Loan emi calculator in excel xls file download here here below down you can download the emi calculator in excel format which will hep you to calculate the emi of any loan like home car loan personal loan etc. It can be done in two ways do a lump sum repayment of your loan or repay lump sum amounts at monthly intervals whichever option you choose. No charges for banking transactions.
Has fixed value in balance field of q11 column which is basis of all emi calculation suppose i change my loan amount to greater than 3000000 lakh then i think the calculation is wrong kindly have a look and suggest. 24 7 anytime anywhere access. When you have financial liquidity due to maybe an unexpected bonus you can choose to partially repay your home loan. Check out the part payment calculator by the idfc bank which helps you to find out how part payment will change your loan tenure emi.
It allows you to visualize the monthly and yearly evolution of interest and principle components and the balance of the loan. Actually the excel calculator utility with name download the excel emi calculator with ad hoc payments. Book and manage your. Hdfc s home loan calculator helps you calculate your home loan emi with ease.
It can accommodate regular monthly quarterly bi annual and annual and irregular random months pre payment schedules. This is called partial prepayment. Emi calculator xls file download here. Home loans in quick and easy steps.