Module 3: Part 1 - Section B Financial Condition Analysis
Overview of Asset Management Ratios
Asset management ratios are used to measure how effectively a firm's assets are being utilized to generate revenue. These ratios highlight whether the business has sufficient or excessive assets for its level of operation.
Fixed Asset (FA) Turnover Ratio: Measures the efficiency of the use of net fixed assets (net plant and equipment) to generate total revenue.
Formula:
Riverside Memorial Hospital 2017 Calculation:
Total Asset (TA) Turnover Ratio: Measures the efficiency of the utilization of all the business's assets in generating revenue.
Formula:
Riverside Memorial Hospital 2017 Calculation: \frac{\117,476}{\text{\151,278}} = 0.78 \text{ times}
Days in Patient Accounts Receivable (DIPAR): Measures the average number of days it takes for a hospital to collect its receivables from patients and insurers.
Formula:
Riverside Memorial Hospital 2017 Calculation:
Riverside Memorial Hospital Financial Statements
Income Statement for 2017 and 2016:
Net patient services revenue: (2017); (2016)
Other revenue: (2017); (2016)
Net operating revenue: (2017); (2016)
Nursing services: (2017); (2016)
Dietary services: (2017); (2016)
General services: (2017); (2016)
Administrative services: (2017); (2016)
Employee health and welfare: (2017); (2016)
Malpractice insurance: (2017); (2016)
Depreciation: (2017); (2016)
Interest expense: (2017); (2016)
Total expenses: (2017); (2016)
Operating income: (2017); (2016)
Nonoperating income: (2017); (2016)
Net income: (2017); (2016)
Balance Sheet (Assets) for 2017 and 2016:
Cash and equivalents: (2017); (2016)
Short-term investments: (2017); (2016)
Accounts receivable: (2017); (2016)
Inventories: (2017); (2016)
Total current assets: (2017); (2016)
Gross plant and equipment: (2017); (2016)
Accumulated depreciation: (2017); (2016)
Net plant and equipment: (2017); (2016)
Total assets: (2017); (2016)
Asset Management Ratio Analysis and Interpretation
Comparative Asset Management Data (Riverside vs. Industry):
FATO:
2017: 0.98
2016: 0.90
Industry Average (Ind.): 2.2
TATO:
2017: 0.78
2016: 0.73
Industry Average (Ind.): 0.97
DIPAR:
2017: 73.4
2016: 77.7
Industry Average (Ind.): 64.0
Du Pont Analysis
Du Pont analysis summarizes and highlights a business's financial condition by decomposing Return on Equity (ROE) into three specific ratios:
Total Margin: Represents expense control.
Total Asset Turnover: Represents asset utilization.
Equity Multiplier: Represents debt utilization.
The Du Pont Equation:
Riverside Du Pont Comparative Data:
2016:
Ratio calculation:
2017:
Ratio calculation:
Industry:
Note: The Du Pont equation can be recast to focus specifically on operating margin rather than total margin.
Operating Indicator Analysis
Operating indicator analysis utilizes data outside of financial statements to explain the business's financial performance. Understanding underlying operating conditions allows managers to address financial problem areas more effectively.
Categories of Operating Indicators:
Profit indicators.
Price indicators.
Volume (utilization) indicators.
Length-of-stay indicators.
Intensity-of-service indicators.
Efficiency indicators.
Unit cost indicators.
Profit per Discharge (PPD) (Profit indicator):
Formula:
Industry average:
Net Price per Discharge (NPPD) (Price indicator):
Formula:
Industry average:
Occupancy Rate (OR) (Volume indicator):
Formula:
Industry average: 45.4%
Average Length of Stay (LOS) (Length-of-stay indicator):
Formula:
Industry average: 4.7 days
All Patient Case-Mix Index (CMI) (Intensity-of-service indicator):
Measures the severity of illness of patients treated at the hospital.
Riverside 2017: 1.12
Industry average: 1.15
Inpatient FTEs per Occupied Bed (Efficiency indicator):
Formula:
Industry average: 5.6
Salary per FTE (Unit cost indicator):
Formula:
Industry average:
Limitations of Financial Condition Analysis
Dividing performance analysis is difficult when a business operates in many different divisions.
"Average" performance may not be synonymous with "good" performance.
Seasonal factors can distort specific ratios depending on the time of year.
Inflation effects can distort the historical data presented on financial statements.
Different operating and accounting practices among businesses can skew comparisons.
It is often difficult to provide a singular judgment on whether a business is in a strong or weak position overall.
Advanced Analytical Tools for Financial Position:
Multiple discriminant analysis.
Altman Z-Score.
Financial flexibility index (Reference: Cleverley, "Predicting Financial Flexibility: A Key to Hospital Survival," Healthcare Financial Management, 1985).
Benchmarking
Benchmarking is the process of comparing performance data against selected standards. This can include national averages, industry medians, or specific competitors.
Total Margin Comparison for Riverside (2017 vs. 2016):
National/GFB: 9.8% (2017); 9.6% (2016)
Industry top quartile: 8.4% (2017); 8.0% (2016)
St. Anthony's (Competitor): 8.0% (2017); 7.9% (2016)
Riverside: 7.3% (2017); 2.2% (2016)
Industry median: 5.0% (2017); 4.7% (2016)
Pennant Healthcare: 4.8% (2017); 5.0% (2016)
Industry lower quartile: 1.8% (2017); 2.1% (2016)
Woodbridge Memorial: 0.5% (2017); (1.3%) (2016)
Key Performance Indicators (KPIs) and Dashboards
Ratio analysis results are frequently presented in a dashboard format.
Dashboards: Designed to focus on Key Performance Indicators (KPIs) while keeping data clutter to a minimum.
Example Dashboard Components (Based on Datapine.com example):
Return on Assets.
Return on Equity.
Working Capital Ratio.
Debt-Equity Ratio.
Balance Sheet Overview (Total Assets, Liabilities, Shareholder Equity).
Questions & Discussion
Discussion Item: What are some areas of financial and operating performance that should be routinely monitored? If creating a dashboard for Riverside, what specific areas would be covered by KPIs?
Conclusion: This concludes Module 3 - Part 1 (Financial Condition Analysis). Next step: Quiz for Module 3 - Part 1.