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.