Calculates the net present value for a schedule of cash flows that is not necessarily periodic.
Ta funkcja działa w Arkuszach Google tak samo jak w Excelu — ta sama składnia i argumenty.
XNPV(rate, values, dates)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"})Wynik: 4.73
Calculates the NPV of a $1000 investment with returns of $500 and $600 over two years at a 10% discount rate.
NPV assumes cash flows occur at equal time intervals, while XNPV allows for irregular dates.