Download the file : Flexible Mortgage Computations.xls
A friend stopped by to take my advice about repaying his outstanding personal loan.
I recalled creating an Excel Spreadsheet a few years back for myself. The spreadsheet uses Excel Function PMT to compute the EMI. Websites like EMICalc are very useful to check the schedule based on initial values of Principal, Term and Rate of Interest. But I wanted to build a sheet to check the effect of change of interest rates, partial repayment and modifying the term.
My friend found this sheet useful. Hopefully others will too.