Note that because this is a payment, Excel will display this number in parenthesis and red font. To avoid that, insert a "-" sign in front of the PMT formula, like below.

‘Excel’ling. Understanding MS Excel functions: PMT The ‘payment’ function can be used to find out how much to invest on a regular basis to accumulate a desired corpus ...

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.