An investor is thinking about buying a small company for $$1,000,000$ that is expected to generate the cash flows shown in the Excel sheet for Question $2.$ The internal rate of return of an investment is the discount rate that makes the present value of the cash flows equal to the initial cost $($in this case that's just the purchase price$).$ Assuming cash flows are zero beyond year $10,$ use Solver and Excel$$s $=$npv$()$ function to determine the IRR associated with buying this company.

Hint: if you have never used the $=$npv$()$ function before, you can find out more about it by either starting to type it into a cell and looking at the tooltip, or by clicking the Insert Function button $($it looks like an italic fx$)$ just below the ribbon on the left. Do note that present value calculations are non$-$linear. Also note that it does not matter to me whether or not you include the purchase price in the $=$npv$()$ function or not, just that you know what your version should be equal to$.$

Note: there are other ways to get the answer but the point is to set this up as an optimization problem and find the solution with Solver.$\backslash$table$[[$Question $?],[$Data$,$Cash Flow per Year$],[1,2,3,4,5,6,7,8,9,10]]$