Calculates the net present value for a schedule of cash flows that is not necessarily periodic.
الصيغة
XNPV(rate, values, dates)المعاملات
rateمطلوب
The discount rate to apply to the cash flows.
valuesمطلوب
A series of cash flows corresponding to a schedule of payments in dates.
datesمطلوب
A schedule of payment dates that corresponds to the cash flow payments.
XNPV returns the net present value of an investment based on a specific discount rate and a series of payments occurring at irregular dates. Unlike the standard NPV function, it allows for cash flows that do not occur at equal time intervals.
=XNPV(0.1, {-1000, 500, 600}, {"2023-01-01", "2024-01-01", "2025-01-01"})→4.73Calculates the NPV of a $1000 investment with returns of $500 and $600 over two years at a 10% discount rate.
Prepare your data
List your cash flows in one column and their corresponding dates in an adjacent column.
Apply the function
Enter the XNPV function, selecting the rate, the range of values, and the range of dates.
NPV assumes cash flows occur at equal time intervals, while XNPV allows for irregular dates.