About this tutorial:
Video duration: 00:07:58
Some impotent financial functions used in MS-Excel
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.
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.
The Excel PPMT function calculates the payment on the principal, during a specific period of a loan or investment that is paid in constant…