Dear Users/Developers/Specialists,

 

I have had multiple instances where concerns were raised on loan
installments, that the installment amounts are not always the same and the
rounded off values are not adjusted in the last installment.

This is true especially when "Installment in multiples of" is set to a
'convenient' value: for example, in multiples of 10, 50, 100 etc.

Currently, Mifos ignores the rounded-off values for each installment and is
not adjusted against or accumulated towards the last installment - which I
think should be the way Mifos should handle rounding off.

 

https://mifosforge.jira.com/browse/MIFOSX-1464 was raised to address this.

 

I have added some comments and uploaded an excel file with examples on how
this can be handled.

 

Can you please review this carefully and let me know if any of you see
concerns. If this is implemented, the installments will all remain the same
throughout the tenure - except for the last installment which will be
adjusted to collect any excess or lesser amount as needed.

 

Basically, the following is the summary of my comments/thoughts:

 

Add the following configurations for loan products (these cannot be
overridden at account level):

a)      Decimal places - already present - however, this will be used for
internal computations and for the principal and Interest Split will be shown
with these many decimal places (i.e. these values will not be rounded off)

b)      Installment may be specified by user: (Yes or No) - new
configuration - where a user can specify the installment amount rather than
allowing the system to compute it.

c)       Installment in multiples of - existing configuration

 

Modify the behaviour of loan accounts as follows:

.         "Interest for each installment" will be computed and shown as per
decimal places

.         If Installment may be specified by user - then an "Installment
Amount" field is displayed for which user may enter a value when submitting
loan application (value entered will be validated against the "installment
in multiples of" rule)

.         If user does not enter the installment amount or "If Installment
may be specified by user" is set to false for the product, then system
calculates the installment amount and rounds it off as per "Installment in
multiples of" configuration value. If this field is not specified, then no
rounding-off is done.

.         Principal portion of an installment will be computed as
"Installment Amount" minus "Interest for each installment"

.         The last installment will be adjusted to ensure that:

o   for flat loans - total interest matches the interest percentage of
principal amount

o   any additional principal outstanding is collected along with the last
installment - hence there is a possibility that the last installment can be
quite different from other installments if "Installment in multiples of" is
specified as a value that can impact the installment amounts a lot

 

Please let me know if there are any serious concerns from anyone on
implementing this change.

 

Thanks 
Binny

 

------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
_______________________________________________
Mifos-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-users

Reply via email to