Need the Seasonal index and Seasonally adj. actual for 2021 solved. Use data from table to solve

Important: This is an individual assignmentI you are NOT allowed to receive or give assistance of any kind This assignment has FOUR spreadsheets [3 sheets with guestions and one sheet with data! (Do not share your file) Case 1 Assume there is a 40% chance of recession next year. Considering the following investment alternatives and their projected 1 90\"\" returns for 2023 under recession and no recession if you invest $100 today. Assume you have to invest your $100 in one investment alternative only. Use the Expected Value (Bayes) method to determine the optimal investment decision. Investment Alternative Recession No Recession Investment-Grade Bonds ' Texas Instrument Incorporated (Dividend Stock) ' Walmart (Consumer Staples) ' Vertex Pharmaceuticals Inc (Growth Stock) 1 point Conduct a sensitivity analysis using Excel's Data Table, with similar columns to the ones we developed in class: -First column: Prob of Recession with values ranging from 0 to 1 by .1 increments -Second column: Optimal Decision -Third column: Expected Value Place Sensitvity Table inside the yellow area below Important: This is an individual assignment! you are NOT allowed to receive or give assistance of any kind This assignment has FOUR spreadsheets (3 sheets with guestions and one sheet with data! (Do not share your file) Import data and Seasonal Indexes from sheet 2 Actual Actual Actual Actual Actual Actual Seasonal Index Forecast 2016 2017 2018 2019 2020 2021 2022 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Annual Using Year and annual carloads 2016-2021, obtain the POLYNOMIAL ORDER 3 (NOT ORDER 2) equation to estimate trend from the Excel's Scatter Diagram 1 point Paste Scatter Diagram ................................................................................................................................. > 1 point Using the equation from your scatter diagram, forecast annual carloads for year 2022 in orange ce|| below. > Enter Forecast Annual carloads for 2022 1 point Using the seasonal indexes obtained and your forecast for Year 2022, forecast monthly carloads for Year 2022 (enter values in appropriate orange cells above)