please do 3 and 4 in 10 minutes will upvote

3. Emily Tang is suggesting a discount rate (MARR) of 7%. Is that appropriate? Why or why not? Determine what rate should be used for the analysis. 4. Using the information in the case study and the excel template provided on Blackboard, conduct a DCF analysis. 5. Perform sensitivity analysis by creating a series of DCF analysis changing the . 1 A B C D E F G 1 Exhit 2 2 Calabash Community Hospital Financial Data on Comparable Companies (financial statement data from 2018) 000 V AWN Tenet Healthcare Description: Operates 475 outpatient centers, 255 ambulatory surgery centers, 68 hospitals, 23 surgical hospita 7 Revenue $18.3 billion Enterprise value $21.4 billion 10 Market equity value $6.8 billion 11 Total debt $14.6 billion 12 Operating margin 11.0% 13 Return on assets 5.5% 14 Beta 0.75 15 Bond rating Ba 16 17 Surgery Partners 18 Description: Operates 108 ambulatory surgical centers and 15 surgical hospitals in 31 states. 19 20 Revenue $1.8 billion 21 Enterprise value $4.7 billion 22 Market equity value $2.4 billion 23 Total debt $2.3 billion 24 Operating margin 14.7% 25 Return on assets 3.5% 26 Beta 0.80 27 Bond rating B 28 29 Sources: Descriptions and company data are from Yahoo! Finance; bond ratings are from Moody's; Beta estimates a 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 A B D 1 Exhibit 3 Calabash Community Hospital Capital Markets Information (December 2019) 2 3 4 5 6 7 8 10-Year Government Bond Yields 9 10 11 12 13 14 15 16 17 18 19 20 21 Australia Brazil Canada France Germany Hong Kong India Italy Japan Mexico South Korea United Kingdom United States 1.19% 6.82% 1.44% -0.05% -0.35% 1.47% 6.47% 1.28% -0.04% 7.12% 1.71% 0.67% 1.72% 22 23 24 25 US Corporate Bond Yields 26 27 A Baa 29 Ba 30 B 31 28 2.32% 2.81% 3.42% 4.32% 5.55% 32 Note: The bond rating represented the creditworthiness of the bor A B D E F G H 1 J K L M Calabash Community Hospital Discounted Cash Flow Analysis Model Discount rate 1 2 3 4 Assumptions: 5 Procedures per year 6 Current avg net reimbursement per procedure 7 Annual rate of change for reimbursment 8 9 Fixed cost 10 Annual inflation rate 11 Variable cost 12 Impact on hospital 13 14 Years 15 Procedures per year 16 Avg reimbursement rate 17 Net reimbursements/ Incremental Revenue 18 19 Fixed cost 20 Variable cost 21 Depreciation 22 Net effect on inpatient profits 23 Total Expenses Capital expenditure Salvage value Value of land Account receivable days 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 24 Operating profit/ Net Cash Flow 25 Capital expenditure 26 Free cash flow 27 28 Net present value (NPV) 29 30 s! 22 23 33 24 34 25 35 36 S6 27 37 28 30 20 39 an 40 11 41 44 13 43 44 45 46 48 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 12 73 7 17 75 76 10 77 79 1 70 12 an 09 81 02 02 93 03 BA 07 95 0 86 09 82 0 oo 00 RO 09 an 90 01 21 02 92 02 93 99 95 93 98 99 100 101 102 103 3. Emily Tang is suggesting a discount rate (MARR) of 7%. Is that appropriate? Why or why not? Determine what rate should be used for the analysis. 4. Using the information in the case study and the excel template provided on Blackboard, conduct a DCF analysis. 5. Perform sensitivity analysis by creating a series of DCF analysis changing the . 1 A B C D E F G 1 Exhit 2 2 Calabash Community Hospital Financial Data on Comparable Companies (financial statement data from 2018) 000 V AWN Tenet Healthcare Description: Operates 475 outpatient centers, 255 ambulatory surgery centers, 68 hospitals, 23 surgical hospita 7 Revenue $18.3 billion Enterprise value $21.4 billion 10 Market equity value $6.8 billion 11 Total debt $14.6 billion 12 Operating margin 11.0% 13 Return on assets 5.5% 14 Beta 0.75 15 Bond rating Ba 16 17 Surgery Partners 18 Description: Operates 108 ambulatory surgical centers and 15 surgical hospitals in 31 states. 19 20 Revenue $1.8 billion 21 Enterprise value $4.7 billion 22 Market equity value $2.4 billion 23 Total debt $2.3 billion 24 Operating margin 14.7% 25 Return on assets 3.5% 26 Beta 0.80 27 Bond rating B 28 29 Sources: Descriptions and company data are from Yahoo! Finance; bond ratings are from Moody's; Beta estimates a 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 A B D 1 Exhibit 3 Calabash Community Hospital Capital Markets Information (December 2019) 2 3 4 5 6 7 8 10-Year Government Bond Yields 9 10 11 12 13 14 15 16 17 18 19 20 21 Australia Brazil Canada France Germany Hong Kong India Italy Japan Mexico South Korea United Kingdom United States 1.19% 6.82% 1.44% -0.05% -0.35% 1.47% 6.47% 1.28% -0.04% 7.12% 1.71% 0.67% 1.72% 22 23 24 25 US Corporate Bond Yields 26 27 A Baa 29 Ba 30 B 31 28 2.32% 2.81% 3.42% 4.32% 5.55% 32 Note: The bond rating represented the creditworthiness of the bor A B D E F G H 1 J K L M Calabash Community Hospital Discounted Cash Flow Analysis Model Discount rate 1 2 3 4 Assumptions: 5 Procedures per year 6 Current avg net reimbursement per procedure 7 Annual rate of change for reimbursment 8 9 Fixed cost 10 Annual inflation rate 11 Variable cost 12 Impact on hospital 13 14 Years 15 Procedures per year 16 Avg reimbursement rate 17 Net reimbursements/ Incremental Revenue 18 19 Fixed cost 20 Variable cost 21 Depreciation 22 Net effect on inpatient profits 23 Total Expenses Capital expenditure Salvage value Value of land Account receivable days 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 24 Operating profit/ Net Cash Flow 25 Capital expenditure 26 Free cash flow 27 28 Net present value (NPV) 29 30 s! 22 23 33 24 34 25 35 36 S6 27 37 28 30 20 39 an 40 11 41 44 13 43 44 45 46 48 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 12 73 7 17 75 76 10 77 79 1 70 12 an 09 81 02 02 93 03 BA 07 95 0 86 09 82 0 oo 00 RO 09 an 90 01 21 02 92 02 93 99 95 93 98 99 100 101 102 103