In this problem, you will analyze the hypothetical problem of Nike considering investing in the production of "Nike Cola", a soft drink for active lifestyles. You will proceed in calculating the WACC as in the first problem, but now you will look up the necessary data on line. Some suggested on$-$line sources are given, but you may use others if you wish. Hint: it will take a bit of searching around to find the information you need at these sites, but the information is there, and you'll get quicker at finding the information as you practice searching around. Note that in this problem your answers will vary depending on when data is retrieved because data $($e$.$g$.$ stock prices, risk$-$free rates$)$ change in real time. Step $1$: Unlever Beta. The comparable firms will be Coca$-$Cola Co$.($KO$)$ and Pepsico Inc. $($PEP$).$ Find betas for these companies on line. Also calculate their debt ratios $($D$/$N$)$ from on$-$line data. Use their most recent financial statements available. When finding D use book values $($we can't figure out market values$)$ and use long$-$term sources of debt $($i$.$e$.,$ total liabilities minus current liabilities.$)$ The table to the right on the spreadsheet might be helpful for keeping track of the information you look up$.$ Q$3$: What is the average unlevered beta for Pepsico and Coca$-$Cola?