Formulas > =XNPV()
How to Use XNPV() in Google Sheets
Description
How To Actually Use XNPV() in Sheets
XNPV(discount, cashflow_amounts, cashflow_dates)
Try XNPV yourself
Use the XNPV formula to calculate the net present value of cash flows in range B2:B6 with corresponding dates in range C2:C6, using a discount rate of 10%.
Hints (3)
-
Remember to include the discount rate as a decimal.
-
Ensure the cash flow amounts and dates are correctly paired.
-
Check that your ranges match the number of cash flows.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
Learn more about the XNPV() formula:
Generate a XNPV() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses XNPV(). 2 free AI generations, no signup. Members get unlimited use.
Generate a XNPV() formula