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

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.