A B C D E G H I J L M F Historical Results K Forecast Period Review Later 1 Corporate Finance Institute. All rights reserved. 2 FINANCIAL STATEMENTS 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 OKOKOKOKOKOKOKOKOKOK 3 Balance Sheet Check .5%A +5% A Rank ABS Output Driver Pos Neg 176 Assumption 177 Revenue Growth +/-5% 178 COGS +/-5% 179 Discount Rate +/-5% 180 EV/EBITDA +/-5% The formula contained in the ORANGE cell (H178) is = ($A$177:$G$180, $F$177:$F$180,0), MATCH($A$177,$A$177: $F$177,0)) Hint: do not forget the $ when using absolute references. A B C D E G H I J L M F Historical Results K Forecast Period Review Later 1 Corporate Finance Institute. All rights reserved. 2 FINANCIAL STATEMENTS 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 OKOKOKOKOKOKOKOKOKOK 3 Balance Sheet Check .5%A +5% A Rank ABS Output Driver Pos Neg 176 Assumption 177 Revenue Growth +/-5% 178 COGS +/-5% 179 Discount Rate +/-5% 180 EV/EBITDA +/-5% The formula contained in the ORANGE cell (H178) is = ($A$177:$G$180, $F$177:$F$180,0), MATCH($A$177,$A$177: $F$177,0)) Hint: do not forget the $ when using absolute references