Question: show me the excel steps too 15 points Summary Balanee Sheet (in 000s) as of Dec 31, 2021 Cash and irvestments Other current assets Property
15 points Summary Balanee Sheet (in 000s) as of Dec 31, 2021 Cash and irvestments Other current assets Property and equipment, net Other assets Total Assets Current labilies Long-Tem Debe Other labulies Total Llabinties Net assets Unrestricted Pestricted Total Net Assets (Equity) Tetal liabilities and net assets Summary Statement of Revenue and Expenses (in 000s) for the year ended Dee 31, 2021 Operating Revenue Operating Expenses Salules and Employee Benefits Supples and other expenset Oepreciation, amentization and interest Total Operating Expenses Operating Income Nonsperating income Excess of Revenues over Expenses (Net income) ROE (NLTE) Tetal Margin (TM) (NivT) Tetal Asset Turnover (TR/TA) Equily Multiplier (TA/TE) MOA (TM TAT) Current Ratio (CA)CL) Debt Ratio (TUTA) 2021 Common Size Analysis $4,249,248 $1,166,721 $2,594,968 $1,680,692 $9,691,650 $1,340,412 $2.349,254 $846.217 $4,535,883 $5.073,856 $81,830 55,155,696 $9,691,569 2021 $6,656,531 $3,531,749 $2,417,078 $375,596 $5.124,423 56,324,423 5332,100 $398.691 $730,799 \begin{tabular}{|c|c|l|} Calculated Ratios: & industry standard & interoretation \\ \hline & 25.5% & \\ \hline 3.9% & \\ \hline 2.1 & \\ \hline 3.2 & \\ \hline & 0.0% & \\ \hline 1.3% & \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
