Question

Here is set of summary statistical reports and financial statements for a fictitious hospital. Using this...

Here is set of summary statistical reports and financial statements for a fictitious hospital. Using this information please calculate key ratios at the bottom.

Beach Memorial Hospital
Selected Financial and Statistical Information
Fiscal Year 2015

Statistical Information
Licensed beds 90
Staffed beds 70
Inpatient Admissions 4500
Inpatient Discharges 4600
Inpatient Days of Care 15500
Newborn Deliveries 500
Newborn Days of Care 1100
Emergency Room Visits 30000
Outpatient Surgery Visits 5000
Outpatient Diagnostic and Therapeutic Visits 50000
Case Mix Index 1.2
Medicare Case Mix Index 1.4

Balance Sheet
Cash & cash equivalents                             24000
Patient accounts receivable                        50000
Inventory                                                        7500
Prepaid expenses                                          1200
Total current assets                                    82700

Restricted assets                                         12000

Investments - Marketable securities          430000
Fixed assets, net                                         300500
Other assets 15000

Total assets                                                 840200

Current portion of long-term debt                    5000
Accounts payable                                          10000
Notes payable                                                 4000
Due to third parties                                         2500
Total current  liabilities                                   21500

Long-term debt, net of current portion         200000
Other long-term liabilities                               20000
Total liabilities                                             241500

Total net assets                                          598700
Total liabilites and net assets                      840200


Statement of Operations


Inpatient revenues                                 285000
Outpatient revenues                               175000
Gross patient services revenues            460000
Less deductions from revenue             -240000
Net patient services revenues               220000
Other Operating revenues                        50000
Total operating revenues                       270000

Operating expenses
Salaries                                                   225000
Supplies                                                    10500
Utilities & other                                          2500
Depreciation                                               5750
Interest                                                       3500
Bad debts                                                   4600
Other operating expenses                        10000
Total operating expenses                       261850

Operating income                                       8150

Nonoperating income                                    850

Excess of revenues over expenses            9000

Change in net assets                                   9000

From Statement of Cash Flows
Principal payment on long-term debt           5500

Calculate the following

Total asset turnover
Fixed asset turnover
Current asset turnover
Inventory turnover
Net asset financing
Long-term debt to capitalization
Debt service coverage
Cash flow to debt

Homework Answers

Answer #1

Total asset turnover

= Sales Revenue / Total Assets

= 270000 / 840200

= 0.32

Fixed asset turnover

= Sales Revenue / Fixed Assets

= 270000 / 300500

= 0.8985

Current asset turnover

= Sales Revenue / Current Assets

= 270000 / 82700

=3.26

Inventory turnover

= Sales Revenue / Inventory

= 270000 / 7500

= 36

Net asset financing

=Net Assets / Total Assets

=598700 / 840 200

= 0.71

Long-term debt to capitalization

= Long term debt / Total capital

= 220000 / 598700

= 0.36

Debt service coverage

= Net Operating Income / Total Debt Service

= 8150 / 9000 ..........=Interest 3500 + Principal 5500 = 9000

= 0.91

Cash flow to debt

= Cash Flow from Operations / Total Debt

= 9000 + 5750 (Depreciation ) / 241500

