Question: why pmt is negative in excel?
Answer: Notice that the Excel PMT function returns a negative value because this represents payments being made from you to your lender. Alternatively, if you prefer the PMT function return a positive value you can enter the Loan Amount as a negative figure.