Problem 2 - Net Present Value / Internal Rate of Return You invest at the present time $1,600, expecting the following returns for each of the following years: $100, $300, $400, $500 and $600 with an interest rate of 2.5%. Calculate in a separate EXCEL sheet the Present Values of the above monetary flows using the PV and the NPV function as well as the formula PV where i is the for every year. Find the IRR of this process and create an EXCEL graph to show it. Explain clearly your work in writing. FV (1+r)' 721 blem 1 - Time Value of Money. $250 You have the money flows that you see in the next graph. If the return rate is 2.534% annually, and the deposits /withdraws as indicated in the graph, how much money would be available to be withdrawn at the $190 $180 $100 $100 10 year? 10 8 9 Please present your work in EXCEL and utilize the excel formulae as well as the mathematical formulae providing detail information annually, with how much money is accumulated every year. Explain your work in a WORD document including the able of numerical calculations withing the WORD document. $ 150