Ratio Analysis Form
HCA/270 Version 3
Axia Material
Ratio Analysis Form
Use the table on the next page to complete the Week Eight assignment. In this assignment, you will review the textbook to find the definitions for
each ratio. Use the financial statements for Drs. Smith and Brown, located on the student website, to perform the calculations and complete the
form.
Review the following example on how to perform the inventory turnover calculation, which shows you how to complete the table.
Two different methods can determine the inventory turnover ratio.
o
o
Cost of goods soldoperating revenue of a hospitaldivided by ending inventory
Total revenues plus net nonoperating gains divided by ending inventory
This example uses the first method to perform the calculation.
Because a hospital provides a service, we would find the number that reflects services provided. Total operating revenue reflects money that is
earned for providing services. Locate the Statement of Net Income on the student website. Find the total operating revenue. This is $180,000.
Then, locate the ending inventory number. To find the ending Inventory, use the Balance Sheet on the student website. The ending inventory
number is 5000.
Cost of goods soldoperating revenue: 180,000 divided by ending inventory of 5000; 180,000/5000 = 36
Place this information in the table. You will do the same with the rest of the ratios. Take the result of your calculations and place in the
grid, as in the example.
In addition, you are responsible for stating whether the ratios are solvency, leverage, or profitability ratios. Enter your answers in the
appropriate column. Then, explain what these ratios tell us about the physician group practice.
Note. You will use the financial statements of Drs. Smith & Brown to perform the calculations on the next page. To calculate the debt service
coverage ratio, you need the maximum annual debt service, which is $22,200.
The following table shows the median financial ratios for acute care hospitals. You can use this table to gauge the financial viability of the
physician group practice.
1
Ratio Analysis Form
HCA/270 Version 3
2
Ratio Analysis Form
HCA/270 Version 3
Ratio
Numbers from Arcadia
financial statement
Result
Inventory turnover
(Example)
180,000/5000
36
Current ratio
Quick ratio
Debt service
coverage ratio
/22,200
Operating margin
Return on total
assets
References
Is it a
liquidity,
solvency, or
profitability
ratio?
N/A
3
Define the ratio and explain what the result shown in Column 3 means to the
organization. Do not forget to provide your references at the bottom of the form.
Inventory turnover is calculated to determine how quickly the inventory is used based on the
services rendered. If the inventory turnover is high, this means the hospital does not have
enough inventories on hand to accommodate the patient load. For this example, the
hospital is turning over their inventory 36 times per year, which is about 3 times a month.
The opposite is true if the inventory turnover calculation is lower than the median. This
could mean that there is a build-up of inventory due to lower than expected patient
revenues.