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

Excel will calculate the PMT. The value will have a negative sign before it to indicate cash outflow. Step 4: In this example, the function will return a value of 11365.44.