Hello, I need Both Part 1 A and B. Please if you decide to answer, answer both. I will upvote!!
PART 1 A - COMPUTING A WEIGHTED AVERAGE COST OF CAPITAL (WACC) A firm has determined its optimal capital structure, which is composed of the following sources and target market value proportions: Source of Capital Target Market Proportions 60% 5% Long-term debt Preferred stock Common stock equity 35% Debt: The firm can sell a 15 year bond, compounded monthly, with a $1000 par value and 6.8% coupon rate for $1254. A flotation cost of 1.15% of the face value would also be required. Preferred Stock: The firm has determined that it can issue preferred stock at $125 per share par value. The preferred stock wil pay a $6.75 per share annual dividend. The cost of issuing and selling the preferred will be $3.28 per share. Common Stock: The firm's common stock is currently selling for $23.75per share. The firm will be paying a dividend of $5.25 at the end of the year. Its dividend payments have been growing at a constant rate for the last five years. Five years ago, the dividend was $3.25. For a new issue of common stock to sell, it has been determined that the new issue would need to be underpriced at $1.50 per share and that the firm must pay $1.20per share in flotation costs. The firm's marginal tax rate is 21%, plus 4% for state and local taxes. (ISTR = 25%) To determine the firm's WACC, please complete the following steps, entering your formulas in the blue cells: 4.56% 3.42% 5.55% 10.07% 25.51% 11.26% A. Calculate the rate for the bond, notice is has monthly compounding. B. Calculate the after-tax cost of the bond. 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. Standard formats for your takulations: Debt Preferred Stock Inputs Price New Issue Costs Adjusted Price NPER Coupon Price Coupon Rate PMT Mkt Price Common Stock Growth Rete NPER PV FV RATE= Formulirpus Price New sue costs Adjusted Price ni WACC Market Rate Car ANTE FV RATE TOTAL PART 1 B-CAPITAL BUDGETING The same finalin Part 1 is considering the investment of the independent projects, X and Y, which are described below. Please do not assume anything, Use a WACC of 15% to evaluate the projects. Cust of Eupilan | PROJECT X PROJECT Y A. Calculate Payback Perlad for both projects Year Cash Inflows 8. Calculate NPV for both projects Initial Investment ($11,050,000) $11,250,000) 10 C Calculate for both projects 1 $3,500,000 $5,500,000 D. Calculate MIRR for both projects $3,500,000 $5,800.000 2 E. Which project should the firm accept? Why? 2 $5,800,000 $2,900,000 13 $5,800,000 $1,950,000 For the Payback Pad Cakwetion Cash End of Year Balances PROJECT X PROJECT Y Year 2 2 4 4 Please enter your formulas in the blue cells: A. Payback 2. NPV CIRR D. MIRR E. Accept projects>>> Yes or No Yes or No Why? PART 1 A - COMPUTING A WEIGHTED AVERAGE COST OF CAPITAL (WACC) A firm has determined its optimal capital structure, which is composed of the following sources and target market value proportions: Source of Capital Target Market Proportions 60% 5% Long-term debt Preferred stock Common stock equity 35% Debt: The firm can sell a 15 year bond, compounded monthly, with a $1000 par value and 6.8% coupon rate for $1254. A flotation cost of 1.15% of the face value would also be required. Preferred Stock: The firm has determined that it can issue preferred stock at $125 per share par value. The preferred stock wil pay a $6.75 per share annual dividend. The cost of issuing and selling the preferred will be $3.28 per share. Common Stock: The firm's common stock is currently selling for $23.75per share. The firm will be paying a dividend of $5.25 at the end of the year. Its dividend payments have been growing at a constant rate for the last five years. Five years ago, the dividend was $3.25. For a new issue of common stock to sell, it has been determined that the new issue would need to be underpriced at $1.50 per share and that the firm must pay $1.20per share in flotation costs. The firm's marginal tax rate is 21%, plus 4% for state and local taxes. (ISTR = 25%) To determine the firm's WACC, please complete the following steps, entering your formulas in the blue cells: 4.56% 3.42% 5.55% 10.07% 25.51% 11.26% A. Calculate the rate for the bond, notice is has monthly compounding. B. Calculate the after-tax cost of the bond. 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. Standard formats for your takulations: Debt Preferred Stock Inputs Price New Issue Costs Adjusted Price NPER Coupon Price Coupon Rate PMT Mkt Price Common Stock Growth Rete NPER PV FV RATE= Formulirpus Price New sue costs Adjusted Price ni WACC Market Rate Car ANTE FV RATE TOTAL PART 1 B-CAPITAL BUDGETING The same finalin Part 1 is considering the investment of the independent projects, X and Y, which are described below. Please do not assume anything, Use a WACC of 15% to evaluate the projects. Cust of Eupilan | PROJECT X PROJECT Y A. Calculate Payback Perlad for both projects Year Cash Inflows 8. Calculate NPV for both projects Initial Investment ($11,050,000) $11,250,000) 10 C Calculate for both projects 1 $3,500,000 $5,500,000 D. Calculate MIRR for both projects $3,500,000 $5,800.000 2 E. Which project should the firm accept? Why? 2 $5,800,000 $2,900,000 13 $5,800,000 $1,950,000 For the Payback Pad Cakwetion Cash End of Year Balances PROJECT X PROJECT Y Year 2 2 4 4 Please enter your formulas in the blue cells: A. Payback 2. NPV CIRR D. MIRR E. Accept projects>>> Yes or No Yes or No Why
