'ZY ab vus IDA A A * 12 9 % - I lili III IM alil 4 fx 2 B C D L M N 2 FINANCIAL STATEMENTS 3 Balance Sheet Check 2011 OK Historical Results 2012 2013 OK OK 2014 OK 2015 OK K Forecast Period 2017 2018 OK OK 2016 OK 2019 OK 2020 OK Revenue Growth 150 Share Price Sentivity 160 161 162 10,0% 163 184 Discount Rate 165 166 167 168 169 170 Revenue Growth -9% 171 Change Share 172 0.0% 173 174 175 178 Assumption 177 Revenue Growth +-5% 178 COGS +1-5% 179 Discount Rate +-5% 180 EVIEBITDA -5% 181 182 183 184 185 180 187 18 COGS +/-5% Change 0.0% Share Discount Rate /-5% Change Share 0,0% EVEBITDA -9% Change 5/Share 0.0% Rank ABS Output Driver Pos Nes Impact on Share Price By Change in Assumption DCF & Sensitivity Model 100% HE Please download and open the attached file. This file will be used for following questi Sensitivity Model Questions.xlsx 5 Review What is the share price when the discount rate is 13% and revenue growth is 15%? 35.47 36.70 39.70 36.83 tv o 'ZY ab vus IDA A A * 12 9 % - I lili III IM alil 4 fx 2 B C D L M N 2 FINANCIAL STATEMENTS 3 Balance Sheet Check 2011 OK Historical Results 2012 2013 OK OK 2014 OK 2015 OK K Forecast Period 2017 2018 OK OK 2016 OK 2019 OK 2020 OK Revenue Growth 150 Share Price Sentivity 160 161 162 10,0% 163 184 Discount Rate 165 166 167 168 169 170 Revenue Growth -9% 171 Change Share 172 0.0% 173 174 175 178 Assumption 177 Revenue Growth +-5% 178 COGS +1-5% 179 Discount Rate +-5% 180 EVIEBITDA -5% 181 182 183 184 185 180 187 18 COGS +/-5% Change 0.0% Share Discount Rate /-5% Change Share 0,0% EVEBITDA -9% Change 5/Share 0.0% Rank ABS Output Driver Pos Nes Impact on Share Price By Change in Assumption DCF & Sensitivity Model 100% HE Please download and open the attached file. This file will be used for following questi Sensitivity Model Questions.xlsx 5 Review What is the share price when the discount rate is 13% and revenue growth is 15%? 35.47 36.70 39.70 36.83 tv o