In: Accounting
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 |
|||||||