Calculators      Interest FAQ     Excel templates     

 irr calculation
  Net Present Value
Effective rates:
  Savings Plan
  Repayment Plan
  Early repayment charge  
Retirement provision:
  Pension by lump sum payment
  Withdrawal plan  
Internal Rate of Return

Repayment plan, effective interest and early repayment charge

Online calculator for a repayment plan

You can build a repayment plan, also called amortization schedule, on the basis of the nominal interest. Here, the interest is variable and a change of interest rates is possible. Special repayments can be included into the repayment plan. The effective interest and an early repayment charge can be calculated.

Basic mortgage conditions:

Name of the creditor: Nominal interest rate: %
Credit sum: Amount of monthly payments:  or
Disbursement date: Initial repayment ratio(%):
other duration:

Repayment plan--> Result

Nr. Date Debt previous month Interest rate Payment Special repayment Interest Repayment New debt
1. 2009-04-01100000.00   433.332676.67 97323.33
2. 2009-05-0197323.33   421.732688.27 94635.07
3. 2009-06-0194635.07   410.092699.91 91935.15
4. 2009-07-0191935.15   398.392711.61 89223.54
5. 2009-08-0189223.54   386.642723.36 86500.17
6. 2009-09-0186500.17   374.832735.17 83765.01
7. 2009-10-0183765.01   362.982747.02 81017.99
8. 2009-11-0181017.99   351.082758.92 78259.07
9. 2009-12-0178259.07   339.122770.88 75488.19
10. 2010-01-0175488.19   327.122782.88 72705.31
11. 2010-02-0172705.31   315.062794.94 69910.36
12. 2010-03-0169910.36   302.942807.06 67103.31
13. 2010-04-0167103.31   290.782819.22 64284.09
14. 2010-05-0164284.09   278.562831.44 61452.65
15. 2010-06-0161452.65   266.292843.71 58608.95
16. 2010-07-0158608.95   253.972856.03 55752.92
17. 2010-08-0155752.92   241.602868.40 52884.52
18. 2010-09-0152884.52   229.172880.83 50003.68
19. 2010-10-0150003.68   216.682893.32 47110.36
20. 2010-11-0147110.36   204.142905.86 44204.51
21. 2010-12-0144204.51   191.552918.45 41286.06
22. 2011-01-0141286.06   178.912931.09 38354.97
23. 2011-02-0138354.97   166.202943.80 35411.17
24. 2011-03-0135411.17   153.452956.55 32454.62
Sums: 74640.0 0.0 7094.6 67545.4

Any warranty for the correctness of the numbers is excluded.
Spreadsheet template for the computation of a amortization schedule -->

Nominal--> Effective interest rate:

If you have changed the repayment plan, you should first compute the plan again. Then the interest rate changes and the special repayments are saved and will be included in the calculation of the effective interest.
Even if you don´t add any extra expenses, the calculated effective interest is different from the nominal interest. The reason is that the effective interest is calculated with daily interest capitalization according to the ISMA method.

Spreadsheet template for the computation of the effective interest -->

Early Repayment--> Redemption penalty

After changing the repayment plan, you should always recalculate it to save the changes. The repayment plan should be calculated with all possible additional repayments, because they reduce the early repayment charge. The repayment plan should only cover the period in which the interest rate is fixed. Changes of interest rate are not possible with the computation of the redemption penalty because the redemption penalty arises from the fixation of the rate.

For most amortized loans, the interest rates are fixed. These loans are called fixed rate mortgages (FRM). The firm interest rate has the advantage for the borrower that they can plan their monthly payments in the future. If the interest rate in the capital markets rises they have an advantage since their payments remain constant. But in case the interest rates falls they will not take profit from that.
If a loan agreement is quit prematurely, compensation is necessary - the so-called "early repayment charge" or "redemption penalty". A currently lower interest rate leads to a payment by the borrower. If the interest rates have risen the creditor will gladly accept the early repayment or will even grant compensation.

  Amortization schedule
  Early repayment charge

Performance of the system    about IRRQ    Excel template for this computation    Contact form    Disclaimer

Mistakes? Help to improve this page.

Valid HTML 4.01 Transitional