ratios

profilechelsea10
untitled_folder_2_2.zip
Home>Business & Finance homework help>ratios

untitled folder 2 2/.DS_Store

__MACOSX/untitled folder 2 2/._.DS_Store

untitled folder 2 2/Copy of Copy of Copy of HospitalratiosSu2017.xlsx

financialstatements

STATEMENT OF NET ASSETS 2016 2015 2014 2013
ASSETS
Current Assets
Cash and Cash Equiv 293022 111789 1160648 1267561
Assets whose use is limited
and that are required for current liabilities 761354 729654 691729 955409
Accounts Receivable, less allowance for doubtful accounts 4177138 4426785 4391774 4522710
Due from 3rd party payors 250792 46923 417638 133242
Other Receivables 629322 435245 609040 286263
Inventories 792447 777774 725005 739290
Prepaid Expenses 234205 207450 245523 307994
Total Current Assets 7138280 6735620 8241357 8212469
Assets Whose Use Is Limited
Employee Benefit Trust Fund 65807
By board for capital improvements:
Cash and Cash Equiv 3145866 2276457 220290 644756
Investments 1223076 1191062 4817008 7742061
Accrued Interest 7642 6702 1192 54859
By oridnance for principal & interest
Cash and Cash Equiv 761354 729654 691729 955409
Property taxes receivable 745032 650269 635137 806393
Total Assets whose use is limited 5882970 4854144 6365356 10269285
Less: Assets whose use is limited and
that are required for current liabilities 761354 729654 691729 955409
Noncurrent assets whose use is limited 5121616 4124490 5673627 9313876
Property, Plant & Equipment
PP&E, cost 36001133 39139827 36416996 35179848
Plant assets under construction 70513 1029446 1433460 456159
Accumulated Depreciation -26553322 -30538480 -29972694 -28713360
PP&E, net 9518324 9630793 7877762 6922647
Other Assets
Investments 44458 47700 0 0
Deferred financing costs, net 90034 86862 92560 98257
Total Other Assets 134492 134562 92560 98257
Total Assets 21912712 20625465 21885306 24547249
LIABILITIES & NET ASSETS
Current Liabilities
Bank Overdraft 2168 7401 76875
Current portion of Long-term Debt 708000 600000 585000 565000
Revenue anticipation note 2000000
Accounts receivable credit balances 128680 127926 110408 119736
Accounts payable 963177 607672 637265 686590
Property taxes paid under protest 21313 21313 15442 15442
Due to third party payors 723670 400088 103438 943013
Accrued salaries and related withholdings 388475 333920 263327 354742
Interest payable 72944 28600 36400 43933
Accrued vacation and holiday expenses 557996 486483 424026 389384
Accrued pension 388852 406350 381813 374403
Total Current Liabilities 5955275 3019753 2633994 3492243
Other Liabilities
Deferred revenue - uncompensated care 2358507 1947772 1873769 2112079
Total Other Liabilities 2358507 1947772 1873769 2112079
Long-Term Liabilities
Long-Term debt
Refunding bond issue 2003 930000 1545000 2145000 2730000
XXXXXXXXX 407000 0 0 0
Total Long-Term Liabilities 1337000 1545000 2145000 2730000
Total Liabilities 9650782 6512525 6652763 8334322
Net Assets 15232543 16212927
Invested in capital net of related debt 9018324 9630793 0
Restricted
Debt service 1506386 1379923 0
Capital projects 4376584 3474236 0
Unrestricted -2639364 -372012 0
Total Net Assets 12261930 14112940 15232543 16212927
Total Liabilities and Net Assets 21912712 20625465 21885306 24547249
STATEMENTS OF ACTIVITIES
2007 2006 2005 2004
Operating Revenues
Net patient services revenue 27146515 26836327 23371293 22294065
Advalorem taxes 766808 695006 684386 825061
Other operating revenue 1397853 591392 1135180 1365132
Total Operating Revenue 29311176 28122725 25190859 24484258
Operating Expenses
Nursing services 7077635 6984769 6502484 6331252
Other professional services 10526986 9891126 9661422 8877362
General services 2693072 2738182 2732232 2575589
Fiscal services 1437360 1299851 1199711 1117162
Administrative services 4125365 4082388 3836153 3211472
Depreciation and Amortization 1336847 1176005 1265033 1258307
Provision for doubtful accounts 3980553 2924176 1055326 900974
Total Operating Expenses 31177818 29096497 26252361 24272118
Income (Loss) from Operations -1866642 -973772 -1061502 212140
Non-Operating Revenues (Expenses)
Income of investments whose use is limited
By board for capital improvements 125308 122496 154164 93370
By ordinance for principal and interest 18696 15187 12486 4763
Interest Income 19480 4331 3335 3324
Interest expense -147852 -70200 -88867 -107422
Loss on sale of assets 0 -212298 0 0
Total Non-Operating Revenues (Expenses) 15632 -140484 81118 -5965
Change in Net Assets -1851010 -1114256 -980384 206175
Total Net Assets, Beginning 14118287 15232543 16212927 16006752
Total Net Assets, Ending 12267277 14118287 15232543 16212927

