Spreadsheet: 121641d1316210689-formula-returning-a-value-error-div-error
Sheet: Termed

 |  |  |  |  |  |  |  | 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 |  | Budget |  |  | Actual
 |  |  |  |  |  |  |  | FY10 |  | FY12 |  |  | FY11
 |  |  |  |  |  |  |  | YearTotal |  | YearTotal |  |  | Y-T-D(Jul)
Net Revenue - Incl Alloc Ded/BD |  |  | 7000 Primary Care | 2012 | Termed |  |  | 0 | 0 | 0 |  |  | 0
EBITDA - Fully Alloc. (No Tail/Bonus) |  |  | 7000 Primary Care | 2012 | Termed |  |  | 0 | 0 | 0 |  |  | 0
[PHONE] Worked RVUs |  |  | 7000 Primary Care | 2012 | Termed |  |  | 0 | 0 | 0 |  |  | 0
999580 Phys Visits |  |  | 7000 Primary Care | 2012 | Termed |  |  | 0 | 0 | 0 |  |  | 0
Reg FTEs-Providers |  |  | 7000 Primary Care | 2012 | Termed |  |  | 0 | 0 | 0 |  |  | 0
Total Physician Hours |  |  | 7000 Primary Care | 2012 | Termed |  |  | 0 | 0 | 0 |  |  | 0
Total Mid-Level Hours |  |  | 7000 Primary Care | 2012 | Termed |  |  | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0
Net Revenue - Incl Alloc Ded/BD |  |  | 7000 Primary Care | 2011 | Termed |  |  | 0 | 0 | 0 |  |  | 0
EBITDA - Fully Alloc. (No Tail/Bonus) |  |  | 7000 Primary Care | 2011 | Termed |  |  | 0 | 0 | 0 |  |  | 0
[PHONE] Worked RVUs |  |  | 7000 Primary Care | 2011 | Termed |  |  | 0 | 0 | 0 |  |  | 0
999580 Phys Visits |  |  | 7000 Primary Care | 2011 | Termed |  |  | 0 | 0 | 0 |  |  | 0
Reg FTEs-Providers |  |  | 7000 Primary Care | 2011 | Termed |  |  | 0 | 0 | 0 |  |  | 0
Total Physician Hours |  |  | 7000 Primary Care | 2011 | Termed |  |  | 0 | 0 | 0 |  |  | 0
Total Mid-Level Hours |  |  | 7000 Primary Care | 2011 | Termed |  |  | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0
Net Revenue - Incl Alloc Ded/BD |  |  | 7000 Primary Care | 2010 | Termed |  |  | 0 | 0 | 0 |  |  | 0
EBITDA - Fully Alloc. (No Tail/Bonus) |  |  | 7000 Primary Care | 2010 | Termed |  |  | 0 | 0 | 0 |  |  | 0
[PHONE] Worked RVUs |  |  | 7000 Primary Care | 2010 | Termed |  |  | 0 | 0 | 0 |  |  | 0
999580 Phys Visits |  |  | 7000 Primary Care | 2010 | Termed |  |  | 0 | 0 | 0 |  |  | 0
Reg FTEs-Providers |  |  | 7000 Primary Care | 2010 | Termed |  |  | 0 | 0 | 0 |  |  | 0
Total Physician Hours |  |  | 7000 Primary Care | 2010 | Termed |  |  | 0 | 0 | 0 |  |  | 0
Total Mid-Level Hours |  |  | 7000 Primary Care | 2010 | Termed |  |  | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0
Net Revenue - Incl Alloc Ded/BD |  |  | 7000 Primary Care | 2009 | Termed |  |  | 518865.72 | 199259.868 | 0 |  |  | 166049.89
EBITDA - Fully Alloc. (No Tail/Bonus) |  |  | 7000 Primary Care | 2009 | Termed |  |  | -929449.39 | -272732.82 | 0 |  |  | -227277.35
[PHONE] Worked RVUs |  |  | 7000 Primary Care | 2009 | Termed |  |  | 5963.53 | 2826.18 | 0 |  |  | 2355.15
999580 Phys Visits |  |  | 7000 Primary Care | 2009 | Termed |  |  | 6851 | 2630.4 | 0 |  |  | 2192
Reg FTEs-Providers |  |  | 7000 Primary Care | 2009 | Termed |  |  | 3.689655172413793 | 1.029885057471264 | 0 |  |  | 0
Total Physician Hours |  |  | 7000 Primary Care | 2009 | Termed |  |  | 6656 | 2150.4 | 0 |  |  | 1792
Total Mid-Level Hours |  |  | 7000 Primary Care | 2009 | Termed |  |  | 1032 | 0 | 0 |  |  | 0
 |  |  |  |  |  |  |  | 3.681992337164751 | 1.029885057471264 | 0
