Effective Interest Rate Spreadsheet

The Effective Interest Rate (or “EIR”) of a loan reflects the true cost of taking that loan, by taking into account the frequency of repayments.

Use this spreadsheet to calculate the EIR or a loan.