EMI Calculation Spreadsheet Model

This Excel EMI Calculator Model can be used to calculate EMI of loan/mortgage or rate of of interest, if EMI is known. It also calculates the effective cost of the loan taking into account the loan upfront costs. The spreadsheet also generates schedule of monthly EMI payments with breakup of principal and interest. Download EMI Spreadsheet Model

Check the online version of this calculator here: EMI Calculator

Calculating EMI value in Excel using PMT function explained here: EMI Calculation in Excel