81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199

Better Sheets
Create Free accountMember Login

XNPV()

Description

Calculates the net present value of an investment based on a specified series of potentially irregularly spaced cash flows and a discount rate.

How To Use in Sheets

XNPV(discount, cashflow_amounts, cashflow_dates)

External Links

XNPV function example in excel

Google Docs Help

0Better Sheets Tutorials

No videos featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.