Bug in Excel 2010 using the Net Present Value formula - Microsoft Community

This is a known anomaly, one of many, in Excel's financial and statistical formulas. The NPV function in Excel does not calculate net present value as we all learned it, at least here in the U.S. It actually calculates PV of a varying cash flow stream. Th

answers.microsoft.com