Net Revenue - Incl Alloc Ded/BD |  |  | 7000 Primary Care | 2008 | Termed |  |  | 269987.53 | 0 | 0 |  |  | 0
EBITDA - Fully Alloc. (No Tail/Bonus) |  |  | 7000 Primary Care | 2008 | Termed |  |  | -32720.39 | -8501.412 | 0 |  |  | -7084.51
[PHONE] Worked RVUs |  |  | 7000 Primary Care | 2008 | Termed |  |  | 0 | 0 | 0 |  |  | 0
999580 Phys Visits |  |  | 7000 Primary Care | 2008 | Termed |  |  | 2923 | 0 | 0 |  |  | 0
Reg FTEs-Providers |  |  | 7000 Primary Care | 2008 | Termed |  |  | 1.065134099616858 | 0.004597701149425288 | 0 |  |  | 0
Total Physician Hours |  |  | 7000 Primary Care | 2008 | Termed |  |  | 2024 | 9.600000000000001 | 0 |  |  | 8
Total Mid-Level Hours |  |  | 7000 Primary Care | 2008 | Termed |  |  | 200 | 0 | 0 |  |  | 0
 |  |  |  |  |  |  |  | 1.065134099616858 | 0.004597701149425288 | 0
Net Revenue - Incl Alloc Ded/BD |  |  | 7000 Primary Care | 2007 | Termed |  |  | 0 | 0 | 0 |  |  | 0
EBITDA - Fully Alloc. (No Tail/Bonus) |  |  | 7000 Primary Care | 2007 | Termed |  |  | 0 | 0 | 0 |  |  | 0
[PHONE] Worked RVUs |  |  | 7000 Primary Care | 2007 | Termed |  |  | 0 | 0 | 0 |  |  | 0
999580 Phys Visits |  |  | 7000 Primary Care | 2007 | Termed |  |  | 0 | 0 | 0 |  |  | 0
Reg FTEs-Providers |  |  | 7000 Primary Care | 2007 | Termed |  |  | 0 | 0 | 0 |  |  | 0
Total Physician Hours |  |  | 7000 Primary Care | 2007 | Termed |  |  | 0 | 0 | 0 |  |  | 0
Total Mid-Level Hours |  |  | 7000 Primary Care | 2007 | Termed |  |  | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0
Net Revenue - Incl Alloc Ded/BD |  |  | 7000 Primary Care | 2006 | Termed |  |  | 0 | 0 | 0 |  |  | 0
EBITDA - Fully Alloc. (No Tail/Bonus) |  |  | 7000 Primary Care | 2006 | Termed |  |  | 0 | 0 | 0 |  |  | 0
[PHONE] Worked RVUs |  |  | 7000 Primary Care | 2006 | Termed |  |  | 0 | 0 | 0 |  |  | 0
999580 Phys Visits |  |  | 7000 Primary Care | 2006 | Termed |  |  | 0 | 0 | 0 |  |  | 0
Reg FTEs-Providers |  |  | 7000 Primary Care | 2006 | Termed |  |  | 0 | 0 | 0 |  |  | 0
Total Physician Hours |  |  | 7000 Primary Care | 2006 | Termed |  |  | 0 | 0 | 0 |  |  | 0
Total Mid-Level Hours |  |  | 7000 Primary Care | 2006 | Termed |  |  | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0
Net Revenue - Incl Alloc Ded/BD |  |  | 7000 Primary Care | 2005 | Termed |  |  | 0 | 0 | 0 |  |  | 0
EBITDA - Fully Alloc. (No Tail/Bonus) |  |  | 7000 Primary Care | 2005 | Termed |  |  | 0 | 0 | 0 |  |  | 0
[PHONE] Worked RVUs |  |  | 7000 Primary Care | 2005 | Termed |  |  | 0 | 0 | 0 |  |  | 0
999580 Phys Visits |  |  | 7000 Primary Care | 2005 | Termed |  |  | 0 | 0 | 0 |  |  | 0
Reg FTEs-Providers |  |  | 7000 Primary Care | 2005 | Termed |  |  | 0 | 0 | 0 |  |  | 0
Total Physician Hours |  |  | 7000 Primary Care | 2005 | Termed |  |  | 0 | 0 | 0 |  |  | 0
Total Mid-Level Hours |  |  | 7000 Primary Care | 2005 | Termed |  |  | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0
Net Revenue - Incl Alloc Ded/BD |  |  | 7000 Specialists | 2012 | Termed |  |  | 0 | 0 | 0 |  |  | 0
EBITDA - Fully Alloc. (No Tail/Bonus) |  |  | 7000 Specialists | 2012 | Termed |  |  | 0 | 0 | 0 |  |  | 0
[PHONE] Worked RVUs |  |  | 7000 Specialists | 2012 | Termed |  |  | 0 | 0 | 0 |  |  | 0
999580 Phys Visits |  |  | 7000 Specialists | 2012 | Termed |  |  | 0 | 0 | 0 |  |  | 0
Reg FTEs-Providers |  |  | 7000 Specialists | 2012 | Termed |  |  | 0 | 0 | 0 |  |  | 0
Total Physician Hours |  |  | 7000 Specialists | 2012 | Termed |  |  | 0 | 0 | 0 |  |  | 0
Total Mid-Level Hours |  |  | 7000 Specialists | 2012 | Termed |  |  | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0
Net Revenue - Incl Alloc Ded/BD |  |  | 7000 Specialists | 2011 | Termed |  |  | 0 | 0 | 0 |  |  | 0
EBITDA - Fully Alloc. (No Tail/Bonus) |  |  | 7000 Specialists | 2011 | Termed |  |  | 0 | 0 | 0 |  |  | 0
[PHONE] Worked RVUs |  |  | 7000 Specialists | 2011 | Termed |  |  | 0 | 0 | 0 |  |  | 0
999580 Phys Visits |  |  | 7000 Specialists | 2011 | Termed |  |  | 0 | 0 | 0 |  |  | 0
Reg FTEs-Providers |  |  | 7000 Specialists | 2011 | Termed |  |  | 0 | 0 | 0 |  |  | 0
Total Physician Hours |  |  | 7000 Specialists | 2011 | Termed |  |  | 0 | 0 | 0 |  |  | 0
Total Mid-Level Hours |  |  | 7000 Specialists | 2011 | Termed |  |  | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0
Net Revenue - Incl Alloc Ded/BD |  |  | 7000 Specialists | 2010 | Termed |  |  | 258735.16 | -28915.464 | 0 |  |  | -24096.22
EBITDA - Fully Alloc. (No Tail/Bonus) |  |  | 7000 Specialists | 2010 | Termed |  |  | -223674.16 | -292016.448 | -1 |  |  | -243347.04
[PHONE] Worked RVUs |  |  | 7000 Specialists | 2010 | Termed |  |  | 2863.46 | 3735.84 | 0 |  |  | 3113.2
999580 Phys Visits |  |  | 7000 Specialists | 2010 | Termed |  |  | 243 | 661.2 | 0 |  |  | 551
Reg FTEs-Providers |  |  | 7000 Specialists | 2010 | Termed |  |  | 0.9195402298850575 | 1.213793103448276 | 0 |  |  | 0
Total Physician Hours |  |  | 7000 Specialists | 2010 | Termed |  |  | 1920 | 2534.4 | 0 |  |  | 2112
Total Mid-Level Hours |  |  | 7000 Specialists | 2010 | Termed |  |  | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  |  |  | 0.9195402298850575 | 1.213793103448276 | 0
Net Revenue - Incl Alloc Ded/BD |  |  | 7000 Specialists | 2009 | Termed |  |  | 3603477.82 | 427384.8479999999 | 0 |  |  | 356154.04
EBITDA - Fully Alloc. (No Tail/Bonus) |  |  | 7000 Specialists | 2009 | Termed |  |  | -1908752.05 | -483196.956 | 0 |  |  | -402664.13
[PHONE] Worked RVUs |  |  | 7000 Specialists | 2009 | Termed |  |  | 42482.04 | 10476.084 | 0 |  |  | 8730.07
999580 Phys Visits |  |  | 7000 Specialists | 2009 | Termed |  |  | 5776 | 1161.6 | 0 |  |  | 968
Reg FTEs-Providers |  |  | 7000 Specialists | 2009 | Termed |  |  | 6.888888888888889 | 2.340229885057471 | 0 |  |  | 0
Total Physician Hours |  |  | 7000 Specialists | 2009 | Termed |  |  | 14376 | 4886.4 | 0 |  |  | 4072
Total Mid-Level Hours |  |  | 7000 Specialists | 2009 | Termed |  |  | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  |  |  | 6.885057471264368 | 2.340229885057471 | 0
Net Revenue - Incl Alloc Ded/BD |  |  | 7000 Specialists | 2008 | Termed |  |  | 658066.07 | 409542.6 | 0 |  |  | 341285.5
EBITDA - Fully Alloc. (No Tail/Bonus) |  |  | 7000 Specialists | 2008 | Termed |  |  | -10639.47 | -12862.692 | 0 |  |  | -10718.91
[PHONE] Worked RVUs |  |  | 7000 Specialists | 2008 | Termed |  |  | 5161.49 | 4950.732 | 0 |  |  | 4125.61
999580 Phys Visits |  |  | 7000 Specialists | 2008 | Termed |  |  | 0 | 0 | 0 |  |  | 0
Reg FTEs-Providers |  |  | 7000 Specialists | 2008 | Termed |  |  | 0.9348659003831418 | 0.7954022988505748 | 0 |  |  | 0
Total Physician Hours |  |  | 7000 Specialists | 2008 | Termed |  |  | 1952 | 1660.8 | 0 |  |  | 1384
Total Mid-Level Hours |  |  | 7000 Specialists | 2008 | Termed |  |  | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  |  |  | 0.9348659003831418 | 0.7954022988505748 | 0
Net Revenue - Incl Alloc Ded/BD |  |  | 7000 Specialists | 2007 | Termed |  |  | 0 | 0 | 0 |  |  | 0
EBITDA - Fully Alloc. (No Tail/Bonus) |  |  | 7000 Specialists | 2007 | Termed |  |  | 0 | 0 | 0 |  |  | 0
[PHONE] Worked RVUs |  |  | 7000 Specialists | 2007 | Termed |  |  | 0 | 0 | 0 |  |  | 0
999580 Phys Visits |  |  | 7000 Specialists | 2007 | Termed |  |  | 0 | 0 | 0 |  |  | 0
Reg FTEs-Providers |  |  | 7000 Specialists | 2007 | Termed |  |  | 0 | 0 | 0 |  |  | 0
Total Physician Hours |  |  | 7000 Specialists | 2007 | Termed |  |  | 0 | 0 | 0 |  |  | 0
Total Mid-Level Hours |  |  | 7000 Specialists | 2007 | Termed |  |  | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0
Net Revenue - Incl Alloc Ded/BD |  |  | 7000 Specialists | 2006 | Termed |  |  | 47133.99 | 26530.392 | 0 |  |  | 22108.66
EBITDA - Fully Alloc. (No Tail/Bonus) |  |  | 7000 Specialists | 2006 | Termed |  |  | -253777.17 | -25186.152 | 0 |  |  | -20988.46
[PHONE] Worked RVUs |  |  | 7000 Specialists | 2006 | Termed |  |  | 0 | 391.6200000000001 | 0 |  |  | 326.35
999580 Phys Visits |  |  | 7000 Specialists | 2006 | Termed |  |  | 2432 | 358.8 | 0 |  |  | 299
Reg FTEs-Providers |  |  | 7000 Specialists | 2006 | Termed |  |  | 0.7152777777777778 | 0.0889367816091954 | 0 |  |  | 0
Total Physician Hours |  |  | 7000 Specialists | 2006 | Termed |  |  | 0 | 0 | 0 |  |  | 0
Total Mid-Level Hours |  |  | 7000 Specialists | 2006 | Termed |  |  | 1508.75 | 185.7 | 0 |  |  | 154.75
 |  |  |  |  |  |  |  | 0.7225814176245211 | 0.0889367816091954 | 0
