Compute the Coca-Cola's enterprise value in 2020 using the discounted cash flow approach and the Coca-Cola's free cash flow in 2020. Assume that (1) the Coca-Cola's short term growth rate from 2021 to 2025 is 14%, (2) the Coca-Cola's long term growth rate after 2025 is 7%, (3) the Coca-Cola's WACC is 12.5%, and (4) the mid-year rather than end-year discounting is applied. (Submit the number in million dollars. For example, submit 12,345 if the enterprise value is $12,345,000,000.)

Please solve on excel. My answers are below they are not correct I am having trouble applying the mid year discounting my attempt of =WACC*14%*.5) or =WACC*14%)^.5 is not working.

Discounted cash flow approach below COCA-COLA VALUATION Free cash flow in 2020 FCF growth rate until 2025 FCF growth rate after 2025 Weighted average cost of capital 8667.0 14.0% 7.0% 12.5% 2020 2021 9273.7 FCF Terminal value Total 2022 11221.2 0.0 11221.2 11,221 2023 15148.6 0.01 15148.6 15.149 2024 2025 22571.4 36791.3 715758.8 22571.4 752550.1 22.571 752,550 9273.7 8,743 4,372 2,186 Enterprise value Enterprise Value 2 discount 459452 458,980 Enterprise value extended 487,322