This problem has NO relation to the problem in Part $1$

The current risk$-$free rate is $5\mathrm{.}51\%$ and the market is expected to return $7\mathrm{.}55\%$ per year. The company's beta is $1\mathrm{.}57.$ The company expects to pay $4\mathrm{.}9\%$ for its debl. the target capital structure for the company is $35\%$ equity and $65\%$ debt. The marginal tax rate is $21\%$ plus $4\%$ for state and local taxes $($ISTR $=25\%).$

CAPM Inputs

A$.$ What is the after$-$tax cost of debt?

B$.$ What is the cost of equity?

C$.$ Calculate the WACC.

$\backslash$table$[[$rF$,5\mathrm{.}51\%$

Please show me how to put these into formulas on excel for the blue cells shown in the picture