Please show your excel work for eaxh quesion. Thank you.

15) Should Tangshan Mining company cost is $5000,000 and it is in year 1, $1,900,000 in year 2. 5700.000 in year 3, and .n No, sce the payback period of the peopect is move than the masie period. B) Yes, since the payback period of the project loe lene than acceptable payback period the maximsam aceptabile payback D) Yes, since the risk exposure of the project is es project is more than the maxinvam acceptable rkexpesure Table 8.2 than the maximum t acceptable risk expomure i are Boing to invest S20,000 in a portfolio consisting of anets X, Y, and Z, as tolhows 0.25 16) The beta of the portfolio in Table 82, containing assets x, Y, and Zis B) 1.6 D) 24 A) 2.0 17 the approximate annual ilerus mde de 17) If a corporation has an average tax rate of 40 percent, for a 10-year, 8 percent, $1.000 par value bond selling at$1,150 is B) 8 percent C) 3.6 peroent A) 6 percent and a 12 percent coupon rate and make semiannual coupon payments. In order to sell the issue, bonds must be underpriced at a discount of 2.5 percent of face value. In addition, the firm would have to pay flotation costs of 25 percent of facevalaeThe firm's tax rate is 33 percent. Given this information, the after-tax cost of debt for Tangshan Mining would be 18) Tangshan Mining is considering issuing long-term debt The debt would have a 30 year maturity D) 12.76% 96.38% B) 4.98% A) 8.48% and the risk-free rate of return equals 19) 19) A firm has a beta of 1.2. The market return equals 14 percent D) 15.6 percent 6 percent. The estimated cost of com mon stock equity is G) 14 percent B) 6 percent A) 72 percent 20) Given that the cost of common stock is 18 percent, dividends are $1.50 per share and the price of the 20) D) 6 percent stock is $12.50 per share, what is the annual growth rate of dividends? C) 5 percent B) 4 percent A) 8 percent