Question
Problem 1 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
Problem 1
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, 2XXX | ||||||||
(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 | |||||||
Rent | $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, 2XXX | ||||||||
(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 (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 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started