Using micosoft for this:

From the text, the Weighted Average Cost of Capital is:

WACC$=(\frac{E}{V})R_E+(\frac{D}{V})R_D(1-T_C)$

In this Research Project, the WACC for a selected company will be determined. Fill in the table to identify your selected company:

$\backslash$table$[[$Name of Company$/$Stock$,],[$Ticker Symbol,$]]$

Part $1$: Cost of Debt ${?}^1$

Complete the following table to arrive at the Cost of Debt and Tax Rate.

$\backslash$table$[[$Interest Income $($Expense$)-$last $2$ years avg,$],[$Earnings Before Tax $-$ last $3$ years total,$],[$Taxation $-$ last $3$ years total,$],[$Corporate Tax Rate, $T^2,],[$Current Debt,$],[$LT Debt & Leases,$],[$Total Debt,$],[$Cost of Debt ${?}^3,]]$

Part $2$: Cost of Equity and CAPM Components

Complete the table and determine the cost of equity. Show your calculations.

$\backslash$table$[[$Beta$,{}_E,],[$Historical Market Return, $i_M,$Assume $9\%],[$Risk Free Rate, if$,$Assume $2\%],[$Cost of Equity, $i_E,]]$

$i_E=i_f+{}_E[E(i_M)-i_f]$

${?}^1$ The inputs from Mergent provide a close approximation to the Cost of Debt

${?}^2$ Divide the Taxation last $3$ years line item by Earnings Before Tax for the last $3$ years, as a percent

${?}^3$ Interest Income $($Expense$)$ last $2-$year average divided by the Total Debt