I. Intro
The XNPV function is used to calculate the net present value of a series of cash flows that may be irregularly distributed. For the net present value of periodic cash flows, use the NPV function.
II. About the function
- Formula: =XNPV(discount, cashflow_amounts, cashflow_dates)
- Parameters:
- discount (required): The discount rate over one period.
- cashflow_amounts (required): A cell range that contains the investment payments.
- cashflow_dates (required): A cell range with dates that correspond to the cash flows in cashflow_amounts.
- Example: =XNPV(8%,B2:B25,C2:C25)
III. Steps
Use the XNPV function
- Select a cell and enter =XNPV.
- Enter the parameters in the cell. For example: =XNPV(8%,A2:A6,B2:B6).
- Press Enter to display the result, which is -60969.52802 in this example.
250px|700px|reset
Delete the XNPV function
Select the cell with the XNPV function, and press Delete.