Term Deposits - A possible spec

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