XNPV with time series

In the last exercise we ran into the limitation of NPV() not knowing exactly when our cash flows started, so it analyzed Year 0 as Year 1.

XNPV() is the most powerful net present value function in Excel, but it only works with time series data, which means it needs dates. The advantage is that it is much more precise at timing calculations, and the periods don't need to be the same!

If you have lost progress, close any open workbooks and load 4_1_net_present_value.xlsx from the Exercises folder.