1. An investment has the following cash flows:

August 12, 2008 $ -1000

February 21, 2009 $ +100

October 7, 2010 $ +200

April 25, 2011 $ +900

May 18, 2012 $ +600

July 29, 2013 $ +300

November 12, 2014 $ +600

August 12, 2015 $ +900

June 30, 2016 $ -2800

1. Calculate the Net Present Value of this investment. Assume the annual discount rate is 14%.
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.