Page 1 of 1
Loans calculations adopting "french" method
Posted: Wed May 19, 2004 5:26 pm
by pz
My problem is how to calculate the principal repayment and the interests repayment of loans, adopting the so called "french" method. This method of rembursement is based on a constant flow (per year or fraction of year), being this flow the sum of varying interest and principal repayment.
Is anybody so kind to help me some way?
Posted: Tue May 25, 2004 1:31 pm
by Salima
Hello,
I used this accounting method in my model that I submitted to the Forum on the 9-3-04 for review. Let me know if you have questions.
Salima
I found a draft solution.
Posted: Thu May 27, 2004 9:33 am
by pz
Hi,
attached is a draft model which addresses the problem. It works correctly only if no new borrowings take place after the main loan starts. I think that - anyway - this kind of credit line doesn't allow new borrowings after the start.
Any comment is welcome!
Posted: Tue Jun 15, 2004 11:28 am
by Pruyn
I don't know if this is what your searching for, but it might help.
Good Luck, Jeroen