please do it in 30 minutes will upvote it's important for me

5. Perform sensitivity analysis by creating a series of DCF analysis changing the following parameters: a. Reimbursement growth rate - Include -1%, 2%, and 5%. b. Inpatient Hospital effect on profits - $300,000 and $700,000 c. Procedures per year - 2000 and 2600 d. 2030 salvage value - $7 million. Di . 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 . B D 1 2 3 4 Exhibit 3 Calabash Community Hospital Capital Markets Information (December 2019) 13 5 6 10-Year Government Bond Yields 7 8 Australia 9 Brazil 10 Canada 11 France 12 Germany Hong Kong 14 India 15 Italy 16 Japan 17 Mexico 18 South Korea 19 United Kingdom 20 United States 21 22 23 24 25 US Corporate Bond Yields 26 27 A 28 Baa 29 Ba 30 B 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% 2.32% 2.81% 3.42% 4.32% 5.55% 31 32 Note: The bond rating represented the creditworthiness of the bo A B D E F G H 1 j K M 1 2 Calabash Community Hospital Discounted Cash Flow Analysis Model Discount rate Capital expenditure Salvage value Value of land Account receivable days 3 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 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 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 5. Perform sensitivity analysis by creating a series of DCF analysis changing the following parameters: a. Reimbursement growth rate - Include -1%, 2%, and 5%. b. Inpatient Hospital effect on profits - $300,000 and $700,000 c. Procedures per year - 2000 and 2600 d. 2030 salvage value - $7 million. Di . 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 . B D 1 2 3 4 Exhibit 3 Calabash Community Hospital Capital Markets Information (December 2019) 13 5 6 10-Year Government Bond Yields 7 8 Australia 9 Brazil 10 Canada 11 France 12 Germany Hong Kong 14 India 15 Italy 16 Japan 17 Mexico 18 South Korea 19 United Kingdom 20 United States 21 22 23 24 25 US Corporate Bond Yields 26 27 A 28 Baa 29 Ba 30 B 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% 2.32% 2.81% 3.42% 4.32% 5.55% 31 32 Note: The bond rating represented the creditworthiness of the bo A B D E F G H 1 j K M 1 2 Calabash Community Hospital Discounted Cash Flow Analysis Model Discount rate Capital expenditure Salvage value Value of land Account receivable days 3 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 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 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105