ownload and open the attached file. This file will be used for following questions. ty Model Questions.xlsx C G 1 e F e Historical Results Forecast Peried 2 FINANCIAL STATEMENTS 3 Balance Sheet Check 2011 2012 2013 2014 2015 2018 2016 2017 2019 202 OK OK OK OK OK OK OK 176 Assumption 177 Revenue Growh 5% 178 COGS % 179 Dscount Rate 15% 180 EVEBITDA S% 5%A +5% Rank ABS Output Driver Pos Neg 181 The formula containe& 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($F$177:SF$180,E179) =SMALL(SE$177:SE$180,F179) -SMALL(E177:E180,$F$179) SMALL(F177:F180,SE$179) Page 7 of 10 DELL