24. Horizontal, vertical, and ratio analyses. Exhibits 4.30a and 4.30b show the balance sheet and income statement for the 660-bed Williams Academic Medical Center for the years 20X0 and 20X1. Assume that principal payments each year come to $5,500,000 and that adjusted discharges are 120,000 for 20X0 and 125,000 for 20X1. a. Perform full horizontal and vertical analyses on the balance sheet. b. Perform full horizontal and vertical analyses on the income statement. C Calculate every ratio described in the chapter for both years, and compare these ratios with the benchmarks (Exhibit 4.16a). DISCUSS Williams's current financial position and future outlook based on these resun Make the basis for the vertical analysis the year 20X0. 206 CHAPTER 4 FINANCIAL STATEMENT ANALYSIS EXHIBIT 4.30a BALANCE SHEET FOR WILLIAMS ACADEMIC MEDICAL CENTER Williams Academic Medical Center Balance Sheet December 31, 20X0 and 20X1 (in thousands) 20X1 20X0 Current assets Cash and cash equivalents Patient accounts receivables, net Inventories Other current assets Total current assets $66,300 105,000 69,500 3,000 243,800 $63,500 125,000 62,000 2,400 252,900 Plant, property, and equipment Gross plant, property, and equipment (Less accumulated depreciation) Net property, plant, and equipment 1,040,000 (254,000) 786,000 976,000 (326,000) 650,000 195,000 175,000 Long-term investments $1,224,800 $1,077,900 Total assets Current liabilities Accounts payable Salaries payable Notes payable Other current liabilities Total current liabilities $87,200 23,000 3,200 2,100 115,500 $89,000 20,000 3,000 1,200 113,200 Noncurrent liabilities Bonds payable Total noncurrent liabilities 466,500 466,500 461,000 461,000 642,800 503,700 Owners' equity Total liabilities and equity $1,224,800 $1,077,900 EXHIBIT 4.30b INCOME STATEMEN 20 INCOME STATEMENT FOR WILLIAMS ACADEMIC MEDICAL CENTER Williams Academic Medical Center Income Statement for the Years Ended December 31, 20X0 and 20X1 (in thousands 20X1 20X0 Revenues Net patient revenues Other operating revenues Total operating revenues $935,300 47,000 982,300 $735,200 35,600 770,800 Expenses Salaries and benefits Supply expenses Depreciation Purchased services 305,000 102,500 55,000 85,000 314,500 28,700 890,700 325,000 105,000 32,800 84,000 172,000 12,500 731,300 Other expenses Interest Total operating expenses Income from operations Nonoperating income: 39,500 91,600 Investment incon 19,000 ment income and contributions 21,000 Total income before taxes Less income taxes) 112,600 58,500 (23,400) Net income (loss) (45,040) $35,100 $67,560 18 CHAPTER & FINANCIAL STATEMENT ANALYSIS Key Equations EXHIBIT 4.16 FORMULAS FOR KEY FINANCIAL RATIOS Net Receivables) / Current Liabilities Liquidity ratios Current ratio Quote Add test ratio D in accounts receivable Deys cash on hand Formula Current Assets / Current Liabilities (Cash+Marketable Securities + Net Receivables) / (Cash + Marketable Securities) / Current Liabilities Net Patient Accounts Receivables/ (Net Patient Revenues / enues/365) (Cash + Marketable Securities + Long-Term Investments) / [(Operating Expenses - Depreciation and Amort Expenses)/365) Current Liabilities/ [(Operating Expenses - Depreciation and Amortization Expenses)/365) ation and Amortization Average payment period, days Formula Revenue, expense, and profitability ratios Operating revenues per adjusted discharge Operating expense per adjusted discharge Salary and benefit expense as percentage of operating expense Operating margin Nonoperating revenue ratio Total Operating Revenues / Adjusted Discharges Total Operating Expenses/Adjusted Discharges Total Salary and Benefit Expense / Total Operating Expenses Operating Income / Total Operating Revenues Nonoperating Revenues and Other Income / Total Operating Revenues Excess of Revenues over Expenses/Total Assets Excess of Revenues over Expenses / Net Assets Return on total assets Return on net assets Formula Activity ratios Total asset turnover ratio Net fixed assets turnover ratio Age of plant ratio Total Operating Revenues / Total Assets Total Operating Revenues / Net Plant and Equipment Accumulated Depreciation / Depreciation Expense Capital structure ratios Formula Long-term debt to net assets ratio Net assets to total assets ratio Times interest earned ratio' Long-Term Debt/Net Assets Net Assets/Total Assets (Excess of Revenues over Expenses + Interest Expense) / Interest Expense (Excess of Revenues over Expenses + Interest Expense + Depreciation and Amortization Expenses) / (Interest Expense + Principal Payments) Debt service coverage ratio "Adjusted Discharges = (Total Gross Patient Revenue / Total Gross Inpatient Revenues) x Total Discharges. yn for-profit health care organizations, calculated as Net Income / Total Assets. Called return on equity in for-profit health care organizations, and calculated as Net Income / Owners' Equity "Called long-term debt to equity in for profit health care organizations, and calculated as LongTerm Debt/Owners "Called equity to total assets in for profit health care organizations, and calculated as Owners' Equity/Total Assets 'In for profit health care organizations, calculated as (Net Income Interest Expensel / Interest Expense. in for-profit health care organizations, calculated as (Net Income Interest Expense + Depreciation and Expenses) / Interest Expense + Principal Payments). preciation and Amortizati