00 8 Review Later D G H M E Historical Results 2012 OK OK 2013 2011 OK 2014 OK 2015 OK 2016 OK Forecast Period 2017 2018
Posted: Tue Apr 26, 2022 10:45 am
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.
00 8 Review Later D G H M E Historical Results 2012 OK OK 2013 2011 OK 2014 OK 2015 OK 2016 OK Forecast Period 2017 2018 OK OK 2019 OK 2020 OK A B 1 Corporate Finance Instuts. All rights reserved. 2 FINANCIAL STATEMENTS 3 Balance Sheet Check 4 176 Assumption -5% 177 Revenue Growth +-5% 178 COGS +/-5% 179 Discount Rate +/-5% 180 EV/EBITDA +/-5% 181 +5% A Rank ABS Output Driver Pos Neg
($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.
00 8 Review Later D G H M E Historical Results 2012 OK OK 2013 2011 OK 2014 OK 2015 OK 2016 OK Forecast Period 2017 2018 OK OK 2019 OK 2020 OK A B 1 Corporate Finance Instuts. All rights reserved. 2 FINANCIAL STATEMENTS 3 Balance Sheet Check 4 176 Assumption -5% 177 Revenue Growth +-5% 178 COGS +/-5% 179 Discount Rate +/-5% 180 EV/EBITDA +/-5% 181 +5% A Rank ABS Output Driver Pos Neg