Please help, show calcuations in excel, show work

Help please, Create an income statement from numbers given as well as answer the questions qiven below, make sure to use the formula function to show work

\begin{tabular}{|l|l|l|l|l} \hline 1.1 & 1.2 & 1.3 & 1.4 \\ \hline \end{tabular} CHAPTER 3: DNCOME STATE MENT and STATEMENT OF CHANGES EV EQUIThere are maltiple tabs in this spreadsheet - don't forget to view and answer all tabs Homewark Problem I.I Using the datu below, create an Inceane Statenent for High Plains Medical Center for the 2020 fiscal yeak. Use Exhibit 3.1 as a gaide, but, note that the categories may vary somewhat from this example. a. INCOME STATEMENT (in thousands) Based upon your Inceme Statement, answer the folloning questions: b. How much did the hospital carm it other opcrating revenue? c. What was the hospitars net gain from its opcrations? d. How much did the hospital cam in noh-operating income? e. What is the haspitars bottom line for the year? f. What \% of nel patient nevenue is spent on salanics & benefits? a. Whan \% of act operating revereue is from capitased revenue? h. Whan \% of the hooprial's botlom line was derived from its operabees? L. What was the approsimate cash flow for the year? \begin{tabular}{|l|l|l|l|} 1.1 & 1.2 & 1.3 & 1.4 \\ \hline \end{tabular} CHAPTER 3: INCOME. STATEMENT and STATEMENT OF CHANGES IN EQUIThhere are mattiple tabs in this spreadobeet-doa't forast to view asd answer all tabs Homework Problem 1.1 Lsing the data belon, create an Income Statement for High Plains Medical Center for the 2020 flacal year. Use Exbibit 3.1 as a guide, bet, note that the eategories may vary semewhat from this year. bse esample. \begin{tabular}{|l|r|} \hline Contributions & 224 \\ \hline Depreciation & 6,679 \\ \hline Insurance & 7,422 \\ \hline Imerst expense & 8,395 \\ \hline Imestment incoese & 2,644 \\ \hline Purchased serices & 6,827 \\ \hline Other operating rovenue & 3,695 \\ \hline Net patient services revenue & 171,742 \\ \hline Premium revenue & 14,779 \\ \hline Other operating expenses & 11,275 \\ \hline Salaries and bersfits & 118.468 \\ \hline Supplies \\ \hline \end{tabular} a. INCOME STATEMENT (in thouxands) Based upen your Inceme Statemest, ancwer the follening questiens: b. How much did the hospital cam in ehher eperating reverne?? e. What was the hospitals net zain from ite epsrations? d. How much did the hospital eam in soe-operating income? e. What is the bospitals bottom line for the year? f. What of of net patient revenue is spent on salaries A benefis? 2. What 4 of net eperating teverine is from capitated revenue? h. Whal W of the bogpealls bottom liec was derived from its operations? i. What was the approtimate cash flowe for the year? \begin{tabular}{|l|l|l|l|l} \hline 1.1 & 1.2 & 1.3 & 1.4 \\ \hline \end{tabular} CHAPTER 3: DNCOME STATE MENT and STATEMENT OF CHANGES EV EQUIThere are maltiple tabs in this spreadsheet - don't forget to view and answer all tabs Homewark Problem I.I Using the datu below, create an Inceane Statenent for High Plains Medical Center for the 2020 fiscal yeak. Use Exhibit 3.1 as a gaide, but, note that the categories may vary somewhat from this example. a. INCOME STATEMENT (in thousands) Based upon your Inceme Statement, answer the folloning questions: b. How much did the hospital carm it other opcrating revenue? c. What was the hospitars net gain from its opcrations? d. How much did the hospital cam in noh-operating income? e. What is the haspitars bottom line for the year? f. What \% of nel patient nevenue is spent on salanics & benefits? a. Whan \% of act operating revereue is from capitased revenue? h. Whan \% of the hooprial's botlom line was derived from its operabees? L. What was the approsimate cash flow for the year? \begin{tabular}{|l|l|l|l|} 1.1 & 1.2 & 1.3 & 1.4 \\ \hline \end{tabular} CHAPTER 3: INCOME. STATEMENT and STATEMENT OF CHANGES IN EQUIThhere are mattiple tabs in this spreadobeet-doa't forast to view asd answer all tabs Homework Problem 1.1 Lsing the data belon, create an Income Statement for High Plains Medical Center for the 2020 flacal year. Use Exbibit 3.1 as a guide, bet, note that the eategories may vary semewhat from this year. bse esample. \begin{tabular}{|l|r|} \hline Contributions & 224 \\ \hline Depreciation & 6,679 \\ \hline Insurance & 7,422 \\ \hline Imerst expense & 8,395 \\ \hline Imestment incoese & 2,644 \\ \hline Purchased serices & 6,827 \\ \hline Other operating rovenue & 3,695 \\ \hline Net patient services revenue & 171,742 \\ \hline Premium revenue & 14,779 \\ \hline Other operating expenses & 11,275 \\ \hline Salaries and bersfits & 118.468 \\ \hline Supplies \\ \hline \end{tabular} a. INCOME STATEMENT (in thouxands) Based upen your Inceme Statemest, ancwer the follening questiens: b. How much did the hospital cam in ehher eperating reverne?? e. What was the hospitals net zain from ite epsrations? d. How much did the hospital eam in soe-operating income? e. What is the bospitals bottom line for the year? f. What of of net patient revenue is spent on salaries A benefis? 2. What 4 of net eperating teverine is from capitated revenue? h. Whal W of the bogpealls bottom liec was derived from its operations? i. What was the approtimate cash flowe for the year