Which оf the fоllоwing best describes the goаl of eаrly intervention physicаl therapy following concussion?
Mid-term.xlsx 1. The file аttаched here cоntаins selected infоrmatiоn from S&P 500 companies. (1) Create a pivot table from the original data that shows the top 20 GICS sub-Industries by sum of market value. The pivot table result should show only top 20 results. Sort the 20 results from highest to lowest if you are able to. (2) Create a new pivot table in a separate tab to report each industry's profitability using Net Profit Margin. Graph a pivot chart to visualize the results. (3) Create a new pivot table in a separate tab to examine relationship between beta and return. Add a calculated field “3-year average”, calculated as the average of 2016,2017,2018 returns. Report each company’s 3-year average along with its beta in the pivot table. Copy Paste both columns into an empty area and plot a scatter chart to show whether 3-year average can be determined by beta. Answer this question: does the scatter chart seem to suggest a linear relationship between beta and 3-year average stock return? You can just type the answer in a cell or insert a textbox. 2. Adventure Island is considering the purchase of a new log flume ride. The cost to purchase the equipment is $5,000,000, and it will cost an additional $380,000 to have it installed. The equipment has an expected life of 6 years and a salvage value of $450,000, and it will be depreciated using straight-line method. Management expects to run about 150 rides per day, with each ride averaging 25 riders. The season will last for 125 days per year. In the first year, the ticket price per rider is expected to be $5.25, and it will be increased by 4% per year. The variable cost per rider will be $1.50, and total fixed costs will be $425,000 per year. After six years, the ride will be dismantled at a cost of $215,000 and the parts will be sold for $450,000. The cost of capital is 8.5%, and its marginal tax rate is 32%. (1) Set up the input, calculate initial outlay, annual after-tax cash flow for each year, and the terminal cash flow. (2) Calculate NPV, IRR, MIRR, PI of the new equipment. Is the project acceptable? (3) Conduct a sensitivity diagram containing 3 variables of your choice. (4) Create a best-case scenario and a worst-case scenario. Change 3 variables of your choice, report NPV, IRR, MIRR and PI in the scenario summary. (5) If there's a 80% probability of base case, 10% probability of best case, and 10% probability of worst case, calculate expected NPV, Variance, Standard deviation, and the probability of a negative NPV. View rubric below This is the rubric that specifies the criteria for a successful submission. Criteria Points Pivot table for top 20 sub-industries by MV 3 Pivot table for Net Profit Margin by Industry 2 Pivot chart 1 Calculated field for 3Y average 2 Pivot table for beta and 3Y average 1 Scatter chart 1 Answer the question about scatter chart 1 Set up year-by-year CFs 5 Calculate NPV, IRR, MIRR, answer if it's acceptable 2 Create 3 data tables and 3 diagrams 4 Create scenario summary 3 Calculate expected NPV, Variance, Stand deviation, and the probability of a negative NPV 3 Overall formatting, organization, coherence 2 Total 30