a)

b)

c)

please use excel and thoroughly show each step/which formulas to use. im still learning how to use excel so filling in the formulas is a little confusing. please help a sis out. Thank you in advance!

Walmart is considering issuing bonds. They estimate they will issue bonds similar to a recent bond issue. This bond has a quoted price of 107.0; (of course this is the % of $1000). If an underwriter charges 1.8% in flotation charges, what is the Net Proceeds of the bond in $? You are estimating the cost of common stock (stockholders' expected rate of return) of UPS using the CAPM. UPS has a beta of 1.18. You estimate a risk free rate of 2.6% and a market risk premium of 5.0%. What is UPSestimated cost of stock? Express answer in 4 decimal places. FedEx is estimating its weighted average cost of capital. The first step is finding market value weights of debt and equity. FedEx has a common stock market cap of 9,321 million and Debt value of 3,310 million. What is FedEx's weight on debt? (Express in percentages in 4 decimals; if it is 30.32% put as .3032)