WACC (based on Engineering Economy Chapter 13) Estimate the weighted average cost of capital for The Boeing
Question:
WACC (based on Engineering Economy Chapter 13) Estimate the weighted average cost of capital for The Boeing Company (ticker BA), using income statement, balance sheet, and stock market data from wwwmorningstar.com, and using the historical stock price data for BA and VFINX from www.finance.yahoo.com. (Do not use balance sheet and income statement from finance.yahoo.com, it has errors in it. Make sure you use year 2018 data from the balance sheet and income statement on Morningstar - do not use the TTM column.)
1. Generate a sheet in your Excel file that estimates the weighted average cost of capital, listing the necessary inputs at the top of your sheet. Obtain any necessary data from the sources listed above. Link to other sheets in your file that will calculate Boeing's cost of equity and beta.