Spreadsheet: 145167d1331330435-nested-negative-if-statement-roic-calcs-0311-v3
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.08 | -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.96 | -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.97 | -2889827.54 | -3891531.7 | -1805346.96 | -3254984.62 | -2946190.98 | -1558193.24 | -500278.5200000037 | -583310.1100000014 | -1893277.33
CF_AR | (Inc)/Decr in Net Accounts Receivable | 10182967.77 | 2721999.37 | -2742005.17 | 622478.1999999993 | -887613.99 | -461794.7799999993 | -3574116.22 | -3075483.06 | 2057606.44 | 526870.84 | 4045861.78 | 2417900.01
CF_INVENT | (Inc)/Decr in Inventory | 1098354.98 | -436747.7 | -139090.36 | -231226.23 | -134331.5899999992 | -132609.46 | -378195.09 | 192085.03 | -553677.11 | -39065.71999999974 | -215296.1700000009 | 98685.39000000013
CF_PPD | (Inc)/Decr in Prepaid expenses | 141566.4 | -51991.82 | 69904.07 | 9929.14 | -35858.78 | -361387.16 | 127384.84 | -22741.02 | -683150.24 | 485721.27 | 30190.2699999999 | 17024.39000000013
CF_OTH_REC | (Inc)/Decr in Other Receivables | 274231.13 | 101917.63 | -578138.75 | -566374.45 | 574520.97 | 302874.86 | -459370.35 | 503739.53 | 25655.59 | 73793.52 | -397972.7 | -442275.03
CF_AP | Inc/(Decr) in Accounts Payable | -1259385.82 | 2160138.44 | -756963.98 | 328185 | 408465.53 | -87255.54999999981 | 348264.28 | 757751.64 | -2097249.93 | 145487.79 | 609315.77 | 11359.04999999981
CF_ACC_SAL | Inc/(Decr) in Accrued Salaries | -805585.47 | 34358.75 | -141043.14 | 236990.97 | 231961.15 | -429146.79 | 303155.56 | -221868.53 | 54776.62000000011 | 169924.49 | -48316.46999999974 | 97981.95
CF_PAY_TAX | Inc/(Decr) in Payroll Taxes & W/H Pay | -25027.01 | -19829.95 | 19943.93 | 74823.96 | 34255.58 | -77935.14000000007 | 255034.79 | -24081.75 | -176813.82 | -927.0599999999686 | -34833.39 | -9546.320000000007
CF_ACC_EXP | Inc/(Decr) in Accrued Expenses | -340920.23 | 438353.4 | -187120.74 | 41626.6399999999 | -231223.43 | 750914.65 | 970758.94 | 791954.42 | 512476.43 | -2944829.19 | 203328.31 | -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.28 | 3874.94 | -1605.27 | 40860.54 | 11718.69 | 3229.020000000019 | -4179.330000000016 | 8166.78 | -41155.01 | 3574916.39 | 318964.4199999995 | -528025.88
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.06 | -4456119.41 | 557293.7699999986 | -28105.86999999941 | -493110.3499999992 | -2411262.58 | -1090476.96 | -901531.030000004 | 1991892.33 | 4511241.82 | 1448913.82
 | Change in PPE(1 Yr lag)/Working Capital Incremental | 14931080.17 |  | -5293206.19 | -1051227.2 | -2917933.41 | -4384642.05 | -4216609.54 | -4345461.58 | -3847722.01 | 433699.0900000029 | 4010963.3 | 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.3068496638329534 | -1.033428691723365 | -0.1989052690547844 | -0.71794510112862 | -0.6999063351737216 | 0.4187537702266393 | -0.5563988444165175 | 3.514901403182519 | 1.395321620120536 | 2.567123204682142
 | Year 2 |  |  |  | 0.4272386079854524 | 0.4199277489050791 | 0.5105492754470002 | 0.7091019192010406 | 0.1321588309815327 | 0.0392020582075094 | 0.1805666084983427 | 1.602144938167058 | -1.603319540973551
 | Year 3 |  |  |  |  | 0.3553065097789065 | 0.5763474618635606 | 0.5798636222961951 | 0.3305461033860219 | 0.2636966914532236 | -0.1550644092400728 | 8.342751532405934 | -1.75944190819363
 | Year 5 |  |  |  |  |  |  | 0.5256574018204841 | 0.3515187182958516 | 0.3551448405622567 | 0.2992496244097781 | -0.4831775002352393 | -4.924457791901472
 | 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.3644917001898763 | 4.476062892988027 | 0.2126675759925703 | 0.787276261520756 | 0.9446170590437223 | -1.207613068353375 | 0.7425478966749286 | 1.18023128377925 | 1.305521514945305 | 2.070327735088647
 | Year 2 |  |  |  | 0.5768647525299587 | 0.5608566840413671 | 0.5541821186108093 | 0.8562906707739175 | 0.2443378319880118 | 0.07316431515054263 | 0.3873398031703968 | 1.276512287320617 | 1.458665349504611
 | Year 3 |  |  |  |  | 0.443054599462781 | 0.6907417834020091 | 0.6779982250695163 | 0.4959070749124955 | 0.4354960152009023 | -0.3883411833093531 | 1.84768108796681 | 1.404600079397869
 | Year 5 |  |  |  |  |  |  | 0.6453394245426665 | 0.5125445182527117 | 0.4915613599258321 | 0.4790022088936051 | -1.988141691405682 | 3.988797986295038
CF_PPE | Purchase of property and equipment | #N/A | 0 | -799999.9999999984 | -2701000 | -3505400.000000001 | -713000 | -416362 | -1981607 | -700273.0000000028 | -224385 | -375600 | -1174699.999999998
CF_PPE | Change in PPE(1 Yr lag)/Working Capital Incremental | #N/A |  | -4456119.41 | -242706.2299999997 | -2729105.869999999 | -3998510.35 | -3124262.58 | -1506838.96 | -2883138.030000004 | 1291619.329999997 | 4286856.82 | 1073313.82
 | Pioneer no Phys