Loans calculations adopting "french" method

[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?

[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

[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!

[Pruyn]

I don't know if this is what your searching for, but it might help.

Good Luck, Jeroen