The left is the information given. The right is the excel sheet I prepared.

I am not very good with accounting, but have been trying hard in my healthcare finance class. We were asked to read a case study and then given some numbers. The task here is to figure out which kind of financial statement to prepare and to create an excel sheet. Financial statements we've learned this week include: Balance Sheet, Statement of Operations (income), Statement of Changes in Net Assets, and Statement of Cash Flows.

Based on the numbers given, I felt like the Statement of Operations was the best option. Is this right? If so, did I enter the numbers right on excel? I have a quiz after based on this information. Class powerpoints and lectures didn't help a whole lot.

If I did it wrong, could somebody please help me by correcting it? Thank you so much.

D9 fic She has specifically asked that you separate the accounting/reporting for items 3 and 11 from operating activities to make better sense of hospital operating line-items 1.Patient Services Revenue (net of contractuals) = $231,058,000 2. Supplies and Equipment = $49,173,000 3. Transfer to parent corporation = $25,000 4.Depreciation and Amortization = $4,981,000 5.Other operating revenue = $1,217,000 B 1 Palo Alto Hospital 2 Year Ending July 31, 2020 3 Statement of Operations 4 5 Unrestricted revenues 6 Patient serviecs revenues $231,058,000 7 Provision for bad debts -8,200,000 8 Net Patient Service Revenue $222,858,000 9 10 Investment Income 1,200,000 11 Rental Income 795,000 12 Other Operating Revenue 1,217,000 13 Total Revenues 226,070,000 14 15 Operating Expenses: 16 Labor expense 95,142,000 17 Supplies & Equipment 49,173,000 18 Professional fees 57,419,000 19 Financing & Interest Costs 4,031,000 20 Depreciation expense 4,981,000 21 Total Operating Expenses 210,746,000 22 23 Excess of revenues over expenses 15,324,000 24 Transfer to parent corporation - 25,000 25 Increase in unrestricted net assets 15,299,000 6. Salaries and Benefits = $95,142,000 7. Provision for Bad Debts and Charity Care = $8,200,000 8. Rental income = $795,000 9.Financing and Interest Costs = $4,031,000 10. Professional Fees = $57,419,000 11. Investment Income, including Joint Ventures and Swap Change = $1,200,000 26