Home        Online Calculators        Personal Finance        Corporate Finance        Spreadsheet Models        Derivatives   
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

Prepayment Premium Calculation Model

Lenders often charge a premium when borrowers prepay the outstanding loan or when the contracted fixed interest rate is to be reduced. This premium is arrived at by computing the present value of the future notional interest loss that the lender suffers by agreeing to such prepayment or for reduction of interest rate as the case may be. This spreadsheet template can be used to readily calculate such premium on the fly.