Using Arrays in Excel; NPV Analysis Please refer to footnote 15 and the data referenced in the footnote. Required 1. Follow the directions given in footnote 15 to calculate the NPV of the referenced...

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

Required 1. Follow the directions given in footnote 15 to calculate the NPV of the referenced investment project. (Hint: If need be, consult the following: https://support.office.com/en-us/Search/results?query= array+formulas&src=as.) 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 (Ctrl+F3) under the Formulas tab in Excel.)