| HOSPITAL INPATIENT P & L | 2016 | 2017 | Variance | Variance % | Per DC 2016 | Per DC 2017 |
| Total Number of Beds | 149 | 149 |
| Maximum Occupancy | 55,745 | 54,561 |
| Total Patient Days | 37,250 | 37,926 |
| Actual Occupancy % |
| ALOS |
| Discharges by Payer |
| Medicare/Medicaid | 4,922 | 4,989 |
| Commercial Ins | 5,241 | 5,099 |
| Private Pay/Bad Debt | 1,280 | 1,162 |
| Total Discharges |
| REVENUE |
| Gross Patient Revenue | $ 161,325,872 | $ 135,365,715 |
| Contract Allowances, Uncollectables | $ (84,696,083) | $ (65,680,261) |
| Net Patient Revenue |
| Misc Income | $ 378,530 | $ 303,233 |
| NET REVENUE |
| Patient Care Expenses |
| Salaries | $ 18,387,223 | $ 18,244,610 |
| Benefits | $ 4,140,146 | $ 4,211,157 |
| Contract Labor | $ 1,724,507 | $ 1,820,377 |
| Physician Contract Services | $ 6,439,165 | $ 6,335,188 |
| Lab Services | $ 1,589,648 | $ 1,575,808 |
| Radiology Services | $ 2,336,043 | $ 2,343,920 |
| Rehabilitation Services | $ 655,766 | $ 679,444 |
| General Supplies | $ 653,941 | $ 689,766 |
| Medical Supplies | $ 1,006,220 | $ 1,029,151 |
| Cost of Food | $ 576,245 | $ 612,890 |
| Patient Transportation | $ 35,324 | $ 36,031 |
| Total Patient Care Expenses |
| General and Administrative Expenses |
| Salaries | $ 8,450,134 | $ 8,629,126 |
| Benefits | $ 2,001,199 | $ 1,993,174 |
| Contract Labor | $ 157,925 | $ 161,015 |
| Purchased Services | $ 1,285,925 | $ 1,355,602 |
| Medical Director | $ 162,909 | $ 167,207 |
| Telephone | $ 586,985 | $ 596,466 |
| Meals & Entertainment | $ 254,517 | $ 289,185 |
| Travel | $ 126,951 | $ 141,561 |
| General Supplies | $ 332,069 | $ 337,874 |
| Postage | $ 53,760 | $ 57,383 |
| Building Expense | $ 2,685,376 | $ 2,950,379 |
| Equipment Rents | $ 363,302 | $ 429,694 |
| Repairs and Maintenance | $ 337,711 | $ 366,311 |
| Insurance | $ 644,384 | $ 715,563 |
| Utilities | $ 504,959 | $ 556,226 |
| Total General and Administrative Expenses |
| Net Operating Expenses |
| NET PROFIT (LOSS) before Interest, Taxes and Depreciation (EBITDA) |
| NET PROFIT (LOSS) % | | | | | | | | | | | | 2017 |
| CASH FLOW 2016 | | | | | RELEVANT FINANCIAL RATIOS 2016 |
| What is your average Daily Revenue? | | | | | Return on Assets (ROA) | | | | | | | | | | Return on Assets (ROA) |
| Assume your AR Days are 55, what is your Total AR? | | | | | Return on Equity (ROE) | | | | | | | | | | Return on Equity (ROE) |
| What is your Average Daily Expense? | | | | | Current Ratio | | | | | | | | | | Current Ratio |
| Assume your AP Days are 35, what is your total AP? | | | | | Debt Ratio | | | | | | | | | | Debt Ratio |
| BALANCE SHEET 2016 |
| ASSETS |
| Cash and Equivalents | | | Assume 45 days of Expenses | | | | | | | | | | Assume 45 days of Expenses |
| Accounts Receivable | | $ - 0 | | | | | | | | | | $ - 0 |
| Inventory All Supplies | | | Assume 55 days of supplies | | | | | | | | | | Assume 55 days of supplies |
| Total Current Assets |
| Fixed Assets: | | xxxxxxxxxxxxxx | | | | | | | | | | xxxxxxxxxxxxxx |
| Bldg and Equipment | | $ 14,700,779 | | | | | | | | | | $14,700,779 |
| Total Assets |
| LIABILITIES AND EQUITY |
| Current Liabilities | | xxxxxxxxxxxxxx | | | | | | | | | | xxxxxxxxxxxxxx |
| Accounts Payable | | $ - 0 | | | | | | | | | | $0 |
| Long Term Debt | | xxxxxxxxxxxxxx | | | | | | | | | | xxxxxxxxxxxxxx |
| Bldg and Equipment | | $ 8,149,152 | | | | | | | | | | $8,149,152 |
| Total Liabilities |
| Equity |
| Total Liabilities and Equity |
| ITEMS | POINT VALUE |
| Occupany Calcs | 2 |
| Hospital Cols B & C | 3 |
| Variance (2014-2013) $ and % | 2 |
| PPD 2013 - 2014 | 2 |
| Cash flow 2014 | 2 |
| Balance Sheet Calculations | 5 |
| Relevant Financial Ratios | 4 |
| Sub-Total | 20 |
onomatopoeia
Project_2.xlsx
