load

Trusted by many

9.5

Trustpilot

Pay attention! Borrowing money, costs money

How can I calculate interest on interest in Excel?

Frequently asked questions about calculations and formulas

Interest on interest represents the difference between the nominal and effective interest. With our Excel calculation module you can easily calculate the interest on interest of your loan. For the calculation of the interest on interest, the Excel calculation module assumes that you pay interest monthly instead of once a year. Because with a monthly repayment you need the interest amount earlier than at the end of the year, you cannot receive interest on this amount on, for example, a savings account. As a result, the interest that you actually pay (effective interest) is a fraction higher than the interest based on a monthly repayment (nominal interest).

When calculating the effective interest in our Excel calculation module, monthly repayment and the effect of interest on interest are taken into account. That is why the effective interest that our Excel calculation module calculates is higher than the nominal interest. Nominal interest does not take into account an annual interest payment.

Are you looking for a suitable loan, but are you not yet sure which loan is best for you? Use our loan wiser to find a suitable loan that is adjusted to your needs.


You can also directly specify the desired loan amount and request a quote for your loan completely free of charge and without obligation:


Current interest rates

Request a quote without obligation
en