Cost Management: A Strategic Emphasis 7th Edition by Edward Blocher,David Stout ,Paul Juras,Gary Cokins

Exercise 57

Using Arrays in Excel; NPV Analysis Please refer to footnote 14 and the data referenced in the footnote.
Required
1. Follow the directions given in footnote 14 to calculate the NPV of the referenced investment project. ( Hint: If need be, consult the following: http://office.microsoft.com/en-us/starter-help/create-or-delete-a-formula-HP010342373.aspx CTT=3#_Toc251333379.)
2. Repeat the procedure using a discount rate (WACC) of 10% and the following cash flows, time 0 through time 10: ($1,000), $100, $200, $300, $400, $500, $600, $700, $800, $900, $1,000. ( Hints: The NPV should be $1,903.59; remember to use the Name Manager under the Formulas tab in Excel 2010.)