PLEASE DO NOT USE EXCEL

5. Consider the two one-shot investment alternatives shown in the table below. Neither alternative is expected to be available again in the future, but it is expected that investment options returning MARR will always be available. EOY 0 2 3 4 5 6 7 Alternative W $100,000 $20,000 $20,000 $50,000 $80,000 $110,000 Alternative X -$150,000 $40,000 $45,000 $50,000 $55,000 $60,000 $65,000 $70,000 Determine the following: a. What is the length of the planning horizon? b. What measure of worth is preferred? c. What measure of worth should be avoided? d. Which alternative is preferred if MARR is 8 percent