Please provide the excel formulas, thank you.

Task 2: Weighted Average Cost of Capital (WACC) You are given the following information for Full Moon, Inc:: Debt: 1,250,000 bonds outstanding with a 5.5% coupon rate, $1,000 par value, 14 years to maturity, selling for $946; the bonds make semiannual payments. Common stock: 14,541,000 shares outstanding, selling for $64 per share; the beta is 0.74 ; the dividend payment was $3.25 per share last year; the dividend will grow steadily at a rate of 3.00% per year into the indefinite future Preferred stock: 475,000 shares of 6.15% preferred stock, currently selling for $106 per share. Market: 9.80% expected return on the market and a 4.75% risk-free rate. Tax rate: 21% Questions: 3. What is the company's after-tax cost of debt? (5 points) 4. What is the company's cost of common stock (Use the average of the two methods)? (5 points) 5. What is the company's cost of preferred stock? (5 points) 6. What is the company's WACC? ( 5 points) \begin{tabular}{|l|l|} \hline 1 & Input \\ 2 & Debt \\ 3 & Settlement date \\ 4 & Maturity date \\ 5 & Bonds outstanding \\ 6 & Annual coupon rate \\ 7 & Face value (\$) \\ 8 & Coupons per year \\ 9 & Years to maturity \\ 10 & Bond price (\$) \\ 11 & Common stock \\ 12 & Shares outstanding \\ 13 & Beta \\ 14 & Share price (\$) \\ 15 & Dividend (\$) \\ 16 & Dividend growth rate \\ 17 & Preferred stock \\ 18 & Shares outstanding \\ 19 & Coupon rate \\ 20 & Share price (\$) \\ 21 & Market \\ \hline 22 & Expected Market Return \\ 23 & Risk-free rate \\ 24 & Tax rate \\ 25 & \\ \hline \end{tabular} \begin{tabular}{|r|} \hline 01/01/00 \\ \hline 01/01/14 \\ \hline 1,250,000 \\ \hline 5.50% \\ \hline$1,000.00 \\ \hline 2 \\ \hline$14 \\ \hline \end{tabular} \begin{tabular}{|rr|} \hline & 14,541,000 \\ \hline & 0.74 \\ \hline$ & 64.00 \\ \hline$ & 3.25 \\ \hline & 3.00% \\ \hline \end{tabular} \begin{tabular}{|r|} \hline 9.80% \\ \hline 4.75% \\ \hline 21.00% \\ \hline \end{tabular} \begin{tabular}{l|l} 26 & \multicolumn{1}{|c}{ A } \\ \hline 27 & Calculation \& Output \\ 28 & \\ 29 & Market value of debt \\ 30 & Market value of equity \\ 31 & Market value of preferred \\ 32 & Market value of firm \\ 33 & Market value capital structure \\ 34 & Weight of Debt \\ 35 & Weight of Common Stock \\ 36 & Weight of Preferred Stock \\ 37 & \\ 38 & Question 3 \\ 39 & Pretax cost of debt \\ 40 & Aftertax cost of debt \\ 41 & Question 4 \\ 42 & Cost of common stock (SML) \\ 43 & Cost of common stock (DDM) \\ 44 & Cost of common stock (Average) \\ 45 & Question 5 \\ 46 & Cost of preferred stock \\ 47 & Question 6 \\ 48 & WACC \\ 49 & \end{tabular} \begin{tabular}{|l|} \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \end{tabular}