EMI Calculation with Variable Interest Rates

Dear Friends,

I have prepared an excel sheet for calculation of EMI in accordance with the other attachment. Basically it is in relation to a loan, for which the ROI is 9.25% for the First Year, 10.25% for the next two years and 11% from 3rd Year onwards.

However, the principal amount does not come to a zero with the end of loan tenure and rather the borrower appears to pay excess.

Can you kindly review the file and let me have your comments / corrections.

Regards

DC