Added a superb "Loan Amortization Schedule" excel sheet to the opening post; members can download the same. Thanks to BHPian
nikunj_cal for sharing it with us. It will help you to calculate the EMI for different loan amounts, juggle between interest rates, calculate total interest, calculate foreclosure charges and so on.