A 3 Capital Structure Weights 4 Market Value of Equity or Market Cap ($Bill) 5 Value of Net Debt ($Bill) 6 Total Value of Firm ($Bill) 7 8 Equity weight 9 Debt weight 10 11 Required Return from CAPM 12 Beta 13 Expected Return on Market 14 Risk Free Rate 15 Required Return from CAPM 16 17 Required Return from Dividend Growth Model 18 DY or Forward Dividend Yield 19 Past Dividend Growth Rate 20 Forecasted Dividend Growth Rate 21 Estimated Average Dividend Growth Rate 22 Required Return from Dividend Growth Model 23 24 COST OF EQUITY 25 COST OF EQUITY AVERAGE 26 27 COST OF DEBT 28 Yield to Maturity on Debt 29 Tax Rate 30 COST OF DEBT AFTER TAX 31 32 Weighted Average Cost of Capital 33 WACC 34 B Source Yahoo Finance Quote KO, Summary Page (Note units are $billions) https://finance.yahoo.com/quote/KO?p=KO Source Yahoo Finance Quote KO, Financials, Balance Sheet (Note units must be converted from $thousands to $billions https://finance.yahoo.com/quote/KO/balance- sheet?p=KO calculate calculate calculate Source Yahoo Finance Quote KO, Summary Page (Beta (5Y monthly) https://finance.yahoo.com/quote/KO?p=KO given Source Yahoo Finance Markets, US Treasury Bond Rates, Treasury Yield 10 Years (Note use Last Price (units are %) https://finance.yahoo.com/bonds calculate Source Yahoo Finance Quote KO, Summary Page (Note the dividend yield is in parentheses in percentage) https://finance.yahoo.com/quote/KO?p=KO Source Yahoo Finance Quote KO, Analysis, Growth Estimates (Note use PAST 5 years) https://finance.yahoo.com/quote/KO/analysis?p= KO Source Yahoo Finance Quote KO, Analysis, Growth Estimates (Note use NEXT 5 years) https://finance.yahoo.com/quote/KO/analysis?p= KO calculate (average of past and forecast) calculate calculate given given calculate calculate C 10.00% 4.00% 20% D E F G H I Find Source Input Values from Yahoo Finance and Calculate Values in Bold. J A 3 Capital Structure Weights 4 Market Value of Equity or Market Cap ($Bill) 5 Value of Net Debt ($Bill) 6 Total Value of Firm ($Bill) 7 8 Equity weight 9 Debt weight 10 11 Required Return from CAPM 12 Beta 13 Expected Return on Market 14 Risk Free Rate 15 Required Return from CAPM 16 17 Required Return from Dividend Growth Model 18 DY or Forward Dividend Yield 19 Past Dividend Growth Rate 20 Forecasted Dividend Growth Rate 21 Estimated Average Dividend Growth Rate 22 Required Return from Dividend Growth Model 23 24 COST OF EQUITY 25 COST OF EQUITY AVERAGE 26 27 COST OF DEBT 28 Yield to Maturity on Debt 29 Tax Rate 30 COST OF DEBT AFTER TAX 31 32 Weighted Average Cost of Capital 33 WACC 34 B Source Yahoo Finance Quote KO, Summary Page (Note units are $billions) https://finance.yahoo.com/quote/KO?p=KO Source Yahoo Finance Quote KO, Financials, Balance Sheet (Note units must be converted from $thousands to $billions https://finance.yahoo.com/quote/KO/balance- sheet?p=KO calculate calculate calculate Source Yahoo Finance Quote KO, Summary Page (Beta (5Y monthly) https://finance.yahoo.com/quote/KO?p=KO given Source Yahoo Finance Markets, US Treasury Bond Rates, Treasury Yield 10 Years (Note use Last Price (units are %) https://finance.yahoo.com/bonds calculate Source Yahoo Finance Quote KO, Summary Page (Note the dividend yield is in parentheses in percentage) https://finance.yahoo.com/quote/KO?p=KO Source Yahoo Finance Quote KO, Analysis, Growth Estimates (Note use PAST 5 years) https://finance.yahoo.com/quote/KO/analysis?p= KO Source Yahoo Finance Quote KO, Analysis, Growth Estimates (Note use NEXT 5 years) https://finance.yahoo.com/quote/KO/analysis?p= KO calculate (average of past and forecast) calculate calculate given given calculate calculate C 10.00% 4.00% 20% D E F G H I Find Source Input Values from Yahoo Finance and Calculate Values in Bold. J