Solution used in the attached code sample is more like a brute force or trial error method.
There is no formula that can help with direct calculations. I think we should have a technical discussion in the community here to decide if we want to take this solution approach. Regards, Adi From: srinivasa Rao Yedida [mailto:sre.mi...@gmail.com] Sent: 30 June 2016 10:05 To: dev@fineract.incubator.apache.org; Edward Cable <edca...@openmf.org> Cc: Adi Raju (JIRA) <j...@mifosforge.jira.com> Subject: Re: [JIRA] (MIFOSX-2235) All Adjusted EMI amount collection at first insalment In repayment SCH Hi Ed Please update status on this issue On Tue, Jun 28, 2016 at 2:03 PM, srinivasa Rao Yedida <sre.mi...@gmail.com <mailto:sre.mi...@gmail.com> > wrote: Dear Adi Raju and Other Developers, I hope related to this issue provided formulas are given some inputs (earlier attached this files in JIRA) Again enclosed here Please find Moratorium period interest example in excel and system logic which used by our partner NBFC Please let me know in case of clarification related to this calculations Requesting you please do needful ASAP On Mon, May 23, 2016 at 2:20 PM, Adi Raju (JIRA) <j...@mifosforge.jira.com <mailto:j...@mifosforge.jira.com> > wrote: [ https://mifosforge.jira.com/browse/MIFOSX-2235?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel <https://mifosforge.jira.com/browse/MIFOSX-2235?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=92230#comment-92230> &focusedCommentId=92230#comment-92230 ] Adi Raju commented on MIFOSX-2235: ---------------------------------- [~srinivasulu] I can see some tables which is outlining the repayment schedule for the required use case. Can you share the formula or procedure to be able to derive this for any combination of duration/amount/interest? Also is this expected to be supported with interest recalculation or multi-tranche disbursals? If yes, how can you derive the schedule? Also please raise your requirement on the user list and may be interact with [~edcable] to be able to prioritise these enhancements. > All Adjusted EMI amount collection at first insalment In repayment SCH > ---------------------------------------------------------------------- > > Key: MIFOSX-2235 > URL: https://mifosforge.jira.com/browse/MIFOSX-2235 > Project: Mifos X > Issue Type: New Feature > Components: Loan > Affects Versions: 15.09.2.RELEASE > Environment: At Loan repayment scheduled > Reporter: srinivasa rao Yedida > Priority: Major > Labels: candidate, estimate > Fix For: 15.12.RELEASE > > Attachments: 1st and 2-18 Installments amounts for 26K.xlsx, > screenshot-demo openmf org 2015-09-11 23-15-24.jpg > > > Hi > Expecting EMI adjustment at first installment instead of Last EMI amount at > loan repayment schedule. > Example > BI-weekly 26 Installments > 1 to 25 EMI:1090 > 26th Last EMI:971.4 > Expecting: > 1st EMI as a 971.4 > 2nd to 25th 1090 > Please do needful asap. > Thanks > Srinivasa Rao Yedida -- This message was sent by Atlassian JIRA (v1000.5.2#72002)