Formuladrill

Level 5: Finance Exercise 92 of 118

NPV on irregular dates

An Excel formula exercise from Formuladrill. Solve it with a formula bar on a live sheet in your browser, and it is checked the moment you submit.

The task

The cash flows fall on irregular dates, so NPV, which assumes equal periods, does not fit. Calculate the net present value at the yearly rate in E1 with XNPV, in E2.

What this exercise teaches

XNPV discounts each cash flow by the actual number of days since the first date, divided by 365. Unlike NPV it does not discount the first value, so the initial outflow belongs inside the range.

A hint if you get stuck

XNPV(rate, cash flows, dates). The whole range of cash flows goes in, including the first outflow.

Functions used: XNPV

Try it now, free, no account needed

Your first 15 exercises on Formuladrill are free. Open it on the practice page, solve it, and get instant feedback with a hint. A free account adds the worked solution; Pro unlocks every exercise, timed mode and the certificate.

Open this exercise

More exercises in Finance