^{show work in excel please}

1. An investment has the following cash flows:

May 22, 2015 $ -1600

January 20, 2016 $ +1200

August 9, 2017 $ +800

February 10, 2018 $ +700

July 27, 2019 $ +900

December 15, 2020 $ +200

June 24, 2021 $ -2400

1. Calculate the Net Present Value of this investment. Assume the annual discount rate is 8%.
2. Create a data table and graph illustrating the impact of the discount rate on the Net Present Value of this investment. Include a title and label the axes for the graph.
3. Use Solver to determine the Internal Rate of Return(s) associated with this investment.