Acme Corp is considering three different projects. Each of the projects will take a bit of the limited resources for the firm and as such they must decide which is the most beneficial for the company. For this analysis their first step is to determine what the project is worth, how much benefits the project has in relation to the money put into it, when the project would pay itself back, and the internal rate of return for each of the projects. The project1 has outflows (in years) of 500,0,2000,1000,0 , Project 2: 3500,0,0,0,0, Project 3: 250, 0, 0, 0, 4000. Project inflows (in years) [1] 0,500,1000,2000,3000 [2] 500,500,500,2000,3000 and [3] 0,0,0,0,10000. The company's cost of capital is 12.5%, which project should the company choose based solely on financials? what other considerations might the company want to keep in mind when choosing between the projects? (assume all cash flows are accounted for at the end of the time period)
Use Microsoft Excel to solve and upload file if possible.