Function Problems

How to Calculate Net Present Value for Eight Years in Excel

Steve KSteve K Nov 13, 2026 869 views

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.
Before you start

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.

Solution 1Recommended

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.

1
Select the result cell

Click the empty cell where you want the net present value to appear.

2
Enter the NPV formula

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.

3
Add the initial investment

If there is a time-zero investment, change the formula to =InitialInvestment+NPV(B1,B2:I2), for example =-10000+NPV(B1,B2:I2).

Use the Excel NPV Function for Eight Years of Cash Flows
Why add the initial investment separately?: Excel's NPV function treats each listed cash flow as occurring at the end of the period, so a time-zero investment must not be included in the NPV range.

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. 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. 2. Select the output cell: Click the empty cell where the NPV result should appear.
  3. 3. Enter the NPV function: Type =NPV(B1,B2:I2) and press Enter, or use Formulas > Financial > NPV to insert the function.
  4. 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).
NPV function works with the same syntax as Microsoft ExcelOpens and saves .xlsx workbooks without losing formulas or formattingFree and lightweight spreadsheet environment for financial calculationsFamiliar toolbar and formula bar make migration from Excel easy
QA img-9

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.