|
||||||||
|
This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira |
||||||||
------------------------------------------------------------------------------ This SF.net email is sponsored by Windows:
Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev
_______________________________________________ Mifos-issues mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/mifos-issues
Enrique,
Thanks for the excel document. To respond to the following points you made:
MIFOSX-375: The rounding problem is caused at the migration of historic tevi´s data mostly. In the attached excel we can see the manage of one client and the Summary, on it you can see that even when it shows two decimals, internally excel makes the calculations with the maximun qauntity of decimals it can. We know that when you create a product on Mifos X, we can introduce the quantity of decimals that the product can handle, data that will be saved on bd, the calculations and when it shows on the screen. I think that the problem can come because for example, tevi can make a product with 5 digit decimals but want to see on the creen just two or without decimals, rounding the number.
To do the verification we are checking with a data set of tevi´s real data and with it certificate that the numbers we are showing and handling the right way. As sonn as we finish we will let you know.
Whats not clear is what exactly the terms of the TEVI loan is, for instance, 'credit 1' seems to be the following:
Loan amount: 270,000
Interest Rate = 0.20034 ==> 20.034%
You work it out as weekly payment of 6,233 for a 52 week loan
Total interest expected = 54,092
Total cost of loan = 324,092
So when I replicate it through mifosx loan products I did the following;
Created loan product with Argentina currency (peso) - it has two decimal places so left it as default.
Create loan product with 52 repayments occurring every 1 week, FLAT interest method, Equal Installments
The weekly payment due works out as 6,232.54 per week,
The total interest expected = 54,091.80
Total cost of loan = 324,091.80
If TEVI choose not to deal with coins / deal in centavos, you can choose to set the loan product with zero decimals. The result of this is as follows:
The weekly payment due works out as 6,232 per week, (6,260) on last payment
The total interest expected = 54,092
Total cost of loan = 324,092
So why the difference of 1 peso per week in the total installment due?
1. 52 x 6,233 = 324,116 which is 24 pesos above your own value that you set for total cost of loan (because you round UP)
2. we work out the FLAT amount due by dong the following:
= Principal 270,000 / 52 = 5192.307692307692 = 5192 per weekly installment
= Interest = 54,092 /52 = 1040.230769230769 = 1040 per weekly installment
=> total installment due = Principal + Interest = 6,232
Note: Principal and Interest components MUST be real monetary amounts too that comply with the 'decimals' rule associated with the currency. Thats why we dont just add them together and come up with 6,232.537 which would be 6,233
Hope that makes it clear why the weekly installment due is should be 6,232 and not 6,233.