Memorial Hospital of Converse County Financial and Statistical Packet Table of Contents - December 2014 Admissions and Avg. IP Daily Census Graphs Page # 1 Average Floor Census Breakdown Graph 2 Average Monthly Inpatient Admissions by Physician Graph 3 Average Length of Stay by Physician Graph 4 Payor Mix Comparisons and Emergency Room Visits Graphs 5 Total Surgeries and Orthopedic Surgeries Graphs 6 General and OB/GYN Surgery Graphs 7 Procedure Core Visits Graphs 8 Mammography Exams Graph 9 MRI and Cat Scan Graphs 10 Nuclear Medicine and Ultrasound Exams Graphs 11 Lab Procedures and Other X-Ray Graphs 12 Newborns and Net Days of Revenue in A/R Graphs 13 Respiratory and EKG Procedures Graphs 14 Hospital Revenue Graph 15 Income Statement and Budget Variance Report 16 Financial and Statistical Highlights 17 Statistics (Ratios - Productivity Indicators) 18 Balance Sheet 19 Cash Flow Statement 20 Memorial Hospital of Converse County Admissions and Avg. IP Daily Census Dec 2014 Admissions 120 100 80 60 40 20 0 Curr. 12 mo. Current Budget Prev. 12 mo. Jan 77 75 84 Feb. 63 75 95 Mar 78 75 72 Apr 89 75 77 May 92 75 87 June 100 75 83 July 89 81 68 Current 12 mo. avg. = 84 Aug 85 81 91 Sep 94 81 78 Oct 70 81 78 Nov 81 81 59 Dec 86 81 63 Previous 12 mo. avg. = 78 Average IP Daily Census 10.00 9.00 8.00 7.00 6.00 5.00 4.00 3.00 2.00 1.00 0.00 Curr. 12 mo. Current Budget Prev. 12 mo. Jan 7.32 9.17 7.61 Feb. 6.14 9.17 9.50 Mar 6.48 9.17 6.68 Apr 8.03 9.17 6.93 May 9.42 9.17 6.39 June 7.70 9.17 7.80 Curr. 12 mo. avg. = 7.41 July 9.23 6.84 5.71 Aug 7.58 6.84 7.35 Sep 7.23 6.84 5.60 Oct 6.61 6.84 6.65 Nov 6.83 6.84 4.17 Dec 6.29 6.84 5.10 Prev. 12 mo. avg. = 6.62 Page 1 Memorial Hospital of Converse County (FY 2014) Average Floor Census Breakdown Dec 2014 (FY 2015) Average Floor Census Breakdown 14.00 12.00 2.58 2.33 0.56 0.60 10.00 1.13 8.00 1.97 2.02 3.00 0.71 0.67 1.10 0.51 0.65 1.00 6.00 9.23 4.00 9.17 7.58 7.23 7.69 6.61 6.29 2.00 0.00 SB OBS IP Jul. Aug. Sep. Oct. Nov. Dec. 2.58 0.56 9.23 1.13 0.71 7.58 1.97 0.51 7.23 3.00 0.65 6.61 2.33 0.60 9.17 1.10 1.00 6.29 IP Jan. Feb. Mar. Apr. May June Average 2.02 0.67 7.69 OBS SB Page 2 Memorial Hospital of Converse County Average Monthly Inpatient Admissions by Physician Dec 2014 Average Monthly Inpatient Admissions by Physician Based on Previous 12 Months 40.00 35.00 30.00 25.00 20.00 15.00 10.00 5.00 0.00 Page 3 Memorial Hospital of Converse County Average Length of Stay by Physician Dec 2014 Average Length of Stay by Physician for Fiscal Year 2015 4.00 3.50 3.00 2.50 2.00 1.50 1.00 0.50 0.00 Retherford Lansang Thalken Hospitalist Grosdidier White, W. Croft Skuza Yost Engle Current Month Avg. Length of Stay 0.00 2.00 0.00 0.00 2.52 2.25 0.00 2.40 2.33 1.71 2.00 1.96 YTD FY 2015 Avg. Length of Stay 0.00 1.50 0.00 0.00 3.25 2.45 0.00 3.52 2.83 1.61 1.50 1.80 Page 4 Memorial Hospital of Converse County Payor Mix Comparisons and ER Visits Dec 2014 Payor Mix Comparisons 50.00% 45.00% 40.00% 35.00% 30.00% 25.00% 20.00% 15.00% 10.00% 5.00% 0.00% Insurance Medicare Medicaid Self Pay Workers Comp. Other Payors Fiscal Year 2014 Fiscal Year 2015 Emergency Room Visits 800 700 600 500 400 300 200 100 0 Curr. 12 mo. Current Budget Prev. 12 mo. Jan 447 507 492 Feb. 393 507 485 Mar 429 507 514 Apr 474 507 418 May 582 507 514 June 565 507 491 Curr. 12 mo. avg. = 538 July 626 477 482 Aug 703 477 532 Sep 661 477 446 Oct 503 477 455 Nov 546 477 384 Dec 525 477 371 Prev. 12. mo. avg. = 465 Page 5 Memorial Hospital of Converse County Total Surgeries and Orthopedic Surgeries Dec 2014 Total Surgeries 160 140 120 100 80 60 40 20 0 Curr. 12 mo. Current Budget Prev. 12 mo. Jan 93 119 139 Feb. 94 119 108 Mar 77 119 101 Apr 100 119 126 May 88 119 134 June 98 119 108 July 83 105 139 Current 12 mo. avg. = 94 Aug 88 105 118 Sep 85 105 97 Oct 110 105 105 Nov 89 105 94 Dec 127 105 119 Previous 12 mo. avg. = 116 Orthopedic Surgeries 90 80 70 60 50 40 30 20 10 0 Curr. 12 mo. Current Budget Prev. 12 mo. Jan 37 73 83 Feb. 42 73 71 Mar 40 73 55 Apr 39 73 80 May 49 73 70 June 37 73 66 Curr. 12 mo. avg. = 40 July 43 52 73 Aug 28 52 72 Sep 36 52 58 Oct 37 52 45 Nov 46 52 56 Dec 47 52 53 Prev. 12 mo. avg. = 65 Page 6 Memorial Hospital of Converse County General and OB/GYN Surgeries Dec 2014 General Surgeries 35 30 25 20 15 10 5 0 Curr. 12 mo. Current Budget Prev. 12 mo. Jan 28 21 26 Feb. 25 21 19 Mar 20 21 16 Apr 22 21 20 May 22 21 23 June 24 21 26 July 23 24 28 Curr. 12 mo. avg. = 25 Aug 26 24 27 Sep 24 24 22 Oct 29 24 18 Nov 23 24 16 Dec 32 24 22 Prev. 12 mo. avg. = 22 OB/GYN Surgeries 14 12 10 8 6 4 2 0 Jan Feb. Mar Apr May June Curr. 12 mo. avg. = 9 Curr. 12 mo. July Aug Sep Oct Nov Dec Prev. 12 mo. avg. = 10 Current Budget Prev. 12 mo. Page 7 Memorial Hospital of Converse County Procedure Core Visits Dec 2014 Procedure Core Visits 70 60 50 40 30 20 10 0 Curr. 12 mo. Current Budget Prev. 12 mo. Jan 41 46 35 Feb. 49 46 47 Mar 64 46 57 Apr 37 46 44 May 45 46 44 June 41 46 35 July 47 49 40 Aug 44 49 41 Curr. 12 mo. avg. = 46 Sep 34 49 54 Oct 55 49 49 Nov 38 49 50 Dec 60 49 61 Prev. 12 mo. avg. = 46 Procedure Core Visit Types 100 90 80 70 40 60 50 40 48 30 20 Curr. 12 mo. Scopes Curr. 12 mo. Minor Procedures 42 29 41 28 37 40 35 47 22 32 24 10 0 31 16 4 Jan 37 4 9 8 Feb. 41 8 Mar 48 16 Apr 28 9 5 6 May 40 5 June 35 6 July 40 47 15 12 Aug 29 15 Sep 22 12 18 6 Oct 31 24 Nov 32 6 Dec 42 18 Page 8 Memorial Hospital of Converse County Mammography Exams Dec 2014 Mammography Exams 140 120 100 80 60 40 20 0 Curr. 12 mo. Current Budget Prev. 12 mo. Jan 93 90 82 Feb. 96 90 84 Mar 102 90 79 Apr 90 90 80 May 90 90 93 June 82 90 86 Curr. 12 mo. avg. = 93 July 95 94 80 Aug 96 94 84 Sep 92 94 65 Oct 112 94 75 Nov 81 94 117 Dec 92 94 95 Prev. 12 mo. avg. = 85 Page 9 Memorial Hospital of Converse County MRI & Cat Scans Dec 2014 MRI Exams 120 100 80 60 40 20 0 Curr. 12 mo. Current Budget Prev. 12 mo. Jan 90 89 95 Feb. 70 89 79 Mar 94 89 78 Apr 76 89 86 May 88 89 73 June 97 89 88 Curr. 12 mo. avg. = 89 July 105 84 61 Aug 82 84 71 Sep 94 84 65 Oct 93 84 91 Nov 79 84 96 Dec 97 84 83 Prev. 12 mo. avg. = 81 CT Exams 300 250 200 150 100 50 0 Curr. 12 mo. Current Budget Prev. 12 mo. Jan 189 169 194 Feb. 152 169 171 Mar 158 169 196 Apr 181 169 182 May 195 169 276 June 164 169 225 Curr. 12 mo. avg. = 198 July 214 201 246 Aug 253 201 275 Sep 242 201 233 Oct 201 201 226 Nov 176 201 174 Dec 247 201 155 Prev. 12 mo. avg. = 213 Page 10 Memorial Hospital of Converse County Nuclear Med and Ultrasound Exams Dec 2014 Nuclear Medicine Exams 40 35 30 25 20 15 10 5 0 Curr. 12 mo. Current Budget Prev. 12 mo. Jan 26 18 30 Feb. 20 18 29 Mar 25 18 20 Apr 28 18 13 May 36 18 14 June 36 18 21 July 38 25 26 Curr. 12 mo. avg = 29 Aug 30 25 16 Sep 27 25 22 Oct 38 25 16 Nov 13 25 19 Dec 32 25 13 Nov 144 176 148 Dec 190 176 191 Prev. 12 mo. avg. = 20 Ultrasound Exams 250 200 150 100 50 0 Curr. 12 mo. Current Budget Prev. 12 mo. Jan 149 158 157 Feb. 140 158 184 Mar 192 158 164 Apr 204 158 142 May 224 158 186 June 199 158 172 Curr. 12 mo. avg. = 191 July 214 176 145 Aug 228 176 156 Sep 206 176 147 Oct 198 176 156 Prev. 12 mo. avg. = 162 Page 11 Memorial Hospital of Converse County Lab Procedures and Other X-Ray Exams Dec 2014 Lab Procedures 45,000 40,000 35,000 30,000 25,000 20,000 15,000 10,000 5,000 0 Jan Feb. Mar Apr May June July Aug Sep Oct Nov Dec Curr. 12 mo. 25,973 22,836 27,622 38,230 30,980 29,091 32,256 40,728 34,548 33,336 26,829 29,939 Current Budget 23,409 23,409 23,409 23,409 23,409 23,409 29,531 29,531 29,531 29,531 29,531 29,531 Prev. 12 mo. 29,217 24,029 25,658 34,126 29,692 25,921 29,163 40,549 24,336 30,996 21,915 22,361 Curr. 12 mo. avg. = 31,031 Prev. 12 mo. avg. = 28,164 Total Other X-Ray Exams 700 600 500 400 300 200 100 0 Curr. 12 mo. Current Budget Prev. 12 mo. Jan 499 423 413 Feb. 437 423 387 Mar 505 423 362 Apr 559 423 359 May 602 423 440 June 486 423 466 Curr. 12 mo. avg. = 541 July 625 483 448 Aug 624 483 462 Sep 598 483 440 Oct 598 483 433 Nov 450 483 399 Dec 503 483 355 Prev. 12 mo. avg. = 414 Page 12 Memorial Hospital of Converse County Newborns and Net A/R Days Dec 2014 Newborns 20 18 16 14 12 10 8 6 4 2 0 Curr. 12 mo. Current Budget Prev. 12 mo. Jan 12 11 12 Feb. 12 11 16 Mar 17 11 11 Apr 16 11 13 May 12 11 15 June 19 11 14 July 14 15 9 Curr. 12 mo. avg. = 14 Aug 12 15 17 Sep 14 15 11 Oct 8 15 16 Nov 15 15 12 Dec 17 15 12 Nov 69.09 53.00 55.62 Dec 64.15 53.00 53.61 Prev. 12 mo. avg. = 13 Net Days of Revenue in A/R 80.00 70.00 60.00 50.00 40.00 30.00 20.00 10.00 0.00 Jan Curr. 12 mo. 57.25 Current Budget 53.00 Prev. 12 mo. 43.26 Feb. 54.43 53.00 50.34 Mar 53.54 53.00 59.35 Apr 61.17 53.00 56.48 May 65.31 53.00 62.21 June 71.01 53.00 63.07 Curr. 12 mo. avg. = 63.68 July 63.76 53.00 62.15 Aug 67.46 53.00 61.79 Sep 69.98 53.00 60.50 Oct 67.01 53.00 57.03 Prev. 12 mo. avg. = 57.95 Page 13 Memorial Hospital of Converse County Respiratory and EKG Procedures Dec 2014 Respiratory Procedures 5000 4500 4000 3500 3000 2500 2000 1500 1000 500 0 Jan Feb. Mar Apr May June July Current 12 mo. Avg = 3,460 Curr. 12 mo. Aug Sep Oct Nov Previous 12 mo. Avg. = 3,239 Current Budget Dec Prev. 12 mo. EKG Procedures 500 450 400 350 300 250 200 150 100 50 0 Jan Feb. Mar Apr May Current 12 mo. Avg. = 373 Curr. 12 mo. June July Aug Sep Oct Nov Dec Previous 12 mo. Avg. = 372 Current Budget Prev. 12 mo. Page 14 Memorial Hospital of Converse County Hospital Patient Revenues Dec 2014 Hospital Patient Revenues 7,000,000 6,000,000 5,000,000 4,000,000 3,000,000 2,000,000 1,000,000 0 Curr. 12 mo. Jan 5,037,823 Feb. 4,732,954 Mar 4,679,530 Apr 5,688,110 May 6,044,398 June 5,973,921 July 6,284,035 Aug 6,179,897 Sep 6,582,246 Oct 6,384,088 Nov 6,214,322 Dec 6,623,555 Current Budget 5,424,304 4,818,806 4,818,806 4,870,486 4,637,970 5,134,485 5,522,322 4,988,287 5,522,327 5,344,299 5,522,325 5,522,325 Prev. 12 mo. 4,654,329 4,589,688 4,385,660 4,209,355 3,701,345 4,618,919 4,388,895 5,014,654 4,581,501 4,556,531 3,832,418 4,681,439 Curr. 12 mo. avg. = $5,868,740 Prev. 12 mo. avg. = $4,434,561 Page 15 Memorial Hospital of Converse County Income Statement Summary Budget Variance Report Current Month Year to Date Dec 2014 Budget Variance Amount $1,527,507 3,393,495 1,702,553 $6,623,555 $1,312,863 2,703,165 1,328,276 $5,344,304 $214,644 690,330 374,277 $1,279,251 534,432 421,778 65,004 627,700 115,658 $1,764,572 368,444 234,469 40,993 410,448 81,985 $1,136,339 4,858,983 December YTD Thru Dec 2014 YTD Budget Prior Year YTD Variance Amount YTD Thru Dec 2013 Change From Prior YTD Patient Revenue Inpatient Outpatient Physician Clinics Total Patient Revenue $10,017,183 18,531,854 9,719,105 $38,268,142 $7,920,940 16,309,130 8,013,794 $32,243,864 $2,096,243 2,222,724 1,705,311 $6,024,278 $884,065 2,643,778 1,153,595 $4,681,438 $9,133,118 15,888,076 8,565,510 $33,586,704 165,988 187,309 24,011 217,252 33,673 $628,233 Deductions From Revenue Medicare Medicaid Worker's Compensation Other Contractuals Other Total Deductions 3,343,545 1,579,292 574,422 2,901,003 772,400 $9,170,662 2,222,942 1,414,631 247,321 2,476,369 494,643 $6,855,906 1,120,603 164,661 327,101 424,634 277,757 $2,314,756 349,783 248,958 105,368 225,904 97,847 $1,027,860 2,993,762 1,330,334 469,054 2,675,099 674,553 $8,142,802 4,207,965 651,018 Net Patient Revenue 29,097,480 25,387,958 3,709,522 3,653,578 25,443,902 33,725 $4,892,708 85,988 $4,293,953 (52,263) $598,755 Other Operating Revenue Total Operating Revenue 581,853 $29,679,333 515,928 $25,903,886 65,925 $3,775,447 199,400 $3,852,978 382,453 $25,826,355 2,241,845 550,688 570,223 107,514 70,244 1,018 13,475 101,940 56,895 41,483 35,059 25,539 34,929 49,775 341,664 691,536 $4,933,827 2,187,989 498,395 368,512 99,466 69,653 4,167 26,092 76,115 31,750 32,500 33,479 120,296 32,883 47,951 385,833 377,390 $4,392,471 53,856 52,293 201,711 8,048 591 (3,149) (12,617) 25,825 25,145 8,983 1,580 (94,757) 2,046 1,824 (44,169) 314,146 $541,356 Operating Expenses Salaries & Wages Benefits Supplies Lease & Rentals Other Expenses Legal Travel & Education Maintenance & Repair Physician Fees Interest Professional Fees Purchased Services Insurance Utilities Depreciation Indigent Care Total Expenses 13,825,548 2,946,560 3,053,393 539,006 525,630 5,835 106,509 586,117 277,396 258,601 286,943 760,765 208,199 289,055 2,351,434 2,612,466 $28,633,457 13,200,879 2,990,379 2,211,102 596,798 417,978 25,000 156,528 456,696 190,500 195,000 200,872 721,783 197,300 287,710 2,315,000 2,265,009 $26,428,534 624,669 (43,819) 842,291 (57,792) 107,652 (19,165) (50,019) 129,421 86,896 63,601 86,071 38,982 10,899 1,345 36,434 347,457 $2,204,923 2,025,548 596,258 515,989 105,780 86,849 4,777 28,060 80,387 33,797 30,775 142,126 135,621 31,254 46,186 372,138 357,157 $4,592,702 11,800,000 2,350,302 2,537,404 433,226 438,781 1,058 78,449 505,730 243,599 227,826 144,817 625,144 176,945 242,869 1,979,296 2,255,309 $24,040,755 (41,119) (98,518) 57,399 Operating Income (Loss) 87,500 37,500 69,113 87,500 37,500 47,424 0 0 21,689 Non-Operating Revenue County - Indigent Care Reimbursement County - Ambulance Reimbursement Other Non-Operating 0 $152,994 0 $73,906 0 $79,088 Non-Operating Expense Net Income/(Loss) 1,045,876 (524,648) 525,000 375,000 220,654 525,000 225,000 284,550 0 $2,166,530 0 $509,902 1,570,524 0 150,000 (63,896) 0 $1,656,628 (739,724) 72,917 33,333 40,396 0 ($593,078) 1,785,600 452,083 341,667 180,258 0 $2,759,608 Page 16 Memorial Hospital of Converse County Financial and Statistical Highlights Dec 2014 Page # Patient Volumes IP Daily Census………. Surgeries……………. .. Radiology Exams……… Laboratory Tests……. .. Emer. Rm. Visits……… At 6.29 up 1.19 from December 2013 - down .54 from November 2014 At 127 up 8 from December 2013 - up 38 from November 2014 At 1,161 up 352 from December 2013 - up 218 from November 2014 At 29,939 up 7,578 from December 2013 - up 3,110 from November 2014 At 525 up 154 from December 2013 - down 21 from November 2014 1-2 6-7 9-12 12 5 Income Statement Gross Patient Revenue for the month was $6,623,000 compared to $4,681,439 last December and $6,214,000 last month. Net Income for December is $152,000 compared to ($593,077) last year and $189,000 last month. 15 Monthly Revenue - over budget by $1,279,000 The departments that are under budget by $10,000 or more are as follows: Med/Surg - 83,000 Swing Bed - 10,000 Deductions From Revenue - Over budget by $628,000 Monthly Expense Variances - Over budget by $541,000 Supplies - $201,000 Med/Surg - 12,000 Ambulance 3,100 Drugs - 64,500 Lab - 26,000 Cardiopulmonary - 6,200 Arbor Café - 6,000 Surgery - 100,000 Physician Services - 5,500 Physician Fees - $25,000 Hospitalists - 9,000 Radiologists - 2,600 ER - 13,000 Indigent Care - $314,000 Interest - $8,000 Lease & Rentals - $8,000 Housing & Storage Insurance - $2,000 Benefits - $52,000 Health Insurance - 34,000 Retirement - 19,000 Maintenance & Repairs -$25,000 Surgery - 12,000 Facilities - 13,000 Professional Fees - $1,500 Surgery - 5,000 Salaries & Wages - $53,000 Utilities - $1,800 Electricity Cash Status Cash balances as of December 31, 2014 are $15,376,226 This equates to 108 days of expenses on hand. Accounts Receivable Net Accounts Receivable days are at 64.15 days for the end of December compared to 63.33 last year and 69.09 last month. Page 17 Memorial Hospital of Converse County Statistics For The Period Ended December 31, 2014 Monthly Dec 2014 Dec 2013 Variance From Prior Dec Year to Date Budget Variance Amount % 86 1 63 4 23 (3) 79 4 7 (3) 87 67 20 83 4 195 34 158 53 37 (19) 208 55 (13) (21) -6.3% -38.2% 229 211 18 263 (34) -12.9% 17 34 12 21 5 13 15 23 2 11 13.3% 47.8% 127 119 8 105 22 3,241 525 2,532 371 709 154 2,817 477 3,766 2,903 863 3,294 327 315 12 331 Financial Ratios Days Cash on Hand Operating Margin Dec 2014 108 Dec 2013 114 YTD Thru Dec 2013 Variance From Prior YTD YTD Budget Variance Amt. 419 25 425 16 (6) 9 474 24 (55) 1 -11.6% 4.2% Total A & P Admissions 444 441 3 498 (54) -10.8% A & P Patient Days - Regular -Swing Bed 1,343 371 1,062 293 281 78 1,248 330 95 41 7.6% 12.4% Total A & P Patient Days 1,714 1,355 359 1,578 136 8.6% Newborn - Admissions -Patients Days 80 142 77 122 3 20 90 138 (10) 4 -11.1% 2.9% 21.0% Surgeries 582 672 (90) 630 (48) -7.6% 424 48 15.1% 10.1% Outpatient Registrations ER Registrations 19,279 3,564 15,297 2,670 3,982 894 16,902 2,862 2,377 702 14.1% 24.5% 472 14.3% Total Registrations 22,843 17,967 4,876 19,764 3,079 15.6% -1.1% FTE's 324 316 8 331 YTD N/A 4.8% US 69 WY Misc. Measurements 86 Total Revenue per FTE YTD - 15 $236,223 YTD - 14 $171,236 Variance From Prior Year $64,987 WY $114,924 (7) -19.20% 3.52% 0.68% 0.64% Contractual Deductions 23.96% 17.28% 6.68% 27.29% -3.33% Net Margin 3.13% -15.39% 7.30% 2.33% 4.98% Inpatient Revenue % 35.09% 30.78% 4.31% 31.41% 3.68% Current Ratio 6.05 4.37 64.91% 69.22% -4.31% 68.59% -3.68% 70.33 64.15 71.50 63.33 N/A 2.32 4.29 Outpatient Revenue % Average Length of Stay 51.53 2.29 2.63 (0.34) 3.30 -2.2% Variance From WY $121,299 -0.08% Gross A/R Days Net A/R Days % A & P Admissions - Regular -Swing Bed (4) 8.9% -75.0% YTD Thru Dec 2014 (1.01) 55.62 Medicare Inp. Payer Mix 33.10% 25.00% 8.10% Average I/P Daily Census 7.30 5.10 Salaries to Total Expense 48.29% 44.93% 3.36% Benefits as % of Salaries 21.31% 23.18% -1.87% 31.00% 2.10% Medicare Rural Hospital Flexibility Program Monitoring Team - US CAH Median-2011 2.20 3.92 3.38 Medicare Rural Hospital Flexibility Program Monitoring Team -WY CAH Medium-2011 46.32% 1.97% Page 18 Memorial Hospital of Converse County Balance Sheet December 31, 2014 Dec 2014 Dec 2013 ASSETS CURRENT ASSETS Cash On Hand And In Banks Certificates Of Deposit - Unrestricted Total Cash Assets $5,194,210 1,731,695 $6,925,905 $7,159,649 618,390 $7,778,039 Helmsley Trust Grant Total Designated Cash Assets 0 $0 0 $0 Assets Whose Use is Restricted Bond Reserve Fund - (Bond Covenant Requirement) Bond Payment Fund-(Bond Covenant Requirement) Certificates of Deposit Securing Loan Reserve Account - (Patient Contracts) Additional (Bond Covenant Requirement) Total Restricted Assets 628,360 158,899 5,000,000 12,413 2,650,648 $8,450,320 626,261 163,966 6,000,000 12,413 (385,751) $6,416,889 Accounts Receivable (Gross) Uncollectable Accts. & Contratual. Adj. Net Patient Accounts 14,874,985 (4,861,077) $10,013,908 11,520,734 (3,774,773) $7,745,961 Due From Physicians Inventories Of Supplies Other Current Assets Total Current Assets 107,988 1,070,302 3,019,234 $29,587,657 225,022 1,028,106 3,322,150 $26,516,167 31,118,752 28,991,059 283,888 7,762 $291,650 357,999 140,922 $498,921 $60,998,059 $56,006,147 LAND, BUILDING AND EQUIPMENT, net OTHER ASSETS Investment - Big Country Rehab Investment - Powder River Imaging Total Other Assets Total Assets LIABILITIES AND FUND EQUITY CURRENT LIABILITIES Accounts Payable Accrued Bond Interest/Principal Payable Accrued Salaries Accrued Self Funded Health Ins. Accrued Taxes And Deductions Current Portion Of Capital Leases Contingent Liability-(Patient Contracts) Total Current Liabilities 1,878,083 (72,945) 2,241,415 0 580,774 253,146 12,413 $4,892,886 2,356,123 (59,001) 1,833,531 0 339,698 1,579,108 12,413 $6,061,872 OTHER LIABILITIES Revenue Bonds Payable Long Term EIB Accrual Deferred Loss On Early Retirement Of Bonds Discount On Bonds Medicare Cost Report Settlement Long Term Capital Lease Obligations Total Other Liabilities 6,308,504 83,485 (587,840) (30,494) 95,000 5,943,927 $11,812,582 6,768,333 81,793 (701,091) (30,494) 95,000 942,551 $7,156,092 Total Liabilities FUND EQUITY Fund Balance Net Income $16,705,467 42,126,062 2,166,530 $13,217,964 43,759,841 (971,658) Total Fund Balance $44,292,592 $42,788,183 Total Liabilities And Fund Equity $60,998,059 $56,006,147 Page 19 Cash Flow Statement for December 2014 and FYTD 2015 Cash Flow From Operations Dec 2014 Net Earnings/(Loss) Additions/Subtractions to Cash Depreciation Decrease/(Increase) in AR (Decrease)/Increase in AP Decrease/(Increase) in Inventory Net Cash Flow From Operations FYTD $152,994 $2,166,530 341,664 906,660 (50,276) 7,568 $1,358,610 2,351,434 (862,765) 320,892 26,488 $4,002,579 Cash Flow from Investing Equipment, Fixed Assets Loan Advance (188,048) 0 (1,168,182) 0 Cash Flow from Financing Bonds, Notes Payable (61,946) (361,905) Cash Flow for the Month Ending: Dec 2014 $1,108,616 $2,472,492 Page 20 October 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Days Recorded 31 IP 7 5 5 4 5 5 5 6 6 4 10 12 11 2 0 0 2 8 10 12 10 10 7 9 10 8 8 7 6 5 3 202 6.5 OBS 0 2 1 4 0 1 3 0 1 2 1 1 2 0 0 0 1 4 1 2 0 0 0 1 4 2 0 1 0 0 1 35 1.1 SW 2 2 2 1 1 1 1 1 1 1 1 1 1 2 2 2 2 1 1 1 1 1 1 1 2 2 2 2 2 2 4 47 9 9 8 9 6 7 9 7 8 7 12 14 14 4 2 2 5 13 12 15 11 11 8 11 16 12 10 10 8 7 8 1.5 9.2 Days Recorded 30 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 IP 4 9 8 11 11 11 8 11 10 7 5 4 5 10 13 9 8 9 8 7 8 9 11 12 7 6 4 6 16 16 263 8.8 OBS 4 0 1 4 0 0 3 1 1 2 0 0 1 1 2 2 0 0 0 0 0 3 2 0 0 0 0 1 0 1 29 1.0 109 3.6 13.4 Days Recorded 31 November SW 4 3 2 2 2 2 3 4 2 3 4 3 3 3 3 2 3 3 3 3 5 5 4 4 6 6 6 6 5 5 12 12 11 17 13 13 14 16 13 12 9 7 9 14 18 13 11 12 11 10 13 17 17 16 13 12 10 13 21 22 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 IP 10 7 6 8 7 9 14 12 15 7 7 8 9 12 11 7 4 4 10 12 8 7 5 5 8 5 8 11 9 6 8 OBS 0 0 0 0 2 5 0 1 0 0 1 0 1 0 1 0 0 1 2 2 0 1 1 0 0 1 0 0 2 1 SB 5 5 5 5 3 2 3 4 4 3 3 1 2 2 1 1 1 1 1 1 1 2 2 2 2 2 3 3 3 4 December Aug. Sep. Oct. Nov. Dec. Jan. Feb. Mo's Rec 6 Mar. Apr. May June Average 259 8.4 IP 9.23 7.58 7.23 6.61 9.17 6.29 7.69 0 22 0.7 OBS 0.56 0.71 0.51 0.65 0.60 1.00 0.67 4 81 2.6 11.7 SB 2.58 12.37 1.13 9.42 1.97 9.71 3.00 10.26 2.33 12.10 1.10 8.39 Days Recorded 31 Hi Lo 16 2 22 7 January 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 IP 6 5 8 8 13 12 11 9 8 8 7 8 3 2 4 7 10 10 11 10 13 13 14 16 7 9 8 9 8 9 12 278 9.0 OBS 0 0 1 0 1 1 0 0 1 2 0 1 3 1 0 0 3 2 4 2 1 1 0 2 0 1 1 0 0 1 2 31 1.0 SB 3 4 4 3 3 2 4 4 6 4 3 3 4 5 5 5 3 3 2 3 3 3 3 3 6 4 3 3 3 4 4 112 3.6 13.6 Days Recorded 28 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 February IP 13 13 7 8 7 10 11 12 8 9 1 2 4 9 14 18 20 16 13 6 10 8 6 5 4 5 8 13 260 9.3 OBS 1 1 1 0 3 1 1 1 3 1 0 0 4 3 0 1 1 1 0 1 2 1 1 0 0 0 0 0 28 1.0 SB 4 3 4 3 3 2 3 2 3 5 4 4 3 2 2 2 3 4 4 2 2 2 2 2 2 2 3 3 80 2.9 13.1 Days Recorded 31 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 7.7 March IP 11 12 5 10 7 4 4 3 3 5 5 3 9 11 7 7 8 4 5 8 11 11 11 12 11 7 7 9 8 10 12 240 OBS 0 2 1 0 0 1 1 1 1 0 0 1 1 1 0 2 0 0 0 0 1 1 1 0 0 1 1 3 3 2 3 28 0.9 SB 4 4 4 4 4 3 2 2 3 3 3 3 3 3 3 1 1 1 1 2 2 3 2 2 1 1 2 2 2 2 2 75 2.4 11.1 Days Recorded 30 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 April IP 12 14 11 15 12 10 12 7 5 3 5 4 6 5 3 1 2 4 8 8 4 3 7 6 8 14 9 13 12 8 205 6.8 OBS 0 1 2 2 1 1 0 0 0 0 3 0 1 1 0 0 0 1 0 2 0 0 0 0 2 0 0 2 0 2 21 0.7 SB 2 2 2 2 2 2 1 1 1 1 1 2 2 2 2 2 2 2 2 2 3 3 3 4 4 3 4 4 4 5 72 2.4 9.9 Days Recorded 31 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 6.6 May 0.00 0.00 0.00 0.00 0.00 0.00 2.02 10.38 0.00 31 IP 12 14 11 15 12 10 12 7 5 3 5 4 6 5 3 1 2 4 8 8 4 3 7 6 8 14 9 13 12 8 205 OBS 0 1 2 2 1 1 0 0 0 0 3 0 1 1 0 0 0 1 0 2 0 0 0 0 2 0 0 2 0 2 21 0.7 SB 2 2 2 2 2 2 1 1 1 1 1 2 2 2 2 2 2 2 2 2 3 3 3 4 4 3 4 4 4 5 72 2.3 9.6 Z:\Clients\Converse County\Admin\Client content\2015\Copy of December 2014 Financial Report (2).xlsm Jul. 1/30/2015 Statistics Curr. 12 mo. Current Budget Prev. 12 mo. Surgeries Curr. 12 mo. Current Budget Prev. 12 mo. IP Daily Census Curr. 12 mo. Current Budget Prev. 12 mo. CTs Curr. 12 mo. Current Budget Prev. 12 mo. MRIs Curr. 12 mo. Current Budget Prev. 12 mo. Total Other X-ray Exams Lab Procedures Curr. 12 mo. Current Budget Prev. 12 mo. Curr. 12 mo. Current Budget Prev. 12 mo. Emergency Room Visits Curr. 12 mo. Current Budget Prev. 12 mo. Hospital Revenues Curr. 12 mo. Current Budget Prev. 12 mo. Net Days of Revenue in A/R Curr. 12 mo. Current Budget Prev. 12 mo. Orthopedic Surgeries Dec 2014 Dec Prior Dec Thru Dec Dec 2013 Dec 2014 Dec 2013 Prior Dec Jan 93 119 139 Feb. 94 119 108 Mar 77 119 101 Apr 100 119 126 May 88 119 134 June 98 119 108 July 83 105 139 Aug 88 105 118 Sep 85 105 97 Oct 110 105 105 Nov 89 105 94 Dec 127 105 119 Jan 7.32 9.17 7.61 Feb. 6.14 9.17 9.50 Mar 6.48 9.17 6.68 Apr 8.03 9.17 6.93 May 9.42 9.17 6.39 June 7.70 9.17 7.80 July 9.23 6.84 5.71 Aug 7.58 6.84 7.35 Sep 7.23 6.84 5.60 Oct 6.61 6.84 6.65 Nov 6.83 6.84 4.17 Dec 6.29 6.84 5.10 Jan 189 169 194 Feb. 152 169 171 Mar 158 169 196 Apr 181 169 182 May 195 169 276 June 164 169 225 July 214 201 246 Aug 253 201 275 Sep 242 201 233 Oct 201 201 226 Nov 176 201 174 Dec 247 201 155 Jan 90 89 95 Feb. 70 89 79 Mar 94 89 78 Apr 76 89 86 May 88 89 73 June 97 89 88 July 105 84 61 Aug 82 84 71 Sep 94 84 65 Oct 93 84 91 Nov 79 84 96 Dec 97 84 83 Jan 499 423 413 Feb. 437 423 387 Mar 505 423 362 Apr 559 423 359 May 602 423 440 June 486 423 466 July 625 483 448 Aug 624 483 462 Sep 598 483 440 Oct 598 483 433 Nov 450 483 399 Dec 503 483 355 Jan 25,973 23,409 29,217 Feb. 22,836 23,409 24,029 Mar 27,622 23,409 25,658 Apr 38,230 23,409 34,126 May 30,980 23,409 29,692 June 29,091 23,409 25,921 July 32,256 29,531 29,163 Aug 40,728 29,531 40,549 Sep 34,548 29,531 24,336 Oct 33,336 29,531 30,996 Nov 26,829 29,531 21,915 Dec 29,939 29,531 22,361 Jan 447 507 492 Feb. 393 507 485 Mar 429 507 514 Apr 474 507 418 May 582 507 514 June 565 507 491 July 626 477 482 Aug 703 477 532 Sep 661 477 446 Oct 503 477 455 Nov 546 477 384 Dec 525 477 371 Jan Feb. Mar Apr May June July Aug Sep Oct Nov Dec 5,037,823 4,732,954 4,679,530 5,688,110 6,044,398 5,973,921 6,284,035 6,179,897 6,582,246 6,384,088 6,214,322 6,623,555 5,424,304 4,818,806 4,818,806 4,870,486 4,637,970 5,134,485 5,522,322 4,988,287 5,522,327 5,344,299 5,522,325 5,522,325 4,654,329 4,589,688 4,385,660 4,209,355 3,701,345 4,618,919 4,388,895 5,014,654 4,581,501 4,556,531 3,832,418 4,681,439 Jan 57.25 53.00 43.26 Feb. 54.43 53.00 50.34 Mar 53.54 53.00 59.35 Apr 61.17 53.00 56.48 May 65.31 53.00 62.21 June 71.01 53.00 63.07 July 63.76 53.00 62.15 Aug 67.46 53.00 61.79 Sep 69.98 53.00 60.50 Oct 67.01 53.00 57.03 Nov 69.09 53.00 55.62 Dec 64.15 53.00 53.61 Jan 37 73 83 Feb. 42 73 71 Mar 40 73 55 Apr 39 73 80 May 49 73 70 June 37 73 66 July 43 52 73 Aug 28 52 72 Sep 36 52 58 Oct 37 52 45 Nov 46 52 56 Dec 47 52 53 Jan Feb. Mar Apr May June July Aug Sep Oct Nov Dec 94 116 7.41 6.62 198 213 89 81 541 414 31,031 28,164 0 538 465 5,868,740 4,434,561 63.68 57.12 40 65 Curr. 12 mo. Current Budget Prev. 12 mo. Newborns Curr. 12 mo. Current Budget Prev. 12 mo. General Surgeries Curr. 12 mo. Current Budget Prev. 12 mo. Procedure Core Visits Curr. 12 mo. Current Budget Prev. 12 mo. Mammography 12 11 12 12 11 16 17 11 11 16 11 13 12 11 15 19 11 14 14 15 9 12 15 17 14 15 11 8 15 16 15 15 12 17 15 12 Jan 28 21 26 Feb. 25 21 19 Mar 20 21 16 Apr 22 21 20 May 22 21 23 June 24 21 26 July 23 24 28 Aug 26 24 27 Sep 24 24 22 Oct 29 24 18 Nov 23 24 16 Dec 32 24 22 Jan 41 46 35 Feb. 49 46 47 Mar 64 46 57 Apr 37 46 44 May 45 46 44 June 41 46 35 July 47 49 40 Aug 44 49 41 Sep 34 49 54 Oct 55 49 49 Nov 38 49 50 Dec 60 49 61 Jan 93 90 82 Feb. 96 90 84 Mar 102 90 79 Apr 90 90 80 May 90 90 93 June 82 90 86 July 95 94 80 Aug 96 94 84 Sep 92 94 65 Oct 112 94 75 Nov 81 94 117 Dec 92 94 95 Year Dec-04 Dec-05 Dec-06 Dec-07 Dec-08 Dec-09 Dec-10 Dec-11 Curr. 12 mo. Current Budget Prev. 12 mo. Ultrasound Curr. 12 mo. Current Budget Prev. 12 mo. Nuclear Medicine Curr. 12 mo. Current Budget Prev. 12 mo. OB/GYN Surgeries Curr. 12 mo. Current Budget Prev. 12 mo. Admissions Fiscal Year 2014 Fiscal Year 2015 Payor Mix 13 25 22 46 46 93 85 Mammo Exams 977 1,037 1,081 1,101 1,154 1,231 1,208 979 Jan 149 158 157 Feb. 140 158 184 Mar 192 158 164 Apr 204 158 142 May 224 158 186 June 199 158 172 July 214 176 145 Aug 228 176 156 Sep 206 176 147 Oct 198 176 156 Nov 144 176 148 Dec 190 176 191 Jan 26 18 30 Feb. 20 18 29 Mar 25 18 20 Apr 28 18 13 May 36 18 14 June 36 18 21 July 38 25 26 Aug 30 25 16 Sep 27 25 22 Oct 38 25 16 Nov 13 25 19 Dec 32 25 13 Jan 11 11 9 Feb. 7 11 10 Mar 4 11 6 Apr 8 11 14 May 5 11 12 June 11 11 8 July 8 10 10 Aug 11 10 11 Sep 11 10 6 Oct 12 10 11 Nov 8 10 10 Dec 14 10 12 Jan 77 75 84 Feb. 63 75 95 Mar 78 75 72 Apr 89 75 77 May 92 75 87 June 100 75 83 July 89 81 68 Aug 85 81 91 Sep 94 81 78 Oct 70 81 78 Nov 81 81 59 Dec 86 81 63 Other 0.21% 0.17% 100.00% 100.00% Aug July June May Apr Mar Feb. Insurance Medicare Medicaid Self Pay Workers Co 47.11% 32.17% 9.84% 6.79% 3.88% 45.73% 33.10% 9.18% 8.58% 3.24% Avg. 14 Dec Nov Oct. Sep 191 162 29 20 9 10 84 78 Jan Thalken Yost Murphy Retherford Campbell Rupp Robertson Lansang Grosdidier White, W. Wortham Engle Hospitalist Skuza Croft Newborns Admissions Curr. 12 mo. Minor Procedures Curr. 12 mo. Scopes Procedure Core Visits 0.08 0.25 0.58 3.25 3.17 0.00 4.42 0.00 2.75 1.92 0.92 9.67 33.67 1.42 5.17 13.92 81.17 0 0 0 2 5 0 6 0 3 4 0 12 29 2 6 17 86 0 0 0 2 5 0 7 0 5 2 0 10 30 0 5 15 81 0 0 0 3 3 0 6 0 3 2 0 8 30 3 4 8 70 0 2 0 4 4 0 6 0 3 2 0 10 42 3 5 13 94 0 1 0 5 2 0 2 0 4 2 0 6 46 0 5 12 85 0 0 0 6 4 0 4 0 2 4 0 7 43 0 5 14 89 0 0 0 7 5 0 5 0 4 1 0 8 42 1 4 19 96 0 0 1 3 3 0 4 0 4 2 0 8 49 0 4 12 90 0 0 0 4 2 0 6 0 2 1 0 8 38 1 9 16 87 0 0 0 1 3 0 3 0 0 0 3 23 20 5 6 17 81 0 0 0 0 1 0 2 0 2 2 3 8 12 1 8 12 51 Jan-00 0 0 0 0 Jan-00 0 0 0 0 Jan-00 0 0 0 0 Jan-00 0 0 0 0 Jan-00 0 0 0 0 Jan-00 0 0 0 0 Jan-00 0 0 0 0 Jan-00 0 0 0 0 Jan-00 0 0 0 0 Jan-00 0 0 0 0 Jan-00 0 0 0 0 Jan-00 0 0 0 0 Jan 4 37 Feb. 8 41 Mar 16 48 Apr 9 28 May 5 40 June 6 35 July 47 40 Aug 15 29 Sep 12 22 Oct 24 31 Nov 6 32 Dec 18 42 Avg. Length of Stay 0.00 2.00 YTD FY 2015 Avg. Length of Stay 0.00 1.50 Lansang Thalken 0.00 0.00 0.00 0.00 Hospitalist Grosdidier 2.52 2.25 0.00 2.40 2.33 1.71 2.00 1.96 0.00 1.67 2.33 3.25 2.45 0.00 3.52 2.83 1.61 1.50 1.80 0.00 2.04 2.43 Jan 3965 3265 4302 Feb. 3160 3265 4647 Mar 3073 3265 3702 Apr 3461 3265 2894 May 3985 3265 2820 June 3531 3265 4070 July 3633 3228 2363 Aug 2855 3228 3195 Sep 3219 3228 2988 Oct 3654 3228 3195 Nov 3857 3228 1925 Dec 3124 3228 2765 Jan 358 366 442 Feb. 274 366 367 Mar 396 366 323 Apr 358 366 342 May 465 366 473 June 347 366 416 July 420 369 455 Aug 382 369 409 Sep 440 369 257 Oct 416 369 409 Nov 262 369 280 Dec 362 369 286 Current Month Retherford White, W. Croft Skuza Yost Engle Rupp Campbell Robertson Curr. 12 mo. Current Budget Prev. 12 mo. RT Procedures Curr. 12 mo. Current Budget Prev. 12 mo. 1 0 6 2 1 0 2 0 1 1 5 8 23 1 1 12 64 3,460 3,239 373 372
© Copyright 2024