Annuity, bond, mortgage and other complex financial calculations can be mathematically challenging, so Microsoft included 53 related functions in Excel. The PMT () function, for example ...

The PMT function in Excel is a financial function used to calculates the payment of a loan based on payments and interest rates. The formula for the PMT function is PMT (rate,nper,pv, [fv], [type]).