| | | Make sure that you are consistent about the units you use for specifying rate and nper. |
| | | If you make monthly payments on a four-year loan at an annual interest rate of 12 percent, use 12%/12 for rate and 4*12 for nper. |
| | | If you make annual payments on the same loan, use 12% for rate and 4 for nper. |
| | | For all the arguments, the cash you pay out, such as deposits to savings or other withdrawals, is represented by negative numbers; the cash you receive, such as dividend checks and other deposits, is represented by positive numbers. |
| | | This function is provided for compatibility with Lotus 1-2-3 and is now redundant. |
| | | This function is closely related to the PV() function. |
