{"text_format":"1","workbook":"xlsx","n_sheets":24,"sheets":["Cover","Start","Header","1. Instructions","2. Hospital Information","3. Key Assumptions","4. Clinical Staffing Coverage","5. Staffing Costs","6. Capital Costs","7. Operating Costs","8. Expected Revenue","9. Pro Forma","10. Feasibility Results","Scenario Data","Data Tables","Scenario Model","Avg Cost Curve","Expense Summary","Assumptions","3 Model Graph","FED FAST Inputs","Definitions","References","Acknowledgements"],"not_rendered":{"charts":10,"images":13,"macros":1,"external_links":0,"defined_names":49,"comments":0,"pivot_tables":6},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Cover","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Start","index":1,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Welcome to the FED FAST"]
[null,"The Freestanding Emergency Department Financial Assessment Strategic Tool"]

{"sheet":"Header","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"1. Instructions","index":3,"n_rows":80,"n_cols":18,"rows_kept":80,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"1. Instructions",null,null,null,null,"6. Capital Costs"]
[null,null,"2. Hospital Information",null,null,null,null,"7. Operating Costs"]
[null,null,"3. Key Assumptions",null,null,null,null,"8. Expected Revenue"]
[null,null,"4. Clinical Staffing Coverage",null,null,null,null,"9. Pro Forma"]
[null,null,"5. Staffing Costs",null,null,null,null,"10. Feasibility Results"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"FED FAST References",null,null,"FED FAST Definitions",null,null,"List of Inputs for the FED FAST"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"                                                                                  "]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Yellow shaded cells require user input for the line item"]
[]
[null,"Green shaded cells indicate assumptions for the feasibility analysis"]
[]
[null,"Grey shaded cells are intermediate calculations"]
[]
[null,"Orange shaded cells are calculations that feed into the feasibility analysis"]
[]
[null,"Blue shaded cells reflect final output"]
[]
[null,"Dark Blue shaded boxes with white text indicate links to important information"]
[]
[null,"The \"Info\" symbol indicates a helpful tip for using the tool. "]
[]
[null,"The \"?\" symbol indicates important information about data presented in the tool."]
[]
[null,"Click the \"Home\" button at the top of the page to return to the Instructions page."]
[]
[null,"Click the \"Next\" buttons to move to the next worksheet. "]
[]
[null,"Click the \"Back\" buttons to go back to the previous worksheet. "]

{"sheet":"2. Hospital Information","index":4,"n_rows":221,"n_cols":62,"rows_kept":221,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"Please enter information about your organization in the space provided."]
[]
[]
[]
[null,"Hospital Name","General Hospital"]
[]
[null,"Hospital State","North Carolina",{"$f":"HYPERLINK(\"#\"&ADDRESS(ROW(),COLUMN()-1),CHAR(128))","v":"€"}]
[]
[null,"Affiliation with Hospital System?","Yes",{"$f":"HYPERLINK(\"#\"&ADDRESS(ROW(),COLUMN()-1),CHAR(128))","v":"€"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Organizational Cost of Capital",0.04,{"$f":"HYPERLINK(\"#\"&ADDRESS(ROW(),COLUMN()-1),CHAR(128))","v":"€"}]
[]
[null,"Organizational Tax Rate",0]
[]
[null,"Number of ED Patient Beds",12]
[]
[null,"Average Monthly ED Visits",{"$f":"(10607)/12","v":883.91666666666663}]
[]
[]
[]
[]
[null,"Average Monthly Outpatient Visits",{"$f":"EDMonthlyVolume*1.25","v":1104.8958333333333}]
[]
[null,"Number of Hospitals/EDs                     within 35 Mile Radius",1]
[]
[null,"Number of Outpatient Lab/Imaging Facilities within 35 Mile Radius",3]
[]
[null,"Estimated ED Square Footage",{"$f":"NumberBeds*1666.66","v":19999.920000000002}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(Expansion,C12)>0","v":false}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Medicaid Expansion",null,null,null,"No Expansion"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Alabama"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Alaska",null,0.03,null,1,"Arizona",null,null,1,"Alabama"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Arizona",null,0.04,null,2,"Arkansas",null,null,2,"Alaska"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Arkansas",null,0.05,null,3,"California",null,null,3,"Florida"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"California",null,0.06,null,4,"Colorado",null,null,4,"Georgia"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Colorado",null,0.08,null,5,"Connecticut",null,null,5,"Idaho"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Connecticut",null,0.1,null,6,"Delaware",null,null,6,"Kansas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Delaware",null,0.12,null,7,"District of Columbia",null,null,7,"Louisiana"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Florida",null,0.15,null,8,"Hawaii",null,null,8,"Maine"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Georgia",null,0.19,null,9,"Illinois",null,null,9,"Mississippi"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Hawaii",null,0.22,null,10,"Indiana",null,null,10,"Missouri"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"Idaho",null,null,null,11,"Iowa",null,null,11,"Montana"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"Illinois",null,null,null,12,"Kentucky",null,null,12,"Nebraska"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"Indiana",null,null,null,13,"Maryland",null,null,13,"North Carolina"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"Iowa",null,null,null,14,"Massachusetts",null,null,14,"Oklahoma"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"Kansas",null,null,null,15,"Michigan",null,null,15,"South Carolina"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,"Kentucky",null,null,null,16,"Minnesota",null,null,16,"South Dakota"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,"Louisiana",null,null,null,17,"Nevada",null,null,17,"Tennessee"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,"Maine",null,null,null,18,"New Hampshire",null,null,18,"Texas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,"Maryland",null,null,null,19,"New Jersey",null,null,19,"Utah"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,"Massachusetts",null,null,null,20,"New Mexico",null,null,20,"Virginia"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,"Michigan",null,null,null,21,"New York",null,null,21,"Wisconsin"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,"Minnesota",null,null,null,22,"North Dakota",null,null,22,"Wyoming"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,"Mississippi",null,null,null,23,"Ohio",null,null,23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,"Missouri",null,null,null,24,"Oregon",null,null,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,"Montana",null,null,null,25,"Pennsylvania"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,"Nebraska",null,null,null,26,"Rhode Island"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,"Nevada",null,null,null,27,"Vermont"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,"New Hampshire",null,null,null,28,"Washington"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,"New Jersey",null,null,null,29,"West Virginia"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31,"New Mexico"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32,"New York"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33,"North Carolina"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,"North Dakota"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35,"Ohio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,"Oklahoma"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37,"Oregon"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,"Pennsylvania"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39,"Rhode Island"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,"South Carolina"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41,"South Dakota"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42,"Tennessee"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43,"Texas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,"Utah"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,"Vermont"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46,"Virginia"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47,"Washington"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48,"West Virginia"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49,"Wisconsin"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,"Wyoming"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"District of Columbia"]

{"sheet":"3. Key Assumptions","index":5,"n_rows":95,"n_cols":5,"rows_kept":95,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"The calculations provided in this tool are based on the following assumptions. "]
[null,"*Note: The values below can be used as a starting point, but may be modified if you have organization-specific values. "]
[]
[]
[null,"General Assumption(s)"]
[]
[]
[null,"Inflation rate on costs:",null,0.03]
[]
[]
[]
[]
[]
[]
[]
[null,"Volume Assumption(s)"]
[]
[null,"Annual projected demand is based on average monthly visits. "]
[]
[null,"Volume Growth Rate",null,8.8500000000000002E-3,0.03]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Staffing Assumption(s)"]
[]
[]
[null,"Automated staff ratio calculations are dependent on the number of ED beds."]
[]
[null,"Calculated FTEs accounts for budgeted time off. "]
[]
[null,"The staffing model assumes physicians will be employed by the FED."]
[]
[]
[null,"Revenue Assumption(s)"]
[]
[]
[null,"Average charge for ED visit",null,1845]
[]
[]
[]
[]
[null,"Average charge for Outpatient visit",null,1308]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Medicare reimbursement will change annually by:",null,2.1999999999999999E-2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Depreciation Assumption(s)"]
[]
[]
[null,"Avg. Useful life of clinical equipment and office furniture:",null,7]
[]
[null,"Avg. Useful life of computers and technology equipment:",null,3]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Other Assumptions"]
[]
[]
[null,"The desired staffing ratios are based on the number of beds in the facility. "]
[]
[null,"Charges will be the same across all services, and will"]

{"sheet":"4. Clinical Staffing Coverage","index":6,"n_rows":52,"n_cols":9,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"How many beds will each RN be responsible for?",8]
[null,null,null,null,"How many beds will each CNA be responsible for?",12]
[]
[null,null,null,null,"Number of ED Beds in Facility",{"$f":"NumberBeds","v":12}]
[null,null,null,null,"Hours Per Day",24]
[null,null,null,null,"Days in Week",7]
[null,null,null,null,"Hours Worked / Week (1 FTE)",36]
[]
[null,null,null,null,"Providers Needed","Daily RN Hours","Weekly RN Hours","Yearly RN Hours","Total RN FTEs"]
[null,null,null,null,{"$f":"IF((F17<F20),(F20/F17),1)","v":1.5},{"$f":"E26*F21","v":36},{"$f":"F26*F22","v":252},{"$f":"G26*52","v":13104},{"$f":"ROUNDUP(H26/(F23*52),1)","v":7}]
[]
[null,null,null,null,"Providers Needed","Daily CNA Hours","Weekly CNA Hours","Yearly CNA Hours","Total CNA FTEs"]
[null,null,null,null,{"$f":"IF(F18>0,(F20/F18),0)","v":1},{"$f":"E29*F21","v":24},{"$f":"F29*F22","v":168},{"$f":"G29*52","v":8736},{"$f":"ROUNDUP(H29/(F23*52),1)","v":4.6999999999999993}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"How many beds will each MD be responsible for?",8]
[null,null,null,null,"How many beds will each PA be responsible for?",0]
[null,null,null,null,"How many beds will each NP be responsible for?",12]
[]
[null,null,null,null,"Number of Beds",{"$f":"NumberBeds","v":12}]
[null,null,null,null,"Hours Per Day",24]
[null,null,null,null,"Days in Week",7]
[null,null,null,null,"Hours Worked/Week (1 FTE)",36]
[]
[null,null,null,null,"Providers Needed","Daily MD Hours","Weekly MD Hours","Yearly MD Hours","Total MD FTEs"]
[null,null,null,null,{"$f":"(IF((F36<F40),(F40/F36),1))","v":1.5},{"$f":"E46*F41","v":36},{"$f":"F46*F42","v":252},{"$f":"G46*52","v":13104},{"$f":"ROUNDUP(H46/(F43*52),1)","v":7}]
[]
[null,null,null,null,"Providers Needed","Daily PA Hours","Weekly PA Hours","Yearly PA Hours","Total PA FTEs"]
[null,null,null,null,{"$f":"IF(F37>0,ROUNDUP(F40/F37,0),0)","v":0},{"$f":"E49*F41","v":0},{"$f":"F49*F42","v":0},{"$f":"G49*52","v":0},{"$f":"ROUNDUP(H49/(F43*52),1)","v":0}]
[]
[null,null,null,null,"Providers Needed","Daily NP Hours","Weekly NP Hours","Yearly NP Hours","Total NP FTEs"]
[null,null,null,null,{"$f":"(IF(F38>0,ROUNDUP(F40/F38,0),0))/2","v":0.5},{"$f":"E52*F41","v":12},{"$f":"F52*F42","v":84},{"$f":"G52*52","v":4368},{"$f":"ROUNDUP(H52/(F43*52),1)","v":2.4}]

{"sheet":"5. Staffing Costs","index":7,"n_rows":53,"n_cols":7,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"This worksheet calculates the staffing costs for your FED. "]
[]
[null,"Please enter your annual FTEs and staffing costs in the spaces provided below. "]
[]
[null,"Administration","FTEs","Salary","Bonus","Benefits","Total Compensation"]
[null,"Emergency Services Director",1,109918,null,{"$f":"LeadershipCosts[[#This Row],[Salary]]*0.224","v":24621.632000000001},{"$f":"LeadershipCosts[[#This Row],[FTEs]]*SUM(LeadershipCosts[[#This Row],[Salary]:[Benefits]])","v":134539.63200000001}]
[null,"Charge Nurse - ED",1,82319,null,{"$f":"LeadershipCosts[[#This Row],[Salary]]*0.224","v":18439.456000000002},{"$f":"LeadershipCosts[[#This Row],[FTEs]]*SUM(LeadershipCosts[[#This Row],[Salary]:[Benefits]])","v":100758.45600000001}]
[null,"Other",null,null,null,{"$f":"LeadershipCosts[[#This Row],[Salary]]*0.224","v":0},{"$f":"LeadershipCosts[[#This Row],[FTEs]]*SUM(LeadershipCosts[[#This Row],[Salary]:[Benefits]])","v":0}]
[null,"Other",null,null,null,{"$f":"LeadershipCosts[[#This Row],[Salary]]*0.224","v":0},{"$f":"LeadershipCosts[[#This Row],[FTEs]]*SUM(LeadershipCosts[[#This Row],[Salary]:[Benefits]])","v":0}]
[null,"Other",null,null,null,{"$f":"LeadershipCosts[[#This Row],[Salary]]*0.224","v":0},{"$f":"LeadershipCosts[[#This Row],[FTEs]]*SUM(LeadershipCosts[[#This Row],[Salary]:[Benefits]])","v":0}]
[null,"Total",{"$f":"SUBTOTAL(109,LeadershipCosts[FTEs])","v":2},{"$f":"SUBTOTAL(109,LeadershipCosts[Salary])","v":192237},{"$f":"SUBTOTAL(109,LeadershipCosts[Bonus])","v":0},{"$f":"SUBTOTAL(109,LeadershipCosts[Benefits])","v":43061.088000000003},{"$f":"SUBTOTAL(109,LeadershipCosts[Total Compensation])","v":235298.08800000002}]
[null,"Clinical Support","FTEs","Salary","Bonus","Benefits","Total Compensation"]
[null,"Physician - ED / FP",{"$f":"'4. Clinical Staffing Coverage'!I46","v":7},280000,null,{"$f":"ProviderCosts[[#This Row],[Salary]]*0.224","v":62720},{"$f":"ProviderCosts[[#This Row],[FTEs]]*SUM(ProviderCosts[[#This Row],[Salary]:[Benefits]])","v":2399040}]
[null,"Physician Assistant",{"$f":"'4. Clinical Staffing Coverage'!I49","v":0},83425,null,{"$f":"ProviderCosts[[#This Row],[Salary]]*0.224","v":18687.2},{"$f":"ProviderCosts[[#This Row],[FTEs]]*SUM(ProviderCosts[[#This Row],[Salary]:[Benefits]])","v":0}]
[null,"Nurse Practitioner",{"$f":"'4. Clinical Staffing Coverage'!I52","v":2.4},89005,null,{"$f":"ProviderCosts[[#This Row],[Salary]]*0.224","v":19937.12},{"$f":"ProviderCosts[[#This Row],[FTEs]]*SUM(ProviderCosts[[#This Row],[Salary]:[Benefits]])","v":261461.08799999999}]
[null,"Registered Nurse",{"$f":"'4. Clinical Staffing Coverage'!I26","v":7},54900,null,{"$f":"ProviderCosts[[#This Row],[Salary]]*0.224","v":12297.6},{"$f":"ProviderCosts[[#This Row],[FTEs]]*SUM(ProviderCosts[[#This Row],[Salary]:[Benefits]])","v":470383.20000000007}]
[null,"C N A / EMT",{"$f":"'4. Clinical Staffing Coverage'!I29","v":4.6999999999999993},26906,null,{"$f":"ProviderCosts[[#This Row],[Salary]]*0.224","v":6026.9440000000004},{"$f":"ProviderCosts[[#This Row],[FTEs]]*SUM(ProviderCosts[[#This Row],[Salary]:[Benefits]])","v":154784.83679999999}]
[null,"Unit Coordinator",2.4,34000,null,{"$f":"ProviderCosts[[#This Row],[Salary]]*0.224","v":7616},{"$f":"ProviderCosts[[#This Row],[FTEs]]*SUM(ProviderCosts[[#This Row],[Salary]:[Benefits]])","v":99878.399999999994}]
[null,"Medical Scribe",0,36140,null,{"$f":"ProviderCosts[[#This Row],[Salary]]*0.224","v":8095.3600000000006},{"$f":"ProviderCosts[[#This Row],[FTEs]]*SUM(ProviderCosts[[#This Row],[Salary]:[Benefits]])","v":0}]
[null,"Ultrasound Tech",2.4,51000,null,{"$f":"ProviderCosts[[#This Row],[Salary]]*0.224","v":11424},{"$f":"ProviderCosts[[#This Row],[FTEs]]*SUM(ProviderCosts[[#This Row],[Salary]:[Benefits]])","v":149817.60000000001}]
[null,"CT / X-Ray Tech",4.7,56154,null,{"$f":"ProviderCosts[[#This Row],[Salary]]*0.224","v":12578.496000000001},{"$f":"ProviderCosts[[#This Row],[FTEs]]*SUM(ProviderCosts[[#This Row],[Salary]:[Benefits]])","v":323042.73119999998}]
[null,"X-Ray Tech ",0,45525,null,{"$f":"ProviderCosts[[#This Row],[Salary]]*0.224","v":10197.6},{"$f":"ProviderCosts[[#This Row],[FTEs]]*SUM(ProviderCosts[[#This Row],[Salary]:[Benefits]])","v":0}]
[null,"Med Lab Tech",4.7,50100,null,{"$f":"ProviderCosts[[#This Row],[Salary]]*0.224","v":11222.4},{"$f":"ProviderCosts[[#This Row],[FTEs]]*SUM(ProviderCosts[[#This Row],[Salary]:[Benefits]])","v":288215.28000000003}]
[null,"Respiratory Therapist",2.4,59000,null,{"$f":"ProviderCosts[[#This Row],[Salary]]*0.224","v":13216},{"$f":"ProviderCosts[[#This Row],[FTEs]]*SUM(ProviderCosts[[#This Row],[Salary]:[Benefits]])","v":173318.39999999999}]
[null,"Traveling Nurse",0,null,null,{"$f":"ProviderCosts[[#This Row],[Salary]]*0.224","v":0},{"$f":"ProviderCosts[[#This Row],[FTEs]]*SUM(ProviderCosts[[#This Row],[Salary]:[Benefits]])","v":0}]
[null,"Medical Social Worker",0.5,52079,null,{"$f":"ProviderCosts[[#This Row],[Salary]]*0.224","v":11665.696},{"$f":"ProviderCosts[[#This Row],[FTEs]]*SUM(ProviderCosts[[#This Row],[Salary]:[Benefits]])","v":31872.347999999998}]
[null,"Pharmacist",0.8,120000,null,{"$f":"ProviderCosts[[#This Row],[Salary]]*0.224","v":26880},{"$f":"ProviderCosts[[#This Row],[FTEs]]*SUM(ProviderCosts[[#This Row],[Salary]:[Benefits]])","v":117504}]
[null,"Pharmacy Technician",0,35000,null,{"$f":"ProviderCosts[[#This Row],[Salary]]*0.224","v":7840},{"$f":"ProviderCosts[[#This Row],[FTEs]]*SUM(ProviderCosts[[#This Row],[Salary]:[Benefits]])","v":0}]
[null,"Other",null,null,null,{"$f":"ProviderCosts[[#This Row],[Salary]]*0.224","v":0},{"$f":"ProviderCosts[[#This Row],[FTEs]]*SUM(ProviderCosts[[#This Row],[Salary]:[Benefits]])","v":0}]
[null,"Other",null,null,null,{"$f":"ProviderCosts[[#This Row],[Salary]]*0.224","v":0},{"$f":"ProviderCosts[[#This Row],[FTEs]]*SUM(ProviderCosts[[#This Row],[Salary]:[Benefits]])","v":0}]
[null,"Other",null,null,null,{"$f":"ProviderCosts[[#This Row],[Salary]]*0.224","v":0},{"$f":"ProviderCosts[[#This Row],[FTEs]]*SUM(ProviderCosts[[#This Row],[Salary]:[Benefits]])","v":0}]
[null,"Total",{"$f":"SUBTOTAL(109,ProviderCosts[FTEs])","v":38.999999999999993},{"$f":"SUBTOTAL(109,ProviderCosts[Salary])","v":1073234},{"$f":"SUBTOTAL(109,ProviderCosts[Bonus])","v":0},{"$f":"SUBTOTAL(109,ProviderCosts[Benefits])","v":240404.416},{"$f":"SUBTOTAL(109,ProviderCosts[Total Compensation])","v":4469317.8840000005}]
[null,"Nonclinical Support","FTEs","Salary","Bonus","Benefits","Total Compensation"]
[null,"Patient Registrar",2.4,28050,null,{"$f":"AdminCosts[[#This Row],[Salary]]*0.224","v":6283.2},{"$f":"AdminCosts[[#This Row],[FTEs]]*SUM(AdminCosts[[#This Row],[Salary]:[Benefits]])","v":82399.679999999993}]
[null,"Clinical Admin. Coordinator",1,35626,null,{"$f":"AdminCosts[[#This Row],[Salary]]*0.224","v":7980.2240000000002},{"$f":"AdminCosts[[#This Row],[FTEs]]*SUM(AdminCosts[[#This Row],[Salary]:[Benefits]])","v":43606.224000000002}]
[null,"Patient Accounts Rep",2.4,38220,null,{"$f":"AdminCosts[[#This Row],[Salary]]*0.224","v":8561.2800000000007},{"$f":"AdminCosts[[#This Row],[FTEs]]*SUM(AdminCosts[[#This Row],[Salary]:[Benefits]])","v":112275.072}]
[null,"HR/Credentialing/Recruiting",3,52000,null,{"$f":"AdminCosts[[#This Row],[Salary]]*0.224","v":11648},{"$f":"AdminCosts[[#This Row],[FTEs]]*SUM(AdminCosts[[#This Row],[Salary]:[Benefits]])","v":190944}]
[null,"Business/Payroll",1,60649,null,{"$f":"AdminCosts[[#This Row],[Salary]]*0.224","v":13585.376},{"$f":"AdminCosts[[#This Row],[FTEs]]*SUM(AdminCosts[[#This Row],[Salary]:[Benefits]])","v":74234.376000000004}]
[null,"Billing/Med Records Asst",4.7,34398,null,{"$f":"AdminCosts[[#This Row],[Salary]]*0.224","v":7705.152},{"$f":"AdminCosts[[#This Row],[FTEs]]*SUM(AdminCosts[[#This Row],[Salary]:[Benefits]])","v":197884.8144}]
[null,"Security Officer",4.7,28500,null,{"$f":"AdminCosts[[#This Row],[Salary]]*0.224","v":6384},{"$f":"AdminCosts[[#This Row],[FTEs]]*SUM(AdminCosts[[#This Row],[Salary]:[Benefits]])","v":163954.80000000002}]
[null,"Property Superintendent",1,52855,null,{"$f":"AdminCosts[[#This Row],[Salary]]*0.224","v":11839.52},{"$f":"AdminCosts[[#This Row],[FTEs]]*SUM(AdminCosts[[#This Row],[Salary]:[Benefits]])","v":64694.520000000004}]
[null,"Facilities Staff",2.4,24000,null,{"$f":"AdminCosts[[#This Row],[Salary]]*0.224","v":5376},{"$f":"AdminCosts[[#This Row],[FTEs]]*SUM(AdminCosts[[#This Row],[Salary]:[Benefits]])","v":70502.399999999994}]
[null,"Transport/Delivery/Receiving",0,29000,null,{"$f":"AdminCosts[[#This Row],[Salary]]*0.224","v":6496},{"$f":"AdminCosts[[#This Row],[FTEs]]*SUM(AdminCosts[[#This Row],[Salary]:[Benefits]])","v":0}]
[null,"Other",null,null,null,{"$f":"AdminCosts[[#This Row],[Salary]]*0.224","v":0},{"$f":"AdminCosts[[#This Row],[FTEs]]*SUM(AdminCosts[[#This Row],[Salary]:[Benefits]])","v":0}]
[null,"Total",{"$f":"SUBTOTAL(109,AdminCosts[FTEs])","v":22.599999999999998},{"$f":"SUBTOTAL(109,AdminCosts[Salary])","v":383298},{"$f":"SUBTOTAL(109,AdminCosts[Bonus])","v":0},{"$f":"SUBTOTAL(109,AdminCosts[Benefits])","v":85858.752000000008},{"$f":"SUBTOTAL(109,AdminCosts[Total Compensation])","v":1000495.8864000001}]
[]
[]
[null,"Total Staffing Costs",null,null,null,null,{"$f":"SUM(LeadershipCosts[[#Totals],[Total Compensation]],ProviderCosts[[#Totals],[Total Compensation]],AdminCosts[[#Totals],[Total Compensation]])","v":5705111.8584000012}]

{"sheet":"6. Capital Costs","index":8,"n_rows":46,"n_cols":5,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"This worksheet calculates the total capital costs required for your FED. "]
[]
[]
[null,"Please enter any initial investment costs in the table provided below. "]
[]
[]
[null,"Initial Investment Costs","Cost"]
[null,"Construction/Renovation"]
[null,"Other Costs",{"$f":"20*(EDMonthlyVolume*12)","v":212140}]
[null,"Total",{"$f":"SUBTOTAL(109,EquipCosts101315[Cost])","v":212140}]
[]
[null,"Recurring Annual Average Capital Costs"]
[null,"Please enter your equipment costs and the estimated salvage values in the table below. "]
[null,"*Note: If your organization is not-for-profit, later calculations will ignore the depreciation values. "]
[]
[null,"Equipment","Cost","Estimated Salvage Value","Depreciation"]
[null,"Computer/IT Equipment",0,0,{"$f":"IF(EquipCosts106[[#This Row],[Cost]]>0,(EquipCosts106[[#This Row],[Cost]]-EquipCosts106[[#This Row],[Estimated Salvage Value]])/'3. Key Assumptions'!D77,0)","v":0}]
[null,"Telehealth Equipment",{"$f":"1*(EDMonthlyVolume*12)","v":10607},100,{"$f":"IF(EquipCosts106[[#This Row],[Cost]]>0,(EquipCosts106[[#This Row],[Cost]]-EquipCosts106[[#This Row],[Estimated Salvage Value]])/'3. Key Assumptions'!D77,0)","v":3502.3333333333335}]
[null,"Clinical Equipment",0,0,{"$f":"IF(EquipCosts106[[#This Row],[Cost]]>0,(EquipCosts106[[#This Row],[Cost]]-EquipCosts106[[#This Row],[Estimated Salvage Value]])/'3. Key Assumptions'!D75,0)","v":0}]
[null,"Laboratory Equipment",0,0,{"$f":"IF(EquipCosts106[[#This Row],[Cost]]>0,(EquipCosts106[[#This Row],[Cost]]-EquipCosts106[[#This Row],[Estimated Salvage Value]])/'3. Key Assumptions'!D75,0)","v":0}]
[null,"Radiology Equipment",0,0,{"$f":"IF(EquipCosts106[[#This Row],[Cost]]>0,(EquipCosts106[[#This Row],[Cost]]-EquipCosts106[[#This Row],[Estimated Salvage Value]])/'3. Key Assumptions'!D75,0)","v":0}]
[null,"Pharmacy Equipment",0,0,{"$f":"IF(EquipCosts106[[#This Row],[Cost]]>0,(EquipCosts106[[#This Row],[Cost]]-EquipCosts106[[#This Row],[Estimated Salvage Value]])/'3. Key Assumptions'!D75,0)","v":0}]
[null,"Administrative Equipment",null,null,{"$f":"(EquipCosts106[[#This Row],[Cost]]-EquipCosts106[[#This Row],[Estimated Salvage Value]])/'3. Key Assumptions'!$D$77","v":0}]
[null,"Other Equipment",0,0,{"$f":"IF(EquipCosts106[[#This Row],[Cost]]>0,(EquipCosts106[[#This Row],[Cost]]-EquipCosts106[[#This Row],[Estimated Salvage Value]])/'3. Key Assumptions'!D75,0)","v":0}]
[null,"Total",{"$f":"SUBTOTAL(109,EquipCosts106[Cost])","v":10607},{"$f":"SUBTOTAL(109,EquipCosts106[Estimated Salvage Value])","v":100},{"$f":"SUBTOTAL(109,EquipCosts106[Depreciation])","v":3502.3333333333335}]
[]
[null,"Please enter any other capital costs in the table below. "]
[]
[null,"Other Capital Costs","Cost"]
[null,"Other Costs",{"$f":"22.1*(EDMonthlyVolume*12)","v":234414.7}]
[null,"Total",{"$f":"SUBTOTAL(109,EquipCosts10131511[Cost])","v":234414.7}]
[]
[null,"*Note: Equipment and capital costs (above) are expected average annual one year values. On Tab 9, these values are considered for year 1 "]
[null,"and then multiplied times the inflation rate (Tab 3) for years 2-5. "]
[null,"Alternatively, you may enter your own equipment and capital costs for years 2-5 on Tab 9. "]
[]
[null,"Total Depreciation",{"$f":"IF(TaxRate>0,EquipCosts106[[#Totals],[Depreciation]],\"Not Applicable\")","v":"Not Applicable"}]
[]
[null,"Total Equipment Costs",{"$f":"EquipCosts106[[#Totals],[Cost]]","v":10607}]
[]
[null,"Total Capital Costs",{"$f":"TotalEquipCosts+EquipCosts101315[[#Totals],[Cost]]+EquipCosts10131511[[#Totals],[Cost]]","v":457161.7}]

{"sheet":"7. Operating Costs","index":9,"n_rows":87,"n_cols":7,"rows_kept":87,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"This worksheet calculates the total operating costs required for your FED. "]
[]
[null,"ED and Other Operating Costs"]
[null,"Please enter your facility, administrative, and other ED operating costs in the tables below. "]
[]
[null,"Facility Cost","Cost","Overhead rate per facility gross square foot:"]
[null,"Utilities & Maintenance",null,null,null,null,3.23]
[null,"Environmental Services"]
[null,"Dietary"]
[null,"Other Facility Cost (per sq ft)",{"$f":"12*Footage","v":239999.04000000004}]
[null,"Other Marginal Facility Cost",{"$f":"3*('8. Expected Revenue'!D41+'8. Expected Revenue'!D61)","v":71597.25}]
[null,"Total",{"$f":"SUBTOTAL(109,ClinSuppCosts111416[Cost])","v":311596.29000000004}]
[null,"Other Operating Costs","Cost"]
[null,"Other",0]
[null,"Other",0]
[null,"Other",0]
[null,"Total",{"$f":"SUBTOTAL(109,ClinSuppCosts111417[Cost])","v":0}]
[]
[null,"ED Operating Cost","Cost"]
[null,"Medical/Surgical Supplies",0]
[null,"Contract Labor (Facilities, Marketing, IT, Billing, Security, Medical Records, etc.)",0]
[null,"Facilities"]
[null,"Marketing",0]
[null,"IT Support",0]
[null,"Billing",0]
[null,"Security",0]
[null,"Medical Records",0]
[null,"Transport Costs",0]
[null,"Traveling/Continuing Education"]
[null,"Other",{"$f":"(188*'8. Expected Revenue'!D41)","v":1994116}]
[null,"Total",{"$f":"SUBTOTAL(109,ClinSuppCosts1114[Cost])","v":1994116}]
[]
[null,"Ancillary Operating Costs (Laboratory, Radiology, Mammography, CT, Ultrasound, Pharmacy, Infusion, etc.)"]
[null,"Please enter your ancillary costs in the tables below. "]
[]
[null,"Ancillary Cost","Cost"]
[null,"Medical Supplies",0]
[null,"Other"]
[null,"Other"]
[null,"Other"]
[null,"Other"]
[null,"Other"]
[null,"Other Direct Cost",{"$f":"43*(OPMonthlyVolume*12)","v":570126.25}]
[null,"Total",{"$f":"SUBTOTAL(109,LabCosts18[Cost])","v":570126.25}]
[]
[]
[null,"Total Ancillary Costs",{"$f":"LabCosts18[[#Totals],[Cost]]","v":570126.25}]
[]
[null,"Total Operating Costs",{"$f":"TotalAncillaryCosts+ClinSuppCosts111416[[#Totals],[Cost]]+ClinSuppCosts1114[[#Totals],[Cost]]+ClinSuppCosts111417[[#Totals],[Cost]]","v":2875838.54}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Facility Costs","Cost"]
[null,"Overhead",0]
[null,"Utilities & Maintenance",0]
[null,"Depreciation",0]
[null,"?",0]
[null,"?",0]
[null,"Total",{"$f":"SUBTOTAL(109,Table1182026182159[Cost])","v":0}]
[null,"Transfer Costs","Cost"]
[null,"?",0]
[null,"?",0]
[null,"?",0]
[null,"?",0]
[null,"?",0]
[null,"Total",{"$f":"SUBTOTAL(109,Table118202618215[Cost])","v":0}]

{"sheet":"8. Expected Revenue","index":10,"n_rows":77,"n_cols":4,"rows_kept":77,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"This worksheet calculates expected revenue based on payer mix and estimated reimbursement. "]
[]
[]
[null,"Please enter your current estimated ED or outpatient payer mix into the table below. "]
[null,"*Note: Payer mix is considered the same for outpatient and ED in subsequent calculations. "]
[]
[null,null,"Estimated ED / Hospital Outpatient Payer Mix","Estimated %"]
[null,null,"Medicare",0.26700000000000002]
[null,null,"Medicaid",0.27400000000000002]
[null,null,"Self-Pay/Uninsured",0.22800000000000001]
[null,null,"Commercial",0.20100000000000001]
[null,null,"Other (Tricare, Worker's Comp, etc.)",0.03]
[null,null,"Total",{"$f":"SUM(D13,D14,D15,D16,D17)","v":1}]
[]
[]
[null,"Please enter your estimated reimbursement from each payer (based on charge) into the table below. "]
[]
[null,null,"Payer Reimbursement Rates","Estimated %"]
[null,null,"Medicare",0.129]
[null,null,"Medicaid",0.19800000000000001]
[null,null,"Self-Pay/Uninsured",3.1E-2]
[null,null,"Commercial",0.58399999999999996]
[null,null,"Other (Tricare, Worker's Comp, etc.)",0.245]
[]
[]
[null,"Hospital cost to charge ratio",null,1]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Estimated ED Revenue"]
[]
[null,null,"Projected Annual ED Demand",{"$f":"EDMonthlyVolume*12","v":10607}]
[]
[null,null,"Average Cost per ED Service",{"$f":"AverageChargeED*Cost_to_Charge","v":1845}]
[]
[]
[null,null,"Annual Revenue by Payer","Column1"]
[null,null,"Medicare",{"$f":"IFERROR(D13*$D$41*$D$43*D24,0)","v":674046.582345}]
[null,null,"Medicaid",{"$f":"IFERROR(D14*$D$41*$D$43*D25,0)","v":1061707.0285800002}]
[null,null,"Self-Pay/Uninsured",{"$f":"IFERROR(D15*$D$41*$D$43*D26,0)","v":138320.15922}]
[null,null,"Commercial",{"$f":"IFERROR(D16*$D$41*$D$43*D27,0)","v":2297194.9023599997}]
[null,null,"Other (Tricare, Worker's Comp, etc.)",{"$f":"IFERROR(D17*$D$41*$D$43*D28,0)","v":143838.87524999998}]
[null,null,"Total",{"$f":"SUM(D47:D51)","v":4315107.5477549993}]
[]
[null,null,"Total ED Services Revenue",{"$f":"D52","v":4315107.5477549993}]
[]
[]
[]
[]
[null,null,"Estimated Outpatient Revenue"]
[]
[null,null,"Projected Annual Outpatient Demand",{"$f":"OPMonthlyVolume*12","v":13258.75}]
[]
[null,null,"Average Cost per Outpatient Service",{"$f":"AverageChargeOutpatient*Cost_to_Charge","v":1308}]
[]
[]
[null,null,"Annual Revenue by Payer","Column1"]
[null,null,"Medicare",{"$f":"IFERROR(D13*$D$61*$D$63*D24,0)","v":597325.83313500008}]
[null,null,"Medicaid",{"$f":"IFERROR(D14*$D$61*$D$63*D25,0)","v":940862.32614000014}]
[null,null,"Self-Pay/Uninsured",{"$f":"IFERROR(D15*$D$61*$D$63*D26,0)","v":122576.40126}]
[null,null,"Commercial",{"$f":"IFERROR(D16*$D$61*$D$63*D27,0)","v":2035725.5638799998}]
[null,null,"Other (Tricare, Worker's Comp, etc.)",{"$f":"IFERROR(D17*$D$61*$D$63*D28,0)","v":127466.97074999999}]
[null,null,"Total",{"$f":"SUM(D67:D71)","v":3823957.0951649998}]
[]
[null,null,"Total Outpatient Services Revenue",{"$f":"D72","v":3823957.0951649998}]
[]
[]
[null,null,"Total Revenue",{"$f":"SUM(D54,D74)","v":8139064.6429199986}]

{"sheet":"9. Pro Forma","index":11,"n_rows":88,"n_cols":14,"rows_kept":88,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"This worksheet provides a summary using the data entered on previous sheets. "]
[null,"*Note: There is no data entry required on this sheet."]
[]
[]
[null,"Assumptions"]
[]
[null,"Construction/Renovation Costs",null,null,{"$f":"'6. Capital Costs'!C13","v":0},null,"Volume Growth Rate",null,null,{"$f":"DemandGrowthRate","v":8.8500000000000002E-3}]
[null,"Other Initial Investment Costs",null,null,{"$f":"'6. Capital Costs'!C14","v":212140},null,"Inflation Rate on Costs",null,null,{"$f":"'3. Key Assumptions'!D13","v":0.03}]
[null,"Staffing Cost",null,null,{"$f":"TotalStaffingCost","v":5705111.8584000012},null,"Organizational Tax Rate",null,null,{"$f":"TaxRate","v":0}]
[null,"Equipment Cost",null,null,{"$f":"TotalEquipCosts","v":10607},null,"Cost of Capital",null,null,{"$f":"CostofCapital","v":0.04}]
[null,"Other Capital Cost",null,null,{"$f":"OtherCapitalCosts","v":234414.7},null,"Purchasing Discount",null,null,{"$f":"Discount","v":0}]
[null,{"$f":"ClinSuppCosts111416[[#Headers],[Facility Cost]]","v":"Facility Cost"},null,null,{"$f":"ClinSuppCosts111416[[#Totals],[Cost]]","v":311596.29000000004},null,"Medicare Reimbursement Growth Rate",null,null,{"$f":"'3. Key Assumptions'!D62","v":2.1999999999999999E-2}]
[null,{"$f":"ClinSuppCosts1114[[#Headers],[ED Operating Cost]]","v":"ED Operating Cost"},null,null,{"$f":"ClinSuppCosts1114[[#Totals],[Cost]]","v":1994116},null,"Overhead Rate (per sq. ft.)",null,null,{"$f":"'7. Operating Costs'!G12","v":3.23}]
[null,{"$f":"LabCosts18[[#Headers],[Ancillary Cost]]","v":"Ancillary Cost"},null,null,{"$f":"TotalAncillaryCosts","v":570126.25},null,"Facility Square Footage",null,null,{"$f":"Footage","v":19999.920000000002}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"FED Operating Year"]
[null,null,null,null,"Initial Investment","Year 1","Year 2","Year 3","Year 4","Year 5"]
[null,"Net Patient Revenue"]
[null,"ED Services"]
[null,"Medicare",null,null,null,{"$f":"'8. Expected Revenue'!D47","v":674046.582345},{"$f":"F30*(1+$J$12)*(1+$J$17)","v":694972.15627992584},{"$f":"G30*(1+$J$12)*(1+$J$17)","v":716547.35837998928},{"$f":"H30*(1+$J$12)*(1+$J$17)","v":738792.35615668853},{"$f":"I30*(1+$J$12)*(1+$J$17)","v":761727.94321586622}]
[null,"Medicaid",null,null,null,{"$f":"'8. Expected Revenue'!D48","v":1061707.0285800002},{"$f":"F31*(1+$J$12)","v":1071103.1357829331},{"$f":"G31*(1+$J$12)","v":1080582.398534612},{"$f":"H31*(1+$J$12)","v":1090145.5527616434},{"$f":"I31*(1+$J$12)","v":1099793.3409035839}]
[null,"Self-Pay/Uninsured",null,null,null,{"$f":"'8. Expected Revenue'!D49","v":138320.15922},{"$f":"F32*(1+$J$12)","v":139544.29262909701},140779.25961886451,142025.15606649147,143282.07869767991]
[null,"Commercial",null,null,null,{"$f":"'8. Expected Revenue'!D50","v":2297194.9023599997},2317525.077245886,2338035.1741795121,2358726.7854710007,2379601.5175224193]
[null,"Other",null,null,null,{"$f":"'8. Expected Revenue'!D51","v":143838.87524999998},145111.84929596249,146396.08916223174,147691.69455131749,148998.76604809664]
[null,"Total ED Services Revenue",null,null,null,{"$f":"SUM(F30:F34)","v":4315107.5477549993},{"$f":"SUM(G30:G34)","v":4368256.5112338047},{"$f":"SUM(H30:H34)","v":4422340.2798752086},{"$f":"SUM(I30:I34)","v":4477381.5450071413},{"$f":"SUM(J30:J34)","v":4533403.6463876469}]
[]
[null,"Outpatient Services"]
[null,"Medicare",null,null,null,{"$f":"'8. Expected Revenue'!D67","v":597325.83313500008},{"$f":"F38*(1+$J$12)*(1+$J$17)","v":615869.63442692626},{"$f":"G38*(1+$J$12)*(1+$J$17)","v":634989.12246681983},{"$f":"H38*(1+$J$12)*(1+$J$17)","v":654702.16927706555},{"$f":"I38*(1+$J$12)*(1+$J$17)","v":675027.20171162125}]
[null,"Medicaid",null,null,null,{"$f":"'8. Expected Revenue'!D68","v":940862.32614000014},{"$f":"F39*(1+$J$12)","v":949188.95772633911},{"$f":"G39*(1+$J$12)","v":957589.28000221727},{"$f":"H39*(1+$J$12)","v":966063.94513023691},{"$f":"I39*(1+$J$12)","v":974613.61104463949}]
[null,"Self-Pay/Uninsured",null,null,null,{"$f":"'8. Expected Revenue'!D69","v":122576.40126},{"$f":"F40*(1+$J$12)","v":123661.202411151},124755.60405248968,125859.69114835422,126973.54941501716]
[null,"Commercial",null,null,null,{"$f":"'8. Expected Revenue'!D70","v":2035725.5638799998},2053741.7351203379,2071917.349476153,2090253.8180190171,2108752.5643084855]
[null,"Other",null,null,null,{"$f":"'8. Expected Revenue'!D71","v":127466.97074999999},128595.0534411375,129733.11966409157,130881.25777311879,132039.55690441089]
[null,"Total Outpatient Services Revenue",null,null,null,{"$f":"SUM(F38:F42)","v":3823957.0951649998},{"$f":"SUM(G38:G42)","v":3871056.5831258916},{"$f":"SUM(H38:H42)","v":3918984.4756617714},{"$f":"SUM(I38:I42)","v":3967760.8813477922},{"$f":"SUM(J38:J42)","v":4017406.4833841743}]
[]
[null,"Total Revenues",null,null,null,{"$f":"SUM(F35,F43)","v":8139064.6429199986},{"$f":"SUM(G35,G43)","v":8239313.0943596959},{"$f":"SUM(H35,H43)","v":8341324.75553698},{"$f":"SUM(I35,I43)","v":8445142.4263549335},{"$f":"SUM(J35,J43)","v":8550810.1297718212}]
[]
[null,"Less: "]
[null,"Capital Cost"]
[null,"Initial Investment Cost   (Amortized Portion)",null,null,null,{"$f":"(EquipCosts101315[[#Totals],[Cost]])/15*1.05","v":14849.8},{"$f":"(EquipCosts101315[[#Totals],[Cost]])/15*1.05","v":14849.8},{"$f":"(EquipCosts101315[[#Totals],[Cost]])/15*1.05","v":14849.8},{"$f":"(EquipCosts101315[[#Totals],[Cost]])/15*1.05","v":14849.8},{"$f":"(EquipCosts101315[[#Totals],[Cost]])/15*1.05","v":14849.8}]
[null,"Equipment Cost",null,null,null,{"$f":"E15","v":10607},{"$f":"F50*(1+$J$13)","v":10925.210000000001},{"$f":"G50*(1+$J$13)","v":11252.966300000002},11590.555289000002,11938.271947670002]
[null,"Other Capital Cost",null,null,null,{"$f":"E16","v":234414.7},{"$f":"F51*(1+$J$13)","v":241447.14100000003},248690.55523000003,256151.27188690004,263835.81004350702]
[]
[null,"Operating Cost"]
[null,{"$f":"B14","v":"Staffing Cost"},null,null,null,{"$f":"E14","v":5705111.8584000012},{"$f":"F54*(1+$J$13)","v":5876265.2141520018},{"$f":"G54*(1+$J$13)","v":6052553.1705765622},{"$f":"H54*(1+$J$13)","v":6234129.7656938592},{"$f":"I54*(1+$J$13)","v":6421153.6586646754}]
[null,{"$f":"B17","v":"Facility Cost"},null,null,null,{"$f":"E17","v":311596.29000000004},{"$f":"F55*(1+$J$13)","v":320944.17870000005},330572.50406100007,340489.67918283009,350704.36955831503]
[null,{"$f":"B18","v":"ED Operating Cost"},null,null,null,{"$f":"E18","v":1994116},2053939.48,2115557.6644000001,2179024.3943320001,2244395.12616196]
[null,{"$f":"B19","v":"Ancillary Cost"},null,null,null,{"$f":"E19","v":570126.25},587230.03749999998,604846.93862499995,622992.34678374999,641682.11718726251]
[null,"Total Operating Cost",null,null,null,{"$f":"SUM(F54:F57)","v":8580950.3984000012},{"$f":"SUM(G54:G57)","v":8838378.910352001},{"$f":"SUM(H54:H57)","v":9103530.2776625641},{"$f":"SUM(I54:I57)","v":9376636.1859924383},{"$f":"SUM(J54:J57)","v":9657935.2715722136}]
[]
[null,"Depreciation",null,null,null,{"$f":"IF(Depreciation=\"Not Applicable\",0,Depreciation)","v":0},{"$f":"IF(Depreciation=\"Not Applicable\",0,Depreciation)","v":0},{"$f":"IF(Depreciation=\"Not Applicable\",0,Depreciation)","v":0},{"$f":"IF(Depreciation=\"Not Applicable\",0,Depreciation)","v":0},{"$f":"IF(Depreciation=\"Not Applicable\",0,Depreciation)","v":0}]
[null,"Total Cost",null,null,null,{"$f":"SUM(F49:F51,F54:F57,F60:F60)","v":8840821.8984000012},{"$f":"SUM(G49:G51,G54:G57,G60:G60)","v":9105601.0613520015},{"$f":"SUM(H49:H51,H54:H57,H60:H60)","v":9378323.5991925634},{"$f":"SUM(I49:I51,I54:I57,I60:I60)","v":9659227.8131683394},{"$f":"SUM(J49:J51,J54:J57,J60:J60)","v":9948559.1535633877}]
[]
[null,"  Income before Taxes",null,null,null,{"$f":"F45-F61","v":-701757.25548000261},{"$f":"G45-G61","v":-866287.96699230559},{"$f":"H45-H61","v":-1036998.8436555834},{"$f":"I45-I61","v":-1214085.3868134059},{"$f":"J45-J61","v":-1397749.0237915665}]
[null,"Taxes",null,null,null,{"$f":"$J$14*F63","v":0},{"$f":"$J$14*G63","v":0},{"$f":"$J$14*H63","v":0},{"$f":"$J$14*I63","v":0},{"$f":"$J$14*J63","v":0}]
[null,"  Projected Net Income",null,null,null,{"$f":"F63-F64","v":-701757.25548000261},{"$f":"G63-G64","v":-866287.96699230559},{"$f":"H63-H64","v":-1036998.8436555834},{"$f":"I63-I64","v":-1214085.3868134059},{"$f":"J63-J64","v":-1397749.0237915665}]
[null,"  Net Margin",null,null,null,{"$f":"F65/F45","v":-8.6220872577839336E-2},{"$f":"G65/G45","v":-0.10514079961172147},{"$f":"H65/H45","v":-0.12432064139059237},{"$f":"I65/I45","v":-0.1437613867854477},{"$f":"J65/J45","v":-0.16346392944978952}]
[null,"Plus: Depreciation",null,null,null,{"$f":"F60","v":0},{"$f":"G60","v":0},{"$f":"H60","v":0},{"$f":"I60","v":0},{"$f":"J60","v":0}]
[null,"Plus: Net building/equipment salvage value",null,null,null,null,null,null,null,{"$f":"EquipCosts106[[#Totals],[Estimated Salvage Value]]","v":100}]
[]
[null,"Net Cash Flow",null,null,{"$f":"-SUM(E49:E49)","v":0},{"$f":"F65+F67+F68","v":-701757.25548000261},{"$f":"G65+G67+G68","v":-866287.96699230559},{"$f":"H65+H67+H68","v":-1036998.8436555834},{"$f":"I65+I67+I68","v":-1214085.3868134059},{"$f":"J65+J67+J68","v":-1397649.0237915665}]
[]
[null,"Cumulative Net Cash Flow",null,null,{"$f":"E70","v":0},{"$f":"E70+F70","v":-701757.25548000261},{"$f":"E70+F70+G70","v":-1568045.2224723082},{"$f":"E70+F70+G70+H70","v":-2605044.0661278917},{"$f":"E70+F70+G70+H70+I70","v":-3819129.4529412976},{"$f":"E70+F70+G70+H70+I70+J70","v":-5216778.476732864}]
[]
[]
[]
[null,null,null,null,"Year 1",null,null,null,null,null,null,null,"ed","op"]
[null,"Average Payment Needed Per Visit",null,null,{"$f":"-F65/('8. Expected Revenue'!D41+'8. Expected Revenue'!D61)","v":29.404366319097562},null,null,null,null,null,null,null,{"$f":"'8. Expected Revenue'!D54/'8. Expected Revenue'!D77","v":0.53017241379310343},{"$f":"'8. Expected Revenue'!D74/'8. Expected Revenue'!D77","v":0.46982758620689663}]
[null,"Annual Payment Needed",null,null,{"$f":"-'9. Pro Forma'!F65","v":701757.25548000261}]
[null,"% increase needed from Medicare",null,null,{"$f":"-'9. Pro Forma'!F65/('8. Expected Revenue'!D47+'8. Expected Revenue'!D67)","v":0.55196828791904995}]
[]
[null,null,null,null,null,{"$f":"IF(F72<0,\"n/m\",ABS(E72)/F70)","v":"n/m"},{"$f":"IF(G72<0,\"n/m\",ABS(F72)/G70)","v":"n/m"},{"$f":"IF(H72<0,\"n/m\",ABS(G72)/H70)","v":"n/m"},{"$f":"IF(I72<0,\"n/m\",ABS(H72)/I70)","v":"n/m"},{"$f":"IF(J72<0,\"n/m\",ABS(I72)/J70)","v":"n/m"}]
[]
[]
[null,"NPV",null,null,{"$f":"NPV(J15,F70:J70)+E70","v":-4584157.6052147904}]
[null,"IRR",null,null,{"$f":"IFERROR(IRR(E70:J70),\"Unable to Calculate\")","v":"Unable to Calculate"}]
[null,"MIRR",null,null,{"$f":"IFERROR(MIRR(E70:J70,$J$15,$J$15),\"Unable to Calculate\")","v":-1}]
[null,"Payback Period",null,null,{"$f":"IFERROR(COUNTIF(F72:J72,\"<0\")+INDEX(F81:J81,COUNTIF(F72:J72,\"<0\")+1),\"n/a\")","v":"n/a"}]
[null,"Payback Period (Show)",null,null,{"$f":"IF(E87<=5,E87,\"Greater Than Projected Time Period\")","v":"Greater Than Projected Time Period"}]

{"sheet":"10. Feasibility Results","index":12,"n_rows":262,"n_cols":8,"rows_kept":262,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,"This worksheet provides a profitability analysis, scenario analysis, and sensitivity analysis using the information from previous worksheets. "]
[null,null,"*Note: There is no data entry required on this sheet."]
[]
[]
[null,null,"Profitability Analysis for: ",null,null,{"$f":"HospitalName","v":"General Hospital"}]
[]
[null,null,{"$f":"IF('9. Pro Forma'!E84>0,\"Based on your estimated costs and revenues, converting to a FED is profitable.\",\"Based on your estimated costs and revenues, converting to a FED is not profitable.\")","v":"Based on your estimated costs and revenues, converting to a FED is not profitable."}]
[]
[null,null,"Results: "]
[]
[null,null,"NPV","IRR","MIRR","Payback Period"]
[null,null,{"$f":"'9. Pro Forma'!E84","v":-4584157.6052147904},{"$f":"'9. Pro Forma'!E85","v":"Unable to Calculate"},{"$f":"'9. Pro Forma'!E86","v":-1},{"$f":"'9. Pro Forma'!E88","v":"Greater Than Projected Time Period"}]
[]
[null,null,"Explanation: "]
[]
[null,null,"NPV ≥ 0?","IRR > Cost       of Capital?","MIRR > Cost of Capital?","Payback             Period < 5?"]
[null,null,{"$f":"IF(C17>0, \"Yes\",\"No\")","v":"No"},{"$f":"IF(D17=\"Unable to Calculate\",\"N/A\",IF(D17>CostofCapital,\"Yes\",\"No\"))","v":"N/A"},{"$f":"IF(E17>CostofCapital,\"Yes\",\"No\")","v":"No"},{"$f":"IF(F17<5,\"Yes\",\"No\")","v":"No"}]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Total Costs vs. Total Revenue (Over 5 Year Period)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Total Operating Costs (Over 5 Year Period)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Total Revenues for Emergency Services by Payer Mix (Over 5 Year Period)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null," Sensitivity Analysis"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Changes in Annual Patient Volume (ED)"]
[null,null,"% Change in               Patient Volume","Resulting                            Patient Volume","Resulting NPV"]
[null,null,-0.5,{"$f":"(EDMonthlyVolume*12)*(1+C120)","v":5303.5},{"$f":"'Data Tables'!D149","v":-14871197.573017461}]
[null,null,-0.4,6364.2,{"$f":"'Data Tables'!D150","v":-12903927.890184505}]
[null,null,-0.3,7424.9,{"$f":"'Data Tables'!D151","v":-10936658.207351552}]
[null,null,-0.2,8485.6,{"$f":"'Data Tables'!D152","v":-8969388.5245186016}]
[null,null,-0.1,9546.3000000000011,{"$f":"'Data Tables'!D153","v":-7002118.8416856453}]
[null,null,0,10607,{"$f":"'Data Tables'!D154","v":-5034849.1588526955}]
[null,null,0.1,11667.7,{"$f":"'Data Tables'!D155","v":-3067579.4760197415}]
[null,null,0.2,12728.4,{"$f":"'Data Tables'!D156","v":-1100309.7931867898}]
[null,null,0.3,13789.1,{"$f":"'Data Tables'!D157","v":866959.88964616391}]
[null,null,0.4,14849.8,{"$f":"'Data Tables'!D158","v":2834229.5724791144}]
[null,null,0.5,15910.5,{"$f":"'Data Tables'!D159","v":4801499.2553120693}]
[]
[]
[]
[null,null,"Changes in Annual Patient Volume (Outpatient)"]
[null,null,"% Change in               Patient Volume","Resulting                            Patient Volume","Resulting NPV"]
[null,null,-0.5,{"$f":"(OPMonthlyVolume*12)*(1+C136)","v":6629.375},{"$f":"'Data Tables'!D163","v":-13751613.200673504}]
[null,null,-0.4,7955.25,{"$f":"'Data Tables'!D164","v":-12008260.392309342}]
[null,null,-0.3,9281.125,{"$f":"'Data Tables'!D165","v":-10264907.583945177}]
[null,null,-0.2,10607,{"$f":"'Data Tables'!D166","v":-8521554.7755810171}]
[null,null,-0.1,11932.875,{"$f":"'Data Tables'!D167","v":-6778201.9672168577}]
[null,null,0,13258.75,{"$f":"'Data Tables'!D168","v":-5034849.1588526955}]
[null,null,0.1,14584.625000000002,{"$f":"'Data Tables'!D169","v":-3291496.3504885309}]
[null,null,0.2,15910.5,{"$f":"'Data Tables'!D170","v":-1548143.5421243743}]
[null,null,0.3,17236.375,{"$f":"'Data Tables'!D171","v":195209.26623978716}]
[null,null,0.4,18562.25,{"$f":"'Data Tables'!D172","v":1938562.0746039497}]
[null,null,0.5,19888.125,{"$f":"'Data Tables'!D173","v":3681914.8829681133}]
[]
[]
[]
[null,null,"Changes in Medicare Reimbursement Rate"]
[null,null,"% Change in            Medicare Rate","Resulting Medicare Reimbursement Growth Rate","Resulting NPV"]
[null,null,-1,{"$f":"MedicareRate*(1+C152)","v":0},{"$f":"'Data Tables'!D178","v":-5285836.6923296684}]
[null,null,-0.75,5.4999999999999997E-3,{"$f":"'Data Tables'!D179","v":-5224101.0550142368}]
[null,null,-0.5,1.0999999999999999E-2,{"$f":"'Data Tables'!D180","v":-5161694.9055312499}]
[null,null,-0.25,1.6500000000000001E-2,{"$f":"'Data Tables'!D181","v":-5098612.7720213477}]
[null,null,0,2.1999999999999999E-2,{"$f":"'Data Tables'!D182","v":-5034849.1588526955}]
[null,null,0.25,2.7499999999999997E-2,{"$f":"'Data Tables'!D183","v":-4970398.5466209725}]
[null,null,0.5,3.3000000000000002E-2,{"$f":"'Data Tables'!D184","v":-4905255.3921493962}]
[null,null,0.75,3.85E-2,{"$f":"'Data Tables'!D185","v":-4839414.1284886757}]
[null,null,1,4.3999999999999997E-2,{"$f":"'Data Tables'!D186","v":-4772869.1649170667}]
[]
[]
[]
[]
[]
[null,null,"Scenario Analysis"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Current Values ",null,null,"Scenario Values"]
[]
[null,null,"Organizational Assumptions",null,null,"Organizational Assumptions"]
[]
[null,null,"Cost of Capital",{"$f":"'9. Pro Forma'!J15","v":0.04},null,"Cost of Capital",null,{"$f":"'Scenario Model'!J75","v":0.04}]
[null,null,"Tax Rate",{"$f":"'9. Pro Forma'!J14","v":0},null,"Tax Rate",null,{"$f":"'Scenario Model'!J74","v":0}]
[null,null,"Purchasing Discount",{"$f":"Discount","v":0},null,"Purchasing Discount",null,{"$f":"GETPIVOTDATA(\"Value\",'Scenario Data'!$F$46,\"Variable\",\"Purchasing Discount\")","v":0.2}]
[null,null,"Demand Growth Rate",{"$f":"'9. Pro Forma'!J12","v":8.8500000000000002E-3},null,"Demand Growth Rate",null,{"$f":"'Scenario Model'!J72","v":0.08}]
[]
[null,null,"Hospital Payer Mix",null,null,"Hospital Payer Mix"]
[]
[null,null,"Medicare",{"$f":"'8. Expected Revenue'!D13","v":0.26700000000000002},null,"Medicare",null,{"$f":"'Scenario Model'!D8","v":0.33800000000000002}]
[null,null,"Medicaid",{"$f":"'8. Expected Revenue'!D14","v":0.27400000000000002},null,"Medicaid",null,{"$f":"'Scenario Model'!D9","v":0.20699999999999999}]
[null,null,"Self Pay",{"$f":"'8. Expected Revenue'!D15","v":0.22800000000000001},null,"Self Pay",null,{"$f":"'Scenario Model'!D10","v":0.185}]
[null,null,"Commercial",{"$f":"'8. Expected Revenue'!D16","v":0.20100000000000001},null,"Commercial",null,{"$f":"'Scenario Model'!D11","v":0.247}]
[null,null,"Other",{"$f":"'8. Expected Revenue'!D17","v":0.03},null,"Other",null,{"$f":"'Scenario Model'!D12","v":2.3E-2}]
[]
[null,null,"Payer Reimbursement",null,null,"Payer Reimbursement"]
[]
[null,null,"Medicare",{"$f":"'8. Expected Revenue'!D24","v":0.129},null,"Medicare",null,{"$f":"'Scenario Model'!D20","v":0.99}]
[null,null,"Medicaid",{"$f":"'8. Expected Revenue'!D25","v":0.19800000000000001},null,"Medicaid",null,{"$f":"'Scenario Model'!D21","v":0.9}]
[null,null,"Self Pay",{"$f":"'8. Expected Revenue'!D26","v":3.1E-2},null,"Self Pay",null,{"$f":"'Scenario Model'!D22","v":3.1E-2}]
[null,null,"Commercial",{"$f":"'8. Expected Revenue'!D27","v":0.58399999999999996},null,"Commercial",null,{"$f":"'Scenario Model'!D23","v":0.58399999999999996}]
[null,null,"Other",{"$f":"'8. Expected Revenue'!D28","v":0.245},null,"Other",null,{"$f":"'Scenario Model'!D24","v":0.245}]
[]
[null,null,"Cash Flow Assumptions",null,null,"Cash Flow Assumptions"]
[]
[null,null,"Initial Investment",{"$f":"'9. Pro Forma'!E70","v":0},null,"Initial Investment",null,{"$f":"'Scenario Model'!E130","v":-212140}]
[null,null,"Total Revenues",{"$f":"'9. Pro Forma'!F45","v":8139064.6429199986},null,"Total Revenues",null,{"$f":"'Scenario Model'!F107","v":24972614.209680002}]
[null,null,"Total Costs",{"$f":"'9. Pro Forma'!F61","v":8840821.8984000012},null,"Total Costs",null,{"$f":"'Scenario Model'!F122","v":8888450.4400000013}]
[]
[null,null,"Income Before Taxes",{"$f":"'9. Pro Forma'!F63","v":-701757.25548000261},null,"Income Before Taxes",null,{"$f":"'Scenario Model'!F124","v":16084163.769680001}]
[null,null,"Taxes",{"$f":"'9. Pro Forma'!F64","v":0},null,"Taxes",null,{"$f":"'Scenario Model'!F125","v":0}]
[null,null,"Net Income After Taxes",{"$f":"'9. Pro Forma'!F65","v":-701757.25548000261},null,"Net Income After Taxes",null,{"$f":"'Scenario Model'!F126","v":16084163.769680001}]
[]
[null,null,"Current Results",null,null,"Results Under Chosen Scenario(s)"]
[]
[null,null,"NPV",{"$f":"'9. Pro Forma'!E84","v":-4584157.6052147904},null,"NPV",null,{"$f":"'Scenario Model'!E137","v":90521592.295099989}]
[null,null,"IRR",{"$f":"'9. Pro Forma'!E85","v":"Unable to Calculate"},null,"IRR",null,{"$f":"'Scenario Model'!E138","v":75.944465107099077}]
[null,null,"MIRR",{"$f":"'9. Pro Forma'!E86","v":-1},null,"MIRR",null,{"$f":"'Scenario Model'!E139","v":2.4935147525502335}]
[null,null,"Payback Period",{"$f":"'9. Pro Forma'!E88","v":"Greater Than Projected Time Period"},null,"Payback Period",null,{"$f":"'Scenario Model'!E141","v":1.3189370802099249E-2}]
[]
[]
[]
[]
[null,null,"Recommendations & Other Considerations"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"You may also want to consider the following information regarding Medicaid expansion, competition, and affiliation. "]
[]
[]
[null,null,{"$f":"IF(ExpansionDecision=TRUE,\"You indicated that your hospital is in a state that has expanded Medicaid.\",\"You indicated that your hospital is in a state that has not expanded Medicaid.\")","v":"You indicated that your hospital is in a state that has not expanded Medicaid."}]
[]
[]
[]
[]
[null,null,"You also indicated that your organization has:"]
[]
[null,null,{"$f":"EDNearby","v":1},"Hospitals and/or EDs within a 35 mile radius"]
[null,null,{"$f":"OutpatientNearby","v":3},"Outpatient Lab/Imaging Facilities within a 35 radius"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(Affiliation=\"YES\",\"You indicated that your hospital is affiliated with another hospital or health system.\",\"You indicated that your hospital is not affiliated with another hospital or health system.\")","v":"You indicated that your hospital is affiliated with another hospital or health system."}]

{"sheet":"Scenario Data","index":13,"n_rows":113,"n_cols":7,"rows_kept":113,"cut":false,"hidden":true,"merged":[[1,1,1,3]]}
[]
[null,"Scenario Data"]
[]
[null,"Scenario","Variable","Value"]
[null,"Base Case"]
[null,"Base Case"]
[null,"Base Case"]
[null,"Base Case"]
[null,"Base Case"]
[null,"Base Case"]
[null,"Base Case"]
[null,"Base Case"]
[null,"Base Case"]
[]
[]
[]
[null,"Scenario","Variable","Value",null,"Row Labels","Sum of Value"]
[null,0.03,"Cost of Capital",0.03,null,"Cost of Capital",0.04]
[null,0.04,"Cost of Capital",0.04,null,"Grand Total",0.04]
[null,0.05,"Cost of Capital",0.05]
[null,0.06,"Cost of Capital",0.06]
[null,0.08,"Cost of Capital",0.08]
[null,0.1,"Cost of Capital",0.1]
[null,0.12,"Cost of Capital",0.12]
[null,0.15,"Cost of Capital",0.15]
[null,0.19,"Cost of Capital",0.19]
[null,0.22,"Cost of Capital",0.22]
[]
[]
[]
[]
[]
[null,"Scenario","Variable","Value",null,"Row Labels","Sum of Value"]
[null,0,"Tax Rate",0,null,"Tax Rate",0]
[null,0.2,"Tax Rate",0.2,null,"Grand Total",0]
[null,0.25,"Tax Rate",0.25]
[null,0.3,"Tax Rate",0.3]
[null,0.35,"Tax Rate",0.35]
[null,0.4,"Tax Rate",0.4]
[]
[]
[]
[]
[]
[]
[null,"Scenario","Variable","Value",null,"Row Labels","Sum of Value"]
[null,0,"Purchasing Discount",0,null,"Purchasing Discount",0.2]
[null,0.05,"Purchasing Discount",0.05,null,"Grand Total",0.2]
[null,0.1,"Purchasing Discount",0.1]
[null,0.15,"Purchasing Discount",0.15]
[null,0.2,"Purchasing Discount",0.2]
[null,0.25,"Purchasing Discount",0.25]
[null,0.3,"Purchasing Discount",0.3]
[null,0.35,"Purchasing Discount",0.35]
[null,0.4,"Purchasing Discount",0.4]
[null,0.45,"Purchasing Discount",0.45]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Scenario","Variable","Value",null,"Row Labels","Sum of Value"]
[null,"Hospital Affiliation","Medicare Reimbursement",{"$f":"'8. Expected Revenue'!D24","v":0.129},null,"Medicare Reimbursement",0.99]
[null,"Hospital Affiliation","Medicaid Reimbusement",{"$f":"'8. Expected Revenue'!D25","v":0.19800000000000001},null,"Medicaid Reimbusement",0.9]
[null,"No Affiliation","Medicare Reimbursement",0.25,null,"Grand Total",1.8900000000000001]
[null,"No Affiliation","Medicaid Reimbusement",0]
[]
[]
[]
[]
[null,"Scenario","Variable","Value",null,"Row Labels","Sum of Value"]
[null,-0.1,"Demand Growth Rate",-0.1,null,"Demand Growth Rate",0.08]
[null,-0.09,"Demand Growth Rate",-0.09,null,"Grand Total",0.08]
[null,-0.08,"Demand Growth Rate",-0.08]
[null,-7.0000000000000007E-2,"Demand Growth Rate",-7.0000000000000007E-2]
[null,-0.06,"Demand Growth Rate",-0.06]
[null,-0.05,"Demand Growth Rate",-0.05]
[null,-0.04,"Demand Growth Rate",-0.04]
[null,{"$f":"-3%","v":-0.03},"Demand Growth Rate",{"$f":"-3%","v":-0.03}]
[null,-0.02,"Demand Growth Rate",-0.02]
[null,-0.01,"Demand Growth Rate",-0.01]
[null,0,"Demand Growth Rate",0]
[null,0.01,"Demand Growth Rate",0.01]
[null,0.02,"Demand Growth Rate",0.02]
[null,0.03,"Demand Growth Rate",0.03]
[null,0.04,"Demand Growth Rate",0.04]
[null,0.05,"Demand Growth Rate",0.05]
[null,0.06,"Demand Growth Rate",0.06]
[null,7.0000000000000007E-2,"Demand Growth Rate",7.0000000000000007E-2]
[null,0.08,"Demand Growth Rate",0.08]
[null,0.09,"Demand Growth Rate",0.09]
[null,0.1,"Demand Growth Rate",0.1]
[]
[]
[null,"Scenario","Variable","Value",null,"Row Labels","Sum of Value"]
[null,"Favorable Payer Mix","Medicare",0.45,null,"Commercial",0.247]
[null,"Favorable Payer Mix","Medicaid",0.16,null,"Medicaid",0.20699999999999999]
[null,"Favorable Payer Mix","Self Pay",0.05,null,"Medicare",0.33800000000000002]
[null,"Favorable Payer Mix","Commercial",0.34,null,"Other",2.3E-2]
[null,"Favorable Payer Mix","Other",0,null,"Self Pay",0.185]
[null,"Current Payer Mix","Medicare",{"$f":"'8. Expected Revenue'!D13","v":0.26700000000000002},null,"Grand Total",1]
[null,"Current Payer Mix","Medicaid",{"$f":"'8. Expected Revenue'!D14","v":0.27400000000000002}]
[null,"Current Payer Mix","Self Pay",{"$f":"'8. Expected Revenue'!D15","v":0.22800000000000001}]
[null,"Current Payer Mix","Commercial",{"$f":"'8. Expected Revenue'!D16","v":0.20100000000000001}]
[null,"Current Payer Mix","Other",{"$f":"'8. Expected Revenue'!D17","v":0.03}]
[null,"Less Favorable Payer Mix","Medicare",0.2]
[null,"Less Favorable Payer Mix","Medicaid",0.5]
[null,"Less Favorable Payer Mix","Self Pay",0.15]
[null,"Less Favorable Payer Mix","Commercial",0.1]
[null,"Less Favorable Payer Mix","Other",0.05]

{"sheet":"Data Tables","index":14,"n_rows":186,"n_cols":12,"rows_kept":186,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,"Estimated Hospital Payer Mix","Estimated %"]
[null,null,"Medicare",{"$f":"'8. Expected Revenue'!D13","v":0.26700000000000002}]
[null,null,"Medicaid",{"$f":"'8. Expected Revenue'!D14","v":0.27400000000000002}]
[null,null,"Self Pay",{"$f":"'8. Expected Revenue'!D15","v":0.22800000000000001}]
[null,null,"Commercial",{"$f":"'8. Expected Revenue'!D16","v":0.20100000000000001}]
[null,null,"Other (TriCare, etc.)",{"$f":"'8. Expected Revenue'!D17","v":0.03}]
[null,null,"Total",{"$f":"SUM(D8,D9,D10,D11,D12)","v":1}]
[]
[]
[null,"Please enter your estimated reimbursement from each payer into the table below. "]
[]
[]
[null,null,"Payer Reimbursement Rates","Estimated %"]
[null,null,"Medicare",{"$f":"'8. Expected Revenue'!D24","v":0.129}]
[null,null,"Medicaid",{"$f":"'8. Expected Revenue'!D25","v":0.19800000000000001}]
[null,null,"Self Pay",{"$f":"'8. Expected Revenue'!D26","v":3.1E-2}]
[null,null,"Commercial",{"$f":"'8. Expected Revenue'!D27","v":0.58399999999999996}]
[null,null,"Other (TriCare, etc.)",{"$f":"'8. Expected Revenue'!D28","v":0.245}]
[]
[null,null,"% Uncollected",{"$f":"'8. Expected Revenue'!#REF!","v":{"$error":"#REF!"}}]
[]
[null,null,"Estimated ED Revenue"]
[]
[null,null,"Projected Annual ED Demand",{"$f":"(EDMonthlyVolume*12)*(1+F30)","v":10607},null,0]
[]
[null,null,"Average Charge per ED Service",{"$f":"AverageChargeED*Cost_to_Charge","v":1845}]
[]
[]
[null,null,"Annual Revenue by Payer","Column1"]
[null,null,"Medicare",{"$f":"IFERROR(D8*$D$30*$D$32*D20,0)","v":674046.582345}]
[null,null,"Medicaid",{"$f":"IFERROR(D9*$D$30*$D$32*D21,0)","v":1061707.0285800002}]
[null,null,"Self Pay",{"$f":"IFERROR(D10*$D$30*$D$32*D22,0)","v":138320.15922}]
[null,null,"Commercial",{"$f":"IFERROR(D11*$D$30*$D$32*D23,0)","v":2297194.9023599997}]
[null,null,"Other",{"$f":"IFERROR(D12*$D$30*$D$32*D24,0)","v":143838.87524999998}]
[null,null,"Total",{"$f":"SUM(D36:D40)","v":4315107.5477549993}]
[]
[null,null,"Total ED Services Revenue",{"$f":"D41*(1-$D$26)","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[null,null,"Estimated Outpatient Revenue"]
[]
[null,null,"Projected Annual Outpatient Demand",{"$f":"(OPMonthlyVolume*12)*(1+F50)","v":13258.75},null,0]
[]
[null,null,"Average Charge per Outpatient Service",{"$f":"AverageChargeOutpatient*Cost_to_Charge","v":1308}]
[]
[]
[null,null,"Annual Revenue by Payer","Column1"]
[null,null,"Medicare",{"$f":"IFERROR(D8*$D$50*$D$52*D20,0)","v":597325.83313500008}]
[null,null,"Medicaid",{"$f":"IFERROR(D9*$D$50*$D$52*D21,0)","v":940862.32614000014}]
[null,null,"Self Pay",{"$f":"IFERROR(D10*$D$50*$D$52*D22,0)","v":122576.40126}]
[null,null,"Commercial",{"$f":"IFERROR(D11*$D$50*$D$52*D23,0)","v":2035725.5638799998}]
[null,null,"Other",{"$f":"IFERROR(D12*$D$50*$D$52*D24,0)","v":127466.97074999999}]
[null,null,"Total",{"$f":"SUM(D56:D60)","v":3823957.0951649998}]
[]
[null,null,"Total Outpatient Services Revenue",{"$f":"D61*(1-$D$26)","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[null,"Cash Flow Assumptions"]
[]
[null,"Construction/Renovation costs",null,null,{"$f":"'6. Capital Costs'!C13","v":0},null,"Demand growth rate",null,null,{"$f":"DemandGrowthRate*(1+L71)","v":8.8500000000000002E-3},null,0]
[null,"Other Initial Investment costs",null,null,{"$f":"'6. Capital Costs'!C14","v":212140},null,"Inflation rate on costs",null,null,{"$f":"Inflation*(1+L72)","v":0.03},null,0]
[null,"Staffing Costs",null,null,{"$f":"TotalStaffingCost","v":5705111.8584000012},null,"Organizational tax rate",null,null,{"$f":"TaxRate","v":0}]
[null,"Equipment & costs",null,null,{"$f":"TotalEquipCosts*(1-Discount)","v":10607},null,"Cost of capital",null,null,{"$f":"CostofCapital","v":0.04}]
[null,"Other capital costs",null,null,{"$f":"OtherCapitalCosts","v":234414.7},null,"Purchasing Discount",null,null,{"$f":"Discount","v":0}]
[null,"Ancillary costs",null,null,{"$f":"TotalAncillaryCosts","v":570126.25},null,"Medicare reimbursement growth rate",null,null,{"$f":"'3. Key Assumptions'!D62*(1+L76)","v":2.1999999999999999E-2},null,0]
[null,"Facility Costs",null,null,{"$f":"ClinSuppCosts111416[[#Totals],[Cost]]","v":311596.29000000004},null,"Overhead rate (per sq. ft.)",null,null,{"$f":"'7. Operating Costs'!G12","v":3.23}]
[null,"Other Operating costs",null,null,{"$f":"ClinSuppCosts1114[[#Totals],[Cost]]+ClinSuppCosts111417[[#Totals],[Cost]]","v":1994116},null,"Facility Square Footage",null,null,{"$f":"Footage","v":19999.920000000002}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"FED Operating Year"]
[null,null,null,null,"Initial Investment","Year 1","Year 2","Year 3","Year 4","Year 5"]
[null,"Construction/Renovation costs",null,null,{"$f":"-'6. Capital Costs'!C13","v":0}]
[null,"Other Initial Investment costs",null,null,{"$f":"-'6. Capital Costs'!C14","v":-212140}]
[null,"Net patient revenue"]
[null,"ED Services"]
[null,"Medicare",null,null,null,{"$f":"D8*D20*$D$30*$D$32","v":674046.582345},{"$f":"F92*(1+$J$71)*(1+$J$76)","v":694972.15627992584},{"$f":"G92*(1+$J$71)*(1+$J$76)","v":716547.35837998928},{"$f":"H92*(1+$J$71)*(1+$J$76)","v":738792.35615668853},{"$f":"I92*(1+$J$71)*(1+$J$76)","v":761727.94321586622}]
[null,"Medicaid",null,null,null,{"$f":"D9*D21*$D$30*$D$32","v":1061707.0285800002},{"$f":"F93*(1+$J$71)","v":1071103.1357829331},{"$f":"G93*(1+$J$71)","v":1080582.398534612},{"$f":"H93*(1+$J$71)","v":1090145.5527616434},{"$f":"I93*(1+$J$71)","v":1099793.3409035839}]
[null,"Self Pay",null,null,null,{"$f":"D10*D22*$D$30*$D$32","v":138320.15922},{"$f":"F94*(1+$J$71)","v":139544.29262909701},140779.25961886451,142025.15606649147,143282.07869767991]
[null,"Commercial",null,null,null,{"$f":"D11*D23*$D$30*$D$32","v":2297194.9023600002},2317525.0772458864,2338035.1741795125,2358726.7854710012,2379601.5175224198]
[null,"Other",null,null,null,{"$f":"D12*D24*$D$30*$D$32","v":143838.87525000001},145111.84929596251,146396.08916223177,147691.69455131752,148998.76604809667]
[null,"Total ED Services Revenue",null,null,null,{"$f":"SUM(F92:F96)","v":4315107.5477550002},{"$f":"SUM(G92:G96)","v":4368256.5112338047},{"$f":"SUM(H92:H96)","v":4422340.2798752096},{"$f":"SUM(I92:I96)","v":4477381.5450071422},{"$f":"SUM(J92:J96)","v":4533403.6463876469}]
[]
[null,"Outpatient Services"]
[null,"Medicare",null,null,null,{"$f":"D8*D20*$D$50*$D$52","v":597325.83313500008},{"$f":"F100*(1+$J$71)*(1+$J$76)","v":615869.63442692626},{"$f":"G100*(1+$J$71)*(1+$J$76)","v":634989.12246681983},{"$f":"H100*(1+$J$71)*(1+$J$76)","v":654702.16927706555},{"$f":"I100*(1+$J$71)*(1+$J$76)","v":675027.20171162125}]
[null,"Medicaid",null,null,null,{"$f":"D9*D21*$D$50*$D$52","v":940862.32614000014},{"$f":"F101*(1+$J$71)","v":949188.95772633911},{"$f":"G101*(1+$J$71)","v":957589.28000221727},{"$f":"H101*(1+$J$71)","v":966063.94513023691},{"$f":"I101*(1+$J$71)","v":974613.61104463949}]
[null,"Self Pay",null,null,null,{"$f":"D10*D22*$D$50*$D$52","v":122576.40126},{"$f":"F102*(1+$J$71)","v":123661.202411151},124755.60405248968,125859.69114835422,126973.54941501716]
[null,"Commercial",null,null,null,{"$f":"D11*D23*$D$50*$D$52","v":2035725.56388},2053741.7351203382,2071917.3494761533,2090253.8180190173,2108752.5643084855]
[null,"Other",null,null,null,{"$f":"D12*D24*$D$50*$D$52","v":127466.97075000001},128595.05344113751,129733.11966409159,130881.25777311881,132039.55690441091]
[null,"Total Outpatient Services Revenue",null,null,null,{"$f":"SUM(F100:F104)","v":3823957.0951649998},{"$f":"SUM(G100:G104)","v":3871056.5831258921},{"$f":"SUM(H100:H104)","v":3918984.4756617714},{"$f":"SUM(I100:I104)","v":3967760.8813477932},{"$f":"SUM(J100:J104)","v":4017406.4833841743}]
[]
[null,"Total Revenues",null,null,null,{"$f":"SUM(F97,F105)","v":8139064.6429200005},{"$f":"SUM(G97,G105)","v":8239313.0943596968},{"$f":"SUM(H97,H105)","v":8341324.7555369809},{"$f":"SUM(I97,I105)","v":8445142.4263549354},{"$f":"SUM(J97,J105)","v":8550810.1297718212}]
[]
[]
[null,"Equipment & Supplies costs",null,null,null,{"$f":"E74","v":10607},{"$f":"F110*(1+$J$72)","v":10925.210000000001},{"$f":"G110*(1+$J$72)","v":11252.966300000002},11590.555289000002,11938.271947670002]
[null,"Other capital costs",null,null,null,{"$f":"E75","v":234414.7},{"$f":"F111*(1+$J$72)","v":241447.14100000003},248690.55523000003,256151.27188690004,263835.81004350702]
[]
[null,"Operating Costs"]
[null,"Staffing costs",null,null,null,{"$f":"E73","v":5705111.8584000012},{"$f":"F114*(1+$J$72)","v":5876265.2141520018},{"$f":"G114*(1+$J$72)","v":6052553.1705765622},{"$f":"H114*(1+$J$72)","v":6234129.7656938592},{"$f":"I114*(1+$J$72)","v":6421153.6586646754}]
[null,"Ancillary costs",null,null,null,{"$f":"E76","v":570126.25},{"$f":"F115*(1+$J$72)","v":587230.03749999998},604846.93862499995,622992.34678374999,641682.11718726251]
[null,"Facility Costs",null,null,null,{"$f":"E77","v":311596.29000000004},320944.17870000005,330572.50406100007,340489.67918283009,350704.36955831503]
[null,"Other Operating costs",null,null,null,{"$f":"E78","v":1994116},2053939.48,2115557.6644000001,2179024.3943320001,2244395.12616196]
[null,"Total Operating Costs",null,null,null,{"$f":"SUM(F114:F117)","v":8580950.3984000012},{"$f":"SUM(G114:G117)","v":8838378.910352001},{"$f":"SUM(H114:H117)","v":9103530.2776625622},{"$f":"SUM(I114:I117)","v":9376636.1859924383},{"$f":"SUM(J114:J117)","v":9657935.2715722136}]
[]
[null,"Incremental overhead",null,null,null,{"$f":"J77*J78","v":64599.741600000008},66537.733848000003,68533.865863440005,70589.881839343201,72707.578294523497]
[null,"Depreciation",null,null,null,{"$f":"'9. Pro Forma'!F60","v":0},{"$f":"'9. Pro Forma'!G60","v":0},{"$f":"'9. Pro Forma'!H60","v":0},{"$f":"'9. Pro Forma'!I60","v":0},{"$f":"'9. Pro Forma'!J60","v":0}]
[null,"Total Costs",null,null,null,{"$f":"SUM(F110:F111,F114:F117,F120:F121)","v":8890571.8399999999},{"$f":"SUM(G110:G111,G114:G117,G120:G121)","v":9157288.9952000007},{"$f":"SUM(H110:H111,H114:H117,H120:H121)","v":9432007.6650560033},{"$f":"SUM(I110:I111,I114:I117,I120:I121)","v":9714967.8950076811},{"$f":"SUM(J110:J111,J114:J117,J120:J121)","v":10006416.931857914}]
[]
[null,"  Income before taxes",null,null,null,{"$f":"F107-F122","v":-751507.19707999937},{"$f":"G107-G122","v":-917975.90084030386},{"$f":"H107-H122","v":-1090682.9095190223},{"$f":"I107-I122","v":-1269825.4686527457},{"$f":"J107-J122","v":-1455606.8020860925}]
[null,"Taxes",null,null,null,{"$f":"$J$73*F124","v":0},{"$f":"$J$73*G124","v":0},{"$f":"$J$73*H124","v":0},{"$f":"$J$73*I124","v":0},{"$f":"$J$73*J124","v":0}]
[null,"  Projected net income",null,null,null,{"$f":"F124-F125","v":-751507.19707999937},{"$f":"G124-G125","v":-917975.90084030386},{"$f":"H124-H125","v":-1090682.9095190223},{"$f":"I124-I125","v":-1269825.4686527457},{"$f":"J124-J125","v":-1455606.8020860925}]
[null,"Plus: Depreciation",null,null,null,{"$f":"F121","v":0},{"$f":"G121","v":0},{"$f":"H121","v":0},{"$f":"I121","v":0},{"$f":"J121","v":0}]
[null,"Plus: Net building/equipment salvage value",null,null,null,null,null,null,null,{"$f":"'9. Pro Forma'!J68","v":100}]
[]
[null,"Net cash flow",null,null,{"$f":"SUM(E88:E89)","v":-212140},{"$f":"F126+F127+F128","v":-751507.19707999937},{"$f":"G126+G127+G128","v":-917975.90084030386},{"$f":"H126+H127+H128","v":-1090682.9095190223},{"$f":"I126+I127+I128","v":-1269825.4686527457},{"$f":"J126+J127+J128","v":-1455506.8020860925}]
[]
[null,"Cumulative net cash flow",null,null,{"$f":"E130","v":-212140},{"$f":"E130+F130","v":-963647.19707999937},{"$f":"E130+F130+G130","v":-1881623.0979203032},{"$f":"E130+F130+G130+H130","v":-2972306.0074393256},{"$f":"E130+F130+G130+H130+I130","v":-4242131.4760920713},{"$f":"E130+F130+G130+H130+I130+J130","v":-5697638.2781781638}]
[]
[null,null,null,null,null,{"$f":"IF(F132<0,\"n/m\",ABS(E132)/F130)","v":"n/m"},{"$f":"IF(G132<0,\"n/m\",ABS(F132)/G130)","v":"n/m"},{"$f":"IF(H132<0,\"n/m\",ABS(G132)/H130)","v":"n/m"},{"$f":"IF(I132<0,\"n/m\",ABS(H132)/I130)","v":"n/m"},{"$f":"IF(J132<0,\"n/m\",ABS(I132)/J130)","v":"n/m"}]
[]
[]
[null,"NPV",null,null,{"$f":"NPV(J74,F130:J130)+E130","v":-5034849.1588526955}]
[null,"IRR",null,null,{"$f":"IFERROR(IRR(E130:J130),\"Unable to Calculate\")","v":"Unable to Calculate"}]
[null,"MIRR",null,null,{"$f":"IFERROR(MIRR(E130:J130,$J$74,$J$74),\"Unable to Calculate\")","v":-1}]
[null,"Payback Period",null,null,{"$f":"IFERROR(COUNTIF(F132:J132,\"<0\")+INDEX(F134:J134,COUNTIF(F132:J132,\"<0\")+1),\"n/a\")","v":"n/a"}]
[null,"Payback Period (Show)",null,null,{"$f":"IF(E140<=5,E140,\"Greater Than Projected Time Period\")","v":"Greater Than Projected Time Period"}]
[]
[]
[]
[]
[]
[null,null,"Change in Patient Volume (ED Services)"]
[null,null,null,{"$f":"E137","v":-5034849.1588526955}]
[null,null,-0.5,-14871197.573017461]
[null,null,-0.4,-12903927.890184505]
[null,null,-0.3,-10936658.207351552]
[null,null,-0.2,-8969388.5245186016]
[null,null,-0.1,-7002118.8416856453]
[null,null,0,-5034849.1588526955]
[null,null,0.1,-3067579.4760197415]
[null,null,0.2,-1100309.7931867898]
[null,null,0.3,866959.88964616391]
[null,null,0.4,2834229.5724791144]
[null,null,0.5,4801499.2553120693]
[]
[null,null,"Change in Patient Volume (Outpatient Services)"]
[null,null,null,{"$f":"E137","v":-5034849.1588526955}]
[null,null,-0.5,-13751613.200673504]
[null,null,-0.4,-12008260.392309342]
[null,null,-0.3,-10264907.583945177]
[null,null,-0.2,-8521554.7755810171]
[null,null,-0.1,-6778201.9672168577]
[null,null,0,-5034849.1588526955]
[null,null,0.1,-3291496.3504885309]
[null,null,0.2,-1548143.5421243743]
[null,null,0.3,195209.26623978716]
[null,null,0.4,1938562.0746039497]
[null,null,0.5,3681914.8829681133]
[]
[]
[null,null,"Changes in Medicare Growth Rate"]
[null,null,null,{"$f":"E137","v":-5034849.1588526955}]
[null,null,-1,-5285836.6923296684]
[null,null,-0.75,-5224101.0550142368]
[null,null,-0.5,-5161694.9055312499]
[null,null,-0.25,-5098612.7720213477]
[null,null,0,-5034849.1588526955]
[null,null,0.25,-4970398.5466209725]
[null,null,0.5,-4905255.3921493962]
[null,null,0.75,-4839414.1284886757]
[null,null,1,-4772869.1649170667]

{"sheet":"Scenario Model","index":15,"n_rows":141,"n_cols":10,"rows_kept":141,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,"Estimated Hospital Payer Mix","Estimated %"]
[null,null,"Medicare",{"$f":"GETPIVOTDATA(\"Value\",'Scenario Data'!$F$98,\"Variable\",\"Medicare\")","v":0.33800000000000002}]
[null,null,"Medicaid",{"$f":"GETPIVOTDATA(\"Value\",'Scenario Data'!$F$98,\"Variable\",\"Medicaid\")","v":0.20699999999999999}]
[null,null,"Self Pay",{"$f":"GETPIVOTDATA(\"Value\",'Scenario Data'!$F$98,\"Variable\",\"Self Pay\")","v":0.185}]
[null,null,"Commercial",{"$f":"GETPIVOTDATA(\"Value\",'Scenario Data'!$F$98,\"Variable\",\"Commercial\")","v":0.247}]
[null,null,"Other (TriCare, etc.)",{"$f":"GETPIVOTDATA(\"Value\",'Scenario Data'!$F$98,\"Variable\",\"Other\")","v":2.3E-2}]
[null,null,"Total",{"$f":"SUM(D8,D9,D10,D11,D12)","v":1}]
[]
[]
[null,"Please enter your estimated reimbursement from each payer into the table below. "]
[]
[]
[null,null,"Payer Reimbursement Rates","Estimated %"]
[null,null,"Medicare",{"$f":"GETPIVOTDATA(\"Value\",'Scenario Data'!$F$65,\"Variable\",\"Medicare Reimbursement\")","v":0.99}]
[null,null,"Medicaid",{"$f":"GETPIVOTDATA(\"Value\",'Scenario Data'!$F$65,\"Variable\",\"Medicaid Reimbusement\")","v":0.9}]
[null,null,"Self Pay",{"$f":"'8. Expected Revenue'!D26","v":3.1E-2}]
[null,null,"Commercial",{"$f":"'8. Expected Revenue'!D27","v":0.58399999999999996}]
[null,null,"Other (TriCare, etc.)",{"$f":"'8. Expected Revenue'!D28","v":0.245}]
[null,null,"% Uncollected",{"$f":"'8. Expected Revenue'!D29","v":0}]
[]
[]
[]
[null,null,"Estimated ED Revenue"]
[]
[null,null,"Projected Annual ED Demand",{"$f":"(EDMonthlyVolume*12)","v":10607}]
[]
[null,null,"Average Charge per ED Service",{"$f":"AverageChargeED*Cost_to_Charge","v":1845}]
[]
[]
[null,null,"Annual Revenue by Payer","Column1"]
[null,null,"Medicare",{"$f":"IFERROR(D8*$D$31*$D$33*D20,0)","v":6548484.9573000008}]
[null,null,"Medicaid",{"$f":"IFERROR(D9*$D$31*$D$33*D21,0)","v":3645875.1645}]
[null,null,"Self Pay",{"$f":"IFERROR(D10*$D$31*$D$33*D22,0)","v":112233.462525}]
[null,null,"Commercial",{"$f":"IFERROR(D11*$D$31*$D$33*D23,0)","v":2822921.0989199998}]
[null,null,"Other",{"$f":"IFERROR(D12*$D$31*$D$33*D24,0)","v":110276.47102499999}]
[null,null,"Total",{"$f":"SUM(D37:D41)","v":13239791.154270003}]
[]
[null,null,"Total ED Services Revenue",{"$f":"D42*(1-$D$25)","v":13239791.154270003}]
[]
[]
[]
[]
[null,null,"Estimated Outpatient Revenue"]
[]
[null,null,"Projected Annual Outpatient Demand",{"$f":"OPMonthlyVolume*12","v":13258.75}]
[]
[null,null,"Average Charge per Outpatient Service",{"$f":"'8. Expected Revenue'!D63","v":1308}]
[]
[]
[null,null,"Annual Revenue by Payer","Column1"]
[null,null,"Medicare",{"$f":"IFERROR(D8*$D$51*$D$53*D20,0)","v":5803128.9458999997}]
[null,null,"Medicaid",{"$f":"IFERROR(D9*$D$51*$D$53*D21,0)","v":3230897.5034999996}]
[null,null,"Self Pay",{"$f":"IFERROR(D10*$D$51*$D$53*D22,0)","v":99458.922075000009}]
[null,null,"Commercial",{"$f":"IFERROR(D11*$D$51*$D$53*D23,0)","v":2501613.00636}]
[null,null,"Other",{"$f":"IFERROR(D12*$D$51*$D$53*D24,0)","v":97724.677575000009}]
[null,null,"Total",{"$f":"SUM(D57:D61)","v":11732823.05541}]
[]
[null,null,"Total Outpatient Services Revenue",{"$f":"D62*(1-D25)","v":11732823.05541}]
[]
[]
[]
[]
[]
[null,"Cash Flow Assumptions"]
[]
[null,"Construction/Renovation costs",null,null,{"$f":"'6. Capital Costs'!C13","v":0},null,"Demand growth rate",null,null,{"$f":"GETPIVOTDATA(\"Value\",'Scenario Data'!$F$74,\"Variable\",\"Demand Growth Rate\")","v":0.08}]
[null,"Other Initial Investment costs",null,null,{"$f":"'6. Capital Costs'!C14","v":212140},null,"Inflation rate on costs",null,null,{"$f":"'3. Key Assumptions'!D13","v":0.03}]
[null,"Staffing Costs",null,null,{"$f":"TotalStaffingCost","v":5705111.8584000012},null,"Organizational tax rate",null,null,{"$f":"GETPIVOTDATA(\"Value\",'Scenario Data'!$F$33,\"Variable\",\"Tax Rate\")","v":0}]
[null,"Equipment & Supplies costs",null,null,{"$f":"TotalEquipCosts*(1-J76)","v":8485.6},null,"Cost of capital",null,null,{"$f":"GETPIVOTDATA(\"Value\",'Scenario Data'!$F$17,\"Variable\",\"Cost of Capital\")","v":0.04}]
[null,"Other capital costs",null,null,{"$f":"OtherCapitalCosts","v":234414.7},null,"Purchasing Discount",null,null,{"$f":"GETPIVOTDATA(\"Value\",'Scenario Data'!$F$46,\"Variable\",\"Purchasing Discount\")","v":0.2}]
[null,"Ancillary costs",null,null,{"$f":"TotalAncillaryCosts","v":570126.25},null,"Medicare reimbursement growth rate",null,null,{"$f":"'3. Key Assumptions'!D62","v":2.1999999999999999E-2}]
[null,"Facility Costs",null,null,{"$f":"ClinSuppCosts111416[[#Totals],[Cost]]","v":311596.29000000004},null,"Overhead rate (per sq. ft.)",null,null,{"$f":"'7. Operating Costs'!G12","v":3.23}]
[null,"Other Operating costs",null,null,{"$f":"ClinSuppCosts1114[[#Totals],[Cost]]+ClinSuppCosts111417[[#Totals],[Cost]]","v":1994116},null,"Facility Square Footage",null,null,{"$f":"Footage","v":19999.920000000002}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"FED Operating Year"]
[null,null,null,null,"Initial Investment","Year 1","Year 2","Year 3","Year 4","Year 5"]
[null,"Construction/Renovation costs",null,null,{"$f":"-'6. Capital Costs'!C13","v":0}]
[null,"Other Initial Investment costs",null,null,{"$f":"-'6. Capital Costs'!C14","v":-212140}]
[null,"Net patient revenue"]
[null,"ED Services"]
[null,"Medicare",null,null,null,{"$f":"D8*D20*$D$31*$D$33","v":6548484.9573000008},{"$f":"F92*(1+$J$72)*(1+$J$77)","v":7227955.75646945},{"$f":"G92*(1+$J$72)*(1+$J$77)","v":7977928.4457607204},{"$f":"H92*(1+$J$72)*(1+$J$77)","v":8805718.3012928534},{"$f":"I92*(1+$J$72)*(1+$J$77)","v":9719399.6322349999}]
[null,"Medicaid",null,null,null,{"$f":"D9*D21*$D$31*$D$33","v":3645875.1645},{"$f":"F93*(1+$J$72)","v":3937545.17766},{"$f":"G93*(1+$J$72)","v":4252548.7918728003},{"$f":"H93*(1+$J$72)","v":4592752.6952226246},{"$f":"I93*(1+$J$72)","v":4960172.910840435}]
[null,"Self Pay",null,null,null,{"$f":"D10*D22*$D$31*$D$33","v":112233.462525},{"$f":"F94*(1+$J$72)","v":121212.13952700001},130909.11068916002,141381.83954429283,152692.38670783627]
[null,"Commercial",null,null,null,{"$f":"D11*D23*$D$31*$D$33","v":2822921.0989199998},3048754.7868336001,3292655.1697802884,3556067.5833627116,3840552.990031729]
[null,"Other",null,null,null,{"$f":"D12*D24*$D$31*$D$33","v":110276.47102499999},119098.588707,128626.47580356001,138916.59386784481,150029.9213772724]
[null,"Total ED Services Revenue",null,null,null,{"$f":"SUM(F92:F96)","v":13239791.154270003},{"$f":"SUM(G92:G96)","v":14454566.44919705},{"$f":"SUM(H92:H96)","v":15782667.993906528},{"$f":"SUM(I92:I96)","v":17234837.013290331},{"$f":"SUM(J92:J96)","v":18822847.841192272}]
[]
[null,"Outpatient Services"]
[null,"Medicare",null,null,null,{"$f":"D8*D20*$D$51*$D$53","v":5803128.9458999997},{"$f":"F100*(1+$J$72)*(1+$J$77)","v":6405261.6053265836},{"$f":"G100*(1+$J$72)*(1+$J$77)","v":7069871.5494952705},{"$f":"H100*(1+$J$72)*(1+$J$77)","v":7803441.4214709001},{"$f":"I100*(1+$J$72)*(1+$J$77)","v":8613126.5033627208}]
[null,"Medicaid",null,null,null,{"$f":"D9*D21*$D$51*$D$53","v":3230897.5035000001},{"$f":"F101*(1+$J$72)","v":3489369.3037800002},{"$f":"G101*(1+$J$72)","v":3768518.8480824004},{"$f":"H101*(1+$J$72)","v":4070000.3559289929},{"$f":"I101*(1+$J$72)","v":4395600.3844033126}]
[null,"Self Pay",null,null,null,{"$f":"D10*D22*$D$51*$D$53","v":99458.92207499998},{"$f":"F102*(1+$J$72)","v":107415.63584099998},116008.88670827998,125289.59764494239,135312.7654565378]
[null,"Commercial",null,null,null,{"$f":"D11*D23*$D$51*$D$53","v":2501613.0063599995},2701742.0468687997,2917881.4106183038,3151311.9234677684,3403416.8773451899]
[null,"Other",null,null,null,{"$f":"D12*D24*$D$51*$D$53","v":97724.677574999994},105542.65178100001,113986.06392348002,123104.94903735843,132953.34496034711]
[null,"Total Outpatient Services Revenue",null,null,null,{"$f":"SUM(F100:F104)","v":11732823.05541},{"$f":"SUM(G100:G104)","v":12809331.243597385},{"$f":"SUM(H100:H104)","v":13986266.758827735},{"$f":"SUM(I100:I104)","v":15273148.247549962},{"$f":"SUM(J100:J104)","v":16680409.875528108}]
[]
[null,"Total Revenues",null,null,null,{"$f":"SUM(F97,F105)","v":24972614.209680002},{"$f":"SUM(G97,G105)","v":27263897.692794435},{"$f":"SUM(H97,H105)","v":29768934.752734262},{"$f":"SUM(I97,I105)","v":32507985.260840293},{"$f":"SUM(J97,J105)","v":35503257.71672038}]
[]
[null,"Less: Capital Costs"]
[null,"Equipment & Supplies costs",null,null,null,{"$f":"E75","v":8485.6},{"$f":"F110*(1+$J$73)","v":8740.1680000000015},{"$f":"G110*(1+$J$73)","v":9002.3730400000022},9272.4442312000028,9550.6175581360039]
[null,"Other capital costs",null,null,null,{"$f":"E76","v":234414.7},{"$f":"F111*(1+$J$73)","v":241447.14100000003},248690.55523000003,256151.27188690004,263835.81004350702]
[]
[null,"Operating Costs"]
[null,"Staffing",null,null,null,{"$f":"E74","v":5705111.8584000012},{"$f":"F114*(1+$J$73)","v":5876265.2141520018},{"$f":"G114*(1+$J$73)","v":6052553.1705765622},{"$f":"H114*(1+$J$73)","v":6234129.7656938592},{"$f":"I114*(1+$J$73)","v":6421153.6586646754}]
[null,"Ancillary costs",null,null,null,{"$f":"E77","v":570126.25},{"$f":"F115*(1+$J$73)","v":587230.03749999998},604846.93862499995,622992.34678374999,641682.11718726251]
[null,"Facility Costs",null,null,null,{"$f":"E78","v":311596.29000000004},320944.17870000005,330572.50406100007,340489.67918283009,350704.36955831503]
[null,"Other Operating costs",null,null,null,{"$f":"E79","v":1994116},2053939.48,2115557.6644000001,2179024.3943320001,2244395.12616196]
[null,"Total Operating Costs",null,null,null,{"$f":"SUM(F114:F117)","v":8580950.3984000012},{"$f":"SUM(G114:G117)","v":8838378.910352001},{"$f":"SUM(H114:H117)","v":9103530.2776625622},{"$f":"SUM(I114:I117)","v":9376636.1859924383},{"$f":"SUM(J114:J117)","v":9657935.2715722136}]
[]
[null,"Incremental overhead",null,null,null,{"$f":"J78*J79","v":64599.741600000008},66537.733848000003,68533.865863440005,70589.881839343201,72707.578294523497]
[null,"Depreciation",null,null,null,{"$f":"IF($J$74>0,EquipCosts106[[#Totals],[Depreciation]],0)","v":0},{"$f":"IF($J$74>0,EquipCosts106[[#Totals],[Depreciation]],0)","v":0},{"$f":"IF($J$74>0,EquipCosts106[[#Totals],[Depreciation]],0)","v":0},{"$f":"IF($J$74>0,EquipCosts106[[#Totals],[Depreciation]],0)","v":0},{"$f":"IF($J$74>0,EquipCosts106[[#Totals],[Depreciation]],0)","v":0}]
[null,"Total Costs",null,null,null,{"$f":"SUM(F110:F111,F114:F117,F120:F121)","v":8888450.4400000013},{"$f":"SUM(G110:G111,G114:G117,G120:G121)","v":9155103.9532000013},{"$f":"SUM(H110:H111,H114:H117,H120:H121)","v":9429757.0717960037},{"$f":"SUM(I110:I111,I114:I117,I120:I121)","v":9712649.7839498818},{"$f":"SUM(J110:J111,J114:J117,J120:J121)","v":10004029.27746838}]
[]
[null,"  Income before taxes",null,null,null,{"$f":"F107-F122","v":16084163.769680001},{"$f":"G107-G122","v":18108793.739594433},{"$f":"H107-H122","v":20339177.680938259},{"$f":"I107-I122","v":22795335.476890411},{"$f":"J107-J122","v":25499228.439252}]
[null,"Taxes",null,null,null,{"$f":"$J$74*F124","v":0},{"$f":"$J$74*G124","v":0},{"$f":"$J$74*H124","v":0},{"$f":"$J$74*I124","v":0},{"$f":"$J$74*J124","v":0}]
[null,"  Projected net income",null,null,null,{"$f":"F124-F125","v":16084163.769680001},{"$f":"G124-G125","v":18108793.739594433},{"$f":"H124-H125","v":20339177.680938259},{"$f":"I124-I125","v":22795335.476890411},{"$f":"J124-J125","v":25499228.439252}]
[null,"Plus: Depreciation",null,null,null,{"$f":"F121","v":0},{"$f":"G121","v":0},{"$f":"H121","v":0},{"$f":"I121","v":0},{"$f":"J121","v":0}]
[null,"Plus: Net building/equipment salvage value",null,null,null,null,null,null,null,{"$f":"'9. Pro Forma'!J68","v":100}]
[]
[null,"Net cash flow",null,null,{"$f":"SUM(E88:E89)","v":-212140},{"$f":"F126+F127+F128","v":16084163.769680001},{"$f":"G126+G127+G128","v":18108793.739594433},{"$f":"H126+H127+H128","v":20339177.680938259},{"$f":"I126+I127+I128","v":22795335.476890411},{"$f":"J126+J127+J128","v":25499328.439252}]
[]
[null,"Cumulative net cash flow",null,null,{"$f":"E130","v":-212140},{"$f":"E130+F130","v":15872023.769680001},{"$f":"E130+F130+G130","v":33980817.509274438},{"$f":"E130+F130+G130+H130","v":54319995.190212697},{"$f":"E130+F130+G130+H130+I130","v":77115330.667103112},{"$f":"E130+F130+G130+H130+I130+J130","v":102614659.10635512}]
[]
[null,null,null,null,null,{"$f":"IF(F132<0,\"n/m\",ABS(E132)/F130)","v":1.3189370802099249E-2},{"$f":"IF(G132<0,\"n/m\",ABS(F132)/G130)","v":0.87648155906575986},{"$f":"IF(H132<0,\"n/m\",ABS(G132)/H130)","v":1.6707075400162825},{"$f":"IF(I132<0,\"n/m\",ABS(H132)/I130)","v":2.3829434423231692},{"$f":"IF(J132<0,\"n/m\",ABS(I132)/J130)","v":3.0242102591375235}]
[]
[]
[null,"NPV",null,null,{"$f":"NPV(J75,F130:J130)+E130","v":90521592.295099989}]
[null,"IRR",null,null,{"$f":"IFERROR(IRR(E130:J130),\"Unable to Calculate\")","v":75.944465107099077}]
[null,"MIRR",null,null,{"$f":"IFERROR(MIRR(E130:J130,$J$75,$J$75),\"Unable to Calculate\")","v":2.4935147525502335}]
[null,"Payback Period",null,null,{"$f":"IFERROR(COUNTIF(F132:J132,\"<0\")+INDEX(F134:J134,COUNTIF(F132:J132,\"<0\")+1),\"n/a\")","v":1.3189370802099249E-2}]
[null,"Payback Period (Show)",null,null,{"$f":"IF(E140<=5,E140,\"Greater Than Projected Time Period\")","v":1.3189370802099249E-2}]

{"sheet":"Avg Cost Curve","index":16,"n_rows":122,"n_cols":19,"rows_kept":122,"cut":false,"hidden":true,"merged":[]}
[null,"12 Bed","12 Bed","12 Bed","12 Bed","12 Bed"]
["Scenario","ED Vis (Ann)","# Tot Visits","Tot Exp","Avg Cost/Visit","MC"]
["Min",8972,20187,8394467,{"$f":"D3/C3","v":415.83529003814334}]
[null,null,{"$f":"C5-3000","v":20866},{"$f":"D5-(3000*$F$6)","v":8476792.9636247605},{"$f":"D4/C4","v":406.24906372207232},{"$f":"(D4-D3)/(C4-C3)","v":121.24589635458102}]
["Model",10607,23866,8840822,370.4358501634124,{"$f":"(D5-D3)/(C5-C3)","v":121.32508833922262}]
["Mid",12000,27000,9221111,341.52262962962965,{"$f":"(D6-D5)/(C6-C5)","v":121.34301212507977}]
[null,null,{"$f":"C6+3000","v":30000},{"$f":"D6+(3000*$F$6)","v":9585140.0363752395},319.50466787917463]
[null,null,33000,9949169.072750479,301.48997190152966]
[null,null,36000,10313198.109125718,286.47772525349217]
[null,null,39000,10677227.145500958,273.77505501284509]
[null,null,42000,11041256.181876197,262.88705194943327]
[null,null,45000,11405285.218251437,253.4507826278097]
["Max",{"$f":"1800*12","v":21600},48600,11841911,243.66072016460905]
[]
[null,null,"sheet 2. annual ed plus annual OP","tab 9. F61"]
[null,null,"also on tab 8 annualized"]
[null,null,{"$f":"'8. Expected Revenue'!D41+'8. Expected Revenue'!D61","v":23865.75},{"$f":"'9. Pro Forma'!F61","v":8840821.8984000012}]
[]
["Scenario",null,"# Tot Visits","Tot Exp","Avg Cost/Visit"]
["Min",null,0,5945111,{"$f":"D20/C20","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[]
[null,"6 Bed","6 Bed","6 Bed","6 Bed","6 Bed",null,"12 Bed","12 Bed","12 Bed","12 Bed","12 Bed",null,null,"18 Bed","18 Bed","18 Bed","18 Bed","18 Bed"]
["Scenario","ED Vis (Ann)","# Tot Visits","Tot Exp","Avg Cost/Visit","MC","Scenario","ED Vis (Ann)","# Tot Visits","Tot Exp","Avg Cost/Visit","MC",null,"Scenario","ED Vis (Ann)","# Tot Visits","Tot Exp","Avg Cost/Visit","MC"]
["Min",4188,7329,5318482,725.67635420930549,null,"Min",8972,20187,8394467,{"$f":"J29/I29","v":415.83529003814334},null,null,"Min",10800,25164,11222123,445.95942616436179]
[null,null,8347,5463843.8820468346,654.58774194882403,142.79163265897304,null,null,{"$f":"I31-3000","v":21334},{"$f":"J31-(3000*$F$6)","v":8533576.9636247605},399.99892020365428,{"$f":"(J30-J29)/(I30-I29)","v":121.28157247145641},null,null,null,30594,11866925.168320218,387.88406773616452,118.74809729654109]
["Model",5341,9347,5606732,599.84294426019039,142.8394449950446,"Model",10815,24334,8897606,365.64502342401579,{"$f":"(J31-J29)/(I31-I29)","v":121.32601880877743},null,"Model",15491,36094,12520029,346.87285975508394,118.74711802378773]
["Mid",6000,10500,5771482,549.6649523809524,142.88811795316565,"Mid",12000,27000,9221111,341.52262962962965,{"$f":"(J32-J31)/(I32-I31)","v":121.34471117779445},null,"Mid",18000,41940,13214219,315.07436814496901,118.74615121450564]
[null,null,11500,5914370.1179531654,514.29305373505781,null,null,null,{"$f":"I32+3000","v":30000},{"$f":"J32+(3000*$F$6)","v":9585140.0363752395},319.50466787917463,null,null,null,null,47440,13867322.831679782,292.31287587857889]
[null,null,12500,6057258.2359063309,484.58065887250649,null,null,null,33000,9949169.072750479,301.48997190152966,null,null,null,null,52940,14520426.663359564,274.2808209928138]
[null,null,13500,6200146.3538594963,459.27010028588859,null,null,null,36000,10313198.109125718,286.47772525349217,null,null,null,null,58440,15173530.495039346,259.64289005885257]
[null,null,14500,6343034.4718126617,437.45065322845943,null,null,null,39000,10677227.145500958,273.77505501284509,null,null,null,null,63940,15826634.326719128,247.52321436845679]
[null,null,15500,6485922.5897658272,418.44661869456951,null,null,null,42000,11041256.181876197,262.88705194943327,null,null,null,null,69440,16479738.158398909,237.3234181797078]
[null,null,16500,6628810.7077189926,401.74610349812076,null,null,null,45000,11405285.218251437,253.4507826278097,null,null,null,null,74940,17132841.990078691,228.62078983291556]
[null,null,17500,6771698.825672158,386.9542186098376,null,"Max",{"$f":"1800*12","v":21600},48600,11841911,243.66072016460905,null,null,"Max",32400,75492,17198411,227.81766279870715]
["Max",10800,18900,6971482,368.86148148148146]
[]
[]
[null,null,"# Tot Visits","6 Bed","12 Bed","18 Bed"]
[null,null,7329,725.67635420930549]
[null,null,8347,654.58774194882403]
[null,null,9347,599.84294426019039]
[null,null,10500,549.6649523809524]
[null,null,11500,514.29305373505781]
[null,null,12500,484.58065887250649]
[null,null,13500,459.27010028588859]
[null,null,14500,437.45065322845943]
[null,null,15500,418.44661869456951]
[null,null,16500,401.74610349812076]
[null,null,17500,386.9542186098376]
[null,null,18900,368.86148148148146]
[null,null,20187,null,415.83529003814334]
[null,null,{"$f":"C58-3000","v":21334},null,399.9986812818326]
[null,null,24334,null,365.64502342401579]
[null,null,27000,null,341.52262962962965]
[null,null,{"$f":"C59+3000","v":30000},null,319.50483778444607]
[null,null,33000,null,301.49028082020504]
[null,null,36000,null,286.47815001667078]
[null,null,39000,null,273.77557779829567]
[null,null,42000,null,262.88765875397416]
[null,null,45000,null,253.4514622488955]
[null,null,48600,null,243.66072016460905]
[null,null,25164,null,null,445.95942616436179]
[null,null,30594,null,null,387.88406773616452]
[null,null,36094,null,null,346.87285975508394]
[null,null,41940,null,null,315.07436814496901]
[null,null,47440,null,null,292.31287587857889]
[null,null,52940,null,null,274.2808209928138]
[null,null,58440,null,null,259.64289005885257]
[null,null,63940,null,null,247.52321436845679]
[null,null,69440,null,null,237.3234181797078]
[null,null,74940,null,null,228.62078983291556]
[null,null,75492,null,null,227.81766279870715]
[]
[]
[]
[]
[null,null,"# Tot Visits","6 Bed","12 Bed","18 Bed"]
[null,null,7329,725.67635420930549]
[null,null,8347,654.58774194882403]
[null,null,9347,599.84294426019039]
[null,null,10500,549.6649523809524]
[null,null,11500,514.29305373505781]
[null,null,12500,484.58065887250649]
[null,null,13500,459.27010028588859]
[]
[]
[]
[]
[]
[null,null,20187,null,415.83529003814334]
[null,null,{"$f":"C97-3000","v":21334},null,399.9986812818326]
[null,null,24334,null,365.64502342401579]
[null,null,27000,null,341.52262962962965]
[null,null,{"$f":"C98+3000","v":30000},null,319.50483778444607]
[]
[]
[]
[]
[]
[]
[]
[null,null,30594,null,null,387.88406773616452]
[null,null,36094,null,null,346.87285975508394]
[null,null,41940,null,null,315.07436814496901]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"# Tot Visits","Hospital Size"]
[null,9347,"Low",599.84294426019039]
[null,23866,"Medium",370]
[null,36094,"High",346.87285975508394]

{"sheet":"Expense Summary","index":17,"n_rows":64,"n_cols":13,"rows_kept":64,"cut":false,"hidden":true,"merged":[[0,1,0,4],[11,6,11,9],[12,7,12,9]]}
[null,"Summary"]
[null,null,"Low","Medium","High"]
[null,"# of Beds",6,{"$f":"NumberBeds","v":12},18]
[null,"Square Footage",14000,{"$f":"Footage","v":19999.920000000002},27500]
[null,"# of ED Visits (annually)",5341,{"$f":"'8. Expected Revenue'!D41","v":10607},15491]
[null,"# of OP Visits (annually)",4006,{"$f":"'8. Expected Revenue'!D61","v":13258.75},20603]
[null,"# of Total Visits (annually)",{"$f":"C5+C6","v":9347},{"$f":"D5+D6","v":23865.75},{"$f":"E5+E6","v":36094}]
[]
[]
[]
[]
[null,null,null,null,null,null,"Costs"]
[null,null,null,null,null,null,null,"Year 1"]
[null,null,null,null,null,null,null,"Low","Medium","High"]
[null,null,null,null,null,null,"Operating Costs"]
[null,null,null,null,null,null,"Staffing Costs",null,null,null,{"$f":"H16/H53","v":0},{"$f":"I16/I53","v":0},{"$f":"J16/J53","v":0}]
[null,null,null,null,null,null,"  Administration",154691,235298,235298]
[null,null,null,null,null,null,"  Clinical Providers",1610784,2660501,3733596]
[null,null,null,null,null,null,"  Clinical Support",1417390,1808817,2540614]
[null,null,null,null,null,null,"  Non-clinical Support",840011,1000496,1394467]
[null,null,null,null,null,null,"  Total Staffing Costs",{"$f":"SUM(H17:H20)","v":4022876},{"$f":"SUM(I17:I20)","v":5705112},{"$f":"SUM(J17:J20)","v":7903975}]
[null,null,null,null,null,null,"Non-labor Operating Costs",1176355,{"$f":"+LabCosts18[[#Totals],[Cost]]+ClinSuppCosts1114[[#Totals],[Cost]]","v":2564242.25},3798238]
[null,null,null,null,null,null,"Facility Costs",196040.01,{"$f":"ClinSuppCosts111416[[#Totals],[Cost]]","v":311596.29000000004},438286.89]
[null,null,null,null,null,null,"Total Operating Costs",{"$f":"SUM(H21:H23)","v":5395271.0099999998},{"$f":"SUM(I21:I23)","v":8580950.5399999991},{"$f":"SUM(J21:J23)","v":12140499.890000001}]
[]
[null,null,null,null,null,null,{"$f":"'9. Pro Forma'!B48","v":"Capital Cost"}]
[null,null,null,null,null,null,"  Initial Investment Cost (Amortized Portion)",7477.4,{"$f":"'9. Pro Forma'!F49","v":14849.8},21687.4]
[null,null,null,null,null,null,"Net patient revenue"]
[null,null,null,null,null,null,"ED Services"]
[null,null,null,null,null,null,"Medicare",359255.52050849999,{"$f":"'8. Expected Revenue'!D47","v":674046.582345},1041982.2632835]
[null,null,null,null,null,null,"Medicaid",515107.69241399999,{"$f":"'8. Expected Revenue'!D48","v":1061707.0285800002},1494014.8405140003]
[null,null,null,null,null,null,"Self-Pay/Uninsured",66070.071395999999,{"$f":"'8. Expected Revenue'!D49","v":138320.15922},191629.18479599999]
[null,null,null,null,null,null,"Commercial",1152924.1254404997,{"$f":"'8. Expected Revenue'!D50","v":2297194.9023599997},3343933.2760154996]
[null,null,null,null,null,null,"Other",66338.104139999996,{"$f":"'8. Expected Revenue'!D51","v":143838.87524999998},192406.58514000001]
[null,null,null,null,null,null,"Total ED Services Revenue",2159695.5138989999,{"$f":"SUM(I30:I34)","v":4315107.5477549993},6263966.1497489996]
[]
[null,null,null,null,null,null,"Outpatient Services"]
[null,null,null,null,null,null,"Medicare",191018.78895329998,{"$f":"'8. Expected Revenue'!D67","v":597325.83313500008},982479.14606965217]
[null,null,null,null,null,null,"Medicaid",273886.52913719998,{"$f":"'8. Expected Revenue'!D68","v":940862.32614000014},1408698.0905971681]
[null,null,null,null,null,null,"Self-Pay/Uninsured",35129.940400799998,{"$f":"'8. Expected Revenue'!D69","v":122576.40126},180686.06777155201]
[null,null,null,null,null,null,"Commercial",613018.19352689991,{"$f":"'8. Expected Revenue'!D70","v":2035725.5638799998},3152975.6554404362]
[null,null,null,null,null,null,"Other",35272.455372000004,{"$f":"'8. Expected Revenue'!D71","v":127466.97074999999},181419.07413168004]
[null,null,null,null,null,null,"Total Outpatient Services Revenue",1148325.9073902001,{"$f":"SUM(I38:I42)","v":3823957.0951649998},5906258.0340104876]
[]
[null,null,null,null,null,null,"Total Revenues",3308021.4212892,{"$f":"SUM(I35,I43)","v":8139064.6429199986},12170224.183759488]
[]
[null,null,null,null,null,null,"Less: "]
[null,null,null,null,null,null,{"$f":"'9. Pro Forma'!B50","v":"Equipment Cost"},5341,{"$f":"'9. Pro Forma'!E15","v":10607},15491]
[null,null,null,null,null,null,{"$f":"'9. Pro Forma'!B51","v":"Other Capital Cost"},118036.1,{"$f":"'9. Pro Forma'!E16","v":234414.7},342351.10000000003]
[null,null,null,null,null,null,"Total Capital Cost",{"$f":"+H27+H48+H49","v":130854.5},{"$f":"+I27+I48+I49","v":259871.5},{"$f":"+J27+J48+J49","v":379529.50000000006}]
[]
[null,null,null,null,null,null,"Depreciation",0,{"$f":"IF(Depreciation=\"Not Applicable\",0,Depreciation)","v":0},0]
[null,null,null,null,null,null,"Total Cost",{"$f":"H24+H50","v":5526125.5099999998},{"$f":"I24+I50","v":8840822.0399999991},{"$f":"J24+J50","v":12520029.390000001}]
[]
[null,"  Income before taxes",null,{"$f":"I45-I53","v":-701757.39708000049}]
[null,"Taxes",null,{"$f":"'9. Pro Forma'!J14*'9. Pro Forma'!F63","v":0}]
[null,"  Projected net income",null,{"$f":"D55-D56","v":-701757.39708000049}]
[null,"  Net Margin",null,{"$f":"D57/I45","v":-8.6220889975415604E-2}]
[null,"Plus: Depreciation",null,{"$f":"I52","v":0}]
[null,"Plus: Net building/equipment salvage value"]
[]
[null,"Net cash flow",null,{"$f":"D57+D59+D60","v":-701757.39708000049}]
[]
[null,"Cumulative net cash flow",null,{"$f":"#REF!+D62","v":{"$error":"#REF!"}}]

{"sheet":"Assumptions","index":18,"n_rows":37,"n_cols":9,"rows_kept":37,"cut":false,"hidden":true,"merged":[[0,0,0,4]]}
["Assumptions"]
["Variable","Low","Medium","High",null,null,null,null,"Why?"]
["Volume Assumptions"]
["OP Volume","75% of ED Volume",1.25,1.33,null,null,null,null,"Basis reflects analysis of current hospitals volumes of similar size. As with most variables, this will vary significantly based on the hospital. Of the hospitals reviewed, the trend shows more OP volume in the larger hospitals."]
["Estimated Square Footage","# Beds X 2,333.33","X 1,666.67","X 1,527.8",null,null,null,null,"Square footage assumes a certain baseline needed to operate. As beds are added, there is a proportionally lower increase of space needed, due to economies of scale. "]
["Staff Assumptions",null,null,null,"Staff Cost Assumptions"]
["Staff FTEs",47.1,{"$f":"+LeadershipCosts[[#Totals],[FTEs]]+ProviderCosts[[#Totals],[FTEs]]+AdminCosts[[#Totals],[FTEs]]","v":63.599999999999994},89.7,"22.4% Staff Benefits Assumed",null,null,null,"Note: Included are only staffing differences. Other staff are included in each model. Additionally, some services are assumed contract labor under operating costs."]
["Administration"]
["  Emergency Services Director",1,1,1,null,null,null,null,"Fixed in all three models"]
["  Charge Nurse - ED",0.2,1,1,null,null,null,null,"Fixed in all three models"]
["Clinical Providers"]
["   MD",4.7,{"$f":"'5. Staffing Costs'!C18","v":7},9.4,"$280,000 salary plus benefits",null,null,null,"Minimum of 1 RN and 1 MD on all shifts for 6 bed. The 12 bed assumes 2 day/1 night and the 18 bed assumes a mix of 1-3 physicians/midlevels at different times."]
["   NP/PA",0,{"$f":"'5. Staffing Costs'!C19+'5. Staffing Costs'!C20","v":2.4},4.7,"$89,000 salary plus benefits",null,null,null,"NP/PA used interchangeably throughout for midlevel care, though supervision regulations vary by state. No midlevels in the 6 bed, 1 during the day in the 12 bed, and 1.5 during the day in the 18 bed."]
["Clinical Support"]
["   RN",4.7,{"$f":"'5. Staffing Costs'!C21","v":7},10.5,"$54,900 salary plus benefits"]
["   CNA/EMT",2.4,{"$f":"'5. Staffing Costs'!C22","v":4.6999999999999993},7,null,null,null,null,"Staffing is proportional to the number of beds actively serviced. "]
["  Unit Coordinator",0,{"$f":"'5. Staffing Costs'!C23","v":2.4},3.6,null,null,null,null,"Unit Coordinator duties are absorbed by other roles in the 6 bed. "]
["  Ultrasound Tech",2.4,{"$f":"'5. Staffing Costs'!C25","v":2.4},4.7,null,null,null,null,"Incorporates a minimum 1 day shift Ultrasound Tech (2.4 FTEs) in the 6 bed and 12 bed and 1.5 in the 18 beds."]
["  CT / X-Ray Tech",4.7,4.7,4.7,null,null,null,null,"Fixed in all three models"]
["  Med Lab Tech",4.7,4.7,4.7,null,null,null,null,"Fixed in all three models"]
["  Respiratory Therapist",2.4,{"$f":"'5. Staffing Costs'!C29","v":2.4},4.7,null,null,null,null,"Includes a minimum 1 day shift Respiratory Therapist in the 6 and 12 beds and 1 Respiratory Therapist all shifts in the 18 bed."]
["  Social Worker",0,{"$f":"'5. Staffing Costs'!C31","v":0.5},1]
["  Pharmacist",0.6,{"$f":"'5. Staffing Costs'!C32","v":0.8},1]
["Nonclinical Support"]
["  Patient Registrar",2.4,{"$f":"'5. Staffing Costs'!C39","v":2.4},4.7,null,null,null,null,"Includes a minimum 1 day shift Respiratory Therapist in the 6 and 12 beds and 1 Respiratory Therapist all shifts in the 18 bed."]
["  Clinical Admin Coordinator",1,{"$f":"'5. Staffing Costs'!C40","v":1},1.5,null,null,null,null,"Assumes a minimum 1 FTE Clinical Admin Coordinator in the 6 and 12 bed and 1.5 FTEs in the 18 bed."]
["  Patient Account Rep",2.4,{"$f":"'5. Staffing Costs'!C41","v":2.4},3.6,null,null,null,null,"Incorporates a minimum 1 day shift Ultrasound Tech (2.4 FTEs) in the 6 bed and 12 bed and 1.5 in the 18 beds."]
["  HR/Credentialing/Recruiting",2,{"$f":"'5. Staffing Costs'!C42","v":3},4]
["  Business/Payroll",1,{"$f":"'5. Staffing Costs'!C43","v":1},1.5,null,null,null,null,"Assumes a minimum 1 FTE Clinical Admin Coordinator in the 6 and 12 bed and 1.5 FTEs in the 18 bed."]
["  Billing/Medical Records",2.4,{"$f":"'5. Staffing Costs'!C44","v":4.7},7.1]
["  Security Officer",4.7,4.7,4.7,null,null,null,null,"Fixed in all three models"]
["  Property Superintendent",1,1,1,null,null,null,null,"Fixed in all three models"]
["  Facilities Staff",2.4,2.4,3.6,null,null,null,null,"Incorporates a minimum 1 day shift Facilities Staff (2.4 FTEs) in the 6 bed and 12 bed and 1.5 in the 18 beds."]
[]
[]
[]
[null,{"$f":"B7-SUM(B9:B33)","v":0},{"$f":"C7-SUM(C9:C33)","v":0},{"$f":"D7-SUM(D9:D33)","v":0}]

{"sheet":"3 Model Graph","index":19,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":true,"merged":[[22,6,24,6],[23,5,24,5],[1,0,1,2]]}
[]
["Three Models",null,null,null,null,null,null,null,null,null,null,null,null,"Three Models of Rural Free-Standing Emergency Departments"]
["6 Beds","12 Beds","18 Beds"]
["14,000 Sq Ft","20,000 Sq Ft","27,500 Sq Ft",null,null,null,null,null,null,null,"Three Models of Rural Free-Standing Emergency Departments"]
["5,341 ED Visits","10,815 ED Visits","15,491 ED Visits"]
["4,006 OP Visits","13,519 OP Visits","20,603 OP Visits"]
["47.9 FTEs","63.6 FTEs","89.7 FTEs"]
["$5.6m Yrly Exp","$8.9m Yrly Exp","$12.5m Yrly Exp"]
[]
[]
[]
[]
[null,null,null,null,"5,341 ED Visits"]
[null,null,null,null,"4,006 OP Visits","10,815 ED Visits"]
[null,null,null,null,"47.9 FTEs","13,519 OP Visits","15,491 ED Visits"]
[null,null,null,null,"$5.6m Yrly Exp","63.6 FTEs","20,603 OP Visits"]
[null,null,null,null,null,"$8.9m Yrly Exp","89.7 FTEs"]
[null,null,null,null,null,null,"$12.5m Yrly Exp"]
[]
[]
[]
["FED (Freestanding Emergency Department)",null,null,null,null,null,"27,500 Sq Ft"]
["HOPD (Hospital Outpatient Department) - Type of FED affiliated with a hospital and reimbursed facility fees by CMS",null,null,null,null,"20,000 Sq Ft","18 Beds"]
["IFED (Independent Freestanding Emergency Department) - Type of FED unaffiliated with a hospital and not reimbursed facility fees by CMS",null,null,null,"14,000 Sq Ft","12 Beds"]
["RFED (Rural Freestanding Emergency Department) - May take the form of a HOPD or IFED",null,null,null,"6 Beds"]

{"sheet":"FED FAST Inputs","index":20,"n_rows":177,"n_cols":6,"rows_kept":177,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Hospital Information"]
[]
[null,"Hospital Name"]
[]
[null,"Hospital State"]
[]
[null,"Affiliation with Hospital System?"]
[null,"If yes, what % discount do you receive on equipment and supplies?"]
[]
[null,"Organizational Cost of Capital"]
[]
[null,"Organizational Tax Rate"]
[]
[null,"Number of ED Patient Beds"]
[]
[null,"Average Monthly ED Visits"]
[]
[null,"Average Monthly Outpatient Visits"]
[]
[null,"Number of Hospitals/EDs                     within 35 Mile Radius"]
[]
[null,"Number of Outpatient Lab/Imaging Facilities within 35 Mile Radius"]
[]
[null,"Estimated ED Square Footage"]
[]
[null,"Key Assumptions"]
[]
[null,"Inflation rate on costs:"]
[]
[null,"Volume Growth Rate"]
[]
[null,"Average charge for ED visit"]
[]
[null,"Average charge for Outpatient visit (per claim)"]
[]
[null,"Cost-to-Charge Ratio"]
[]
[null,"Medicare reimbursement will change annually by:"]
[]
[null,"Avg. Useful life of clinical equipment and office furniture:"]
[]
[null,"Avg. Useful life of computers and technology equipment:"]
[]
[]
[null,"Clinical Staffing Coverage"]
[]
[null,"Nursing Coverage"]
[]
[null,"How many beds will each RN be responsible for?"]
[]
[null,"How many beds will each CNA be responsible for?"]
[]
[null,"Hours Worked / Week (1 FTE)"]
[]
[null,"Physician/Mid-Level Coverage"]
[]
[null,"How many beds will each MD be responsible for?"]
[]
[null,"How many beds will each PA be responsible for?"]
[]
[null,"How many beds will each NP be responsible for?"]
[]
[null,"Hours Worked/Week (1 FTE)"]
[]
[]
[null,"Staffing Costs"]
[]
[null,"Leadership ","FTEs","Salary","Bonus","Benefits"]
[null,"Emergency Services Director"]
[null,"Head Nurse - ED"]
[null,"Other"]
[null,"Other"]
[null,"Other"]
[null,"Clinical Support","FTEs","Salary","Bonus","Benefits"]
[null,"Physician"]
[null,"Physician Assistant"]
[null,"Nurse Practitioner"]
[null,"Registered Nurse"]
[null,"C N A / EMT"]
[null,"Medical Scribe"]
[null,"Ultrasound Tech"]
[null,"CT Tech"]
[null,"X-Ray Tech "]
[null,"Med Lab Tech"]
[null,"Respiratory Therapist"]
[null,"Traveling Nurse"]
[null,"Other"]
[null,"Other"]
[null,"Other"]
[null,"Administrative","FTEs","Salary","Bonus","Benefits"]
[null,"Patient Registrar"]
[null,"Clinical Admin. Coordinator"]
[null,"Medical Social Worker"]
[null,"Other"]
[null,"Other"]
[null,"Other"]
[]
[]
[null,"Capital Costs"]
[]
[null,"Initial Investment Costs","Cost"]
[null,"Construction/Renovation"]
[null,"Other Costs"]
[null,"Equipment","Cost","Estimated Salvage Value"]
[null,"Computer/IT"]
[null,"Telehealth Equipment"]
[null,"Clinical Equipment"]
[null,"Laboratory Equipment"]
[null,"Radiology Equipment"]
[null,"Pharmacy Equipment"]
[null,"Administrative Equipment"]
[null,"Other Equipment"]
[null,"Other Capital Costs","Cost"]
[null,"Other Costs"]
[]
[null,"Operating Costs"]
[]
[null,"Laboratory","Cost"]
[null,"Shipping"]
[null,"Supplies"]
[null,"Other"]
[null,"Radiology","Cost"]
[null,"Supplies"]
[null,"Other"]
[null,"Pharmacy ","Cost"]
[null,"Drugs"]
[null,"Supplies"]
[null,"Other"]
[null,"Facility Costs","Cost","Or, In lieu of actual Utilities & Maintenance Costs"]
[null,"Utilities & Maintenance",null,"Overhead rate per facility gross square foot:"]
[null,"Environmental Services"]
[null,"Dietary"]
[null,"Equipment Maintenance"]
[null,"Other"]
[null,"Administrative Costs","Cost"]
[null,"Marketing"]
[null,"IT Support"]
[null,"Billing"]
[null,"Security"]
[null,"Medical Records"]
[null,"Books"]
[null,"Traveling/Continuing Education"]
[null,"Other"]
[null,"Other Operating Costs","Cost"]
[null,"Other"]
[null,"Other"]
[null,"Other"]
[]
[]
[null,"Expected Revenue"]
[]
[null,"Estimated Hospital Payer Mix","Estimated %"]
[null,"Medicare"]
[null,"Medicaid"]
[null,"Self Pay"]
[null,"% Self-Pay Uncollected"]
[null,"Commercial"]
[null,"Other (TriCare, etc.)"]
[]
[null,"Payer Reimbursement Rates","Estimated %"]
[null,"Medicare"]
[null,"Medicaid"]
[null,"Self Pay"]
[null,"Commercial"]
[null,"Other (TriCare, etc.)"]

{"sheet":"Definitions","index":21,"n_rows":139,"n_cols":2,"rows_kept":139,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Acronyms"]
[null,"ACA: The Patient Protection and Affordable Care Act "]
[null,"ACEP: American College of Emergency Physicians"]
[null,"AHA: American Hospital Association"]
[null,"CAH: Critical Access Hospital"]
[null,"CMS: Center for Medicare & Medicaid Services"]
[null,"CNA: Certified Nursing Assistant"]
[null,"CON: Certificate of Need"]
[null,"CR: Computed Radiography"]
[null,"CT: Computed Tomography"]
[null,"DR: Digital Radiography"]
[null,"ED: Emergency Department"]
[null,"EMR: Electronic Medical Record"]
[null,"EMS: Emergency Medical Services"]
[null,"EMT: Emergency Medical Technician"]
[null,"FED: Freestanding Emergency Department"]
[null,"FESC: Frontier Extended-Stay Clinics"]
[null,"FGI: Facilities Guideline Institute"]
[null,"FQHC: Federally Qualified Health Center"]
[null,"FTE: Full Time Equivalent"]
[null,"GPO: Group Purchasing Organization"]
[null,"HOPDs: Hospital Outpatient Departments"]
[null,"HPSA: Health Professional Shortage Area"]
[null,"HRSA: Health Resources & Services Administration"]
[null,"IFEDs: Independent Freestanding Emergency Departments"]
[null,"IP: Inpatient"]
[null,"IRR: Internal Rate of Return"]
[null,"LIS: Laboratory Information System"]
[null,"MIRR: Modified Internal Rate of Return"]
[null,"MRI: Magnetic Resonance Imaging"]
[null,"MSA: Metropolitan Statistical Area"]
[null,"OMB: Office of Management and Budget"]
[null,"ORHP: Office of Rural Health Policy"]
[null,"OSHA: Occupational Safety & Health Administration"]
[null,"NP: Nurse Practitioner"]
[null,"NPV: Net Present Value"]
[null,"NRHA: National Rural Health Association"]
[null,"PA: Physician Assistant"]
[null,"PACS: Picture Archiving and Communication System"]
[null,"POCT: Point of Care Testing"]
[null,"PPE: Plant, Property, Equipment"]
[null,"RN: Registered Nurse"]
[null,"RT: Respiratory Therapy or Respiratory Therapist"]
[null,"RUCA: Rural-Urban Commuting Area"]
[null,"SWOT Analysis: Strengths Weaknesses Opportunities Threats Analysis"]
[null,"US: Ultrasound"]
[]
[]
[null,"Definitions"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Top"]

{"sheet":"References","index":22,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"Hospital Affiliation"]
[]
[null,"CMS Reimbursement for FEDs"]
[null,"Medicare Part B Reimbursement for FEDs"]
[]
[null,"Key Assumptions"]
[]
[null,"Consumer Price Index"]
[null,"Current & Historical Inflation Rates"]
[null,"Benchmarking 2.0 Health Care Facility Management Report "]
[null,"Hospital Mean Utility Cost per Gross Square Foot"]
[null,"Article: ER Visits Still Rising Despite ACA"]
[null,"HCUP Trends in ED Visits:  2006-2011"]
[null,"Patient Charges for Top 10 Diagnoses in the ED"]
[null,"CAH Financial Indicator Reports"]
[null,"OPPS Update for CY2015 (pg. 66776)"]

{"sheet":"Acknowledgements","index":23,"n_rows":8,"n_cols":1,"rows_kept":8,"cut":false,"hidden":false,"merged":[[5,0,5,7],[7,0,7,7]]}
[]
[]
[]
[]
[]
["This project was supported by the Federal Office of Rural Health Policy (FORHP), Health Resources and Services Administration (HRSA), U.S. Department of Health and Human Services (HHS) under cooperative agreement # U1CRH03714.  The information, conclusions and opinions expressed in this findings brief are those of the authors and no endorsement by FORHP, HRSA, HHS, or The University of North Carolina is intended or should be inferred."]
[]
["We’d also like to acknowledge and thank five students for their work developing the Freestanding Emergency Department Financial Assessment Strategic Tool.  Jasmin Hainey, MHA; Keenan Jones, MHA; Manasi Kulkarni, MHA; Katie Ward, MHA; and Jake Zisette, RN, MHA developed the tool as the final product for their Masters of Health Administration Capstone project. \n"]