PmtsPerYear | |||||||||
Data Type: Float | |||||||||
A floating point (ie not an integer) number.If the value is a string, the function will attempt to convert it to a number, using the part of the string from the start to the first non-numeric character (ie not one of 0123456789+-*/^). | |||||||||
If PmtsPerYear is zero, it defaults to -1 (payments annually in arrear) | |||||||||
Maximum | 1000000 | ||||||||
Minmum | -1000000 | ||||||||
Example: 4 | |||||||||
Variable Values | |||||||||
Example(s) | |||||||||
0 | The usual case for loan interest, quarterly in arrears. | ||||||||
0 | The usual case for property calculations - rent quarterly in advance. | ||||||||
0 | The usual case for financial functions in general. Payment at the end of the year. |