Instructions: Using the Case hospital balance sheet and statement of operations (2017 data only), complete the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Instructions: Using the Case hospital balance sheet and statement of operations (2017 data only), complete the calculations for the financial ratios below using excel formulas. Plug the appropriate numbers (from the financial tables) or formula for intermediary calculations into the yellow cells, then enter formula for calculation into the blue cells. Case Hospital Balance Sheet (in thousands) ASSETS Current Assets Cash Casn Temporary investments Accounts receivables (net) Inventory Prepaid expenses Total Current Assets Noncurrent assets Property, plant and equipment Accumulated depreciation Net property, plant and equipment Long-term investments other noncurrent assets Total noncurrent assets Total Assets LIABILITES Current liabilities Accounts payable Notes payable Accrued expenses payable Deferred revenues Estimated third-party adjustments Current portion of long-term debt Total current liabilities Total liabilities S $ INET ASSETS $ $ S S S S S S S S S S S S Noncurrent liabilities Long-term debt, less current portion $ $ S $ $ S 2017 124 S 280 45 S 30 3,536 S 3,717 175 S 140 32 S 40 3,912 S 4,207 6,980 S (1,730) S 5,250 $ 609 S 113 S 5.972 $ 1016 302 S 345 S 6,580 (1,660) 4,920 990 109 10,939 9,884 S 15,146 370 335 408 871 S 10 $ 15 137 S 224 184 S 178 1,849 S 1,530 3,500 3,600 S 5,449 $ 5,030 S Case Hospital Statement of Operations (in thousands) REVENUES Gross patient revenue Provision for contractual adjustments Provision for charity care Net patient services revenue Provision for bad debt allowance Net patient services revenue less bad debt Premium revenue Other operating revenue Total operating revenue EXPENSES Salaries, wages, and benefits Supplies, drugs, purchase services Depreciation and amortization Interest Total operating expenses OPERATING INCOME NONOPERATING INCOME Investment income EXCESS OF REVENUE OVER EXPENSES CHANGES IN NET ASSETS Unrestricted net assets Temporarily restricted net assets Permanently restricted net assets Total changes in net assets S S $ 13,031 $ S (4,209) $ $ (420) S 8,402 S (600) $ 7,802 S 400 S 440 S 8,642 S D S S S S $ S $ $ S $ $ $ 2017 $ S S $ 4,980 S 3,080 S 471 S 113 S 8,644 $ (2) S 95 $ 93 $ 1016 12,610. (4,083) (408) 8,119 (4,763) 7,643 447 8,090 5,278 2.956 443 109 8,786 (696) 85 (611) 3,285 S 3,896 700 700 S 400 S 600 4,385 $ 5,196 LIQUIDITY RATIOS Current Ratio = Total current assets/Total current liabilities > Measures ability to meet short-term obligations. Current Ratio = Days in accounts receivable = Net receivables/ (net patient services revenue /365) > A ratio of how quickly a hospital is converting is receivables into cash. Days in AR = PROFITABILITY 1 Operating margin = (Operating income / Total operating revenue) x 100 > Reflects profit from only operations. Operating margin= 1 Total margin = (Excess of revenues over expenses/Total operating revenue) x 100 > Reflects profits from both operations and nonoperations (typically investment income) Total margin= Return on assets (%) - (Excess of revenue overs expenses / Net assets) x 100 > Basic measure of profit in relationship to investment ROA (%) = ASSET EFFICIENCY Current asset turnover= (total operating revenue + other income) / Total current assets > Basic measure of how efficiently assets are used in relation to making revenue Cur asset turnover = / CAPITAL STRUCTURE Median Ratios 2.18 111.6 0.75 4.10 7.30 3.48 Debt service coverage = (Escess of revenues over expenses + Depreciation exp. + Interest exp.)/ (Debt principal pmnt + Interest pmnts) > Measures ability to meet long-term debt obligations. Debt serivce cov. = 2.680 Instructions: Using the Case hospital balance sheet and statement of operations (2017 data only), complete the calculations for the financial ratios below using excel formulas. Plug the appropriate numbers (from the financial tables) or formula for intermediary calculations into the yellow cells, then enter formula for calculation into the blue cells. Case Hospital Balance Sheet (in thousands) ASSETS Current Assets Cash Casn Temporary investments Accounts receivables (net) Inventory Prepaid expenses Total Current Assets Noncurrent assets Property, plant and equipment Accumulated depreciation Net property, plant and equipment Long-term investments other noncurrent assets Total noncurrent assets Total Assets LIABILITES Current liabilities Accounts payable Notes payable Accrued expenses payable Deferred revenues Estimated third-party adjustments Current portion of long-term debt Total current liabilities Total liabilities S $ INET ASSETS $ $ S S S S S S S S S S S S Noncurrent liabilities Long-term debt, less current portion $ $ S $ $ S 2017 124 S 280 45 S 30 3,536 S 3,717 175 S 140 32 S 40 3,912 S 4,207 6,980 S (1,730) S 5,250 $ 609 S 113 S 5.972 $ 1016 302 S 345 S 6,580 (1,660) 4,920 990 109 10,939 9,884 S 15,146 370 335 408 871 S 10 $ 15 137 S 224 184 S 178 1,849 S 1,530 3,500 3,600 S 5,449 $ 5,030 S Case Hospital Statement of Operations (in thousands) REVENUES Gross patient revenue Provision for contractual adjustments Provision for charity care Net patient services revenue Provision for bad debt allowance Net patient services revenue less bad debt Premium revenue Other operating revenue Total operating revenue EXPENSES Salaries, wages, and benefits Supplies, drugs, purchase services Depreciation and amortization Interest Total operating expenses OPERATING INCOME NONOPERATING INCOME Investment income EXCESS OF REVENUE OVER EXPENSES CHANGES IN NET ASSETS Unrestricted net assets Temporarily restricted net assets Permanently restricted net assets Total changes in net assets S S $ 13,031 $ S (4,209) $ $ (420) S 8,402 S (600) $ 7,802 S 400 S 440 S 8,642 S D S S S S $ S $ $ S $ $ $ 2017 $ S S $ 4,980 S 3,080 S 471 S 113 S 8,644 $ (2) S 95 $ 93 $ 1016 12,610. (4,083) (408) 8,119 (4,763) 7,643 447 8,090 5,278 2.956 443 109 8,786 (696) 85 (611) 3,285 S 3,896 700 700 S 400 S 600 4,385 $ 5,196 LIQUIDITY RATIOS Current Ratio = Total current assets/Total current liabilities > Measures ability to meet short-term obligations. Current Ratio = Days in accounts receivable = Net receivables/ (net patient services revenue /365) > A ratio of how quickly a hospital is converting is receivables into cash. Days in AR = PROFITABILITY 1 Operating margin = (Operating income / Total operating revenue) x 100 > Reflects profit from only operations. Operating margin= 1 Total margin = (Excess of revenues over expenses/Total operating revenue) x 100 > Reflects profits from both operations and nonoperations (typically investment income) Total margin= Return on assets (%) - (Excess of revenue overs expenses / Net assets) x 100 > Basic measure of profit in relationship to investment ROA (%) = ASSET EFFICIENCY Current asset turnover= (total operating revenue + other income) / Total current assets > Basic measure of how efficiently assets are used in relation to making revenue Cur asset turnover = / CAPITAL STRUCTURE Median Ratios 2.18 111.6 0.75 4.10 7.30 3.48 Debt service coverage = (Escess of revenues over expenses + Depreciation exp. + Interest exp.)/ (Debt principal pmnt + Interest pmnts) > Measures ability to meet long-term debt obligations. Debt serivce cov. = 2.680
Expert Answer:
Answer rating: 100% (QA)
To calculate the financial ratios using the information provided 1 Current Ratio Current Ratio Total ... View the full answer
Related Book For
Intermediate Accounting
ISBN: 978-1260481952
10th edition
Authors: J. David Spiceland, James Sepe, Mark Nelson, Wayne Thomas
Posted Date:
Students also viewed these corporate finance questions
-
For this component of the project, you are asked to complete an analysis of financial ratios for Lowe's, both through time and relative to financial ratios for Home Depot, using both tables and...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
Listed below are the balance sheet and statement of operations for Wynn Memorial 1. Compute Wynn Memorial Nursing Home's current ratio. 2. Compute Wynn Memorial Nursing Home's acid (or acid-test)...
-
The 32-kg spool of outer radius r, = 420 mm has a centroidal radius of gyration k = 265 mm and a central shaft of radius r; = 155 mm. The spool is at rest on the incline when a tension T= 243 N is...
-
In light of ?our answer to Problem 19.56, propose a mechanism for the formation of 3, 5 -dimethylisoxazole from hydroxylamine and 2, 4-pentanedione. CH 3,5-Dimethylisoxazole
-
What product would you expect to obtain from each of the following reactions? a. b. c. CH3CH2CHCH CH2CH2COH CH COCH CH HCI CH OH CH CH COH 1. SOC2 2. AICI3 3. H20
-
Research and prepare a report on the different approaches for accounting for carbon emissions under the EU ETS.
-
Brandon Corporation had the following stockholders equity accounts on January 1, 2012: Common Stock ($5 par) $500,000, Paid-in Capital in Excess of Par Common Stock $200,000, and Retained Earnings...
-
7. 8. The work done by a gas molecule in an isolated system is given by W=ae KT, where x is the displacement, k is the Boltzmann constant and T is the temperature. and are constants. Then the...
-
On the geologic map in Fig. G-1 (Appendix G) draw the correct strike and dip symbol in each circle to indicate the attitude of Formation B and each dike. To verify your attitude symbols, Fig. G-2 can...
-
The Best-Made Company builds one-of-a-kind furniture. It operates as a job shop and keeps track of each part and supply used to build each unique table, chair, chest, etc. To keep track of the parts...
-
Name and describe three typical strategies of how a business can improve the resilience of its operations.
-
Ventus Power Systems is a successful German producer of wind turbines and has gained a reputation as the market leader and technological pacesetter in the industry. Right from its start, Ventus...
-
What is net working capital (NWC) and what are its constitu-ent elements?
-
Your company has been doing business with one of your major suppliers for several years. The business relationship is good but has never gone beyond formal purchasing frame contracts. The suppliers...
-
Explain how collaborative efforts can improve the overall C2C cycle of a supply chain.
-
1.4 Classify items a) through g) shown on the pressure-volume diagram in Fig P1.23 as a property, a state, or a process. (7 pts.) a P2 d P b I V2 S Fig.P1.23C f U1 g e V
-
The power company must generate 100 kW in order to supply an industrial load with 94 kW through a transmission line with 0.09 resistance. If the load power factor is 0.83 lagging, find the...
-
The table below contains selected financial information included in the 2016 financial statements of Tyson Foods Inc. and Pilgrim?s Pride Corp. Required:1. Calculate the 2016 receivables turnover...
-
On January 1, 2021, Allied Industries leased a high-performance conveyer to Karrier Company for a four-year period ending December 31, 2024, at which time possession of the leased asset will revert...
-
Amalgamated General Corporation is a consulting firm that also offers financial services through its credit division. From time to time the company buys and sells securities. The following selected...
-
Which part of the brain controls posture, balance, and fine movements? (a) brainstem (b) cerebellum (c) cerebrum (d) thalamus
-
Multiple tissues combine to make a(n)____, a structure in the body that has a specific function.
-
Which part of the brain is responsible for reasoning, language, and the control of voluntary movement? (a) brainstem (b) cerebellum (c) cerebrum (d) thalamus
Study smarter with the SolutionInn App