Hello, I would like to ask for an advice regarding loan function: I have a loan 3.950 EUR with 10% annual interest rate, loan period is 7 years with 12 payments per year. My question:
- How to write formula that would show the interest in 15th payment?
- How to write formula that would show the principal in 15th payment? Or any xth payment...

I know, there is a template Loan Amortization Schedule in Excel, but I would like to have the calculation in one cell instead of linking it to the template, as I would need to do many templates for many customers.

Thank you

Marian