...

• Principal – Principal as per the Rest Specified
• Days Calculated – based on “Days Calculation Basis”

Other rules that will be followed:

a) When interest recalculation is turned on for a loan product, then any excess amount (over what is currently due or overdue) will be applied to the outstanding principal always. In this respect, it will override the settings for Repayment Strategy selected.

b) Any interest compounding will stop if any amount is overdue more than the number of days for the account to be treated as Non-Performing Asset (overdue_days_for_npa).

c) If there is a disbursement-time fee, which is calculated on principal+interest - then this fee amount will not be recomputed based on interest recalculations.

d) If any interest (or fee) was waived on an account - and the interest (or fee) changes due to the recalculations - then the waived amount will not be automatically changed by Mifos.

Example:

     Total Interest dues: Apr-14 - 300, May-14 - 250 and Jun-14 - 200

     Interest Waived = 300 (i.e. entire Apr-2014's interest is waived)

     Due to interest recalculation (due to a back-dated transaction), the interest amounts now change to: Apr-14 - 250, May-14 - 200 and Jun-14 - 150

     The waived amount remains as 300 (i.e. April's interest of 250  is waived and from May's interest - 50 is waived. If other behavior is needed, then user has to reverse the earlier waiver and then apply interest recalculation and then re-do the waiving with new amount).

The only situation when Mifos will automatically change the waived amount is when the total recalculated interest (or fee) due is less than the waived amount. In such a case, the waived amount is reduced to the recalculated amount.

e) If a fee is already paid and due to the recalculations if the fee is reduced (or increased), then the fee paid transaction is not altered. Any excess fees already paid in can be refunded at the end of the tenure of the loan (as then it will show that the account is overpaid). If there is an increase in fee due to the recalculations, then the additional fee can be collected.

Attributes

For Loan Products and Loan Accounts

...

• Days in Year – Actual
• Recalculate Interest? – checkbox - Null
• Rest or Frequency at which outstanding principal is recalculated – Null
• Days Calculation Basis – Actual

Database changes 

 1. Modifications to Loan Product (“m_product_loan”)

2.   Modifications to Loan Account(“m_loan”)

3. Interest Recalculation settings (m_product_loan_recalculation_details)

3. Interest Recalculation settings (m_loan_recalculation_details)

Use cases:

     1. identify  recalculation : check the payment against schedule and should process recalculation in following scenarios 

1. 1. late payment, should be identified by a  batch job
   2. back dated entry
   3. pre-payment
   4. on time with advanced-payment / less payment(ex : on 3rd should pay 1000 but the payment is done for 500 or 1500)

     2.  process recalculation :

1. 1. identify outstanding principal 
   2. identify amount for interest compound 
   3. regenerate schedule based on outstanding and rest frequency(from calendar instance)
   4. add the extra interest(in-case of late payment ) to next installment
      1. for last installment,  will add extra installments with interest component only 
   5. if prepayment is done then use one of the strategy to reschedule.
      1. adjust EMI amount  
      2. adjust loan duration
      3. adjust next installments

     3. Capture new fields for loan product and account(editable only from product level but will maintain a copy at account level)

     4. Add new screen for pre-payment(internally same as repayment but will return recalculated interest by setting closure date as today)

     5. change schedule generator to use newly added days in year and days in month values

Questions

Below is a list of questions to be addressed as a result of this requirements document:

...