Page 7 of 10 - Assessment - Cor X + CO cfi.brillium.com/Assess.aspx?guid=A7DF18F718F74AC9A443DED51F90D902&_a=Q1 . 7 Review Later D H M 2011 OK Historical Results 2012 2013 OK OK 2014 OK 2015 OK 2016 OK Forecast Period 2017 2018 OK OK 2019 OK 2020 OK +5%A Rank ABS Output Driver Pos Neg 1 Corporate Finance Institute. Al rights reserved 2 FINANCIAL STATEMENTS 3 Balance Sheet Check 4 176 Assumption -5% A 177 Revenue Growth +/-5% 178 COGS +/-5% 179 Discount Rate +/-5% 180 EV/EBITDA +/-5% 181 The formula contained in the YELLOW cell (G179) is Hint: do not forget the $ when using absolute references. Use absolute reference so this formula can be copied over to other cells in this section without any manual modification. =SMALL($E$177:$E$180,F179) =SMALL(E177:E180,$F$179) =SMALL(F177:F180,$E$179) =SMALL($F$177:$F$180, E179) Activate Windows Go to PC settings to activate Windows. & 10. ENG 16:16 30/06/2020 Copporate Finance Institute. All rights reserved. FINANCIAL STATEMENTS Balance Sheet Check 2011 OK Historical Results 2012 2013 OK OK 2014 OK 2015 OK 2016 OK Forecast Period 2017 2018 OK OK 2019 OK 2020 OK Assumptions Income Statement Balance Sheet Cash Flow Statement Supporting Schedules DCF Model Sensitivity Analysis Share Price Sengtivity Revenue Growth 0% 10.0% Discott Rate Revenue Growth +/-5% Change Share 0.0% COGS +/-5% Change 0.0% $1Share Discount Rate +/-5% Change Share 0.0% EV/EBITDA +/-5% Change Share 0.0% -5% A +5% A Rank ABS Output Driver Pos Neg Assumption Revenue Growth +5% COGS -5% Discurt Rate + 5% EVEBITDA +15% Impact on Share Price By Change in Assumption 0 20% BOX 100% 10%