Question: Calculate the math in EXCEL and submit the excel file. 1. You are the head of the project selection team at SIMSOX. Your team is
Calculate the math in EXCEL and submit the excel file. 
1. You are the head of the project selection team at SIMSOX. Your team is considering three different projects. Based on past history, SIMSOX expects at least a rate of return of 20 percent. Your financial advisors predict inflation to remain at 3 percent into the foreseeable future. Given the following information for each project, which one should be SIMSOX first priority? Should SIMSOX fund any of the other projects? If so, what should be the order of priority based on return on investment? Year Cash Flows Project: Dust Project: Ospry Project: Voyagers Devils 0 500,000 250,000 75,000 1 50,000 75,000 15,000 2 250,000 75,000 25,000 3 350,000 75,000 50,000 4 50,000 50,000 5 150,000
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
