Using Arrays in Excel; NPV Analysis Please refer to footnote 12 and the data referen...

Using Arrays in Excel; NPV Analysis Please refer to footnote 12 and the data referenced in the footnote.

Required

1. Follow the directions given in footnote 12 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-ordelete- a-formula-HP010342373.aspx?CTT 5 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.)

Reference: