Say, I want to give an amount of $100,000 as a Loan on 15% IRR for 36
Months, if last 6 instalments/cash flows are mentioned in Amortization
Schedule say $100/=, how can I calculate the 1st 30 instalments/cash flows.

Some one told me that I have to use quadratic equation in Excel, but I don't
know how to use it, any idea please ?

Best Regards,

Luqman

Luqman,

I don't know about a quadratic equation, but a "Goal seek" would do it, if
you have an amorization shcedule set up.
On a $100,000 loan at 15%, for 36 months, with the last 6 cash flows = $100,
the first 30 cash flows would be $4,001.95.

I sent you a workbook using the e-mail address you provided.

Don



"Luqman" wrote in message
...
Say, I want to give an amount of $100,000 as a Loan on 15% IRR for 36
Months, if last 6 instalments/cash flows are mentioned in Amortization
Schedule say $100/=, how can I calculate the 1st 30 instalments/cash
flows.

Some one told me that I have to use quadratic equation in Excel, but I
don't know how to use it, any idea please ?

Best Regards,

Luqman