The Excel NPV function is a financial function that calculates the net present value (NPV) of an investment using a discount rate and a series of future cash flows.
Calculate net present value
Net present value
=NPV (rate, value1, [value2], ...)
rate - Discount rate over one period.
value1 - First value(s) representing cash flows.
value2 - [optional] Second value(s) representing cash flows.
NPV calculates the net present value (NPV) of an investment using a discount rate and a series of future cash flows. The discount rate is the rate for one period, assumed to be annual. NPV in Excel is a bit tricky, because of how the function is implemented. Although NPV carries the idea of "net", as in present value of future cash flows less initial cost, NPV is really just present value of uneven cash flows.
Net present value is defined as the present value of the expected future cash flows less the initial cost of the investment...the NPV function in spreadsheets doesn't really calculate NPV. Instead, despite the word "net," the NPV function is really just a present value of uneven cash flow function.
One simple approach is to exclude the initial investment from the values argument and instead subtract the amount outside the NPV function.
To calculate Net Present Value (NPV) you can use the NPV function. In the example shown, the formula in F6 is:
How this formula works
Net Present Value (NPV) is the present value of expected...
The Excel PV function is a financial function that returns the present value of an investment. You can use the PV function to get the value in today's dollars of a series of future payments, assuming periodic, constant payments and a constant...
The Excel IRR function is a financial function that returns the internal rate of return (IRR) for a series of cash flows that occur at regular intervals.
Excel Formula Training
Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.