D$.$ The Excel file Hospital$\_$Assignment$1.$xlsx includes a hospital's balance sheet and statement of operations for two consecutive years. Please finish the following assignments $(40$ points$).$

Construct a worksheet for producing horizontal analysis for this hospital and explain the outliers.

Construct a worksheet for producing and comparing vertical analysis $($common$-$size$)$ for this hospital and see if the hospital experienced significant change over the two years.

Construct a comparative ratio analysis worksheet.

Calculate the following ratios for both years' data, using the "Move or Copy" function and the "Copy" and "Paste" function.

$\backslash$table$[[,$Industry Average$],[$Profitability ratios,$],[$Profit Margin,$5\mathrm{.}0\%$