Problem #3-Look up values in a table In this problem, the calculations are mostly filled in. Your job is to fill in the cost of debt by creating a lookup formula in Excel. To the right in the workheet is a table of rates applicable to corporate bonds of different credit ratings. The formula in C2S needs to be such that it will adjust automatically when the bond rating is changed in C24. This is doee with the VLOOKUP function, which "looks up" a value in a table and then returns a corresponding value. Find VLOOKUP under Excel's list of functions. VLOOKUP is structured like this: VLOOKUP(cell reference of value to be looked up, cell references of complete table to look up value in, number of column in table corresponding to value you want retumed, enter "FAL SE" here). When you have entered the function correctly, you should be able to change the bond rating and see the cost of debt adjust automatically. Q6: What is the WACC assuming a bond rating of AAA-? Q7: What is the WACC assuming a bond rating of B ? Complete the WACC calculations by putting in a lookup formula for the cost 2 of debt. (See the handout for additional instructions.) \begin{tabular}{|c|c|rrr|} \hline 6 & Comparable & Levered E & DN & Unlevered A \\ \hline 7 & Comp One & 1.25 & 0.34 & 0.83 \\ \hline 8 & Comp Two & 1.66 & 0.40 & 1.00 \\ \hline 9 & AVERAGE A & & & 0.91 \\ \hline 10 & & & & \end{tabular} 11 2. Relever Beta