Net Revenue - Incl Alloc Ded/BD |  |  | 7000 Specialists | 2005 | Termed |  |  | 0 | 0 | 0 |  |  | 0
EBITDA - Fully Alloc. (No Tail/Bonus) |  |  | 7000 Specialists | 2005 | Termed |  |  | 0 | 0 | 0 |  |  | 0
[PHONE] Worked RVUs |  |  | 7000 Specialists | 2005 | Termed |  |  | 0 | 0 | 0 |  |  | 0
999580 Phys Visits |  |  | 7000 Specialists | 2005 | Termed |  |  | 0 | 0 | 0 |  |  | 0
Reg FTEs-Providers |  |  | 7000 Specialists | 2005 | Termed |  |  | 0 | 0 | 0 |  |  | 0
Total Physician Hours |  |  | 7000 Specialists | 2005 | Termed |  |  | 0 | 0 | 0 |  |  | 0
Total Mid-Level Hours |  |  | 7000 Specialists | 2005 | Termed |  |  | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  | 0
Net Revenue - Incl Alloc Ded/BD |  |  | 7000 Primary Care |  | Termed |  |  | 165907.0896454472 | 192617.8724000001
EBITDA - Fully Alloc. (No Tail/Bonus) |  |  | 7000 Primary Care |  | Termed |  |  | -202358.0278646253 | -271859.7576000001
[PHONE] Worked RVUs |  |  | 7000 Primary Care |  | Termed |  |  | 1254.215414987913 | 2731.974000000001
999580 Phys Visits |  |  | 7000 Primary Care |  | Termed |  |  | 2055.611603545528 | 2542.72
Net Revenue - Incl Alloc Ded/BD |  |  | 7000 Specialists |  | Termed |  |  | 482886.0693951745 | 188029.3592619209
EBITDA - Fully Alloc. (No Tail/Bonus) |  |  | 7000 Specialists |  | Termed |  |  | -253404.2821742322 | -183234.7688996795
[PHONE] Worked RVUs |  |  | 7000 Specialists |  | Termed |  |  | 5339.810887364237 | 4405.74150917743
999580 Phys Visits |  |  | 7000 Specialists |  | Termed |  |  | 893.475176586749 | 491.5326794211906
Net Revenue - Incl Alloc Ded/BD |  |  | Tot Depts |  | Termed |  |  | 648793.1590406217 | 380647.231661921 | #N/A
EBITDA - Fully Alloc. (No Tail/Bonus) |  |  | Tot Depts |  | Termed |  |  | -455762.3100388576 | -455094.5264996796 | #N/A
[PHONE] Worked RVUs |  |  | Tot Depts |  | Termed |  |  | 6594.026302352149 | 7137.715509177431 | #N/A
999580 Phys Visits |  |  | Tot Depts |  | Termed |  |  | 2949.086780132277 | 3034.25267942119 | #N/A