I was given the first 5 data points in the WACC Calculation box shown below and I calculated the next 3. I need help calculating WACC, assuming that the pieces needed for the formula are contained in this box (?). My understanding is that the formula for WACC is: cost of equity * value of equity / (debt + equity) + cost of debt * value of debt / (debt + equity). I don't understand how this formula corresponds to the data points contained in this box. Please help!

Ok--the attachment will not attach. Here is what it contained:

WACC Calculation:

Asset beta . 0.82

risk-free rate . 4.86%

market risk premium 5%

cost of debt 6%

target d/v . 35%

implied debt beta . 0.23

re-levered equity beta . 1.14

cost of equity . 10.55%

Click on the cell beside WACC (1), type =B7*E6/E15+B13*E13/E15, and press enter. cost of equity* equity value/debt+equity + cost of debt * value of debt / debt+equity B17 ... X V fx =B7*E6/E15+B13*E13/E15 A B C D E F G H 1 Easily Calculating WACC (Weighted Average Cost of Capital) 2 3 Cost of Equity Equity's Amount 4 Rate of Riskfree 5,40% Shares 1,934 5 2,09 Price 259 6 Market Return 13% Value 500,906 7 Cost of Equity 21,28% 8 9 10 Debt's Expenses Debt's Amount 11 Rate 6,32% Value of Book 91,8 12 Taxrate 32% Adjustment 2 13 Debt's Expenses 4,30% Value 183,6 14 15 Total Capital 684,506 16 17 WACC 1 16,73% 18 19