can the problem be show in excel, as i learn better that way via spreadsheet

pute the payback, the AKR, the , the IRR, ai the protitability index of this investment. 2. Recommend whether the company should invest in this project. 26-31A Using payback, ARR, NPV, IRR, and profitability index to make Learning Objectives 2, 4 capital investment decisions Hill Company operates a chain of sandwich shops. The company is considering two possible expansion plans, Plan A would open eight smaller shops at a cost of $8,700,000. Expected annual net cash inflows are $1,550,000 for 10 years, with zero residual value at the end of 10 years. Under Plan B, Hill Company would open three larger shops at a cost of $8,340,000. This plan is expected to generate net cash inflows of $990,000 per year for 10 years, the estimated useful life of the properties. Estimated residual value for Plan B is $1,200,000. Hill Company uses straight-line depreciation and requires an annual return of 10%. 1. Plan A 1.09 profitability index, Plan B $(1,793,250) NPV Requirements 1. Compute the payback, the ARR, the NPV, and the profitability index of these two plans. 2. What arethe strenths and wlness of these capital budgeting method 3. Which expansion plan should Hill Company choose? Why? 4. Estimate Plan A's IRR. How does the IRR compare with the company's required rate of return