Microsoft KB Archive/42369

Multiplan: PPMT Function Returns Wrong Value PSS ID Number: Q42369 Article last modified on 04-08-1991 PSS database name: D_MPlan

4.01

MS-DOS

Summary:

The PPMT (payment on principal for an investment) function can return an incorrect value if the final argument in the function is set to 1. For instance, the function PPMT(.1,6,60,10000,0,1) returns the value 86.38. This value is incorrect. The correct value is -4.82.

Microsoft has confirmed this to be a problem in Multiplan version 4.01. This problem was corrected in Multiplan version 4.20. Updated or new Microsoft software can be ordered in the US by contacting Microsoft End User Sales and Service at (800) 426-9400. If calling from outside the US, contact Microsoft International Customer Service at (206) 936-8661.

Copyright Microsoft Corporation 1991.