You work for a firm that is looking to raise capital in the near future. As part of your work to prepare for potential investors, you determined that you need to compute the WACC of your firm. Your firm is currently structured in such a way that the Debt$-$to$-$Equity ratio is $0\mathrm{.}4.$ Assume a tax rate of $30\%.$

Since your company size is comparable with publicly traded micro$-$cap companies, you started analyzing the Wilshire Micro$-$Cap ETF, which represents a basket of micro$-$cap companies in the US$.$

Your firm considers the $3-$month Government T$-$Bills as the risk$-$free investment.

Based on the price data in the file attached, answer the following questions.

Cost of Equity:

What was the annualized return for the reference micro$-$cap ETF?

During the period considered, what was the risk premium of micro$-$cap stocks?

Historically your company has produced equity returns that indicate a beta to the general micro$-$cap market of around $1\mathrm{.}25.$

Assuming the beta will remain stable, what should your cost of equity be$?$

Cost of Debt:

Your only debt outstanding in the market is a single bond with the following parameters:

$10$ yrs until maturity

semiannual coupons with an $($annual$)$ coupon rate of $7\%$

a current market price of $95($as a percentage of the notional amount$)$

What is your cost of debt?

Given the results from $1$ and $2,$ what is your firm's WACC?

How would I solve this without uploading file attached?