Excel
NPV function in Excel
Returns the net present value of an investment based on a series of periodic cash flows and a discount rate
=NPV(rate, value1, [value2], ...)NPV syntax and parameters
Three arguments, two required.
- ratenumberRequired
- value1numberRequired
- value2numberRepeating
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 Google Sheets
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 Excel gets this done.
- ACCRINTReturns the accrued interest for a security that pays periodic interestFinancialGoogle Sheets
- ACCRINTMReturns the accrued interest for a security that pays interest at maturityFinancialGoogle Sheets
- AMORDEGRCReturns the depreciation for each accounting period by using a depreciation coefficientFinancialNo Google Sheets equivalent
- AMORLINCReturns the depreciation for each accounting periodFinancialGoogle Sheets
- COUPDAYBSReturns the number of days from the beginning of the coupon period to the settlement dateFinancialGoogle Sheets
- COUPDAYSReturns the number of days in the coupon period that contains the settlement dateFinancialGoogle Sheets