Spreadsheet: 145166d1331330249-nested-negative-if-statement-roic-calcs-0311-v2
Sheet: Pioneer

Application | IASIS65 |  |  |  |  |  | 2005-01-31 00:00:00 | 2005-02-28 00:00:00
Period |  | 2000-09-15 00:00:00 | 2001-09-15 00:00:00 | 2002-09-15 00:00:00 | 2003-09-15 00:00:00 | 2004-09-14 00:00:00 | 2005-09-14 00:00:00 | 2006-09-14 00:00:00 | 2007-09-14 00:00:00 | 2008-09-13 00:00:00 | 2009-09-13 00:00:00 | 2010-09-13 00:00:00 | 2011-09-13 00:00:00
Entity | Pioneer no Phys | PIONEER_NOPHYS | PIONEER_NOPHYS | PIONEER_NOPHYS | PIONEER_NOPHYS | PIONEER_NOPHYS | PIONEER_NOPHYS | PIONEER_NOPHYS | PIONEER_NOPHYS | PIONEER_NOPHYS | PIONEER_NOPHYS | PIONEER_NOPHYS | PIONEER_NOPHYS
Entity Level Statistics | M.YTD | M.YTD | M.YTD | M.YTD | M.YTD | M.YTD | M.YTD | M.YTD | M.YTD | M.YTD | M.YTD | M.YTD | M.YTD
Category | ACTUAL | PRIOR12 | PRIOR11 | PRIOR10 | PRIOR9 | PRIOR8 | PRIOR7 | [NAME] | PRIOR5 | PRIOR4 | PRIOR3 | PRIOR2 | PRIOR1
Account | M.MTD
 | Pioneer no Phys
 |  |  | 2001-09-15 00:00:00 | 2002-09-15 00:00:00 | 2003-09-15 00:00:00 | 2004-09-14 00:00:00 | 2005-09-14 00:00:00 | 2006-09-14 00:00:00 | 2007-09-14 00:00:00 | 2008-09-13 00:00:00 | 2009-09-13 00:00:00 | 2010-09-13 00:00:00 | 2011-09-13 00:00:00
[PHONE] | 840 - Building leases - long-term
EBITDA | EBITDAR (Leased Hospital-add back building rent only) | 6027369.760000009 | 12764208.69999999 | 14388427.23999999 | 15474795.59000001 | 16055187.92000001 | 19203120.20000006 | 22154351.93000001 | 20334673.51 | 22475541.59 | 20951132.05 | 15354548.23999999 | 10032436.87000005
 | Adjust EBITDA for impact of medicaid cuts |  |  |  |  |  |  |  |  |  |  |  | 3100000
PPE | Property Plant and Equipment | 11154860.49 | 12015735.27 | 13868407.29 | 16738766.71 | 20301755.09 | 10279412.9 | 13476826.8 | 15050278.12 | 17180849.9 | 18351682.82 | 19020272.9 | 20789150.23
ACCUM_DEP | Add back:  [NAME]  (re-lived assets) |  |  |  |  |  | 12337524.76 | 12337524.76 | 12337524.76 | 12337524.76 | 12337524.76 | 12337524.76 | 12337524.76
 | TPG Merger Valuation Adj. (FY05) |  |  |  |  |  | -465204 | -465204 | -465204 | -465204 | -465204 | -465204 | -465204
 | Adjusted PPE | 11154860.49 | 12015735.27 | 13868407.29 | 16738766.71 | 20301755.09 | 22151733.66 | 25349147.56 | 26922598.88 | 29053170.66 | 30224003.58 | 30892593.66 | 32661470.99
 | Annual EBITDA/Gross PPE | 0.5403357366417416 | 1.062291105220063 | 1.03749673189761 | 0.9244883961943939 | 0.7908275835673085 | 0.8668901718819264 | 0.873968320929211 | 0.7553012842718546 | 0.7736003017716758 | 0.6931951286514507 | 0.4970300781148458 | 0.3071642692722472
 |  |  |  |  |  |  |  | 3 Yr Avg | 0.832053259027664 | 0.8009566356575805 | 0.740698904898327 | 0.6546085028459908 | 0.4991298253461813
