How to use PMT, PPMT, IPMT, FV, PV function in Excel 365

For soft Exercise File Click Download Button

Use  of PMT, PPMT, IPMT, FV, PV function in Excel 365

PMT: Calculates the payment for a loan based on constant payments and a constant interest rates.

PPMT: Returns the payments on the principal for a given investment based on periodic, constant payments and a constant interest rate.

IPMT: Returns the interest payment for a given period for a investment based on periodic, constant payments and a constant interest rate.

NPER: Returns the number of periods for an investment based on periodic, constant payments and constant interests’ rate

PV: Returns the present value of an investment. The total amount that a series of future payments is worth now.

FV: Returns the future value of an investment based on periodic, constant payments and a constant interest rate.