XNPV practice

XNPV returns the net present value of cash flows on specific dates. Below are the 1 financial modeling exercise on Modeldrill that use it, each checked instantly in your browser.

Syntax

XNPV(discount_rate, cash_flows, dates)

What people get wrong

Unlike NPV, the first cash flow is on its own date, so the initial investment goes inside the function.

financial modeling exercise that use XNPV

• Dated cash flows with XNPV and XIRRLevel 4Pro

Often used together with: SUM, XIRR