How do I add excel data?

Preston Plastics is about to wrap up its capital budgeting cycle, and department managers across the company have submitted 500 capital project requests for consideration in the next round of funding. Prestons CFO, Dan LaMontagne, is trying to decide which projects to recommend for funding to the capital projects executive committee. He has gathered all the information about each projects estimated life, initial investment, and cash flows in an Excel spreadsheet and is ready to make his decisions. Preston requires all capital projects to have a payback period of 5 years or less and uses a 12% discount rate.

What is the shortfall amount?

Suppose Preston chooses to fund capital projects based on net present value.

How many projects will be funded?

What is the total amount of capital funds that will be allocated? Hint: Sort the data from part (c) by net present value and calculate a running sum of project investment to help you determine which projects can be funded.