Trying to do PMT manually is complex and often too time consuming for busy business owners, which is why so many rely on the PMT function in programmes like Excel to support them.

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.