Q:

# How do you use the PMT fucntion in Microsoft Excel?

A:

To use the PMT function, correctly use the function’s formula syntax. The function syntax is PMT (rate, nper, pv, [fv], [type]), where rate is the interest rate, nper is the number of payments, pv is the present value, fv is the future value and type is the status of payment.

## Keep Learning

The PMT function in Excel calculates the payment for a loan based on constant payment and a constant interest rate. The first mandatory argument (rate) specifies the interest rate for the loan. The nper argument, also mandatory, is the total number of payments for the loan. The pv mandatory argument is the total amount that a series of future payments is worth currently.

The two optional arguments included are the future value and type. The fv argument within the syntax is the cash balance that the owner wishes to attain after completing the last payment. If the user omits the future value in the syntax, the compiler assumes it to be zero.

The type argument is an indication of the status of the payment. Set type to zero for indicating the end of the period, and set it to one to indicate the beginning of the period. Omitting the type argument causes the compiler to consider it as zero.

The result returned by the PMT function includes only the principal and interest value and does not include any taxes, reserve payments or fees associated with the loan.

Sources:

## Related Questions

• A: The concatenate function joins the text from cells or functions into one text string. Each cell contains text, numbers, cell references or any combination ... Full Answer >
Filed Under:
• A: The basics of using Microsoft Excel 2013 include knowing how to create a new workbook, how to enter data in worksheet cells, how to create simple formulas ... Full Answer >
Filed Under:
• A: While Microsoft Excel does not have a built-in function to find percentage increase between values, a user simply needs to enter the formula "=(B-A)/ABS(A)... Full Answer >
Filed Under:
• A: You can create a formula in Microsoft Excel by using constants and calculation operators, cell references and names, or functions. Simple formulas to add, ... Full Answer >
Filed Under:
PEOPLE SEARCH FOR