This excel sheet will help anyone taking a loan on the monthly rests basis to keep track of the amount of interest and principal being paid out and to do calculations on how the loan will change on change of interest rate and doing pre payments.
This sheet has the ability to calculate the EMI based on the interest rate and the tenure of the loan. It will also dynamically calculate the affect on the loan on changes of interest rate and part payments that are done.
To use this sheet effectively it is important to keep it updated with the interest rate changes and part payments that have been made. It can also be used to calculate what the effects are on any one of these values changing.
This excel sheets assumes there is no change in EMI. In case there is a change in EMI it is advised to start a new sheet with the new EMI and the new terms and conditions. Read this document carefully before using the sheet.