Answered step by step
Verified Expert Solution
Question
1 Approved Answer
https://online.pmi.edu/bbcswebdav/pid-9328739-dt-content-rid-187569645_1/xid-187569645_1 Q4 im having trouble with what to fill into the blue part AutoSave O Off ) HCA230_Project_Part_3_travers . Saved V Search (Alt+Q) ashley travers
https://online.pmi.edu/bbcswebdav/pid-9328739-dt-content-rid-187569645_1/xid-187569645_1
Q4 im having trouble with what to fill into the blue part
AutoSave O Off ) HCA230_Project_Part_3_travers . Saved V Search (Alt+Q) ashley travers AT O X File Home Insert Page Layout Formulas Data Review View Automate Help Comments Share is Get Add-ins ? de Line Slicer all Column BY Timeline PivotTable Recommended Table Illustrations Recommended Maps PivotChart 3D Link Comment Text Symbols PivotTables My Add-ins Charts Map Do Win/Loss Tables Add-ins Charts Tours Sparklines Filters Links Comments C3 X v fx D E F G H K M N 4 Financial Statements Analysis: What stands out; what should be investigated fu 5 Income Statements Pima Medical Center Tucson Regional 6 Common Size 2019 2020 2021 2021 7 Basis: Percent of Revenue Revenues 100.0% 100.0% 100.0% 100.0% 00 9 Salaries and Benefits 23,560 23,874 26,779 5,411 10 Supplies 8,481 8,369 9,481 1,963 11 Other Operating Expenses 9,481 9,307 9.961 2,857 12 Depreciation/Amortization 2,596 2,721 2,853 458 13 Interest Expense 1,824 1.584 1.566 1,031 14 Total Operating Expenses 45,942 45,855 50,640 11,720 15 Operating Income 5,394 5,678 8, 112 69 16 Income Taxes 1,099 1,043 2,112 14 17 Net Income 4,295 4.635 6.000 551 18 19 20 Balance Sheet 21 Common Size 2019 2020 2021 2021 22 Basis: Percent of Total Assets Assets Q3 Summary and Analysis Hospital Financial Statements Q4 Common Size Fin Statement + H + 80% Ready Ex Accessibility: Investigate 6:28 PM Type here to search O w Rain... ~ 11/19/2022AutoSave O Off ) HCA230_Project_Part_3_travers . Saved V Search (Alt+Q) ashley travers AT O X File Home Insert Page Layout Formulas Data Review View Automate Help Comments Share Line Slicer is Get Add-ins ? de all Column BY Timeline PivotTable Recommended Table Illustrations Recommended Maps PivotChart 3D Link Comment Text Symbols PivotTables My Add-ins Charts Map .' Win/Loss Tables Add-ins Charts Tours Sparklines Filters Links Comments C3 X v fx B D E F G H K L M N 20 Balance Sheets 21 Common Size 2019 2020 2021 2021 22 Basis: Percent of Total Assets Assets 23 Cash 1.4% 3.9% 2.9% 11.9% 24 Short-Term Investments 147 116 103 25 Accounts Receivables, Net 7,333 7,159 8,095 1,927 26 Inventories 1,849 2,025 1,986 335 27 Other Current Assets 1, 190 1,340 1,896 519 28 Total Current Assets 10,519 10,640 12,080 2,781 29 30 Net Property, Plant & Equipment 24,549 25,223 26, 176 5,322 31 Long-Term Note Receivable 37 31 44 59 32 Intangible Assets 8.269 8,578 9,540 4,219 33 Total Assets 100.0% 100.0% 100.0% 100.0% 34 35 Liabilities & Shareholders' Equity 36 Accounts Payable 2,357 2,581 2,842 383 37 Short Term Debt 145 209 237 980 38 Current Portion of Long Term Debt 4,905 5,535 6,111 533 Q3 Summary and Analysis Hospital Financial Statements Q4 Common Size Fin Statement (+ Ready Ex Accessibility: Investigate H + 80% 6:28 PM Type here to search O w Rain... ~ G 11/19/2022AutoSave O Off ) HCA230_Project_Part_3_travers . Saved V Search (Alt+Q) ashley travers AT O X File Home Insert Page Layout Formulas Data Review View Automate Help Comments Share Line Slicer is Get Add-ins ? de all Column BY Timeline PivotTable Recommended Table Illustrations Recommended Maps PivotChart 3D Link Comment Text Symbols My Add-ins Charts Map .' Win/Loss PivotTables Tables Add-ins Charts Tours Sparklines Filters Links Comments C3 X V B D E F G H K L M N 35 Liabilities & Shareholders' Equity 36 Accounts Payable 2,357 2,581 2,842 383 37 Short Term Debt 145 209 237 980 38 Current Portion of Long Term Debt 4,905 5,535 6, 111 533 39 Other Current Liabilities 2,303 2,267 2,461 150 40 Accrued Payroll 2,054 2,314 2,381 637 41 Total Current Liabilities 11,764 12,906 14,032 2,683 42 Long-Term Debt 23, 107 20,301 23,765 11,033 43 Total Liabilities 34,871 33,207 37,797 13, 716 44 45 46 Total Shareholders' Equity (34,870) (33,206) (37,796 (13,715) 47 48 Liabilities & Shareholders' Equity 100.0% 100.0% 100.0% 100.0% 49 50 51 52 53 54 Y ... Q3 Summary and Analysis Hospital Financial Statements Q4 Common Size Fin Statement + + 80% Ready Ex Accessibility: Investigate H 6:29 PM Type here to search O W Rain... ~ 11/19/2022Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started