you should use the XNPV function, which includes three parameters: the discount rate, the series of cash flows and the range of dates when the cash flows are received in time. Using Excel can ...

However, where they differ from the more straightforward AVERAGE function is in their ability to include or discount certain ...