Answered step by step
Verified Expert Solution
Question
1 Approved Answer
7. B D G H L - M 2011 OK Historical Results 2012 2013 OK OK 2014 OK 2015 OK 2016 OK Forecast Period 2017
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)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started