Get the Net Present Value (NPV) for a series of cash flows that may not be periodic. XNPV 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.

Roger is a city manager for a medium-sized, but steadily growing city. The city has limited resources, and like most municipalities, there are more needs than there are resources. He feels like the citizens in the community are fairly active in various community organizations, and believes that he may be…

What is XIRR Function? XIRR Function is a financial function that will calculate the The Internal Rate Of Return, for a series of cash flows that may not be periodic by assigning specific dates to each individual cash flow. In Financial Modelling, the XIRR Function is useful in determining the…