7. B D G H L - 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 Corporate Finance Insth. All rights reserved 2 FINANCIAL STATEMENTS Balance Sheet Check 4 176 Assumption -5% 177 Revenue Growth +/-5% 178 COGS +/-5% 179 Discount Rate +/-5% 180 EV/EBITDA +/-5% 181 Neg 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($F$177:$E$180,E179) =SMALL(E177:E180,$F$179) =SMALL(F177:F180,$E$179)