Managerial Finance- Show the data used and the calculations for each question in a Microsoft Excel sheet- WK 4 project
Your probationary period at the Cosmo K Manufacturing Group continues.
For this week’s project, Gerry has asked you to consider two mutually exclusive investments and incorporate risk considerations into the process of evaluation.
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?
Submission Details:
Show the data used and the calculations for each question in a Microsoft Excel sheet and the analysis in a Microsoft Word document
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
