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

APR Calculation Spreadsheet Model

This is a ready to use Excel spreadsheet based APR Calculator model. This calculator can be used to calculate Annual Percentage Rate of a loan or mortgage. One needs to enter the loan amount, monthly payment, tenure of loan and all front end costs (like admin, legal charges, points etc.) and the model calculates the effective annualized cost of the loan - on IRR basis - by factoring in up front costs and time value of all cash flows. The calculator also generates payment schedule of the loan / mortgage with break up of principal and interest components of monthly payments. Download APR Spreadsheet Model

You may also use this ready to use online version: APR Calculator

Read more about APR Calculation