Computing profits for a group and the portion available to each member

Computing profits for a group and the portion available to each member

 Objective

This feature will enable users to know the profits that a Group has been able to generate through their Savings and Lending activities. And how this profit is to be shared among the

 

 Success metrics

Goal

Metric

Goal

Metric

During a “Cycle” - it should be possible to view the till-date profits earned by the group and show the potential profit that each member would get based on their current share-holdings

A screen (in both mobile app and web app) displays the Group’s earnings till-date and the potential amount from this that each member would get.

At the end of a “Cycle” - it should be possible to distribute the profits earned by a Group to their members in the proportion of their share-holdings

At the click of a button, the system should show (in both mobile app and web app) the Group’s earnings till-date and the potential amount to be distributed to each member.

And on confirmation, the amount would be deposited to each member’s individual savings account.

 Assumptions

  • The profits will be computed based on the following:

    • All fees and penalties

    • Plus all interest (on loans) received by the group from members who have taken loans

    • Minus all interest (in savings) paid by the group (both on Gorup-linked Savings and Inidividual Savings)

  • The profits will be distributed among members fully at the end of a cycle and will not be partially retained by the group

  • Price of shares will not change mid-way in a Cycle

  • Profits will only be distributed at:

    • End of a cycle

 

 Requirements

Requirement

User Story

Importance

Jira Issue

Requirement

User Story

Importance

Jira Issue

Compute and store the proportion and quantum of profits to be distributed each user for current cycle. Also, allow this information to be viewed at the Group Progress dashboard level (along with member-wise listing of potential earnings) and also in each member’s Summary.

As a Group Leader or Data Entry Operator, I want to see the following information:

  • Total profits made by the Group for the cycle

  • For each member:

    • Percentage of the profit-share

    • Amount of profit-share

so that I can know the profits made my Group for current cycle and how it was distributed amount the members.

Must have

 

 Also, allow this information to be viewed for previous years also - at the Group Progress dashboard level (along with member-wise listing of actual earnings).

 As a Group Leader or Data Entry Operator, I want to see the same informations for previous cycles also - so that I can know the profits made my Group in previous cycles and how it was distributed amount the members.

Must have 

 

 Out of Scope

  • Partial distribution of profit at the end of a Cycle

  • Cycle definitions of periods other than a full year

 Design

 

 Open questions

Question

Answer

Date Answered

Question

Answer

Date Answered

How do profits get distributed to the members? Is it deposited to each member’s savings account and then allowed to be withdrawn as they please?

Sinergia to confirm

 

What is the trigger for distributing profits. Should each group initiate it on their own? Or should it be done for all groups in one go? Who will initiate it?

Sinergia to confirm

 

Will Cycle be always a year (i.e. it may start on any month, but it will always be 1st. of the month till the last of the 12th month from this month)? OR should other patterns like:

  • half-year

  • specific-start-date to specific-end-date

  • etc.

Sinergia to confirm

 

How to compute profits for a member who has joined mid-way? (for example: in the 8th month)

Sinergia to confirm.

 

One approach could be to compute a members share as follows:

  • Compute member’s-monthly-share by multiplying “the number of shares purchased by a member during the month” with “the number of months the share is held”

  • Compute member’s-profit-share-for-the-cycle as “Sum of the member’s-monthly-share” / “Sum of all the member’s-monthly-shares”

  • For each member: compute profit share as: total-profit * member’s-profile-share-for-the-cycle.

Example: 2 shares purchased by a member in 1st month is expected to be held for 12 months. And 3 shares purchased by the same member in 2nd month is expected to be held for 11 months. … and 10 shares purchased by the same member in 12th month is expected to be held for 1 month. Hence, the member’s-profit-share-for-the-cycle will be (2 * 12) + (3 * 11) + … + (10 * 1). This could be a fair way to distribute profits.

 

How to compute profits for a member who has been saving irregularly - for example: very poorly at the beginning of the cycle and very large amounts at the end of the cycle.

 

 

 Reference Links