On the excel sheet labeled, Assumptions: enter your assumptions for those cells labeled, Assignment 2.

On the excel sheet labeled, Assignment 2, average the total market discharges and the Medical Center(Jefferson) discharges for 7 years, using the assumptions you entered in the top half.

Assumptions :

Assignment 2:

A B D E F G Assumptions Value To Be Manually Entered Based on Your Forecasts Assignment Number To Be Imported From Other Worksheets or Provided by CFO 696 1,829 53 88 201 1.431 8,045 53 405 1,166 48.64% 22.73% 100.00% 21.73% 17.24% -4.45% 0.16% -11.75% -3.29% -2.40% 1.619 3.23% -11.75% 5.15% 4.749 JMC Assumed Annual Market Share Change - Cardiac-invasive JMC Assumed Annual Market Share Change - Cardiology JMC Assumed Annual Market Share Change - Open Heart JMC Assumed Annual Market Share Change - Thoracic Surgery JMC Assumed Annual Market Share Change - Vascular Surgery Total Market Assumed Annual Growth Rate - Cardiac-Invasive Total Market Assumed Annual Growth Rate - Cardiology Total Market Assumed Annual Growth Rate - Open Heart Total Market Assumed Annual Growth Rate - Thoracic Surgery Total Market Assumed Annual Growth Rate - Vascular Surgery Improvement in Length of Stay as a percentagel Increase in Blue Cross Blue Shield Reimbursement (as a percentage) Calculated Values 1 2 JMC 2017 Discharges - Cardiac - Invasive 3 JMC 2017 Discharges - Cardiology 4 JMC 2017 Discharges - Open Heart 5 JMC 2017 Discharges - Thoracic Surgery 6 JMC 2017 Discharges - Vascular Surgery 7 Total Market 2017 Discharges - Cardiac - Invasive 8 Total Market 2017 Discharges - Cardiology 9 Total Market 2017 Discharges - Open Heart 10 Total Market 2017 Discharges - Thoracic Surgery 11 Total Market 2017 Discharges - Vascular Surgery 12 JMC 2017 Market Share - Cardiac-invasive 13 JMC 2017 Market Share - Cardiology 14 JMC 2017 Market Share - Open Heart 15 JMC 2017 Market Share - Thoracic Surgery 16 JMC 2017 Market Share - Vascular Surgery 17 JMC 2012-2017 Annual Compounded Growth Rate - Cardiac-invasive 18 JMC 2012-2017 Annual Compounded Growth Rate - Cardiology 19 JMC 2012-2017 Annual Compounded Growth Rate - Open Heart 20 JMC 2012-2017 Annual Compounded Growth Rate - Thoracic Surgery 21 JMC 2012-2017 Annual Compounded Growth Rate - Vascular Surgery 22 Total Market 2012-2017 Annual Compounded Growth Rate - Cardiac-invasive 23 Total Market 2012-2017 Annual Compounded Growth Rate - Cardiology 24 Total Market 2012-2017 Annual Compounded Growth Rate - Open Heart 25 Total Market 2012-2017 Annual Compounded Growth Rate - Thoracic Surgery 26 Total Market 2012-2017 Annual Compounded Growth Rate - Vascular Surgery 27 Salaries and Wages Expense per Patient Day (provided by CFO) 28 Benefits Expense per Patient Day (provided by CFO) 29 Supplies Expense per Patient Day (provided by CFO) 30 Professional Fees Expense per Patient Day (provided by CFO) 31 Contract Services Expense per Patient Day (provided by CFO) 32 Repairs & Maintenance Expense per Patient Day provided by CFO) 33 Initial Capital Investment 34 Discount Rate 35 36 Assignment 2 Assignment 2 Assignment 2 Assignment 2 Assignment 2 Assignment 2 Assignment 2 Assignment 2 Assignment 2 Assignment 2 Assignment 3 Assignment 3 A B C D E F G . I Year 1 Year 2 Year 3 Year 4 Years Year 6 Year 7 Total Market Forecasted Discharges Total Market Discharges - Cardiac - Invasive Total Market Discharges - Cardiology Total Market Discharges - Open Heart Total Market Discharges - Thoracic Surgery Total Market Discharges - Vascular Surgery TOTAL MARKET DISCHARGES Year 0 (2017) 1,431 8,045 53 405 1,166 11,100 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Jefferson Medical Center Forecasted Discharges JMC Discharges - Cardiac - Invasive JMC Discharges - Cardiology JMC Discharges - Open Heart JMC Discharges - Thoracic Surgery JMC Discharges - Vascular Surgery JEFFERSON MEDICAL CENTER DISCHARGES Year 0 (2017) 696 1,829 53 88 201 2,867 A B D E F G Assumptions Value To Be Manually Entered Based on Your Forecasts Assignment Number To Be Imported From Other Worksheets or Provided by CFO 696 1,829 53 88 201 1.431 8,045 53 405 1,166 48.64% 22.73% 100.00% 21.73% 17.24% -4.45% 0.16% -11.75% -3.29% -2.40% 1.619 3.23% -11.75% 5.15% 4.749 JMC Assumed Annual Market Share Change - Cardiac-invasive JMC Assumed Annual Market Share Change - Cardiology JMC Assumed Annual Market Share Change - Open Heart JMC Assumed Annual Market Share Change - Thoracic Surgery JMC Assumed Annual Market Share Change - Vascular Surgery Total Market Assumed Annual Growth Rate - Cardiac-Invasive Total Market Assumed Annual Growth Rate - Cardiology Total Market Assumed Annual Growth Rate - Open Heart Total Market Assumed Annual Growth Rate - Thoracic Surgery Total Market Assumed Annual Growth Rate - Vascular Surgery Improvement in Length of Stay as a percentagel Increase in Blue Cross Blue Shield Reimbursement (as a percentage) Calculated Values 1 2 JMC 2017 Discharges - Cardiac - Invasive 3 JMC 2017 Discharges - Cardiology 4 JMC 2017 Discharges - Open Heart 5 JMC 2017 Discharges - Thoracic Surgery 6 JMC 2017 Discharges - Vascular Surgery 7 Total Market 2017 Discharges - Cardiac - Invasive 8 Total Market 2017 Discharges - Cardiology 9 Total Market 2017 Discharges - Open Heart 10 Total Market 2017 Discharges - Thoracic Surgery 11 Total Market 2017 Discharges - Vascular Surgery 12 JMC 2017 Market Share - Cardiac-invasive 13 JMC 2017 Market Share - Cardiology 14 JMC 2017 Market Share - Open Heart 15 JMC 2017 Market Share - Thoracic Surgery 16 JMC 2017 Market Share - Vascular Surgery 17 JMC 2012-2017 Annual Compounded Growth Rate - Cardiac-invasive 18 JMC 2012-2017 Annual Compounded Growth Rate - Cardiology 19 JMC 2012-2017 Annual Compounded Growth Rate - Open Heart 20 JMC 2012-2017 Annual Compounded Growth Rate - Thoracic Surgery 21 JMC 2012-2017 Annual Compounded Growth Rate - Vascular Surgery 22 Total Market 2012-2017 Annual Compounded Growth Rate - Cardiac-invasive 23 Total Market 2012-2017 Annual Compounded Growth Rate - Cardiology 24 Total Market 2012-2017 Annual Compounded Growth Rate - Open Heart 25 Total Market 2012-2017 Annual Compounded Growth Rate - Thoracic Surgery 26 Total Market 2012-2017 Annual Compounded Growth Rate - Vascular Surgery 27 Salaries and Wages Expense per Patient Day (provided by CFO) 28 Benefits Expense per Patient Day (provided by CFO) 29 Supplies Expense per Patient Day (provided by CFO) 30 Professional Fees Expense per Patient Day (provided by CFO) 31 Contract Services Expense per Patient Day (provided by CFO) 32 Repairs & Maintenance Expense per Patient Day provided by CFO) 33 Initial Capital Investment 34 Discount Rate 35 36 Assignment 2 Assignment 2 Assignment 2 Assignment 2 Assignment 2 Assignment 2 Assignment 2 Assignment 2 Assignment 2 Assignment 2 Assignment 3 Assignment 3 A B C D E F G . I Year 1 Year 2 Year 3 Year 4 Years Year 6 Year 7 Total Market Forecasted Discharges Total Market Discharges - Cardiac - Invasive Total Market Discharges - Cardiology Total Market Discharges - Open Heart Total Market Discharges - Thoracic Surgery Total Market Discharges - Vascular Surgery TOTAL MARKET DISCHARGES Year 0 (2017) 1,431 8,045 53 405 1,166 11,100 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Jefferson Medical Center Forecasted Discharges JMC Discharges - Cardiac - Invasive JMC Discharges - Cardiology JMC Discharges - Open Heart JMC Discharges - Thoracic Surgery JMC Discharges - Vascular Surgery JEFFERSON MEDICAL CENTER DISCHARGES Year 0 (2017) 696 1,829 53 88 201 2,867