Home        Online Calculators        Personal Finance        Corporate Finance        Spreadsheet Models        Derivatives        Risk   
APR Calculation Model
EMI Calculation Model
Maturity Profile (ALM) Model
Prepayment Premium
UK PAYE Tax Calculation
IRR Calculation in Excel
Loan Cash Flows Valuation
MIRR Calculation in Excel
XIRR Calculation in Excel
HR Dashboard

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