Hi Veronica
We need more information, is this a monthly loan, what are the dates of the
loan, what is your disbursal date? Is the total a $900 loan? Because the
number of days change each month, the schedule can change depending on when
you disburse.
Kay Chau
Technical Product Manager, SPMC
Grameen Foundation
Skype: kaychau1
Mobile: +1 425 445 3954
www.progressoutofpoverty.org | www.grameenfoundation.org
On Tue, Dec 13, 2011 at 6:14 AM, Veronica Ballarta <
[email protected]> wrote:
> Hello.
> We use the Declining balance calculation with interest recalculation
> to compute the payment schedule. We have transformed of our 4 %
> monthly rate into an equivalent 60.1% annual rate, and calculating at
> excel we have this:
>
> N° Cuota Capital Amortizacion de capital Interes Cuota
> 1 900,00 135,69 36,00
> 171,69
> 2 764,31 141,11 30,57
> 171,69
> 3 623,20
> 146,76 24,93 171,69
> 4 476,44 152,63 19,06
> 171,69
> 5 323,82
> 158,73 12,95 171,69
> 6
> 165,08 165,08 6,60 171,69
> Total
> 900,00 130,11 1.030,11
>
>
>
>
> But we have this results which are similar but not the same in the
> mifos system :
> Numero Plazo Principal Interes Cuotas Total
> 1 131,925 45,075 0
> 0 177
> 2 138,55 38,45 0
> 0 177
> 3 145,508 31,492 0
> 0 177
> 4 152,813 24,187 0
> 0 177
> 5 160,485 16,515 0
> 0 177
> 6 170,719 9,281 0
> 0 180
>
>
> ------------------------------------------------------------------------------
> Systems Optimization Self Assessment
> Improve efficiency and utilization of IT resources. Drive out cost and
> improve service delivery. Take 5 minutes to use this Systems Optimization
> Self Assessment. http://www.accelacomm.com/jaw/sdnl/114/51450054/
> _______________________________________________
> Mifos-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/mifos-users
>
>
------------------------------------------------------------------------------
Systems Optimization Self Assessment
Improve efficiency and utilization of IT resources. Drive out cost and
improve service delivery. Take 5 minutes to use this Systems Optimization
Self Assessment. http://www.accelacomm.com/jaw/sdnl/114/51450054/
_______________________________________________
Mifos-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-users
