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?

la la la

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

la la la

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

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