Question
Calculate the ratios on the attached list of benchmarks for 2017,2016, and 2015. Benchmark them and do trend analysis on them. Present your assignment in a format that you would use to present the information to the hospital board of trustees.
Use the following hospital specific ratios
Average Daily Census [ADC]
Occupancy Rate
- [(Total Inpatient Days/365)/Beds in Service] X 100
Gross Patient Revenue per Adjusted Discharge
- Gross Patient Revenue, Total/Adjusted Discharges
Average Length of Stay, Acute Care
- Total Inpatient Days, Acute Care/Total Discharges, Acute Care
Adjustment Factor
- Gross Patient Revenue/Gross Inpatient Acute Care Revenue
Adjusted Discharges
- Total Discharges, Acute Care *Adjustment Factor
Average age of plant
- Accumulated Depreciation/Current Depreciation Expense
Full-Time Equivalent Personnel per 100 Adjusted Average Daily Census
- Number of Full-Time Equivalent Personnel/Adjusted Average Daily Census
Salary and Benefit Expense per Full-Time Equivalent Personnel
- (Salary Expense, Total + Employee Benefits Expense)/Number of Full-Time Equivalent Personnel
2015 STATEMENT OF NET ASSETS 2017 2016 2014 ASSETS Current Assets Cash and Cash Equiv 293022 111789 1160648 1267561 Assets whose use is limited 955409 and that are required for current liabilities Accounts Receivable, less allowance for doubtful accounts Due from 3rd party payors 761354 691729 729654 4426785 4391774 4522710 4177138 46923 250792 133242 417638 Other Receivables 629322 286263 435245 609040 Inventories 792447 777774 725005 739290 Prepaid Expenses 234205 307994 207450 245523 Total Current Assets 8241357 8212469 7138280 6735620 Assets Whose Use Is Limited Employee Benefit Trust Fund By board for capital improvements: Cash and Cash Equiv 65807 2276457 220290 644756 3145866 1223076 Investments 1191062 4817008 7742061 Accrued Interest By oridnance for principal & interest Cash and Cash Equiy Property taxes receivable 7642 6702 1192 54859 729654 761354 745032 691729 955409 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 4124490 5673627 5121616 9313876 Property, Plant & Equipment PP&E, cost Plant assets under construction 36001133 39139827 36416996 35179848 70513 1029446 1433460 456159 Accumulated Depreciation 26553322 30538480 29972694 28713360 7877762 PP&E, net 9518324 9630793 6922647 Other Assets 44458 Investments 47700 0 0 Deferred financing costs, net 90034 86862 92560 98257 Total Other Assets 92560 134492 134562 98257 Total Assets 21912712 20625465 21885306 24547249 LIABILITIES & NET ASSETS Current Liabilities Bank Overdraft 76875 2168 7401 Current portion of Long-term Debt Revenue anticipation note Accounts receivable credit balances Accounts payable Property taxes paid under protest Due to third party payors Accrued salaries and related withholdings Interest payable Accrued vacation and holiday expenses Accrued pension 708000 600000 585000 565000 2000000 119736 686590 128680 127926 110408 637265 963177 607672 15442 21313 21313 15442 723670 400088 103438 943013 388475 72944 333920 263327 354742 28600 36400 43933 557996 486483 424026 389384 388852 406350 381813 374403 Total Current Liabilities 5955275 3019753 2633994 3492243 Other Liabilities Deferred revenue uncompensated care 2358507 1947772 1873769 2112079 Total Other Liabilities 1873769 2112079 2358507 1947772 Long-Term Liabilities Long-Term debt Refunding bond issue 2003 1545000 2145000 2730000 930000 407000 XXXXXXXXX 0 0 Total Long-Term Liabilities 1337000 1545000 2145000 2730000 Total Liabilities 9650782 6512525 6652763 8334322 Net Assets 15232543 16212927 Invested in Restricted capital net of related debt 9018324 9630793 Debt service 1506386 1379923 Capital projects Unrestricted 4376584 3474236 0 -2639364 -372012 C Total Net Assets 12261930 14112940 15232543 16212927 Total Liabilities and Net Assets 24547249 21912712 20625465 21885306 STATEMENTS OF ACTIVITIES 2016 2014 2017 2015 Operating Revenues Net patient services revenue Advalorem taxes Other operating revenue 27146515 23371293 26836327 22294065 766808 695006 684386 825061 1397853 591392 1135180 1365132 Total Operating Revenue 29311176 28122725 25190859 24484258 Operating Expenses Nursing services Other professional services General services 7077635 6984769 6502484 6331252 10526986 9891126 8877362 9661422 2693072 2738182 2732232 2575589 Fiscal services 1437360 1299851 1199711 1117162 Administrative services Depreciation and Amortization Provision for doubtful accounts 4125365 4082388 3836153 3211472 1336847 1176005 1265033 1258307 1055326 900974 3980553 2924176 Total Operating Expenses 31177818 29096497 26252361 24272118 Income (Loss) from Operations -973772 -1061502 -1866642 212140 Non-Operating Revenues (Expenses) Income of investments whose use is limited By board for capital improvements By ordinance for principal and interest Interest Income Interest expense Loss on sale of assets 125308 122496 154164 93370 18696 15187 12486 4763 4331 3335 19480 3324 -147852 -88867 -70200 -107422 C -212298 0 0 Total Non-Operating Revenues (Expenses) 15632 -140484 81118 -5965 Change in Net Assets -980384 -1851010 -1114256 206175 Total Net Assets, Beginning 16212927 16006752 14118287 15232543. Total Net Assets, Ending 12267277 14118287 15232543 16212927 Additional Information 2017 2016 2015 2014 10,000,000 Salary and Benefits Patient Days Outpatient Revenue 11.500,000 15,500 15,500,000 10.500.000 11,000,000 16,000 16,000,000 15,000 15,000,000 14,500 14,500,000 FTE 290 320 300 290 Beds in Service 60 60 60 60 40,500,000 Gross Revenue 39,000,000 4,500 36,000,000 3,500 35,000,000 3,400 Discharges 4,200 Benchmark Benchmarks Beds in Service 121 ALOS 4.31 Average Daily Census 61 Admissions Discharges Occupancy Percent 64% Payor Mix % Outpatient 42% Captial Structure Average Age of Plant 10.6 Net PP&E per Bed 215,402 164,555 Debt Per Bed LT Debt to Total Assets 29.00% Debt Service Coverage 4.6 Liquidity Current Ratio 1.9 Days in Net A/R 49.9 Average Payment Period 64.3 Revenues & Expenses 17.145 Gross Rev per Adj Discharge Operating Rev per Adj Discharge Expense per Adj Discharge Admin Cost per Adj Discharge 6,792 6,809 771 % Deductions from Gross Revenue 62% Operating Profit Margin Total Profit Margin 2.50% 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% Question Calculate the ratios on the attached list of benchmarks for 2017,2016, and 2015. Benchmark them and do trend analysis on them. Present your assignment in a format that you would use to present the information to the hospital board of trustees. 2015 STATEMENT OF NET ASSETS 2017 2016 2014 ASSETS Current Assets Cash and Cash Equiv 293022 111789 1160648 1267561 Assets whose use is limited 955409 and that are required for current liabilities Accounts Receivable, less allowance for doubtful accounts Due from 3rd party payors 761354 691729 729654 4426785 4391774 4522710 4177138 46923 250792 133242 417638 Other Receivables 629322 286263 435245 609040 Inventories 792447 777774 725005 739290 Prepaid Expenses 234205 307994 207450 245523 Total Current Assets 8241357 8212469 7138280 6735620 Assets Whose Use Is Limited Employee Benefit Trust Fund By board for capital improvements: Cash and Cash Equiv 65807 2276457 220290 644756 3145866 1223076 Investments 1191062 4817008 7742061 Accrued Interest By oridnance for principal & interest Cash and Cash Equiy Property taxes receivable 7642 6702 1192 54859 729654 761354 745032 691729 955409 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 4124490 5673627 5121616 9313876 Property, Plant & Equipment PP&E, cost Plant assets under construction 36001133 39139827 36416996 35179848 70513 1029446 1433460 456159 Accumulated Depreciation 26553322 30538480 29972694 28713360 7877762 PP&E, net 9518324 9630793 6922647 Other Assets 44458 Investments 47700 0 0 Deferred financing costs, net 90034 86862 92560 98257 Total Other Assets 92560 134492 134562 98257 Total Assets 21912712 20625465 21885306 24547249 LIABILITIES & NET ASSETS Current Liabilities Bank Overdraft 76875 2168 7401 Current portion of Long-term Debt Revenue anticipation note Accounts receivable credit balances Accounts payable Property taxes paid under protest Due to third party payors Accrued salaries and related withholdings Interest payable Accrued vacation and holiday expenses Accrued pension 708000 600000 585000 565000 2000000 119736 686590 128680 127926 110408 637265 963177 607672 15442 21313 21313 15442 723670 400088 103438 943013 388475 72944 333920 263327 354742 28600 36400 43933 557996 486483 424026 389384 388852 406350 381813 374403 Total Current Liabilities 5955275 3019753 2633994 3492243 Other Liabilities Deferred revenue uncompensated care 2358507 1947772 1873769 2112079 Total Other Liabilities 1873769 2112079 2358507 1947772 Long-Term Liabilities Long-Term debt Refunding bond issue 2003 1545000 2145000 2730000 930000 407000 XXXXXXXXX 0 0 Total Long-Term Liabilities 1337000 1545000 2145000 2730000 Total Liabilities 9650782 6512525 6652763 8334322 Net Assets 15232543 16212927 Invested in Restricted capital net of related debt 9018324 9630793 Debt service 1506386 1379923 Capital projects Unrestricted 4376584 3474236 0 -2639364 -372012 C Total Net Assets 12261930 14112940 15232543 16212927 Total Liabilities and Net Assets 24547249 21912712 20625465 21885306 STATEMENTS OF ACTIVITIES 2016 2014 2017 2015 Operating Revenues Net patient services revenue Advalorem taxes Other operating revenue 27146515 23371293 26836327 22294065 766808 695006 684386 825061 1397853 591392 1135180 1365132 Total Operating Revenue 29311176 28122725 25190859 24484258 Operating Expenses Nursing services Other professional services General services 7077635 6984769 6502484 6331252 10526986 9891126 8877362 9661422 2693072 2738182 2732232 2575589 Fiscal services 1437360 1299851 1199711 1117162 Administrative services Depreciation and Amortization Provision for doubtful accounts 4125365 4082388 3836153 3211472 1336847 1176005 1265033 1258307 1055326 900974 3980553 2924176 Total Operating Expenses 31177818 29096497 26252361 24272118 Income (Loss) from Operations -973772 -1061502 -1866642 212140 Non-Operating Revenues (Expenses) Income of investments whose use is limited By board for capital improvements By ordinance for principal and interest Interest Income Interest expense Loss on sale of assets 125308 122496 154164 93370 18696 15187 12486 4763 4331 3335 19480 3324 -147852 -88867 -70200 -107422 C -212298 0 0 Total Non-Operating Revenues (Expenses) 15632 -140484 81118 -5965 Change in Net Assets -980384 -1851010 -1114256 206175 Total Net Assets, Beginning 16212927 16006752 14118287 15232543. Total Net Assets, Ending 12267277 14118287 15232543 16212927 Additional Information 2017 2016 2015 2014 10,000,000 Salary and Benefits Patient Days Outpatient Revenue 11.500,000 15,500 15,500,000 10.500.000 11,000,000 16,000 16,000,000 15,000 15,000,000 14,500 14,500,000 FTE 290 320 300 290 Beds in Service 60 60 60 60 40,500,000 Gross Revenue 39,000,000 4,500 36,000,000 3,500 35,000,000 3,400 Discharges 4,200 Benchmark Benchmarks Beds in Service 121 ALOS 4.31 Average Daily Census 61 Admissions Discharges Occupancy Percent 64% Payor Mix % Outpatient 42% Captial Structure Average Age of Plant 10.6 Net PP&E per Bed 215,402 164,555 Debt Per Bed LT Debt to Total Assets 29.00% Debt Service Coverage 4.6 Liquidity Current Ratio 1.9 Days in Net A/R 49.9 Average Payment Period 64.3 Revenues & Expenses 17.145 Gross Rev per Adj Discharge Operating Rev per Adj Discharge Expense per Adj Discharge Admin Cost per Adj Discharge 6,792 6,809 771 % Deductions from Gross Revenue 62% Operating Profit Margin Total Profit Margin 2.50% 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% Question Calculate the ratios on the attached list of benchmarks for 2017,2016, and 2015. Benchmark them and do trend analysis on them. Present your assignment in a format that you would use to present the information to the hospital board of trustees
