please answer higlighted portions with excel formulas

\begin{tabular}{l} Equity Information \\ 10000 outstanding shares \\ $80 per share \\ \hline 8 Meta =1.15 \\ SMarket risk premium =9% \\ seisk-free rate =5% \\ Total equity \\ Total capital \\ Weights \end{tabular} \begin{tabular}{l} - Debt information \\ \hline 1 thousands in outstanding debt (face value) \\ \hline Price =1100 \\ \hline 5 Coupon rate =9%, semiannual coupons \\ \hline 515 years to maturity \\ \hline -Tax rate =21% \\ \hline Total debt \\ \hline \\ \hline Cost of debt (Semiannual) \\ \hline Cost fo debt annual \\ \hline Atter cost of debt \\ \hline \end{tabular}