Change in EBITDA | Incremental EBITDA |  | 6736838.939999977 | 1624218.540000008 | 1086368.350000016 | 580392.3299999945 | 3147932.28000005 | 2951231.729999952 | -1819678.420000009 | 2140868.079999998 | -1524409.539999992 | -5596583.810000012 | -2222111.369999943
 | Growth |  |  | -800000 | -2701000 | -3505400 | -713000 | -416362 | -2007100 | -700273 | -224385 | -375600 | -1174700
 | Maintenance |  | -837086.7799999965 | -808520.9700000016 | -188827.5400000005 | -386131.6999999993 | -1092346.960000001 | -2015322.62 | -952666.98 | -857920.2399999972 | -275893.5200000037 | -207710.1100000014 | -718577.3300000022
 | Info Systems |  |  |  |  |  |  | -823300 | -11917
 | Greenfields |  |  |  |  |  |  |  | 25493
CF_PPE | Purchase of property and equipment | 5702884.700000001 | -837086.7799999965 | -1608520.970000002 | -2889827.540000001 | -3891531.699999999 | -1805346.960000001 | -3254984.62 | -2946190.98 | -1558193.239999997 | -500278.5200000037 | -583310.1100000014 | -1893277.330000002
CF_AR | (Inc)/Decr in Net Accounts Receivable | 10182967.77 | 2721999.370000002 | -2742005.170000002 | 622478.1999999993 | -887613.9900000002 | -461794.7799999993 | -3574116.219999997 | -3075483.060000001 | 2057606.439999996 | 526870.8399999999 | 4045861.780000003 | 2417900.009999998
CF_INVENT | (Inc)/Decr in Inventory | 1098354.98 | -436747.6999999997 | -139090.3600000003 | -231226.2300000004 | -134331.5899999992 | -132609.46 | -378195.0899999999 | 192085.0299999998 | -553677.1099999999 | -39065.71999999974 | -215296.1700000009 | 98685.39000000013
CF_PPD | (Inc)/Decr in Prepaid expenses | 141566.4 | -51991.82000000001 | 69904.07 | 9929.14 | -35858.78000000001 | -361387.16 | 127384.84 | -22741.02000000002 | -683150.24 | 485721.2700000001 | 30190.2699999999 | 17024.39000000013
CF_OTH_REC | (Inc)/Decr in Other Receivables | 274231.13 | 101917.6299999999 | -578138.75 | -566374.4500000002 | 574520.9700000002 | 302874.86 | -459370.35 | 503739.53 | 25655.59000000003 | 73793.52 | -397972.7000000001 | -442275.03
CF_AP | Inc/(Decr) in Accounts Payable | -1259385.82 | 2160138.44 | -756963.98 | 328185 | 408465.5299999998 | -87255.54999999981 | 348264.2800000003 | 757751.6399999997 | -2097249.93 | 145487.79 | 609315.7699999996 | 11359.04999999981
CF_ACC_SAL | Inc/(Decr) in Accrued Salaries | -805585.47 | 34358.75 | -141043.1399999999 | 236990.97 | 231961.1499999999 | -429146.7899999999 | 303155.5599999999 | -221868.53 | 54776.62000000011 | 169924.4899999998 | -48316.46999999974 | 97981.94999999995
CF_PAY_TAX | Inc/(Decr) in Payroll Taxes & W/H Pay | -25027.01000000001 | -19829.95 | 19943.92999999999 | 74823.96000000002 | 34255.58000000002 | -77935.14000000007 | 255034.7900000001 | -24081.75 | -176813.8200000001 | -927.0599999999686 | -34833.38999999996 | -9546.320000000007
CF_ACC_EXP | Inc/(Decr) in Accrued Expenses | -340920.23 | 438353.4 | -187120.74 | 41626.6399999999 | -231223.4299999999 | 750914.6499999999 | 970758.94 | 791954.4200000004 | 512476.4299999997 | -2944829.19 | 203328.3100000001 | -214189.74
CF_IBNR | Inc/(Decr) in Claims Payable/IBNR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CF_OTH_CURLIAB | Inc/(Decr) in Other Current Liabilities | -38006.28000000002 | 3874.940000000002 | -1605.270000000004 | 40860.53999999999 | 11718.69 | 3229.020000000019 | -4179.330000000016 | 8166.779999999999 | -41155.00999999999 | 3574916.39 | 318964.4199999995 | -528025.8799999998
CF_OTH_LT_LIAB | Inc/(Decr) in Other LongTerm [NAME]. | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Calc - total Changes in WC (Source/(Use)) | 9228195.47 | 4952073.060000002 | -4456119.410000003 | 557293.7699999986 | -28105.86999999941 | -493110.3499999992 | -2411262.579999996 | -1090476.96 | -901531.030000004 | 1991892.33 | 4511241.820000001 | 1448913.819999998
 | Change in PPE(1 Yr lag)/Working Capital Incremental | 14931080.17 |  | -5293206.189999999 | -1051227.200000003 | -2917933.41 | -4384642.049999999 | -4216609.539999997 | -4345461.58 | -3847722.010000004 | 433699.0900000029 | 4010963.299999997 | 865603.709999997
 | Return on Capital |  |  | FY 2002 | FY 2003 | FY 2004 | FY 2005 | FY 2006 | FY 2007 | FY 2008 | FY 2009 | FY 2010 | FY 2011
 | Year 1 |  |  | -0.3068496638329535 | -1.033428691723362 | -0.1989052690547844 | -0.7179451011286202 | -0.699906335173722 | 0.4187537702266393 | -0.5563988444165164 | 3.514901403182519 | 1.395321620120537 | 2.567123204682142
 | Year 2 |  |  |  | 0.4272386079854522 | 0.4199277489050788 | 0.5105492754470002 | 0.7091019192010409 | 0.1321588309815328 | 0.03920205820750915 | 0.180566608498342 | 1.602144938167059 | -1.603319540973551
 | Year 3 |  |  |  |  | 0.3553065097789064 | 0.5763474618635603 | 0.5798636222961953 | 0.3305461033860221 | 0.2636966914532233 | -0.1550644092400729 | 8.342751532406023 | -1.759441908193631
 | Year 5 |  |  |  |  |  |  | 0.5256574018204841 | 0.3515187182958516 | 0.3551448405622566 | 0.299249624409778 | -0.4831775002352394 | -4.924457791901493
 | Return on Growth/Greenfield Capital |  |  | FY 2002 | FY 2003 | FY 2004 | FY 2005 | FY 2006 | FY 2007 | FY 2008 | FY 2009 | FY 2010 | FY 2011
 | Year 1 |  |  | 0.364491700189876 | 4.476062892987997 | 0.2126675759925703 | 0.7872762615207561 | 0.9446170590437234 | -1.207613068353375 | 0.7425478966749279 | 1.180231283779247 | 1.305521514945304 | 2.07032773508865
 | Year 2 |  |  |  | 0.5768647525299582 | 0.5608566840413667 | 0.5541821186108093 | 0.856290670773918 | 0.244337831988012 | 0.07316431515054221 | 0.3873398031703963 | 1.276512287320616 | 1.458665349504611
 | Year 3 |  |  |  |  | 0.4430545994627807 | 0.690741783402009 | 0.6779982250695167 | 0.4959070749124957 | 0.4354960152009022 | -0.388341183309354 | 1.847681087966808 | 1.404600079397869
 | Year 5 |  |  |  |  |  |  | 0.6453394245426664 | 0.5125445182527119 | 0.4915613599258321 | 0.4790022088936053 | -1.98814169140569 | 3.988797986295037
CF_PPE | Purchase of property and equipment | 5702884.700000001 | 0 | -800000 | -2701000 | -3505400 | -713000 | -416362 | -1981607 | -700273 | -224385 | -375600 | -1174700
CF_PPE | Change in PPE(1 Yr lag)/Working Capital Incremental | 5702884.700000001 |  | -4456119.410000003 | -242706.2300000014 | -2729105.869999999 | -3998510.349999999 | -3124262.579999996 | -1506838.96 | -2883138.030000004 | 1291619.33 | 4286856.820000001 | 1073313.819999998
 | Pioneer no Phys