I am using the NPER function to determine the number of periods required to
pay of a loan at constant rate and constant payment. The result is
consistently understated (periods are too few to pay off the loan)

Is there a known problem? Has anyone else used this function?