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.
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 exerciseMore exercises in Finance
- Loan installment
- Is the project worth it?
- Growth over time
- Portfolio return
- Internal rate of return
- Value of an annuity
- Total interest on a loan
- Compound annual growth
- Break-even units
- Straight-line depreciation
- Monthly deposit for a goal
- Effective annual rate
- Months to clear a balance
- The rate behind a financing offer
- Interest and principal in one payment
- Average price paid