...
| Page Properties | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Overview
As an Operations Manager, I want to define a loan product that supports interest recalculation.
...
For such scenarios, the exact interest amount calculation depends on following factors:
...
c) Rest or Frequency at which outstanding principal is recalculated – may be daily, weekly, fortnightly or monthly
Background and strategic fit
Many financial institutions have the need to re-compute interest based on actual date of repayment. This feature is a must when Mifos needs to support operations of a commercial bank.
Requirements/User Stories
| # | Title | User Story | Importance | Notes |
|---|---|---|---|---|
| 1 | Define Loan Product | As an Operations Manager, I want to define a loan product that supports interest recalculation | Must Have | |
| 2 | Create Loan Account | As an Loan Officer, I want to create a loan account that supports interest recalculation | Must Have |
Business Rules
A Daily Rest may be specified for loans of any frequency and the days in year may be:
...
These rules will not be implemented in the Mifos X code. But this is expected to be followed defining loan products and loan accounts. Mifos will be tested only in the above scenarios for consistent interest amount calculations.
Interest Amount Calculation will be done as follows:
...
- Principal – Principal as per the Rest SpcifiedSpecified
- Days Calculated – based on “Days Calculation Basis”
Attributes
For Loan Products and Loan Accounts
...
| Attribute | Description | Notes |
|---|---|---|
| Days In Year | Number of days to be considered for a year when calculating interest. Can be: Actual 365 360 364 | Not Null Default is "Actual" |
| Recalculate Interest? | For this loan product, if interest is to be recalculated when early or late payments or exact amount is not paid (True or false) | Checkbox – Nullable Default is Null |
| Frequency at which Outstanding Principal is recalculated | Rest or Frequency at which outstanding principal is recalculated – Same as Repayment Frequencyll Daily Weekly Fortnightly Monthly | Dropdown - Nullable Default is Null |
| Days Calculation Basis | Basis for calculation of number of days between the start and end dates Actual 30 | Default is Actual |
Security and Permissions
No new security considerations or permissions for this feature
Mifos Functionality Enhancements
- Loan Products to be enhanced to capture above 4 attributes
- Loan Accounts to be enhanced to capture above 4 attributes
- When make payment screen is submitted – then system checks if the payment was on time and was for the exact amount. If not, then the current and future installment and interests are re-calculated for the loan as described in Business Rules.
- New Batch job to be introduced for Daily Interest Amount Calculation for Loans
New Screens
None
Changes to Existing Screens
- Loan Products screens to be enhanced to capture above 4 attributes
- Loan Accounts screens to be enhanced to capture above 4 attributes
- Make Payment Screen – interest amount calculation and application of principal changes (see Business Rules for calculations)
Changes/Enhancements to Batch Jobs
New Batch job to be introduced for “Interest Re-Calculation for Loans” – For all loans with overdue repayments, the current and future installment and interests are re-calculated for the loan as described in Business Rules.
- To be verified: If “Loan Summary” job needs to be modified
- To be verified: If “Update Loan Arrears Aging” job needs to be modified
Changes/Enhancements to Accounting Entries
No changes
User interaction and design
TBD
Exception Handling
TBD
Reporting
No new reports or changes to existing reports needed
APIs
APIs to be enhanced for including the above fields for loans products and loan accounts.
Notes
All existing loans to have the following default value during upgrades:
- Days in Year – Actual
- Recalculate Interest? – checkbox - Null
- Rest or Frequency at which outstanding principal is recalculated – Null
- Days Calculation Basis – Actual
Questions
Below is a list of questions to be addressed as a result of this requirements document:
| Question | Outcome |
|---|---|