 ### Trusted by many

9.5  ### Calculations and formulas

• How can I calculate compound interest?

With our Excel calculation module you can easily calculate the compound interest of your revolving credit or personal loan . The compound interest calculation module calculates the interest paid between the beginning and the end of the term. Based on this, you can calculate the compound interest for a loan over a period of time.

There are complicated formulas for calculating interest and compound interest. However, the compound interest of revolving credit or a personal loan can also be calculated manually: Installment amount x (Theoretical) Duration = Total amount to be paid - / - loan amount = Compound interest.

• How can I calculate the cumulative interest?

The cumulative interest is the total interest you pay on a loan. With a revolving credit, the cumulative interest cannot be determined exactly in advance. Because the interest is variable, extra money can be repaid and withdrawn in the meantime, which ensures a variable (theoretical) term, the exact cumulative interest cannot be calculated in advance. The cumulative interest over a certain period can be calculated exactly afterwards.

With a personal loan, the cumulative interest that you pay is easy to calculate. The interest and term with a personal loan are fixed. In addition, no money can be withdrawn in the meantime, so that the repayment schedule (declining annuity) is also fixed and the cumulative interest is easy to calculate.

In addition to complicated formulas for calculating the cumulative interest, it is also possible to manually calculate the cumulative interest of revolving credit or a personal loan: Installment amount x (Theoretical) Term = Total amount to be paid - / - loan amount = Cumulative interest.

• How can I calculate the interest in Excel?

With our Excel calculation module you can easily calculate the interest that you pay for a personal loan or a revolving credit . To calculate your interest in our Excel calculation module, you do need a number of information about your loan, these are the credit amount that you have borrowed, the term and the installment amount that you pay monthly. If you enter this information, the interest is easy to calculate and you will get a good indication of the interest that you pay monthly and annually for your loan.

If you want to calculate the interest of a personal loan in our Excel calculation module, it is important that the original loan amount is entered and the original term.

If you want to calculate the interest of a revolving credit in our Excel calculation module, you can suffice with the current outstanding balance and the (theoretical) term of your revolving credit.

• How can I calculate interest on interest in Excel?

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.

• How can you calculate the interest per month?

You will find our Excel calculation module on our homepage. This allows you to easily calculate the interest you pay per month for a personal loan or revolving credit . To calculate your interest per month in our Excel calculation module, you need the following loan data: the term, the loan amount that you have borrowed and the installment amount that you pay monthly. If you enter this information, the interest is easy to calculate and you will get a good indication of the interest that you pay monthly and annually for your loan.

If you want to calculate the interest per month of a personal loan in our Excel calculation module, it is important that you enter the original loan amount and the original term.

If you want to calculate the interest per month for a revolving credit, you can suffice with the current outstanding balance and the (theoretical) term of your revolving credit.

• What formula can I use to calculate the interest on a loan?

Because the formula to calculate the interest is very complicated, we make our Excel calculation module available. This allows you to easily calculate the interest of a loan without having to delve into the formula. To use our formula to calculate the interest, you do need some information. These are the amount you have borrowed, the term and the monthly installment. If you enter this information, the formula calculates the interest and gives you a good indication of the interest you pay monthly and annually for your loan.

• How can you calculate a credit repayment?

Because the formula with which you can calculate the repayment of a credit is very complex, we make our Excel calculation module available. This allows you to easily calculate the repayment of a credit without having to delve into the formula. To calculate the repayment in our Excel calculation module, you do need a number of data, namely the amount you have borrowed, the term, the monthly installment and the interest. If you fill in this information, the repayment is easy to calculate and you will get a good indication of how much you have repaid on your credit. With our Excel calculation module you can easily calculate the repayment of your revolving credit or personal loan .

• How much can I borrow with a Revolving Credit?

You borrow a minimum of € 5,000 and a maximum of € 75,000 with a Revolving Credit. The exact loan amount depends on your personal situation. The bank calculates the maximum amount you can borrow based on your income, expenses, assets and age.

• How much can I borrow online?

You can take out a loan online from a minimum of € 5,000 and up to € 125,000. The exact loan amount depends on your personal situation. The bank calculates the maximum amount you can borrow based on your income, expenses, assets and age.