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