Excel
· 5 min read
Excel 365: Why Your NPV Is Wrong (and the XNPV Fix Analysts Swear By)
Excel's NPV function quietly assumes your first cash flow lands one full period in the future — so it discounts the whole project by an extra period and hands you a number that's off by thousands. Here's the classic fix, the XNPV/XIRR way for real dates, plus a free workbook.
Read article