Financial management

profilewinniekay90
copy_of_copy_of_hospitalratiosfall20151.xls
Home>Business & Finance homework help>Financial management

Sheet1 - Table 1

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
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
Less: Assets whose use is limited and
that are required for current liabilities 761354 729654 691729 955409
Noncurrent assets whose use is limited
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
Other Assets
Investments 44458 47700 0 0
Deferred financing costs, net 90034 86862 92560 98257
Total Other Assets
Total Assets
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
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
Total Liabilities
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
Total Liabilities and Net Assets
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
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
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)
Change in Net Assets
Total Net Assets, Beginning 16006752
Total Net Assets, Ending

Sheet3 - Table 1

2014 2013 2012 2011
Salary and Benefits 14,000,000 13,000,000 12,000,000 11,500,000
Patient Days 17,500 18,000 15,500 15,000
Outpatient Revenue 20,000,000 17,000,000 16,000,000 14,000,000
FTE 325 305 275 285
Beds in Service 60 60 60 60
Gross Revenue 42,000,000 40,000,000 37,000,000 35,000,000
Discharges 4,100 4,300 3,800 3,500