PMT Arguments

4. What Do You See? In the example on this page, the payment on a $20,000 car would be $590.48 per month for 36 months.

 

What Else Do You See? A payment is a negative number: that means money is taken away from your bank account.

 

Very well, that was a simple example of a financial formula. Microsoft Excel has many formulas for calculating the value of investments, Tbills, price, rate and yield.

Formulas->Function Library->Financial->PMT

Exam 77-888: Microsoft Excel Expert 2010

2. Applying Formulas and Functions

2.4. Apply functions in formulas: FINANCIAL Functions PMT