= 0.061

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
3. Using the income statement and balance sheet examples provided in the chapter, calculate the return...
3. Using the income statement and balance sheet examples provided in the chapter, calculate the return on capital in 2013. Table 3–1 Hospital Income Statement ABC Hospital Income Statement August 31, 2013 Inpatient revenue $1,500,300,000 Outpatient revenue $430,320,200 Total patient revenue $1,930,620,200 Deductions, discounts, and allowances ($1,000,000,000) Net patient revenues $930,620,200 Total operating expenses ($830,220,200) Operating income $100,400,000 Other income (donations, contributions, gifts) $5,200,500 Income from investments $15,000,500 Government appropriations $0 Auxiliary and nonpatient revenue $3,000,000 Total nonpatient revenue $23,201,000...
3. Using the income statement and balance sheet examples provided in the chapter, calculate the return...
3. Using the income statement and balance sheet examples provided in the chapter, calculate the return on capital in 2013. Table 3–1 Hospital Income Statement ABC Hospital Income Statement August 31, 2013 Inpatient revenue $1,500,300,000 Outpatient revenue $430,320,200 Total patient revenue $1,930,620,200 Deductions, discounts, and allowances ($1,000,000,000) Net patient revenues $930,620,200 Total operating expenses ($830,220,200) Operating income $100,400,000 Other income (donations, contributions, gifts) $5,200,500 Income from investments $15,000,500 Government appropriations $0 Auxiliary and nonpatient revenue $3,000,000 Total nonpatient revenue $23,201,000...
Refer to Southeastern Memorial Hospital’s financial statements below for calculating the ratios requested in problems 1-6....
Refer to Southeastern Memorial Hospital’s financial statements below for calculating the ratios requested in problems 1-6. Southeastern Memorial Hospital Statement of Operations For the Year Ended December 31, 2010 Revenues, Gains, Other Support Net patient service revenue $ 1,500,000 Other revenue 200,000 Total Revenue 1,700,000 Expenses Nursing Services 1,200,000 Administrative Services 200,000 Depreciation 100,000 Other Expenses 50,000 Total Expenses 1,550,000 Operating Income 150,000 Investment Income 50,000 Excess of revenues over expenses 200,000 Increase in Unrestricted Net Assets $ 200,000 Southeastern...
Using the condensed summary financial statements for Eli Lilly & Company (included on the following page),...
Using the condensed summary financial statements for Eli Lilly & Company (included on the following page), calculate the following ratios for Eli Lilly for 2019: Current Ratio Accounts Receivable Turnover Average Days in Inventory (also known as Average Days to Sell Inventory) Gross Profit Percentage Debt to Assets Ratio PROBLEM 3, continued Eli Lilly & Company Summary Condensed Balance Sheet $ in Millions Assets Dec. 31, 2019 Dec. 31, 2018 Liabilities and Equity Dec. 31, 2019 Dec. 31, 2018 Cash...
1. You standardize a company’s financial statements as follows. Following the example of Bega Cheese in...
1. You standardize a company’s financial statements as follows. Following the example of Bega Cheese in the textbook, please calculate the following items:             a. NOPAT             b. Net operating working capital c. Net long-term assets             d. Net debt BALANCE SHEET ASSETS INCOME STATEMENT Cash and Marketable Securities 11,511.00 Accounts Receivable 4,430.00 Sales 35,200.00 Inventory 2,650.00 Cost of Goods Sold 11,234.00 Other Current Assets 2,988.00 Gross Profit 23,966.00 Total Current Assets 21,579.00 SG&A 13,179.00 Other Operating Expenses 1,703.00 Long-Term...
Consider the following financia statements for Green Valley Nursing Home, Inc., a for-profit, long term care...
Consider the following financia statements for Green Valley Nursing Home, Inc., a for-profit, long term care facility: Green Valley Nursing Home, Inc., Statement of Income and Rretained Earnings, Year-ended December 31, 2015 Green Valley Nursing home, Inc., Balance sheet, December 31, 2015 Revenue: Assets Net patient service revenue $ 3,163,258.00 Current assets: other revenue $      106,146.00 cash $      105,737.00 total revenues $ 3,269,404.00 marketable securities $      200,000.00 Expenses: net patient accounts receivable $      215,600.00 salaries and benefits $ 1,515,438.00 supplies...
Ivanhoe Corporation recently filed the following financial statements with the SEC. Ivanhoe Corporation Income Statement for...
Ivanhoe Corporation recently filed the following financial statements with the SEC. Ivanhoe Corporation Income Statement for the Fiscal Year Ended July 31, 2017 Net sales $58,589 Cost of products sold 41,674 Gross profit $16,915 Selling, general, and administrative expenses 7,466 Depreciation 848 Operating income (loss) $8,601 Interest expense 519 Earnings (loss) before income taxes $8,082 Income taxes 2,829 Net earnings (loss) $5,253 Ivanhoe Corporation Balance Sheet as of July 31, 2017 Assets Liabilities and Stockholders’ Equity Cash and marketable securities...
Use the​ common-size financial statements found​ here: Common-Size Balance Sheet 2016 Cash and marketable securities $...
Use the​ common-size financial statements found​ here: Common-Size Balance Sheet 2016 Cash and marketable securities $ 460 1.4 % Accounts receivable 6,040 18.3 Inventory 9,480 28.8 Total current assets $ 15,980 48.5 % Net property, plant, and equipment 16,960 51.5 Total assets $ 32,940 100.0 % Accounts payable $ 7,220 21.9 % Short-term notes 6,790 20.6 Total current liabilities $ 14,010 42.5 % Long-term liabilities 7,020 21.3 Total liabilities $ 21,030 63.8 % Total common shareholders’ equity 11,910 36.2 Total...
The Balance Sheet and the Income Statement for ABC Manufacturing Corporation are as follows: DATA (All...
The Balance Sheet and the Income Statement for ABC Manufacturing Corporation are as follows: DATA (All amounts in SAR unless otherwise indicated, all sales are on credit and no hard keys.) Balance Sheet: ABC Corporation Balance Sheet Other current assets Total current assets Gross fixed assets Accumulated depreciation Net fixed assets Total assets LIABILITIES (DEBT) AND EQUITY Accounts payable Short-term notes payable Total current liabilities Long-term debt Total liabilities Common stock (par & paid in capital) Retained earnings Total common...
Solve in excel plz and show work Financial Statements ABC CORPORATION Balance Sheet Year Ended December...
Solve in excel plz and show work Financial Statements ABC CORPORATION Balance Sheet Year Ended December 31 (in $ millions) Assets 2006 2005 Liabilities & Stockowner’s Equity 2006 2005 Current Assets Current Liabilities Cash 22.2 19.5 Accounts Payable 29.2 24.5 Accounts Receivables 18.5 13.2 Notes Payable / Short-Term Debt 4.5 3.2 Inventories 14.2 14.3 Current Maturities of Long-Term Debt 13.3 12.3 Other Current Assets 2.0 1.0 Other Current Liabilities 3.0 4.0 Total Current Assets 56.9 48.0 Total Current Liabilities 50.0...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT