Please convert to an excel model

Apple's beta = 1.12. Risk free rate = 10-Year Treasury Constant Maturity Rate = 0.6%. Market premium for Apple = 6%. Thus using CAPM we get the cost of equity as = 0.6% + (1.12*6%) = 7.32% Next we will compute Apple's cost of debt. The company's interest expense = $3,576 million. Book value of debt = $111,265 million. Thus cost of debt = $3,576 million/$111,265 million = 3.2139% The company's tax rate is 17.14%. Next we need the weights of debt and equity. From the company's latest annual report we get the weight of equity = 0.9175 and weight of debt = 0.0825 Thus WACC = (weight of equity * cost of equity) + (weight of debt * cost of debt * (1-tax rate)) = (0.9175*7.32%) + (0.0825*3.2139%*(1-17.14%)) = 6.94% Hence Apple's WACC is 6.94% Sources: Apple's latest annual report Bloomberg