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: FA turnover=Total revenue (net operating + nonoperating)Net fixed assets (Net plant)\text{FA turnover} = \frac{\text{Total revenue (net operating + nonoperating)}}{\text{Net fixed assets (Net plant)}}

    • Riverside Memorial Hospital 2017 Calculation: $117,476$119,998=0.98 times\frac{\$117,476}{\$119,998} = 0.98 \text{ times}

  • Total Asset (TA) Turnover Ratio: Measures the efficiency of the utilization of all the business's assets in generating revenue.

    • Formula: TA turnover=Total revenue (net operating + nonoperating)Total assets\text{TA turnover} = \frac{\text{Total revenue (net operating + nonoperating)}}{\text{Total assets}}

    • 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: DIPAR=Net patient accounts rec.Net patient services rev./365\text{DIPAR} = \frac{\text{Net patient accounts rec.}}{\text{Net patient services rev.} / 365}

    • Riverside Memorial Hospital 2017 Calculation: $21,840$108,600/365=73.4 days\frac{\$21,840}{\$108,600 / 365} = 73.4 \text{ days}

Riverside Memorial Hospital Financial Statements

  • Income Statement for 2017 and 2016:

    • Net patient services revenue: $108,600\$108,600 (2017); $97,393\$97,393 (2016)

    • Other revenue: $3,644\$3,644 (2017); $6,014\$6,014 (2016)

    • Net operating revenue: $112,244\$112,244 (2017); $103,407\$103,407 (2016)

    • Nursing services: $61,613\$61,613 (2017); $60,221\$60,221 (2016)

    • Dietary services: $5,424\$5,424 (2017); $4,718\$4,718 (2016)

    • General services: $13,198\$13,198 (2017); $11,655\$11,655 (2016)

    • Administrative services: $11,427\$11,427 (2017); $11,585\$11,585 (2016)

    • Employee health and welfare: $10,250\$10,250 (2017); $10,705\$10,705 (2016)

    • Malpractice insurance: $1,320\$1,320 (2017); $1,204\$1,204 (2016)

    • Depreciation: $4,130\$4,130 (2017); $4,025\$4,025 (2016)

    • Interest expense: $1,542\$1,542 (2017); $1,521\$1,521 (2016)

    • Total expenses: $108,904\$108,904 (2017); $105,634\$105,634 (2016)

    • Operating income: $3,340\$3,340 (2017); ($2,227)(\$2,227) (2016)

    • Nonoperating income: $5,232\$5,232 (2017); $4,622\$4,622 (2016)

    • Net income: $8,572\$8,572 (2017); $2,395\$2,395 (2016)

  • Balance Sheet (Assets) for 2017 and 2016:

    • Cash and equivalents: $4,263\$4,263 (2017); $5,095\$5,095 (2016)

    • Short-term investments: $2,000\$2,000 (2017); $0\$0 (2016)

    • Accounts receivable: $21,840\$21,840 (2017); $20,738\$20,738 (2016)

    • Inventories: $3,177\$3,177 (2017); $2,982\$2,982 (2016)

    • Total current assets: $31,280\$31,280 (2017); $28,815\$28,815 (2016)

    • Gross plant and equipment: $145,158\$145,158 (2017); $140,865\$140,865 (2016)

    • Accumulated depreciation: $25,160\$25,160 (2017); $21,030\$21,030 (2016)

    • Net plant and equipment: $119,998\$119,998 (2017); $119,835\$119,835 (2016)

    • Total assets: $151,278\$151,278 (2017); $148,650\$148,650 (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:

    1. Total Margin: Represents expense control.

    2. Total Asset Turnover: Represents asset utilization.

    3. Equity Multiplier: Represents debt utilization.

  • The Du Pont Equation:

    • ROE=Total Margin×Total Asset Turnover×Equity Multiplier\text{ROE} = \text{Total Margin} \times \text{Total Asset Turnover} \times \text{Equity Multiplier}

    • ROE=Net IncomeTotal Revenues×Total RevenuesTotal Assets×Total AssetsTotal Equity\text{ROE} = \frac{\text{Net Income}}{\text{Total Revenues}} \times \frac{\text{Total Revenues}}{\text{Total Assets}} \times \frac{\text{Total Assets}}{\text{Total Equity}}

  • Riverside Du Pont Comparative Data:

    • 2016: 0.0222×0.73×1.50=2.43%0.0222 \times 0.73 \times 1.50 = 2.43\%

    • Ratio calculation: $2,395$108,029×$108,029$148,650×1.50=2.43%\frac{\$2,395}{\$108,029} \times \frac{\$108,029}{\$148,650} \times 1.50 = 2.43\%

    • 2017: 0.0730×0.78×1.41=7.98%0.0730 \times 0.78 \times 1.41 = 7.98\%

    • Ratio calculation: $8,572$117,476×$117,476$151,278×$151,278$107,364=7.98%\frac{\$8,572}{\$117,476} \times \frac{\$117,476}{\$151,278} \times \frac{\$151,278}{\$107,364} = 7.98\%

    • Industry: 5.00%×0.97×1.73=8.39%5.00\% \times 0.97 \times 1.73 = 8.39\%

  • 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:

    1. Profit indicators.

    2. Price indicators.

    3. Volume (utilization) indicators.

    4. Length-of-stay indicators.

    5. Intensity-of-service indicators.

    6. Efficiency indicators.

    7. Unit cost indicators.

  • Profit per Discharge (PPD) (Profit indicator):

    • Formula: PPD=Inpatient profitTotal discharges=$2,875,00018,281=$157\text{PPD} = \frac{\text{Inpatient profit}}{\text{Total discharges}} = \frac{\$2,875,000}{18,281} = \$157

    • Industry average: $73\$73

  • Net Price per Discharge (NPPD) (Price indicator):

    • Formula: NPPD=Net inpatient revenueTotal discharges=$87,740,00018,281=$4,800\text{NPPD} = \frac{\text{Net inpatient revenue}}{\text{Total discharges}} = \frac{\$87,740,000}{18,281} = \$4,800

    • Industry average: $5,056\$5,056

  • Occupancy Rate (OR) (Volume indicator):

    • Formula: OR=Inpatient daysNumber of licensed beds×365=95,061450×365=0.579=57.9%\text{OR} = \frac{\text{Inpatient days}}{\text{Number of licensed beds} \times 365} = \frac{95,061}{450 \times 365} = 0.579 = 57.9\%

    • Industry average: 45.4%

  • Average Length of Stay (LOS) (Length-of-stay indicator):

    • Formula: LOS=Inpatient daysTotal discharges=95,06118,281=5.2 days\text{LOS} = \frac{\text{Inpatient days}}{\text{Total discharges}} = \frac{95,061}{18,281} = 5.2 \text{ days}

    • 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: In FTEs/Bed=Inpatient FTEsAverage daily census=1,251260.55=4.8\text{In FTEs/Bed} = \frac{\text{Inpatient FTEs}}{\text{Average daily census}} = \frac{1,251}{260.55} = 4.8

    • Industry average: 5.6

  • Salary per FTE (Unit cost indicator):

    • Formula: Salary per FTE=Total salariesTotal FTEs=$83,038,6132,681=$30,973\text{Salary per FTE} = \frac{\text{Total salaries}}{\text{Total FTEs}} = \frac{\$83,038,613}{2,681} = \$30,973

    • Industry average: $32,987\$32,987

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.