why is xnpv higher than npv?
The XNPV function in Excel uses specific dates that correspond to each cash flow being discounted in the series, whereas the regular NPV function automatically assumes all the time periods are equal. ... The NPV will be calculated for an investment by using a discount rate and series of future cash flows.