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 |
In Multiples Of | Numeric without decimals | Must Have | Deposit can be accepted in multiple of 100’s, 1000’s etc. | 10 digits, numeric |
View/Edit Interest Rate Chart for this Term Deposit | Link | Could Have | Allows user to view / edit the interest rate chart that is applicable for this term deposit |
|
Valid From and To | Read only text | Must Have | Displayed based on Interest Rate Chart selected. The Period within which the current date falls will be displayed. | Example: if today is 22nd Nov 2013. And the interest rate chart has 3 tables related to different validity periods: a) 01-Jul-2013 to 31-Dec-2014 b) 01-Jan-2013 to 30-Jun-2013 c) 01-Jul-2012 to 31-Dec-2012 Then the dates for a) will be displayed |
Interest Rate Chart | Read only table of interest rates and bands | Must Have | Table which has the interest rates applicable as of today. | Example: if today is 22nd Nov 2013. And the interest rate chart has 3 tables related to different validity periods: d) 01-Jul-2013 to 31-Dec-2014 e) 01-Jan-2013 to 30-Jun-2013 f) 01-Jul-2012 to 31-Dec-2012 Then the interest rate chart for a) will be displayed |
Interest Compounding Period | Dropdown | Must Have | Same as for Savings accounts | Cannot be blank or zero |
Interest Posting Period | Dropdown | Must Have | Same as for Savings accounts | Cannot be blank or zero |
Lock-In Period | Numeric without decimals With dropdown for Days/Months | Must Have | Same as for Savings accounts |
|
For pre-mature Closures | Static Text | Must Have |
|
|
Period when interest will not be paid | Checkbox | Must Have | If checked, then, if the deposit is prematurely closed within the specified period, then no interest will be paid |
|
Period – From/To | 2 text boxes - Numeric without decimals | Must Have | User can select applicable period range, for example: user enters 1 and 30, for “1 to 30 (days)” | Upto 5 digits allowed Has to be specified if “Period when interest will not be paid” is checked |
Period Type | Dropdown | Must Have | User can select “Days” or “Months” | Has to be selected if “Period when interest will not be paid” is checked |
Apply penal interest (less) | Checkbox | Must Have | If checked, then it means that there is a penal interest rate applicable if the account is closure before maturity |
|
Penal Interest Rate | Numeric with 5 decimals | Must Have | Specifies, how much the interest rate will be reduced by because of this premature closure. | “1%” means 1% less than the interest rate applicable. |
Penal Interest Rate Applicable On | Dropdown | Must Have | Specifies if the penal interest is applied on the interest rate for the whole term or applicable only for the interest rate that is applicable for the term till the time this deposit is being closed. Options available: a) Interest Rate Applicable for Whole Term b) Interest Rate Applicable for Term till Pre-mature Withdrawal | Example: if penal interest rate was 1%, For 0-6 months, interest rate is 4% For 6 to 12 months, interest rate is 5%
If an account is opened for 9 months, and was closed at 4 months, then:
For option a) – interest will be 4% (i.e. 5% minus 1%) For option b) – interest will be 3% (i.e. 4% - which is applicable for the 5 month term – minus 1) |
Charges |
| Must Have | Same as for Savings accounts |
|
Accounting |
| Must Have | Same as for Savings accounts |
|
Sample Screen:
4.2 Interest Rate Chart Definition for Term Deposit
Data to be captured:
Field Name | Type | Priority Must – 1 Should – 2 Could – 3 | Description | Validations / Notes |
Interest Rate Chart for <product name> | Static Text | Must Have | “Interest Rate Chart for ” + term deposit product name | Product name came be underlined to highlight it. For example: “Interest Rate Chart for Fixed/Term Deposit - Scheme 1” |
Add New Validity Period | Link | Must Have | Add a new section for capturing a new period of validity and the associated period/amount bands and associated interest rates |
|
View Revisions | Link | Should Have | Clicking on this link will show the list of previous revisions made to this Interest Rate Chart. | The screen displayed on clicking this link will be the same as the Interest Rate Chart screen, except that in the “List of Interest Rate Charts” it will show the same Interest Rate Chart, with the available versions of it and the date of revision. The list will be displayed in descending order of date of revision. All other fields/functionality will be the same, except that the View Revisions Link will not be displayed and all fields will be in the read only mode. |
Validity Period and associated Chart of Interest (period/amount bands and associated interest rates) | Section | Must Have | This section is displayed in descending order of “Valid From” dates. | This section can be repeated multiple times. At least 1 has to exist, if save is to be allowed. There cannot be overlaps between periods. |
Chart of Interest | Table | Must Have | See below fields and screen shot |
|
S.No. | Static Text | Must Have | Running sequence number |
|
Period Type | Dropdown | Must Have | User can select “Days” or “Months” | Has to be selected |
Period – From/To | 2 text boxes - Numeric without decimals | Must Have | User can select applicable period range, for example: user enters 1 and 30, for “1 to 30 (days)” | Upto 5 digits allowed Either, Period Range or Amount Range or Both can be specified. Both Period Range and Amount Range cannot be blank. |
Amount Range | 2 text boxes - Numeric without decimals | Must Have | User can select applicable amount range, for example: user enters 0 and 10,000,000, for “0 to 10 million (rupees)” – which is the standard limit defined by central bank norms | Upto 12 digits allowed Either, Period Range or Amount Range or Both can be specified. Both Period Range and Amount Range cannot be blank. |
Interest % | Numeric with decimals | Must Have | Interest rate applicable for this “band” (“band” is a period and the associated amount range) | 4 digits before and 5 digits after decimal point allowed. Cannot be blank, but can be zero. |
Description | Textbox | Must Have | Description for this “band” | Upto 50 chars. Cannot be blank. |
Incentive field(s) | Multiple columns | Should Have | The customer or account attributes that were selected in the “Interest Incentive” screen is displayed as header. The value displayed under this column will be | To edit the values for this field, click on “Incentives” link (or icon). |
Delete | Link or Icon | Must Have | Will remove this band. | User is asked for confirmation (popup with yes or now) before this band is removed from screen. |
Incentives | Link or Icon | Must Have | Takes user to the “Interest Incentive” screen where user can specify the incentives that are applicable for this band. |
|
Add Row | Link or Icon | Must Have | Adds a new “band” row |
|
Save Button for the screen | Button | Must Have | If new Interest Rate Chart, will save this internally as “Version 1”. If an existing Interest Rate Chart, then the existing version will not be modified internally, but a new “Version Number” is generated and the interest rate chart is stored against this. |
|
Sample Screen:
4.3 Interest Incentives for a specific band in the Interest Rate Chart for a Term Deposit
This screen will only be invoked from the Interest Rate Chart screen. It will be invoked for a specific band within a validity period in the Interest Rate Chart.
This screen will have 2 sections:
a) Customer Attributes – to specify the interest incentives based on Customer Attributes (like gender / age)
b) Account Attributes – to specify the interest incentives based on Account Attributes (like an additional 0.5 interest for loans approved in the month of Jan)