Term Deposits - A possible spec
A possible specification for Term Deposits in Mifos X
This document describes the new feature “Term Deposits” that is planned to be implemented in Mifos X.
Contents:
Term Deposits Overview
Interest Rate Charts
Interest Incentives
Term Deposits Product Definition
Interest Rate Chart Definition for Term Deposit
Interest Incentives for a specific band in the Interest Rate Chart for a Term Deposit
Term Deposit Creation
Term Deposit Approval
Term Deposit Closure at Maturity
Term Deposit Premature Closure
Term Deposit Re-invested at Maturity
Tasks for CodingDevelopment
1. Term Deposits Overview
Term Deposits are deposit accounts which are held for a fixed term – like 1 year, 2 years etc.
Typically, the term deposits would have the following features:
- A lock-in period – before which the deposit can be withdrawn
- Partial withdrawal not possible
- On Maturity, either the money (principal + interest) can be withdrawn, transferred to savings account or re-invested
- Usually will have a sliding interest rate chart (i.e. depending on various parameters like loan, gender, age etc, interest rates can vary)
- Interest is compounded on a certain period
- If withdrawn prior to maturity, there is a penal interest rate applicable (and the client may not get the interest rate that is applicable for that period)
2. Interest Rate Charts
An “Interest Rate Chart” defines an interest rate scheme that can be associated to a product. This will have a band (or range) of deposits periods/amounts and the associated interest rates applicable along with incentives for each band.
The interest rate chart will be maintained along with the creation of the term deposit product and is associated to the deposit product. For now, it will not be maintained independent of the deposit product. Logically, interest rate charts can be “attached” to different types of products like, Savings accounts, Term deposits, Recurring deposits etc.
Example:
S.No. | From | To | Interest Rate | Ladies Incentive | Senior Citizen Incentive | Description |
1 | 1 month | 12 months | 9% | +0.5% | +0.5% | 12 Months |
2 | 13 months | 18 months | 9.50% | +0.5% | +0.5% | 18 Months |
3 | 19 months | 24 months | 11% | +0.5% | +0.5% | 24 Months |
4 | 25 months | 36 months | 12% | +0.5% | +0.5% | 2-3 years |
5 | 37 months | 60 months | 12.50% | +0.75% | +0.75% | 3-5 years |
The interest rates and the associated incentives need to be versioned with each change (or if maker-checker is enabled, then with each approval).
When a term deposit account is created, and an interest rate chart is associated to it, then internally, the current version of the interest rate chart is associated to the term deposit. This is not changed, even if the interest rate chart is later modified (i.e. when the term deposit is approved, an interest rate is associated to it. This interest rate for the specific term deposit is not modified even if the interest rate chart is later altered).
3. Interest Incentives
This feature in Mifos X will allow the operations manager to create interest incentive schemes applicable for a specific band in interest rate. For example,
a) Ladies get an additional 0.5% interest for deposits and senior citizens get an additional 0.5% interest for term deposits for periods upto 3 years.
b) Ladies get an additional 0.75% interest for deposits and senior citizens get an additional 0.75% interest for term deposits for periods greater than 3 years.
4. Term Deposits Product Definition
4.1 Term Deposit Definition
Data to be captured:
Field Name | Type | Priority Must – 1 Should – 2 Could – 3 | Description | Validations / Notes |
Name | Textbox | Must Have | Name of this Term Deposit product | 100 chars Cannot be blank |
Description | TextArea | Must Have | Description for this Term Deposit product | 500 chars |
Fund Source | Dropdown | Must Have | Source of funds for this product |
|
Start Date and End Date | Dates | Must Have | Validity period for this product | Cannot be blank |
Currency | Dropdown | Must Have | Currency in which this Term Deposit can be opened | Cannot be blank |
Decimal Places | Numeric without decimals | Must Have | Number of Decimal Places that has to be used for computations and display for this currency | 3 digits, numeric Cannot be blank, can be zero |