## ISPMT function in Excel

Use ISPMT function calculates the amount of interest paid on a loan/ investment for a specific period. Syntax ISPMT(rate, per, nper, pv) Where, rate means the rate of interest per period, per means the period for which you need to calculate interest, nper means the total number of period over which loan investments will be […]

## PMT function

Use PMT function is used to calculate the periodic payment for a loan, for example, for a loan of $800,000 with the payment period of 36 months (3 years) and interest rate of 16%, the PMT function calculates the monthly payment of $28,150. Syntax PMT(rate, nper, pv, [fv], [type]) Rate – The annual rate of […]

## PPMT function

Use PPMT function calculates the principal value of an investment for a given period. Syntax PPMT(rate, per, nper, pv, [fv], [type]) Rate – The annual interest rate per period. Per – The number of periods that must be from 1 to nper. Nper – The total number of payment periods in an investment/ annuity. Pv […]