35 Which formula will you use in cell H29 (highlighted in yellow) to select the data from scenario 1, 2 and 3 based on the information in cell H3? Review Late E H Corporate Finance Institute. All rights reserved. Forecast Period 2 FINANCIAL STATEMENTS 2016 2017 2018 2019 2020 2021 2022 2023 2024 3 Live Case Share Price $78.60 4 5 Assumptions 6 7 Base Case 8 Revenue Growth (% Change) 9 Cost of Goods Sold (% of Revenue) 10 Depreciation & Amortization (% of PP&E) 11 Interest (% of Debt) 12 Tax Rate (% of Earnings Before Tax) 13 14 Downside Case 10.0% 10.0% 10.0% 10.0% 10.0% 42.0% 47.0% 50.0% 36.0% 35.0% 35.0% 35.0% 35.0% 35.0% 35.0% 10.0% 10.0% 10.0% 10.0% 10.0% 28.0% 28.0% 28.0% 28.0% 28.0% 15 Revenue Growth (% Change) 5.0% 4.5% 4.0% 3.5% 3.0% 16 Cost of Goods Sold (% of Revenue) 37.0% 37.0% 36.0% 36.0% 35.0% 17 Depreciation & Amortization (% of PP&E) 40.0% 40.0% 40.0% 40.0% 40.0% 18 Interest (% of Debt) 5.0% 5.0% 5.0% 5.0% 5.0% 19 Tax Rate (% of Earnings Before Tax) 28.0% 28.0% 28.0% 28.0% 28.0% 20 21 Upside Case 22 Revenue Growth (% Change) 12.0% 12.0% 12.0% 12.0% 12.0% 23 Cost of Goods Sold (% of Revenue) 37.0% 36.0% 35.0% 34.0% 34.0% 24 Depreciation & Amortization (% of PP&E) 40.0% 40.0% 40.0% 40.0% 40.0% 25 Interest (% of Debt) 5.0% 5.0% 5.0% 5.0% 5.0% 26 Tax Rate (% of Earnings Before Tax) 28.0% 28.0% 28.0% 28.0% 28.0% 27 28 Live Case 29 Revenue Growth (% Change) 10.0% 10.0% 10.0% 10.0% 10.0% 30 Cost of Goods Sold (% of Revenue) 42.0% 47.0% 50.0% 36.0% 35.0% 31 Depreciation & Amortization (% of PP&E) 35.0% 35.0% 35.0% 35.0% 35.0% 32 Interest (% of Debt) 10.0% 10.0% 10.0% 10.0% 10.0% 33 Tax Rate (% of Earnings Before Tax) 28.0% 28.0% 28.0% 28.0% 28.0% =VLOOKUP(H8:H26,$H$3) =CHOOSE($H$3,H8,H15,H22) =VLOOKUP(H8, H15,H22,$H$3) =CHOOSE(H8, H15,H22,$H$3)