University of the Cumberlands Coca Cola Financial Assessment Excel Task

Select a publicly traded company, preferable a company from your country that its securities trade in the U.S. capital market.

Download five years of daily stock price of the company and the same for an appropriate index

Estimate the beta of the company and using the information in its financial statement unlever the beta.

Now use the market value information and financial statement information of the company and calculate the levered and unlevered WACC of the company.

What is your recommendation for the company’s capital structure policy?