Excel Financial Functions (PMT, IPMT, PPMT) in Hindi




About this tutorial:

Video duration: 00:07:58
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…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads