please answer question number 4C only with the format below. Thank you.

4. The sweepstakes Division is considering two expansion plans. Plan A would expand a current product line at a cost of $8,750,000. Expected annual net cash inflows are $1,525,000, with zero residual value at the end of 9 years. Under Plan B, the Sweepstakes Division would begin producing a new product at a cost of $8,250,000. Plan B is expected to generate net cash inflows of $1,050,000 per year for 10 years, the estimated useful life of that product line. Estimated residual value for Plan B is $950,000. The Sweepstakes Division uses straight-line depreciation and requires an annual internal rate of return (IRR) of 10%. a. Compute the payback, the ARR, the NPV, and the profitability index for both plans b. Compute the estimated IRR of Plan A. Will this meet what the Sweepstakes Division requir? & Lay out each year and use Excel formulas to verify/validate the NPV calculations you made in Requirement 4(a) and the actual IRR for the two plans. How does the IRR of each plan compare with the company's required internal rate of return? The Sweepstakes Division must rank the plans and make a recommendation to Pokemon's leadership team. Which expansion plan should the Sweepstakes Division recommend? Why? Page Layout Formulas Data Review View Help Search General File Home insert a & Cut Paste" Copy Format Painter der Arial BIU.B 12 - AA .A. E === E Wrap Text Merge & Center $ - % o Clipboard Font Alignment Number B82 ! X fx there will be no sales revenue, no variable expenses but fixed expenses will still incur. F G H I KL 4 184 185 186 Requirement 4b Annuity PV Factor (i = % Plan A = SAS 193 195 196 197 Requirement 4c 198 drew Plan B 199 200 Projects: Plan A Useful life (years) Annual Return rate Initial investment 201 202 CODE GRAY 211 212 213 215 216 NPV IRR 217 218 219 How does the IRR of each plan compare with the company's required rate of return? Comp Problem Part 3 Template