Syntax
=NPV(rate, value1, ...)Arguments
| Argument | Required | Description |
|---|---|---|
rate | Required | The discount rate per period |
value1 | Required | The cash flows, in order |
How to use NPV
NPV takes 2 required arguments, and accepts more values in the same pattern. Type =NPV( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=NPV(0.1, -10000, 3000, 4200, 6800)Result =NPV(0.08, 8000, 9200, 10000, 12000, 14500) - 40000Result Related financial functions
- MDURATIONReturns the modified duration in years of a security that pays periodic interest, for 100 face value.
- MIRRReturns the modified internal rate of return, with separate rates for financing and reinvestment.
- NOMINALReturns the nominal annual interest rate from an effective rate and the compounding periods per year.
- NPERReturns the number of payment periods needed for a loan or investment.
- ODDFPRICEReturns the price per 100 face value of a security with an odd (short or long) first period.
- ODDFYIELDReturns the yield of a security with an odd (short or long) first period.
- ODDLPRICEReturns the price per 100 face value of a security with an odd (short or long) last period.
- ODDLYIELDReturns the yield of a security with an odd (short or long) last period.
- PDURATIONReturns the number of periods an investment needs to grow to a target value at a constant rate.