To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=53845
------- Additional comments from [EMAIL PROTECTED] Sat Aug 27 12:47:44 -0700 2005 ------- Thanks for the report. Your interpretation of the NPV is absolutely correct. But, Calc implements the NPV function in the same way as Excel does. It means, that the first argument is rate and all other arguments are CF at the -> end <- of the first, second, third, ... period. Example: =NPV(10%;10;20;30) 10% -> rate 10 -> CF at the _end_ of the 1st year -> beginning of the _2nd_ year 20 -> CF at the _end_ of the 2nd year -> beginning of the _3rd_ year 30 -> CF at the _end_ of the 3rd year -> beginning of the _4th_ year That's the reason why the NPV is calculated in this way: =10 / 1,1 + 20 / 1,1^2 + 30 / 1,1^3 The best thing to do is to: - add comment in the function wizard (like Excel does) - add comment in to the help --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
