Namskar Dosto,
Some impotent financial functions used in MS-Excel
=PMT()
To calculate a loan payment in Excel, you can use the PMT function. The PMT function calculates the payment for a loan that has constant payments and a constant interest rate.
=IPMT()
The Excel IPMT function calculates the interest payment, during a specific period of a loan or investment that is paid in constant periodic payments, with a constant interest rate.
=PPMT()
The Excel PPMT function calculates the payment on the principal, during a specific period of a loan or investment that is paid in constant periodic payments, with a constant interest rate.
source