Cost of DEBT=5.0649%

Determine the WACC for Ford Motor Company (Ticker symbol F) Hint: The settlement date is the date when price information is retrieved. This term is used in Excel bond "Price" and "Yield" calculations, interpreted as Today's Date." PART 1:Compute the cost of equity for Ford Motor Company using two different approaches - the DCF model and the CAPM. a. What is Ford's cost of equity if the T-bill rate is 2.5% and the market return is 16%? Please estimate beta value for the firm with 5-year monthly data (1/1/2014-12/31/2018) using data from yahoo finance website. b. Ford Motor paid an annual dividend of $0.60 in 2018. It is expected that the company will continue to pay dividend and dividend will grow at 7%. Given the market price of $8.70, what is the required rate of return for Ford's equity? You must also conduct regression analysis and paste your Summary Output into your answer sheet. R= T-bill Market return beta RE D1 Paste your regression results here. Part 2: Calculate the WACC for Ford Motor Company a. Assuming the debt ratio for Ford Motor is 60%. What is the company's weighted average cost of capital? (Use the average of the DCF and CAPM estimates for cost of equity) WACC = Part b. assuming the debt ratio is 20%, what is Ford's WACC? WACC = Part c. Please discuss how capital structure affect a firm's cost of capital. Answer: Determine the WACC for Ford Motor Company (Ticker symbol F) Hint: The settlement date is the date when price information is retrieved. This term is used in Excel bond "Price" and "Yield" calculations, interpreted as Today's Date." PART 1:Compute the cost of equity for Ford Motor Company using two different approaches - the DCF model and the CAPM. a. What is Ford's cost of equity if the T-bill rate is 2.5% and the market return is 16%? Please estimate beta value for the firm with 5-year monthly data (1/1/2014-12/31/2018) using data from yahoo finance website. b. Ford Motor paid an annual dividend of $0.60 in 2018. It is expected that the company will continue to pay dividend and dividend will grow at 7%. Given the market price of $8.70, what is the required rate of return for Ford's equity? You must also conduct regression analysis and paste your Summary Output into your answer sheet. R= T-bill Market return beta RE D1 Paste your regression results here. Part 2: Calculate the WACC for Ford Motor Company a. Assuming the debt ratio for Ford Motor is 60%. What is the company's weighted average cost of capital? (Use the average of the DCF and CAPM estimates for cost of equity) WACC = Part b. assuming the debt ratio is 20%, what is Ford's WACC? WACC = Part c. Please discuss how capital structure affect a firm's cost of capital