Please solve in excel

0-15) Scale Differences The Pinkerton Publishing Company is considering two mutually exclusive expansion plans. Plan A calls for the expenditure of $50 million on a large-scale, integrated plant that will provide an expected cash flow stream of $8 million per year for 20 years. Plan B calls for the expenditure of $15 million to build a somewhat less efficient, more laborintensive plant that has an expected cash flow stream of $3.4 million per year for 20 years. The firm's cost of capital is 10%. a. Calculate each project's NPV and IRR. Answer t NPVA=$18,108,510;NPVB=$13,946,117;IRRA=15.03%;IRRB=22.26%; b. Set up a Project by showing the cash flows that will exist if the firm goes with the large plant rather than the smaller plant. What are the NPV and the IRR for this Project ? Answer 4 NPV=$4,162,393IRR=11.71%. c. Graph the NPV profiles for Plan A, Plan B, and Project