fill in the yellow and please show formulas

3.The FCFs and Interest expenses are given below. Calculate the enterprise value using Adjusted Present Value (APV) method and DCF method using the information provided below. Complete all lighted cells. a) Calculate the PV of Interest Tax Shield (6pts) b) Calculate the PV of FCF and complete APV valuation (6pts) c) DCF valuation (6pts) Corporate Tax Rate Unlevered Beta Risk free Rate Market Risk Premium Before Tax cost of Debt Debt to Asset Ratio 20% 1.6 2% 5% 6% 30% 2020 2022 2023 2021 120000 2024 140238 2025 147250 Firm Free Cash Flow (FCF) 127200 133560 Interest expense 20000 20400 21012 21642 22292 a) Interest Tax Shield (ITS) Terminal Value of ITS @ 2% growth rate ITS including Terminal Value PV of the ITS b) Unlevered Discount Rate Terminal Value of FCF @ 5% growth rate FCF including Terminal Value PV of the FCF Enterprise Value Using APV c) Levered Beta = Unlevered Beta x [1 + (Debt/Equity)x(1-Tax Rate)] Levered Beta Cost of Equity (levered) WACC Enterprise Value Using DCF 3.The FCFs and Interest expenses are given below. Calculate the enterprise value using Adjusted Present Value (APV) method and DCF method using the information provided below. Complete all lighted cells. a) Calculate the PV of Interest Tax Shield (6pts) b) Calculate the PV of FCF and complete APV valuation (6pts) c) DCF valuation (6pts) Corporate Tax Rate Unlevered Beta Risk free Rate Market Risk Premium Before Tax cost of Debt Debt to Asset Ratio 20% 1.6 2% 5% 6% 30% 2020 2022 2023 2021 120000 2024 140238 2025 147250 Firm Free Cash Flow (FCF) 127200 133560 Interest expense 20000 20400 21012 21642 22292 a) Interest Tax Shield (ITS) Terminal Value of ITS @ 2% growth rate ITS including Terminal Value PV of the ITS b) Unlevered Discount Rate Terminal Value of FCF @ 5% growth rate FCF including Terminal Value PV of the FCF Enterprise Value Using APV c) Levered Beta = Unlevered Beta x [1 + (Debt/Equity)x(1-Tax Rate)] Levered Beta Cost of Equity (levered) WACC Enterprise Value Using DCF