e Home Insert Draw v Paste X Calibri Page Layout Formulas Data Review View Help 11 A A = v A E Alignment E Accounting 0 %9 Number Z Conditional Formatting Format as Table Cell Styles Styles Undo Clipboard 124 4 5 6 A Paid to BIU Font vXfx=SUM(C24:F24) B Share Amount Net Bonus Bonus Percentage C D E F G H $1,250.00 $1,250.00 $1,250.00 $16,237.55 $15,996.11 $11,615.38 $1,250.00 $11,509.41 $5,000.00 $55,358.44 35% 17 18 19 20 21 22 23 24 25 26 Projections Department General Medicine Laboratory Radiology Wellness Total Projected Revenue Quarter 1 Quarter 2 Quarter 3 Quarter 4 Trend $121,749.50 $126,672.60 $ 130,152.70 $127,829.75 55,827.25 49,623.20 44,339.75 43,973.35 37,330.70 34,667.74 32,084.48 31,974.90 23,307.55 23,802.25 23,001.73 23,782.10 $238,215.00 $234,765.79 $229,578.66 $227,560.10 What-If Assumptions 27 28 29 30 Revenue +/- Department Increase % General Medicine 8.8% Laboratory Radiology Documentation 5.0% 5.5% Department Analysis Studies + Ready Accessibility: Investigate Total $ 506,404.55 193,763.55 136,057.82 93,893.63 $ 930,119.55