Loan formula to calculate principal and interest for particular month?

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

The formula you are looking for are

Principal component: =PPMT(10%/12 ; 15 ; 7*12 ; 3950 ; 0)
Interest component : =IPMT(10%/12 ; 15 ; 7*12 ; 3950 ; 0)

Thank you, that is exactly what I was looking for! :-)