This is a cost accounting problem, please show all work.

Payback and NPV methods, no income taxes. (CMA, adapted) Andrews Construction is analyzing its capital expenditure proposals for the purchase of equipment in the coming year. The capital budget is limited to $5,000,000 for the year. Lori Bart, staff analyst at Andrews, is preparing an analysis of the three projects under consideration by Corey Andrews, the company's owner. Insert Page Layout Formulas Data Review View Home A D Project C Project A Project B 2 Projected cash outflow 3 Net initial investment $3,000,000 $1,500,000 $4,000,000 4 5 Projected cash inflows: 6 Year 1 7 Year 2 Year 3 9 Year 4 $ 400,000 900,000 800,000 $1,000,000 1,000,000 $2,000,000 2,000,000 200,000 100,000 1,000,000 1,000,000 10 11 Required rate of return 10% 10% 10% Required: 1. Because the company's cash is limited, Andrews thinks the payback method should be used to choose between the capital budgeting projects a. What are the benefits and limitations of using the payback method to choose between projects? b. Calculate the payback period for each of the three projects. Ignore income taxes. Using the payback method, which projects should Andrews choose? 2. Bart thinks that projects should be selected based on their NPVS. Assume all cash flows occur at the end of the year except for initial investment amounts. Calculate the NPV for each project Ignore income taxes 3. Which projects, if any, would you recommend funding? Briefly explain why