How to Calculate Net Present Value for Eight Years in Excel
Question details
The user needs an Excel formula that calculates the net present value of cash flows over eight years using a specified discount rate.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A user is evaluating an eight-year project or investment and needs to discount yearly cash flows to present value.
- Observed behavior
- The goal state is a working NPV formula that returns the present value of the eight cash flows and accounts for an initial investment outside the NPV function.
Arrange the discount rate in one cell and the year-one through year-eight cash flows in eight adjacent cells. Keep the time-zero initial investment in a separate cell so it can be added to the NPV result as a negative value.
Use the Excel NPV Function for Eight Years of Cash Flows
Use this method when the discount rate is in one cell, the eight yearly cash flows are in a continuous range, and an initial investment must be added separately.
Excel's NPV function assumes the listed cash flows occur at the end of each period. Therefore, a time-zero initial investment should not be included inside the NPV range; add it separately as a negative value.
Click the empty cell where you want the net present value to appear.
Type =NPV(B1,B2:I2) and press Enter, where B1 is the discount rate and B2:I2 are the year-one through year-eight cash flows.
If there is a time-zero investment, change the formula to =InitialInvestment+NPV(B1,B2:I2), for example =-10000+NPV(B1,B2:I2).

Calculate NPV for Eight Years in WPS Office Spreadsheet
WPS Office Spreadsheet supports the same NPV function and Excel-compatible formulas, so you can open the workbook, enter =NPV(rate,value1:value8), and add the initial investment outside the function without changing file formats.
- 1. Open the workbook in WPS Office Spreadsheet: Launch WPS Office and open the .xlsx file that contains the discount rate and eight cash flows.
- 2. Select the output cell: Click the empty cell where the NPV result should appear.
- 3. Enter the NPV function: Type =NPV(B1,B2:I2) and press Enter, or use Formulas > Financial > NPV to insert the function.
- 4. Add the initial investment: Adjust the formula to =InitialInvestment+NPV(B1,B2:I2) if there is a time-zero investment, such as =-10000+NPV(B1,B2:I2).

Frequently Asked Questions
Does the Excel NPV function include the initial investment at time zero?
No. Excel NPV treats the listed cash flows as occurring at the end of each period, so add the initial investment separately, normally as a negative value, outside the NPV function.
What discount rate should I use in the NPV formula?
Use the period discount rate that matches the cash-flow frequency. For annual cash flows, use the annual discount rate, such as a percentage in cell B1.
Can I use this NPV formula in WPS Office Spreadsheet?
Yes. WPS Office Spreadsheet supports the same NPV function and Excel-compatible formulas, so you can enter =NPV(B1,B2:I2) in the same way.
Why are the cash flows entered as a continuous range B2:I2?
A continuous range is not required, but it makes the formula shorter and less error-prone. You can also list individual values separated by commas.
What does a negative NPV result indicate?
A negative NPV means the projected cash flows earn less than the discount rate, so the investment may not meet the required return.




