Can someone help me with this? I have attached the full assignment.

Please include at least 2 decimal spaces on all percentages. Must be submitted in excel spreadsheet. Part 1 A Bremond Equipment Supply Corporation (BESC) needs to determine its Weighted Average Cost of Capital in order to make a few capital budgeting decisions. The firm has already established the proporation of its capital. Use these proportions in calculating the firm's WAAC. Target Market Source of Capital Proportions Long-term debt 69% Preferred stock 5% Common stock equity 26% Debt: BESC can sell a 17-year, semi-annual,$1,000 par value, 8.75 percent bond for $985. A flotation cost of 1.75 percent of the face value would be required in addition to the discount of $15. Preferred Stock: BESC has determined it can issue preferred stock at $70 per share par value. The stock will pay an $8.00 annual dividend. The cost of issuing and selling the stock is $2 per share. Common Stock: BESC's common stock is currently selling for $39 per share. The dividend expected to be paid at the end of the coming year is $5.35 Its dividend payments have been growing at a constant rate for the last five years. Five years ago, the dividend was $3.00. It is expected that to sell, a new common stock issue must be underpriced at $4 per share and the firm must pay $1 per share in flotation costs. Additionally, the firm's marginal tax rate is 40 percent. To help determine the firm's WACC, we will break this problem down into steps: A. Calculate the rate for the new bond issue, notice is has semi-annual compounding. B. Calculate the after-tax cost of the bond issue. C. Calculate the cost of the new issue of preferred stock. D. Calculate the growth rate of the common stock dividends. E. Calculate the cost of the new common stock issue. F. Finally, calculate the firm's weighted average cost of capital assuming the firm has exhausted all retained earnings. Part 1 B Bremond Equipment Supply Corporation is now considering investment in two independent projects, A and C, which are described below. Please don't assume anything. Use the firm's WACC which you just calculated to evaluate the projects. Initial Investment Year G. H. I. J. Option A Option C $3,250,000 $3,900,000 Cash Inflows (CF) 1 $1,500,000 $1,800,000 2 1,000,000 1,000,000 3 1,000,000 900,000 4 1,500,000 1,500,000 Calculate Payback Period for both projects Calculate NPV for both projects Calculate PI for both projects Calculate IRR for both projects K. Which project should the firm accept? Why? Part 2 Another company is in the process of determining its WACC. For this problem you will need to use the CAPM to calculate your answer. (This problem is completely independent of Part 1A and 1B, all the information you need is given to you in the question.) The current risk-free rate is 2.5% and the market is expected to return 7.5% per year. The company's beta is 1.5. The company expects to pay 5.75% for its debt. The target capital structure for the company is 55% equity and 45% debt. The marginal tax rate is 37%. L. What is the after-tax cost of debt? M. What is the cost of equity? N. Calculate the WACC. BONUS QUESTION: (10 Points) ABC Appliance Company uses the CAPM to determine its risk-adjusted discount rate, (RADR), for each of its projects: Rj = RF + [b * (rm - RF)] The company is currently interested in investing in the capital project shown below. The return on market is 12.5%, the risk-free rate is currently 8% and the project has a beta of 2.5. Initial Investment ($3,900,000) Cash Inflow Year 1 1,500,000 2 1,750,000 3 000 2,500, A. Using the CAPM compute the RADR B. Compute the Risk-Adjusted NPV of the project