What is the share price when COGS increases by 5%? the excel spreadsheet is used to answer the question

H M C D Copii Alghts reserved FINANCIAL STATEMENTS Balance Sheet Check E Historical Results 2012 2013 OK OK 2011 OK 2014 OK 2015 OK 2016 OK Forecast Period 2017 2018 OK OK 2019 OK 2020 OK 9 Revenue Growth 47.6% Change $/Share 0.35 COGS +/-5% Change 0.0 $/Share Discount Rate 41-5% Change $/Share 009 1 2 3 EVIEBITDA +-5% Change $/Share 0.0% Rank ABS Pos 45% -5% 4 Neg Output Driver 5 6 Assumption 7 Revenue Growth +/-5% 8 COGS +/-5% 9 Discount Rate 5% EVEBITDA +/-5% 1 12 13 34 Impact on Share Prics By Change in Assumption 35 17 DCF Sensitivity Model Please download and open the attached file. This file will be used for following questions. Sensitivity Model Questions.xlsx 6 What is the share price when COGS increases by 5%? 29.29 22.71 26.87 30.47 Tyne here to search H M C D Copii Alghts reserved FINANCIAL STATEMENTS Balance Sheet Check E Historical Results 2012 2013 OK OK 2011 OK 2014 OK 2015 OK 2016 OK Forecast Period 2017 2018 OK OK 2019 OK 2020 OK 9 Revenue Growth 47.6% Change $/Share 0.35 COGS +/-5% Change 0.0 $/Share Discount Rate 41-5% Change $/Share 009 1 2 3 EVIEBITDA +-5% Change $/Share 0.0% Rank ABS Pos 45% -5% 4 Neg Output Driver 5 6 Assumption 7 Revenue Growth +/-5% 8 COGS +/-5% 9 Discount Rate 5% EVEBITDA +/-5% 1 12 13 34 Impact on Share Prics By Change in Assumption 35 17 DCF Sensitivity Model Please download and open the attached file. This file will be used for following questions. Sensitivity Model Questions.xlsx 6 What is the share price when COGS increases by 5%? 29.29 22.71 26.87 30.47 Tyne here to search