[Mifos-users] Declining Balance computation

17 views
Skip to first unread message

Mark Mirasol

unread,
Jan 23, 2015, 6:26:31 AM1/23/15
to Ed Cable, A good place to start for users or folks new to Mifos., mifos-d...@lists.sourceforge.net, IT Support
Hello Ed,

We tried to create a P6000 today with a term of 25 weeks and a 41.6%/year nominal rate.  This should give us a total interest of 6000 * .416/52 * 25 = P1200.

If the interest calculation method is flat, our total interest is P1200.
However, if the interest calculation method is declining balance, our total interest is not equal to P1200.  

Shouldn't the total interest be the same regardless of calculation method?

Please advise.

--
Mark Philippe L. Mirasol
IT Project Manager
TEAMMICRO

Sughosh Bharadwaj

unread,
Jan 23, 2015, 7:57:27 AM1/23/15
to Mifos software development, IT Support, A good place to start for users or folks new to Mifos.
Hello Mark,

If the interest type is flat, it is always calculated on the disbursed principal.
In your case,no matter how much amount is repaid, your interest is always calculated on 6000

Whereas, in declining balance, interest is always calculated on the outstanding principal.
i.e interest keeps reducing down the installments,which is the correct behavior.
If you have repaid principal amount of 1000,then interest for the next installment will be calculated on
amount of 5000 and so on.

Regards,
Sughosh

------------------------------------------------------------------------------
New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
GigeNET is offering a free month of service with a new server in Ashburn.
Choose from 2 high performing configs, both with 100TB of bandwidth.
Higher redundancy.Lower latency.Increased capacity.Completely compliant.
http://p.sf.net/sfu/gigenet
Mifos-developer mailing list
mifos-d...@lists.sourceforge.net
Unsubscribe or change settings at:
https://lists.sourceforge.net/lists/listinfo/mifos-developer

Mark Mirasol

unread,
Jan 24, 2015, 8:18:00 PM1/24/15
to Sughosh Bharadwaj, IT Support, Mifos software development, A good place to start for users or folks new to Mifos.

Thank you, sughosh. So if we wish to earn 20% interest over 25 weeks for our loans, we have to compute the nominal interest rate.  The nominal interest rate for flat rate and declining balance is not the same. 

Mark Mirasol

unread,
Jan 26, 2015, 3:09:11 AM1/26/15
to Sughosh Bharadwaj, IT Support, Mifos software development, A good place to start for users or folks new to Mifos.
Do you have a formula for computing the nominal interest rate for declining balance calculations?

Sangamesh Nadagoudar

unread,
Jan 26, 2015, 6:47:27 AM1/26/15
to Mifos software development, Sughosh Bharadwaj, IT Support, A good place to start for users or folks new to Mifos.

------------------------------------------------------------------------------
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/

Mark Mirasol

unread,
Jan 26, 2015, 7:46:01 PM1/26/15
to Sangamesh Nadagoudar, Sughosh Bharadwaj, IT Support, Mifos software development, A good place to start for users or folks new to Mifos.
Dear Sangamesh,

These formulas assume that we already know what r is and this formula is for computing the EMI.
If I want to have a flat interest of 20% over a term of 25 weeks, how do i compute for r if I wish to get the same total interest using declining balance calculation.

Please advise.
Reply all
Reply to author
Forward
0 new messages