The Microsoft Excel Financial Function !
PMT Function.
The Excel PMT function helps you to calculate the payments for a loan or the future value of an investment based on constant payments and a constant interest rate. This is a part of financial function.
Syntax : -
PMT(rate, nper, pv, fv, type) The PMT Function syntax has the following Arguments : - 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 or 1 and indicates when payments are due. This is an optional.
Remarks :-
The payment returned by PMT includes principal and interest but no taxes. Click To Download File
Remarks :-
The payment returned by PMT includes principal and interest but no taxes. Click To Download File