Additional Info

2016 2015 2014 2013
Salary and Benefits 13,000,000 12,000,000 11,500,000 11,000,000
Patient Days 17,000 17,500 15,000 14,000
Outpatient Revenue 17,000,000 15,500,000 15,000,000 14,000,000
FTE 300 295 270 280
Beds in Service 60 60 60 60
Gross Revenue 40,000,000 38,000,000 35,500,000 34,000,000
Discharges 4,500 4,500 4,000 3,500

__MACOSX/untitled folder 2 2/._Copy of Copy of Copy of HospitalratiosSu2017.xlsx

untitled folder 2 2/Copy of Copy of HospitalBenchmarks.xls(1) (1).xlsx

Benchmarks

2008 2003 Benchmarks
Beds in Service 60 60 121
ALOS 4.6 4.31
Average Daily Census 42 61
Admissions 2156 2131
Discharges 2162 2134
Occupancy Percent 70% 64%
Payor Mix
% Outpatient 42% 42%
Captial Structure
Average Age of Plant 10.6
Net PP&E per Bed $ 154,385 215,402
Debt Per Bed $111,498 164,555
LT Debt to Total Assets 4% 29.00%
Debt Service Coverage 4.6
Liquidity
Current Ratio 1.26 1.9
Days in Net A/R 55.71 49.9
Average Payment Period 64.3
Revenues & Expenses
Gross Rev per Adj Discharge ERROR:#REF! 17,145
Operating Rev per Adj Discharge ERROR:#REF! 6,792
Expense per Adj Discharge ERROR:#REF! 6,809
Admin Cost per Adj Discharge 771
% Deductions from Gross Revenue 53% 62%
Operating Profit Margin -4% 2.50%
Total Profit Margin -1% 1.93%
Productivity & Efficiency
FTES per Avg Daily Census 4.86
FTEs per 100 adjusted Discharge 5.74
Salary & Benefits per FTE 44,809
%Salary and Benefits Expense 43%
%Overhead Expense 30%
Total Assets Turnover Ratio 94%

__MACOSX/untitled folder 2 2/._Copy of Copy of HospitalBenchmarks.xls(1) (1).xlsx

untitled folder 2 2/HospitalSpecificRatios (1).pptx

Hospital Specific Ratios

Hospital Specific Ratios

Average Daily Census [ADC]

Total Inpatient Days/365

Hospital Specific Ratios

Occupancy Rate

[(Total Inpatient Days/365)/Beds in Service] X 100

Hospital Specific Ratios

Gross Patient Revenue per Adjusted Discharge

Gross Patient Revenue, Total/Adjusted Discharges

Hospital Specific Ratios

Average Length of Stay, Acute Care

Total Inpatient Days, Acute Care/Total Discharges, Acute Care

Hospital Specific Ratios

Adjustment Factor

Gross Patient Revenue/Gross Inpatient Acute Care Revenue

Hospital Specific Ratios

Adjusted Discharges

Total Discharges, Acute Care *Adjustment Factor

Hospital Specific Ratios

Average age of plant

Accumulated Depreciation/Current Depreciation Expense

Hospital Specific Ratios

Full-Time Equivalent Personnel per 100 Adjusted Average Daily Census

Number of Full-Time Equivalent Personnel/Adjusted Average Daily Census

Hospital Specific Ratios

Salary and Benefit Expense per Full-Time Equivalent Personnel

(Salary Expense, Total + Employee Benefits Expense)/Number of Full-Time Equivalent Personnel

__MACOSX/untitled folder 2 2/._HospitalSpecificRatios (1).pptx

__MACOSX/._untitled folder 2 2