$5.$ What are the components that go into calculating the Weighted Average Cost of Capital for the firm? Why is it important to do these calculations accurately? $(3$ pts$)$ Consider the following:

Bama Inc has a pre$-$tax cost of debt of $7\mathrm{.}9$ percent, a cost of equity of $15$ percent, and a cost of preferred stock of $8\mathrm{.}1$ percent. The firm has $210,000$ shares of common stock outstanding at a market price of $$26$ a share. There are $27,000$ shares of preferred stock outstanding at a market price of $$42$ a share. The bond issue has a face value of $$570,000$ and a market quote of $101\mathrm{.}0$ percent of face value. The company's tax rate is $32$ percent. What is the firm's weighted average cost of capital? $($provide excel formulas$)$