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. 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






Leave a Reply

Your email address will not be published. Required fields are marked *

seventeen + fifteen =