Calculating NPVs with a Spreadsheet
Spreadsheets are an excellent way to compute NPVs, especially when you have to compute the cash flows as well.
Using the NPV function
The first component is the required return entered as a decimal
The second component is the range of cash flows beginning with year 1
Subtract the initial investment after computing the NPV