Google Sheets
NPV function in Google Sheets
Calculates the net present value of an investment based on a series of periodic cash flows and a discount rate.
=NPV(discount, cashflow1, [cashflow2, ...])NPV syntax and parameters
Three arguments, two required.
- discountnumberRequired
The discount rate of the investment over one period.
- cashflow1numberRequired
The first future cash flow.
- cashflow2numberRepeating
[ OPTIONAL ] - Additional future cash flows.
NPV examples
Formulas you'll actually reuse.
Net present value of five yearly inflows at an 8% hurdle, plus the upfront cost in B2 (NPV discounts every argument, so today's outlay is added outside):
=NPV(8%, C2:C6) + B2Result
9890.65Three future cash flows discounted at 10%:
=NPV(10%, 12000, 15000, 18000)Result
36829.45
NPV in Excel
Same name — your formula ports as-is.
Try NPV in the playground
Edit the example — nothing to install.
Preloaded with the NPV formula from Example 1 — change anything and watch it respond.
Loading the editor…
Related functions
More ways Google Sheets gets this done.
- ACCRINTCalculates the accrued interest of a security that has periodic payments.FinancialExcel
- ACCRINTMCalculates the accrued interest of a security that pays interest at maturity.FinancialExcel
- AMORLINCReturns the depreciation for an accounting period, or the prorated depreciation if the asset was purchased in the middle of a period.FinancialExcel
- COUPDAYBSCalculates the number of days from the first coupon, or interest payment, until settlement.FinancialExcel
- COUPDAYSCalculates the number of days in the coupon, or interest payment, period that contains the specified settlement date.FinancialExcel
- COUPDAYSNCCalculates the number of days from the settlement date until the next coupon, or interest payment.FinancialExcel