excel ratio template
excel ratio template
Review the Week 8 Assignment 1 document provided to you by the Instructor. Examine the financial statements from
ORDER A PLAGIARISM FREE PAPER NOW
the community hospital. Reflect on how you will use this financial data to calculate and analyze the organization’s financial ratios. Refer to Chapter 4 of Financial Management of Health Care Organizations: An Introduction to Fundamental Tools, Concepts and Applications for additional guidance.
The Assignment:
Using the statement of operations and balance sheet for the community hospital, complete the “Week 8 Ratio Excel Template”.
Healthcare Financial Management and Economics Week 8 Assignment 1 — Springfield Community Hospital
Assignment 1: Ratio Analysis
It is important to understand that when interpreting financial statements, the numbers alone may not provide the whole financial picture of an organization. Instead, you must analyze the statements using ratios, which are then compared to benchmarks across the healthcare industry. For this Assignment, you examine the financial documents for Springfield Community Hospital and analyze the organization’s financial health.
Springfield Community Hospital
Springfield Community Hospital is a small community hospital serving a rural population. The adjusted discharges are 3.30 for the 1st year and 3.10 for the 2nd.
page1image1661192464page1image1661193216
Springfield Community Hospital
Statement of Operations (in thousands) for the Years Ended December 31, 2016 and 2017
page1image1661203600page1image1661203920page1image1661204864
2016
$21,000 1,000 22,000
Expenses
Salaries and benefits
Supplies and other expenses
Depreciation 2,300
2017
$17,000 800 17,800
8,000 5,000 1,900
100 15,000
2,800 2,200
5,000 $5,000
Revenues
Net patient service revenue
Net assets released from restriction
Total operating revenues
General services
Total operating expenses
Operating income Non-operating income
Excess of revenues over expenses Increase (decrease) in net assets
200 20,500
1,500 3,500
5,000 $5,000
12,000 6,000
page1image1661251392
© 2015 Laureate Education, Inc.
Page 1 of 3
page2image1599467504page2image1600084288page2image1600084480
Springfield Community Hospital
Balance Sheet (in thousands) for the Years Ended December 31, 2016 and 2017
Current assets Cash and cash
page2image1599802528page2image1599802720page2image1663123152page2image1599354784page2image1599719904page2image1599720096
equivalents
Net patient receivables
Inventory 900
Total current assets
Non-current assets Plant, property, and equipment
Gross plant, property, and equipment
(less accumulated depreciation)
Net plant, property, and equipment
Board-designated funds
Total assets
Current liabilities Accounts payable Accrued expenses
Total current liabilities
Long-term liabilities Bonds payable
Total long-term liabilities Net assets
Total liabilities and net assets
To prepare for this Assignment:
4,000 5,500
2016
$600
25,000 (18,000) 7,000
18,000 30,500
2,500 850 3,350
5,500 5,500
21,650 $30,500
2017
$400
3,500 800 4,700
23,000 (17,000) 6,000
9,000 20,250
2,000 900 2,900
7,500 7,500
9,850 $20,250
page2image1599704224
Examine the financial statements from Springfield Community Hospital. Reflect on howyou will use this financial data to calculate and analyze the organization’s financialratios. Refer to Chapter 4 of Financial Management of Health Care Organizations: An Introduction to Fundamental Tools, Concepts and Applications for additional guidance.
© 2015 Laureate Education, Inc. Page 2 of 3
The Assignment:
Using the statement of operations and balance sheet for Springfield Community Hospital below, complete the “Week 8 Assignment 1 Ratio Excel Template”.
