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
