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 companys owner.

Because the companys cash is limited, Andrews thinks the payback method should be used to choose between the capital budgeting projects. What are the benefits and limitations of using the payback method to choose between projects?

Calculate the payback period for each of the three projects. Ignore income taxes. Using the payback method, which projects should Andrews choose?

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.

Which projects, if any, would you recommend funding? Briefly explain why.

Home Insert Page Layout Formulas Data Review View Project A Project B Project C 2 [Projected cash outflow 3 Net initial investment 4 5 Projected cash inflows: 6 Year1 7 Year 2 8 Year 3 9 Year 4 10 11 Required rate of return $3,000,000 $1,500,000$4,000,000 $1,000,000$ 400,000$2,000,000 900,0002,000,000 200,000 100,000 1,000,000 1,000,000 1,000,000 800,000 10% 10% 10%