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 ...

PMT is short for Payment. On the Excel screen, this function can be found using the command fx and under the category ‘Financial’. Here’s an example of how PMT can be used.