Hi Friends,
If you want to calculate EMI of any loan, then download the excel sheet from the link given below. After downloading you can customize as you want. This sheet is great sheet. This sheet provides all the information needed while taking loan.
Mortage Loan Payment sheet for 30 Years
The download link taken from the website.