Better Health, Inc. is evaluating two investment projects, eachof which requires an up-front expenditure of $2.5 million. Theprojects are expected to produce the following net cash inflows:Year Project A Project B 1 750,000 2,000,000 2 1,250,000 1,250,0003 2,000,000 750,000 a. What is each project's IRR? Project A =IRR(C11: b. What is each project's NPV if the cost of capital is10%?
Attention Chegg Tutor: There is a similar answer onlinein Chegg, but the excel formula doesn't make sense. So please donot copy and paste the answer to answer this question. I am reallytrying to understand how the answer came about. please show allwork.