# How to caluculate the revised period of Home Loan?

I have taken a floating rate housing loan and have made a part pre-payment. The interest rate have also reduced twice since the date the loan was disbursed to my account. I have opted for reduction in the loan tenure instead of reduction in the instalment amount. Can somebody provide me the formula/excel sheet format to calculate the revised tenure of the loan?

## 4 Replies to “How to caluculate the revised period of Home Loan?”

1. Anonymous says:

la la la

2. Judge Julie says:

I think the Bank you used for the floating rate loan, would be glad to give you that information.

3. Ali says:

Type the following formula in a cell
=NPER(rate,pmt,pv,fv,type)
and press the enter.
For example if loan to be repaid is 2100000
rate is 9.75% and EMI is Rs. 19500 then type in the following manner
=nper(9.75%/12,19500,-2100000,0,0) then press the enter
You will find the number of EMI

4. Deepak Vasudevan says:

I would advise you to check with your back to issue you a revised amortization schedule for your loan account.