Advanced Functions 
PMT 
The PMT is a function used to calculate the payments due on a specified regular period as subject to a loan. The formula of the PMT function is PMT(Rate; DPER; PV; FV; F) The PMT function takes four arguments, two of which are optional. The Rate specified the interest rate of the loan. The DPER represents the total number of payments on the set period. The PV represents the present value of the loan. The FV represents the future value intended to achieve after the last payment of the loan. As an optional argument, if you don’t specify it, the function considers it as 0. The F, also an optional argument, indicates when the payments are due. The default value is 0 which indicates that the payments are due at the end of the period. Otherwise, a value of 1 indicates that the payments are due at the beginning of the period. 
Practical Learning: The PMT Function 

Previous  Home  Next 


Copyright © 2002 FunctionX  
