In excel

A company is evaluating the following capital projects for investment over the next two years: Two new machines with costs of $4 million each. Computer software upgrade with a cost of $1 million. Multi-year replacement of two aging machines involving an investment of $4.5 million for the first machine and another $4.5 million for the second machine if projected savings from the first machine are realized. All of these projects have positive net present values and the available budget is $10 million. The company should accept