MUST USE EXCEL, PLEASE LEAVE ALL FORMULAS ON HOW TO CALCULATE

12. You have three potential projects with an initial cost (Year 0) of $4000 that would begin next year. The annual revenues are as follows: Year Project A Project B Project C 1 100 500 900 2 200 500 800 3 300 500 700 4 400 500 600 5 500 500 500 6 600 500 400 7 700 500 300 8 800 500 200 9 900 500 100 (a) What is the NPV of each of the projects assuming an interest rate of 2.5% com- pounded annually? (b) Using Goal Seek in Excel's What If analysis, what is the internal rate of return with annual compounding for each of the projects? (c) If you could earn 2.5% annual rate of return at your local Bank, would you invest in any of the projects