Show calculations/formulas in excel, please Help please

Help please, show work through excel formula function

\begin{tabular}{l|l|l|l|} \hline 1.1 & 1.2 & 1.3 & 1.4 \\ \hline \end{tabular} CHAPTER 3: INCOME STATEMENT and STATEMENT OF CHANGES IN EQUITEhere are multiple tabs in this spreadsheet - don't forget to view and answer all tabs Homework Problem 1.1 Using the data below, create an Income Statement for High Plains Medical Center for the 2020 fiscal year. Use Exhibit 3.1 as a guide, but, note that the categories may vary somewhat from this example. \begin{tabular}{|l|r|} \hline Contributions & 224 \\ \hline Depreciation & 6,679 \\ \hline Insurance & 7,422 \\ \hline Interest expense & 8,395 \\ \hline Investment income & 2,644 \\ \hline Purchased services & 6,827 \\ \hline Other operating revenue & 3,695 \\ \hline Net patient services revenue & 171,742 \\ \hline Premium revenue & 14,779 \\ \hline Other operating expenses & 11,275 \\ \hline Salaries and benefits & 118,468 \\ \hline Supplies & 23,682 \\ \hline \end{tabular} a. INCOME STATEMENT (in thousands) Based upon your Income Statement, answer the following questions: Don't forget to show your work using Excel functions/formulas b. How much did the hospital earn in other operating revenue? c. What was the hospital's net gain from its operations? d. How much did the hospital earn in non-operating income? c. What is the hospital's bottom line for the year? f. What % of net patient revenue is spent on salaries & benefits? g. What % of net operating revenue is from capitated revenue? h. What % of the hospital's bottom line was derived from its operations? i. What was the approximate cash flow for the year? \begin{tabular}{|l|l|l|l|} \hline 1.1 & 1.2 & 1.3 & 1.4 \\ \hline \end{tabular} CHAPTER 3: INCOME STATEMENT and STATEMENT OF CHANGES IN EQUTThere are multiple tabs in this spreadsheet - don't forget to view and answer all tabs Hencwork Problem 1.1 Using the data below, ereate an Income Statement for High Flains Medical Center for the 2e2e fiscal year. Use Exhibit 3.1 as a guide, bot, note that the categeries may vary samewhat from this example. \begin{tabular}{|l|r|} \hline Contributions & 224 \\ \hline Depreciatioe & 6,679 \\ \hline Insurance & 7,422 \\ \hline Interest expense & 8,395 \\ \hline Investment income & 2,644 \\ \hline Purstased services & 6,827 \\ \hline Other operating revenue & 3,695 \\ \hline Net patient services revenue & 171,742 \\ \hline Premium revenue & 14,779 \\ \hline Other operating expenses & 11,275 \\ \hline Salariss and benefits & 118,468 \\ \hline Sapplics & 23,682 \\ \hline \end{tabular} a. INCOME STATEMENT (in theusands) Based upon your Income Statement, answer the following questions: b. How much did the hospital eam in ocher operating revesae? c. What was the hospital's net gain from its operations? d. How much did the hospital earm in non-operating income? e. What is the hospital's bottom line foe the year? t. What \% of net paticnt revenue is spent on sslarics \& benefits? g. What % of net operating revenue is from capitated rovenuc? b. What % of the hospital's botiom line was derived from its operations? i. What was the approximate cash thow for the year? Using the data below, create an Income Statement for High Plains year. Use Exhibit 3.1 as a guide, but, note that the categories may var example. Based upon your Income Statement, answer the following questions: b. How much did the hospital earn in other operating revenue? c. What was the hospital's net gain from its operations? d. How much did the hospital earn in non-operating income? e. What is the hospital's bottom line for the year? f. What % of net patient revenue is spent on salaries & benefits? g. What \% of net operating revenue is from capitated revenue? h. What % of the hospital's bottom line was derived from its operations? i. What was the approximate cash flow for the year