Please show your formula and answer clearly!!!

8. Bring the DCF model for the Steel Dynamics we developed in class into this workbook. On the Steel Dynamics-DCF tab, in the bright yellow section explain how you choose those inputs corresponding to: Revenue Growth Rate, Operating Profit Margin, depreciation, Equity based compensation, Deferred Income Taxes, Gains/Losses on PP&E, Capital Expenditure, Terminal EBITDA, Terminal FCF Growth Rate. Open 43.30 What is the intrinsic value if the terminal value is calculated using the Gordon model? Prev. Close 43.360000 Bid / Ask Would you invest in this stock? Why? 42.33/45.00 43.11 VWAP Turnover USD 151.06M What is the impact of a simultaneous change in the Year 5 Revenue Growth Rate and the Year 5 Operating Margin on to the implied share price? Show your sensitivity analysis table. What is the impact of a simultaneous change in the Terminal EBITDA Multiple and the Discount Rate on to the implied perpetuity growth rate? Show your sensitivity analysis table. 8. Bring the DCF model for the Steel Dynamics we developed in class into this workbook. On the Steel Dynamics-DCF tab, in the bright yellow section explain how you choose those inputs corresponding to: Revenue Growth Rate, Operating Profit Margin, depreciation, Equity based compensation, Deferred Income Taxes, Gains/Losses on PP&E, Capital Expenditure, Terminal EBITDA, Terminal FCF Growth Rate. Open 43.30 What is the intrinsic value if the terminal value is calculated using the Gordon model? Prev. Close 43.360000 Bid / Ask Would you invest in this stock? Why? 42.33/45.00 43.11 VWAP Turnover USD 151.06M What is the impact of a simultaneous change in the Year 5 Revenue Growth Rate and the Year 5 Operating Margin on to the implied share price? Show your sensitivity analysis table. What is the impact of a simultaneous change in the Terminal EBITDA Multiple and the Discount Rate on to the implied perpetuity growth rate? Show your sensitivity analysis table