Financial management

profilewinniekay90
copy_of_copy_of_hospitalratiossummer2016_1.xlsx
Home>Business & Finance homework help>Financial management

Sheet1

STATEMENT OF NET ASSETS 2014 2013 2012 2011
ASSETS
Current Assets
Cash and Cash Equiv 300000 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 7145258 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 21919690 20625465 21885306 24547249
LIABILITIES & NET ASSETS
Current Liabilities
Bank Overdraft 9146 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 5962253 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 9657760 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 21919690 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

&"Helvetica,Regular"&12&K000000&P

Sheet3

2014 2013 2012 2011
Salary and Benefits 13,500,000 13,000,000 12,000,000 11,000,000
Patient Days 16,500 16,000 12,500 11,500
Outpatient Revenue 18,500,000 17,000,000 14,000,000 15,000,000
FTE 215 195 175 200
Beds in Service 60 60 60 60
Gross Revenue 40,000,000 38,000,000 36,000,000 35,000,000
Discharges 4,100 4,000 3,800 3,400

&"Helvetica,Regular"&12&K000000&P