answersLogoWhite

0

PMT has the following structure:

PMT( rate, nper, pv, fv, type )

Rate is the interest rate for the loan.

Nper is the total number of payments for the loan.

Pv is the present value, or the total amount that a series of future payments is worth now; also known as the principal.

Fv is the future value, or a cash balance you want to attain after the last payment is made. If fv is omitted, it is assumed to be 0 (zero), that is, the future value of a loan is 0.

Type is the number 0 (zero) or 1 and indicates when payments are due.

User Avatar

Wiki User

9y ago

What else can I help you with?

Related Questions

Does The PMT function have 4 arguments in Excel?

No, it has five arguments. Two of them are optional.The syntax for the PMT function is:PMT(interest_rate, number_payments, PV, FV, Type)The FV and Type arguments are optional.


Arguments that compromise a PMT function in excel are separated by?

Commas.


What arguments are optional and not required for the PMT function in MS Excel?

The FV and Type arguments are optional in the PMT function.


What function is used to calculate a mortgage payment on Microsoft Excel?

The PMT function.The PMT function.The PMT function.The PMT function.The PMT function.The PMT function.The PMT function.The PMT function.The PMT function.The PMT function.The PMT function.


Which Excel function would you use when you want to determine a monthly loan payment?

The PMT function.


What does Excel use to separate multiple arguments in a function?

Commas are used to separate arguments in Excel functions.


When you enter the rate and nper arguments in a PMT fuction you must?

Divide both values by 12


Can you use the PMT function in Excel to display dates in many different formats?

The PMT function returns the payment amount for a loan, so it has nothing to do with how dates are displayed. It returns numbers.


What function in excel tells you how long it will take to payoff a loan?

Please explain more clearly


What is the difference between the PMT and PPMT functions in Excel?

The PPMT function returns the amt. of interest in a specified instalment number whereas the PMT function returns the amt. of interest in every EMI payment.


Where do you find a list of Excel arguments?

Each function in Excel that has arguments will differ in terms of what arguments are needed. The help for a particular function will indicate what arguments may be needed. Some functions can be used in different ways and may not always need all arguments.


Values used with a function in Excel?

Arguments