Paper Instructions x (1) New Message! X A BibMe: Free American Psyc X https://www.chegg.com/pre d21/1e/content/2896455/viewContent/21917893/View e Introduction MIS Term Paper Instructions & Resources aper Instructions & Resources Notice everywhere the stock price crosses the 200 MA. For the next 2 questions assume you must wait 3 days after the trade to make a next trade. You will need to build an Excel worksheet with the stock data to answer the following questions. You are free to format the Excel worksheet as you like, but if new data is copied over the existing data, all your calculations should still work correctly. Conduct a strategy where you buy every time is crosses the 200 MA line in an upward direction and you sell every time is crosses the 200 MA line in a downward direction. You first must wait for an upward 12 movement to buy before selling. You are limited to a starting amount of $10,000 on day 1. Assume you buy at the daily high and sell at the daily low. What is your CAGR? Now do the opposite strategy. In this case, you sell every time is crosses the 200 MA in an upward direction and you buy every time it crosses in the downward direction. Again, you must first wait until for a downward movement to first buy. You are limited to a starting amount of $10,000 on day. What is your CAGR? Try the same with a 50-day moving average. This will result in more trades, but is either strategy more profitable? Paper Instructions x (1) New Message! X A BibMe: Free American Psyc X https://www.chegg.com/pre d21/1e/content/2896455/viewContent/21917893/View e Introduction MIS Term Paper Instructions & Resources aper Instructions & Resources Notice everywhere the stock price crosses the 200 MA. For the next 2 questions assume you must wait 3 days after the trade to make a next trade. You will need to build an Excel worksheet with the stock data to answer the following questions. You are free to format the Excel worksheet as you like, but if new data is copied over the existing data, all your calculations should still work correctly. Conduct a strategy where you buy every time is crosses the 200 MA line in an upward direction and you sell every time is crosses the 200 MA line in a downward direction. You first must wait for an upward 12 movement to buy before selling. You are limited to a starting amount of $10,000 on day 1. Assume you buy at the daily high and sell at the daily low. What is your CAGR? Now do the opposite strategy. In this case, you sell every time is crosses the 200 MA in an upward direction and you buy every time it crosses in the downward direction. Again, you must first wait until for a downward movement to first buy. You are limited to a starting amount of $10,000 on day. What is your CAGR? Try the same with a 50-day moving average. This will result in more trades, but is either strategy more profitable