Spreadsheet: 121663d1316228761-formula-returning-a-value-error-summary-tan
Sheet: Summary

 |  |  |  |  |  |  |  | 5275 - Physician Group of Arizona Inc | 5275 - Physician Group of Arizona Inc | 5275 - Physician Group of Arizona Inc
 |  |  |  |  |  |  |  | Organic/$ | Organic/$ | Organic/$
 |  |  |  |  |  |  |  | Current | Current | Current
 |  |  |  |  |  |  |  | Actual | Actual | Budget
 |  |  |  |  |  |  |  | FY10 | FY11 | FY12
 |  |  |  |  |  |  |  | YearTotal | YearTotal | YearTotal
Net Revenue - Incl Alloc Ded/BD |  |  | 7000 Primary Care | 2012 | Providers |  |  |  |  | 262405.1718352229
EBITDA - Fully Alloc. (No Tail/Bonus) |  |  | 7000 Primary Care | 2012 | Providers |  |  |  |  | -301149.9879752246
[PHONE] Worked RVUs |  |  | 7000 Primary Care | 2012 | Providers |  |  |  |  | 4127.311920555558
999580 Phys Visits |  |  | 7000 Primary Care | 2012 | Providers |  |  |  |  | 3131.175793060809
Net Revenue - Incl Alloc Ded/BD |  |  | 7000 Primary Care | 2011 | Providers |  |  |  | 341503.976117647 | 398576
EBITDA - Fully Alloc. (No Tail/Bonus) |  |  | 7000 Primary Care | 2011 | Providers |  |  |  | 13580.874 | 24980.5613222963
[PHONE] Worked RVUs |  |  | 7000 Primary Care | 2011 | Providers |  |  |  | 0 | 1803.9
999580 Phys Visits |  |  | 7000 Primary Care | 2011 | Providers |  |  |  | 1430.894117647059 | 1718
Net Revenue - Incl Alloc Ded/BD |  |  | 7000 Primary Care | 2010 | Providers |  |  | 216380.6619101123 | 218146.645625 | 236080.4768719065
EBITDA - Fully Alloc. (No Tail/Bonus) |  |  | 7000 Primary Care | 2010 | Providers |  |  | -193038.2393258426 | -115093.5717708333 | -111656.052962857
[PHONE] Worked RVUs |  |  | 7000 Primary Care | 2010 | Providers |  |  | 1367.796404494382 | 2337.783645833333 | 3220.687871013827
999580 Phys Visits |  |  | 7000 Primary Care | 2010 | Providers |  |  | 2426.713483146067 | 2439.322916666667 | 2623.38758871694
Net Revenue - Incl Alloc Ded/BD |  |  | 7000 Primary Care | 2009 | Providers |  |  | 85857.17614035086 | 184330.978125 | 220043.7541569844
EBITDA - Fully Alloc. (No Tail/Bonus) |  |  | 7000 Primary Care | 2009 | Providers |  |  | -358509.823859649 | -273612.5410416667 | -252187.5912098123
[PHONE] Worked RVUs |  |  | 7000 Primary Care | 2009 | Providers |  |  | 1631.860526315789 | 2746.964583333333 | 2921.442204749217
999580 Phys Visits |  |  | 7000 Primary Care | 2009 | Providers |  |  | 1221.561403508771 | 2052.354166666666 | 2413.496180485881
Net Revenue - Incl Alloc Ded/BD |  |  | 7000 Primary Care | 2008 | Providers
EBITDA - Fully Alloc. (No Tail/Bonus) |  |  | 7000 Primary Care | 2008 | Providers
[PHONE] Worked RVUs |  |  | 7000 Primary Care | 2008 | Providers
999580 Phys Visits |  |  | 7000 Primary Care | 2008 | Providers
Net Revenue - Incl Alloc Ded/BD |  |  | 7000 Primary Care | 2007 | Providers
EBITDA - Fully Alloc. (No Tail/Bonus) |  |  | 7000 Primary Care | 2007 | Providers
[PHONE] Worked RVUs |  |  | 7000 Primary Care | 2007 | Providers
999580 Phys Visits |  |  | 7000 Primary Care | 2007 | Providers
Net Revenue - Incl Alloc Ded/BD |  |  | 7000 Primary Care | 2006 | Providers
EBITDA - Fully Alloc. (No Tail/Bonus) |  |  | 7000 Primary Care | 2006 | Providers
[PHONE] Worked RVUs |  |  | 7000 Primary Care | 2006 | Providers
999580 Phys Visits |  |  | 7000 Primary Care | 2006 | Providers
Net Revenue - Incl Alloc Ded/BD |  |  | 7000 Primary Care | 2005 | Providers
EBITDA - Fully Alloc. (No Tail/Bonus) |  |  | 7000 Primary Care | 2005 | Providers
[PHONE] Worked RVUs |  |  | 7000 Primary Care | 2005 | Providers
999580 Phys Visits |  |  | 7000 Primary Care | 2005 | Providers
Net Revenue - Incl Alloc Ded/BD |  |  | 7000 Specialists | 2012 | Providers |  |  |  |  | 693313.5424084384
EBITDA - Fully Alloc. (No Tail/Bonus) |  |  | 7000 Specialists | 2012 | Providers |  |  |  |  | -347518.661199235
[PHONE] Worked RVUs |  |  | 7000 Specialists | 2012 | Providers |  |  |  |  | 8739.779954954955
999580 Phys Visits |  |  | 7000 Specialists | 2012 | Providers |  |  |  |  | 2460.337837837837
Net Revenue - Incl Alloc Ded/BD |  |  | 7000 Specialists | 2011 | Providers |  |  |  | 197344.2384453781 | 311419.3596179365
EBITDA - Fully Alloc. (No Tail/Bonus) |  |  | 7000 Specialists | 2011 | Providers |  |  |  | -418547.6822268908 | -293726.0326347816
[PHONE] Worked RVUs |  |  | 7000 Specialists | 2011 | Providers |  |  |  | 3005.184705882353 | 4250.065
999580 Phys Visits |  |  | 7000 Specialists | 2011 | Providers |  |  |  | 564.7689075630252 | 1034
Net Revenue - Incl Alloc Ded/BD |  |  | 7000 Specialists | 2010 | Providers |  |  | 228163.4240222575 | 277491.7059027778 | 464215.5013030042
EBITDA - Fully Alloc. (No Tail/Bonus) |  |  | 7000 Specialists | 2010 | Providers |  |  | -449325.1973131955 | -424114.0585416667 | -274088.2364892289
[PHONE] Worked RVUs |  |  | 7000 Specialists | 2010 | Providers |  |  | 4239.420095389507 | 5659.315763888889 | 7343.138333333333
999580 Phys Visits |  |  | 7000 Specialists | 2010 | Providers |  |  | 759.3481717011127 | 1213.972222222222 | 1506
Net Revenue - Incl Alloc Ded/BD |  |  | 7000 Specialists | 2009 | Providers |  |  | 504814.1366355142 | 356337.7220906707 | 664127.771434295
EBITDA - Fully Alloc. (No Tail/Bonus) |  |  | 7000 Specialists | 2009 | Providers |  |  | -308795.5816822432 | -407368.3658149119 | -222893.6213473212
[PHONE] Worked RVUs |  |  | 7000 Specialists | 2009 | Providers |  |  | 8361.731775700937 | 7483.330588235295 | 9169.978641010508
999580 Phys Visits |  |  | 7000 Specialists | 2009 | Providers |  |  | 1731.953271028038 | 1689.1168977145 | 2035.103709074712
Net Revenue - Incl Alloc Ded/BD |  |  | 7000 Specialists | 2008 | Providers |  |  | 231220.6819844359 | 295772.9816666666 | 318627.0518720227
EBITDA - Fully Alloc. (No Tail/Bonus) |  |  | 7000 Specialists | 2008 | Providers |  |  | -462534.2779377432 | -381220.6600000001 | -243913.1837013501
[PHONE] Worked RVUs |  |  | 7000 Specialists | 2008 | Providers |  |  | 4217.170972762647 | 4490.347916666669 | 4777.85
999580 Phys Visits |  |  | 7000 Specialists | 2008 | Providers |  |  | 1186.178988326848 | 1120.125 | 1241
Net Revenue - Incl Alloc Ded/BD |  |  | 7000 Specialists | 2007 | Providers
EBITDA - Fully Alloc. (No Tail/Bonus) |  |  | 7000 Specialists | 2007 | Providers
[PHONE] Worked RVUs |  |  | 7000 Specialists | 2007 | Providers
999580 Phys Visits |  |  | 7000 Specialists | 2007 | Providers
Net Revenue - Incl Alloc Ded/BD |  |  | 7000 Specialists | 2006 | Providers
EBITDA - Fully Alloc. (No Tail/Bonus) |  |  | 7000 Specialists | 2006 | Providers
[PHONE] Worked RVUs |  |  | 7000 Specialists | 2006 | Providers
999580 Phys Visits |  |  | 7000 Specialists | 2006 | Providers
Net Revenue - Incl Alloc Ded/BD |  |  | 7000 Specialists | 2005 | Providers
EBITDA - Fully Alloc. (No Tail/Bonus) |  |  | 7000 Specialists | 2005 | Providers
[PHONE] Worked RVUs |  |  | 7000 Specialists | 2005 | Providers
999580 Phys Visits |  |  | 7000 Specialists | 2005 | Providers
Provider Total
Net Revenue - Incl Alloc Ded/BD |  |  | 7000 Primary Care | Class Tot | Providers |  |  | 302237.8380504632 | 743981.599867647 | 1117105.402864114
EBITDA - Fully Alloc. (No Tail/Bonus) |  |  | 7000 Primary Care | Class Tot | Providers |  |  | -551548.0631854916 | -375125.2388125 | -640013.0708255975
[PHONE] Worked RVUs |  |  | 7000 Primary Care | Class Tot | Providers |  |  | 2999.656930810171 | 5084.748229166667 | 12073.3419963186
999580 Phys Visits |  |  | 7000 Primary Care | Class Tot | Providers |  |  | 3648.274886654839 | 5922.571200980392 | 9886.05956226363
Net Revenue - Incl Alloc Ded/BD |  |  | 7000 Specialists | Class Tot | Providers |  |  | 964198.2426422075 | 1126946.648105493 | 2451703.226635697
EBITDA - Fully Alloc. (No Tail/Bonus) |  |  | 7000 Specialists | Class Tot | Providers |  |  | -1220655.056933182 | -1631250.766583469 | -1382139.735371917
[PHONE] Worked RVUs |  |  | 7000 Specialists | Class Tot | Providers |  |  | 16818.32284385309 | 20638.17897467321 | 34280.8119292988
999580 Phys Visits |  |  | 7000 Specialists | Class Tot | Providers |  |  | 3677.480431055998 | 4587.983027499748 | 8276.441546912549
Net Revenue - Incl Alloc Ded/BD |  |  | Tot Depts | Class Tot | Providers |  |  | 1266436.080692671 | 1870928.24797314 | 3568808.629499811
EBITDA - Fully Alloc. (No Tail/Bonus) |  |  | Tot Depts | Class Tot | Providers |  |  | -1772203.120118673 | -2006376.005395969 | -2022152.806197514
[PHONE] Worked RVUs |  |  | Tot Depts | Class Tot | Providers |  |  | 19817.97977466326 | 25722.92720383987 | 46354.1539256174
999580 Phys Visits |  |  | Tot Depts | Class Tot | Providers |  |  | 7325.755317710837 | 10510.55422848014 | 18162.50110917618
Extender Total
Net Revenue - Incl Alloc Ded/BD |  |  | 7000 Primary Care |  | Extender |  |  | 0 | 48484.57285371701 | 62991.24300318931
EBITDA - Fully Alloc. (No Tail/Bonus) |  |  | 7000 Primary Care |  | Extender |  |  | -175474.2545454545 | -148698.1356354916 | -128145.4370214529
[PHONE] Worked RVUs |  |  | 7000 Primary Care |  | Extender |  |  | 0 | 0 | 0.6440352513867779
999580 Phys Visits |  |  | 7000 Primary Care |  | Extender |  |  | 0 | 460.6618705035971 | 763.8328155641618
Net Revenue - Incl Alloc Ded/BD |  |  | 7000 Specialists |  | Extender |  |  | 101196.0285872576 | 117686.1471932965 | 96937.39876727074
EBITDA - Fully Alloc. (No Tail/Bonus) |  |  | 7000 Specialists |  | Extender |  |  | -382429.2444569658 | -464180.4256503728 | -3346.981249605206
[PHONE] Worked RVUs |  |  | 7000 Specialists |  | Extender |  |  | 0.6836528162511541 | 1.467589411540659 | 0.8571884469642843
999580 Phys Visits |  |  | 7000 Specialists |  | Extender |  |  | 2311.645429362881 | 859.8535897924203 | 871.3861568341105
Net Revenue - Incl Alloc Ded/BD |  |  | Tot Depts |  | Extender |  |  | 101196.0285872576 | 166170.7200470135 | 159928.6417704601
EBITDA - Fully Alloc. (No Tail/Bonus) |  |  | Tot Depts |  | Extender |  |  | -557903.4990024203 | -612878.5612858643 | -131492.4182710581
[PHONE] Worked RVUs |  |  | Tot Depts |  | Extender |  |  | 0.6836528162511541 | 1.467589411540659 | 1.501223698351062
999580 Phys Visits |  |  | Tot Depts |  | Extender |  |  | 2311.645429362881 | 1320.515460296017 | 1635.218972398272