2024 – 17 4 Consider the following financial statements for BestCare HMO a not for profit managed care plan BestCare HMO Statement of Operations and

17.4 Consider the following financial statements for BestCare HMO, a not-for-profit managed care plan:

BestCare HMO Statement of Operations and Change in Net Assets

Year Ended June 30, 2011

(in thousands)

Revenue:

Premiums earned $26,682

Coinsurance $1,689

Interest and other income $242

Total revenue $28,613

Expenses:

Salaries and benefits $15,154

Medical supplies and drugs $7,507

Insurance $3,963

Provision for bad debts $19

Depreciation $367

Interest $385

Total expenses $27,395

Net income $1,218

Net assets, beginning of year $900

Net assets, end of year $2,118

BestCare HMO

Balance Sheet

Year Ended June 30, 2011

(in thousands)

Assets

Cash and cash equivalents $2,737

Net premiums receivable $821

Supplies $387

Total current assets $3,945

Net property and equipment $5,924

Total assets $9,869

Liabilities and Net Assets

Accounts payable – medical services $2,145

Accrued expenses $929

Notes payable $141

Current portion of long-term debt $241

Total current liabilities $3,456

Long-term debt $4,295

Total liabilities $7,751

Net assets – unrestricted (equity) $2,118

Total liabilities and net assets $9,869

a. Perform a Du Pont analysis on BestCare. Assume that the industry average ratios are as follows:

Total margin 3.8%

Total asset turnover 2.1

Equity multiplier 3.2

Return on equity (ROE) 25.5%

b. Calculate and interpret the following ratios for BestCare:

Industry average

Return on assets (ROA) 8.0%

Current ratio 1.3

Days cash on hand 41 days

Average collection period 7 days

Debt ratio 69%

Debt-to-equity ratio 2.2

Times interest earned (TIE) ratio 2.8

Fixed asset turnover ratio 5.2