Please put excel equations.

Better Health, Inc. is evaluating two investment projects, each of which requires an up-front expenditure of $2.8 million. The projects are expected to produce the following net cash inflows: Year 0 Year 0 1 2 3 Project A Project B ($2,800,000) ($2,800,000) $1,100,000 $1,600,000 $1,500,000 $1,500,000 $1,800,000 $900,000 10.0% Project A Project B ($2,800,000) ($2,800,000) $1,000,000 $1,000,000 $1,000,000 $1,000,000 $800,000 $500,000 1 2 3 NPV IRR a. What is each project's IRR? ($463,410.97) ($688,805.41) 0% -6% Project A Project B 24.15% 22.38% b. What is each project's NPV if the cost of capital is 10 percent? Project A Project B $792,036.06 $570,398.20 c. Which one would you buy