• Print
  • Share
  • Dark
    Light

Prepayment Recalculation Methods

  • Updated on 27 Dec 2018
  • 6 minutes to read

Overview

When a client makes an early repayment on a loan using the dynamic method, you can choose whether to recalculate the repayment schedule or not.

Mambu supports different recalculation options which you can choose from, based on your internal operations and the Interest Calculation method used. See below more details.
For Declining Balance interest method:

  • No Recalculation
  • Reschedule Remaining Repayments
  • Recalculate the Schedule, Keep the Same Number of Terms
  • Recalculate the Schedule, Keep the Same Principal Amount

For Declining Balance Equal Installments interest method:
Prepayment Allocation - On Next Installments

  • "Full Due is Paid (on/after Due Date"
  • "Principal Expected is Paid (before/on Due Date"

Prepayment Allocations - On Upcoming Pending Installment Only

  • Reduce Amount per Installment
  • Reduce Number of Installments

When creating a new loan product, you will need to choose one of these methods which will then be associated to that product and to all the accounts created under it.

Next you can see how the schedules would look like for each of the methods, based on the Interest Method used.

Loan details for every example:

  • Amount: 1000
  • 6 installments
  • Principal Payment Interval: 1
  • Interest Rate: 10% charged per year
  • Installments Frequency: Every Month
  • Disbursement Date: 21/01/2017
  • Today's Date: 21/03/2017
  • 360 days in year

Under each recalculation method and each Interest method you will see how the repayment schedule would look like for each method, assuming there is a repayment of 600$ - knowing the due amount in the 21st of March is just the sum of the first 2 installments, therefore there'll be a pre-payment of the remaining amont.


Declining Balance - Recalculation Methods

Based on the product setup mentioned, this is a how the schedule would look like one month after disbursal and without any payment made yet:

Schedlue - Declining Balance (recalculation method)

Below you can see the behaviour of each recalculation method:

No Recalculation
With this method, there will be no changes in the original repayment schedule. The repayments will remain as if the 600$ were paid on the due date.
Schedule - Declining Balance with No Recalculation

Please be Aware
Both the repayments due in Feb and Mar are paid, and without any interest accrued after March 21, the remaining amount will be used to pay the principal of the third installment (the total amount of the principal) and a partial amount of the 4th installment.

The remaining installments will still display the same amount as in the original schedule.

Reschedule Remaining Repayments

With this method, the expected principal amounts of all the upcoming repayments is reduced equally by the pre-payed amount.

Schedule - Reschedule remaining repayments

Please be Aware
In the image above you can see that the first and second repayments are paid. The third installment's principal is also paid and because there was no interest accrued Mambu considers the installment as totally paid. The remaining amount will still be used to pay part of the 4th installment's principal. The remaining repayments are recalculated.

Recalculate the Schedule, Keep the Same Number of Terms

With this method, when there is an overpayment as in this scenario, the next repayments will be recalculated based on the resulting principal balance.

Schedule - recalculate schedule, keep the same number of terms

Please be aware
If instead of an overpayment, there had been a partial pre-payment, the remaining schedule would not be recalculated.

Recalculate the Schedule, Keep the Same Principal Amount

With this method, when there is an overpayment, the next repayments will be recalculated based on the resulting principal balance and the repayment is allocated first on the due installments. When the due installments are paid, the number of installments is reduced by allocating the remaining amount on the Pending installments at the bottom of the schedule and marking as Paid when the Principal Expected is covered.

Schedule - Recalculate schedule, keep the same principle amount


Declining Balance Equal Installments - Recalculation Methods

In order to choose the prepayment recalculation method the Prepayment Allocation must be selected first: you can choose whether a prepayment is allocated on the next pending installments or all the amount is allocated to the current installment only.

  • Prepayment Allocation - On Next Installments

    • Full Due is Paid (on/after Due Date)
    • Principal Expected is Paid (before/on Due Date)
  • Prepayment Allocations - On Upcoming Pending Installment Only

    • Reduce Amount per Installment
    • Reduce Number of Installments

Based on the same account setup, this is the original schedule for an account using Declining Balance Equal Installments method.

Schedule - DBEI - recalculation methods

Prepayment Allocation - On Next Installments

Full Amount Due is Paid (on/after Due Date)

With this method the prepayment is allocated to principal on the current and next installments, however the current installment will be marked "Partially Paid", as there remains interest to be accrued until the due date, therefore requiring the client to return to the bank branch to perform a payment for the interest that will be accrued at due date.

Schedule - Prepayment allocation on next installments

Principal Expected is Paid (before/on Due Date)

When using this method, the prepayment will be allocated to principal on the current and next installment, but the current installment will be marked "Paid", since Principal was covered and interest is recalculated in the next due installment, therefore not requiring the client to return at the bank branch at due date to repay whatever interest was accrued since the prepayment.

Schedule - Principal expected is paid (before/on due date)

Prepayment Allocations - On Upcoming Pending Installment Only

Reduce Amount per Installment

This method allows for the amount per installment to be reduced when a prepayment is performed, therefore keeping the original number of installments. When making a prepayment, once principal is covered on the next due installment, it will be marked as paid and the extra interest to be accrued will be recalculated in the next installment. This will ensure that the client doesn't need to come back to the bank on the due date, just to pay a portion of interest.

Schedule - Reduce Amount per Instalment

Prepayment Allocations - On Upcoming Pending Installment Only

Reduce Number of Installments

This method allows for the number of installments on the account to be reduced when a prepayment is performed. When the prepayment is performed earlier than the expected Due Date and if the Principal amount is covered, then the installment is marked Paid and the remaining un-accrued interest will be recalculated in the next installment. Using this method, the principal due can be reduced to zero in a way that the loan account may be paid off early.

Schedule - Reduce Number of Instalments

Please Note
In the above scenario, the $600 prepayment is allocated fully on the current installment, in our case the first on the schedule. Since Expected Principal was covered the installment is marked Paid and the remaining interest, is recalculated in the next installment. Since the repayment amount was considerably higher than what was expected, the last two installments on the schedule are completely reduced.

Was this article helpful?