You will analyze the cardiology department balance sheet and create an excel sheet, on the excel, you will utilize the f

[answerhappygod]

You will analyze the cardiology department balance sheet and
create an excel sheet, on the excel, you will utilize the first tab
which is labeled W2-Balance Sheet. On your own you will create a
separate word document and title it as follow, Westshore University
Hospital Cardiology Department - Balance sheet analysis. On
this world document you will provide response to the following
question. The question should be answered in an essay format,
in a minimum of 150 word using at least one reference from course
materials and scholarly source.
Attached is the balance sheet you will use to get the answer
from
1. Explain what assets inform us about hospital finances
2. State what information the balance sheet shares about the
hospital. Locate an area where the hospital could make a change to
their spending and suggests a remedy. Justify your
answer.
3. Review the balance sheet statement and analyze the
liabilities of the hospital. Locate an area where the hospital
could make a change to their spending and suggest a remedy. Justify
your answer.
4. According to the total liabilities and fund balance what
would be the hospital net worth? is this good or bad? Justify your
answer.

You Will Analyze The Cardiology Department Balance Sheet And Create An Excel Sheet On The Excel You Will Utilize The F 1 (116.08 KiB) Viewed 12 times

L A B C 13 Accounts payable and accurred expenses 14 Net cash flow from operating activities 15 16 Cash Flow from Noncapital Financing Activities 17 18 Cash Flows from Capital and Related 19 Financing Activities. 20 Acquisition of equipment 21 Proceed from loan for equipment 22 Interest paid on long-term obligation 23 Repayment of long-term obligations 24 Net cash flows from capital 25 26 Cash Flows form Investing Activities 27 Interest income received 28 Investments purchased (net) 29 Net cash flows from investing activities 30 31 Net Increase (Decrease) in Cash and Cash 32 Equivalents 33 Cash and Cash Equivalents, Beginning of Year 34 35 Cash and Cash Equivalents, End of Year 0 0 -20,000 48,000 4 5,000 -101,000 D -9,000 209,000 0 -68,000 -96,000 45,000 145,000 190,000 E -300,000 300,000 0 0 2,000 0 F 185,000 43,000 0 0 2,000 45,000 100,000 145,000
2 3 4 Operating Activities 5 Income from operations 6 Adjustment 7 Depreciation and amoritizations 8 Interest Expense 9 Changes in assets and liablity accounts 10 Patient accounts receivable Inventories 12 Prepaid expenses and other assets 13 Accounts payable and accurred expenses 14 Net cash flow from operating activities 15 16 Cash Flow from Noncapital Financing Activities 17 18 Cash Flows from Capital and Related Financing Activities 19 20 Acquisition of equipment 21 Proceed from loan for equipment 22 Interest paid on long-term obligation 23 Repayment of long-term obligations 24 Net cash flows from capital 25 26 Cash Flows form Investing Activities 4 20-Dec 115, 000 0 0 -20,000 -48,000 40,000 20,000 50,000 -5,000 -2,000 -9,000 209,000 0 -68,000 Analysis 19-Dec 50000.00 40,000 24,000 -250,000 -5,000 -1,000 185,000 43,000 0 -300,000 300,000 0 0 0 W5-2019 Revenue and Expense