You can find the above financial statements from the worksheet $"$Q$3\_$ISBBS"

of the Homework $1$ file. Go to the worksheet named $"$Q$3\_$FS analysis" and

calculate the ratios given with all formulas linked directly to the income

statement and balance sheet. Assume that all sales are credit sales when you

calculate the accounts receivable turnover ratio. Also, evaluate Merrimack's

financial condition using the $2019$ industry averages in column D$.$ Look at the

EPI's analysis file from the Week $2$ folder if needed.

$[$Questions $4-5]$ Use monthly returns for the S&$.$P $500$ index, Amazon

$($AMZN$),$ Micrasoft $($MSFT$),$ and Tesla $($TSLA$)$ from $2015$ through $2020.$ You

can find the returns data from the worksheet $"$Q$4\_$StockReturns."

Create an XY $($Scatter$)$ plot to show the relationship between the

returns on each individual stock and the S$8$P $500.$ I have already

included the chart between S$8$P $500$ and AMZN in your

Q$4\_$StackReturns worksheet. Once you create the chart, right$-$click the

chart, go to Select Data and the data series, and click Edit. As you can

see from the chart between S$8$P $500$ and AMZN, you should have the

S&P $500$ column as $x$ and the AMZN return column as $Y.$ Add a linear

trend line to each chart and display the equation and $R^2$ on each chart.

Run the regression of each individual stock's returns $(y)$ on the S&P

$500$ index returns $(x).$ Present three regression results in one

worksheet named $"$Q$5\_$Regressions." Your regression results should be

the same as the equation and $R^2$ reported in Question $4.$