Your probationary period at the Cosmo K Manufacturing Group continues. Your supervisor, Gerry, assigns you a project each week to test your competence in finance.
For Part -a of this week''s project, Gerry has asked you to consider two mutually exclusive investments and incorporate risk considerations into the process of evaluation.
For Part -b, Gerry has asked that you create your final report, incorporating your findings in Weeks 1-4 into a comprehensive document. This item will be called your Course Project Report and should be submitted in a Microsoft Word document. Review all your responses to Gerry''s questions for Weeks 1 through 4 and make any corrections or improvements that have been provided to you. Then incorporate the revised work into your final report. Make sure you integrate the four parts so that your report reads as one report rather than four reports pasted together. Make sure all responses are complete and accurate, supported by references and documented examples.
Part -a: Project Selection and Risk
The Cosmo K Manufacturing Group is considering the addition of a new smelting machine or a new paving machine. The two investments are mutually exclusive; if one is selected, the other is rejected. The annual cash flows after taxes and the effects of depreciation, which begin one year from project start, and their respective probabilities are given below:
Smelting Machine Paving Machine
Probability Net Cash Flows per Year Probability Net Cash Flows per Year
0.2 $14,100.00 0.2 $2,000.00
0.5 $16,000.00 0.5 $16,000.00
0.2 $17,000.00 0.2 $22,000.00
0.1 $20,000.00 0.1 $33,000.00
Each project has an expected life of 4 years and will cost $45,000. The riskier project will be evaluated at the company''s WACC plus 3%, and the less risky project will be evaluated at the company''s WACC. Cosmo K has the following capital structure:
Debt: 30%
Preferred stock: 16%
Common stock: 54%
This capital structure is current and consistent with the company''s objectives and so will be used to raise any new funds. All new debt will be raised using long-term bonds, with no short-term debt being used for the new project. New bonds will have a coupon rate of 13%. The company''s common stock is currently selling for $65 per share, paid a dividend of $4.25 last year, and has an expected growth rate of 6% indefinitely. There will be no floatation costs on new common stock. Preferred stock can be sold for $90 per share and pays a dividend of $10, with a floatation cost of $2 per share. Currently, the market risk premium is 5% and the risk-free rate is 8%. Cosmo K''s beta coefficient is currently 1.23 and is expected to be consistent for the foreseeable future. The tax rate is expected to be 40% for the next decade.
Tasks:
Answer the following questions:
What is the component cost of capital for the company? Calculate using the CAPM.
What is the company''s WACC?
What are the expected cash flows for the investments?
What is the standard deviation for each investment?
What is the coefficient of variation for each investment?
Given the data above, which investment has the higher risk?
What is the expected net present value (NPV) for each investment?
What is the internal rate of return (IRR) of the investments?
According to the decision rules for the NPV and those for the IRR, is there an acceptable project? Explain your answer.
Is there a conflict between the two decision methods? If so, what would you use to recommend a project?"
I need a Microsoft Excel document showing calculations and a Microsoft Word document essay in APA format with in-text citations and references.