Loan
Level instalments, constant principal or bullet: what your loan really costs, instalment by instalment.
The calculations run in your browser: nothing is sent or kept.
How the app calculatesThe formulas, the example above step by step, the Belgian rule and its sources
The schedule of a loan with constant instalments, constant capital or bullet; monthly, quarterly or yearly; with or without a deferral; the effective rate and the after-tax cost.
The formulas
- periodic rate(1)
- or the equivalent rate(2)
- constant instalment(3)
- interest of the month(4)
- after-tax cost(5)
K capital · t annual rate · n instalments · τ tax rate
The example above, step by step
- €100,000 at 4.5% over 60 months: instalment €1,864.30 (the last €1,864.43, the rounding to the cent).
- First instalment: €375.00 interest and €1,489.30 capital.
- Interest over the term: €11,858.13; effective rate 4.59%; after-tax cost €8,893.60 (tax at 25%).
What the rules say
The schedule is the Fiplan engine’s, to the cent, under the banking convention. The proposed tax rate is the standard corporate income tax rate of the current year.
In FiplanThe same schedule feeds the interest, the outstanding capital and the plan’s cash flow.Financial plan →