Question
Colin was recently hired by Coleman Electronics as a junior budget analyst. He is working for the Venture Capital Division and has been given for
Colin was recently hired by Coleman Electronics as a junior budget analyst. He is working for the Venture Capital Division and has been given for capital budgeting projects to evaluate. He must give his analysis and recommendation to the capital budgeting committee.
Colin has a B.S. in accounting from CWU (2015) and passed the CPA (2017). He has been in public accounting for several years. During that time he earned an MBA from Seattle U. He would like to be the CFO of a company someday--maybe C oleman Electronics-- and this is an opportunity to get onto that career track and to prove his ability.
As Colin looks over the financial data collected, he is trying to make sense of it all. He already has the most difficult part of the analysis complete -- the estimation of cash flows. Through some internet research and application of finance theory, he has also determined the firms beta.
Here is the information that Colin has accumulated so far:
The Capital Budgeting Projects
He must choose one of the four capital budgeting projects listed below:
Table 1
t | A | B | C | D |
0 | (19,000,000) | (20,000,000) | (14,000,000) | (18,000,000) |
1 | 8,000,000 | 11,000,000 | 5,700,000 | 3,600,000 |
2 | 8,000,000 | 10,000,000 | 5,700,000 | 7,600,000 |
3 | 8,000,000 | 8,000,000 | 5,700,000 | 5,600,000 |
4 | 8,000,000 | 4,000,000 | 5,700,000 | 5,600,000 |
Risk | Average | High | Low | Average |
Table 1 shows the expected after-tax operating cash flows for each project. All projects are expected to have a 4 year life. The projects differ in size (the cost of the initial investment), and their cash flow patterns are different. They also differ in risk as indicated in the above table.
The capital budget is $20 million and the projects are mutually exclusive.
Capital Structures
Coleman Electronics has the following capital structure, which is considered to be optimal:
Debt | 50% |
Preferred Equity | 10% |
Common Equity | 40% |
100% |
Cost of Capital
Colin knows that in order to evaluate the projects he will have to determine the cost of capital for each of them. He has been given the following data, which he believes will be relevant to his task.
(1)The firms tax rate is 35%.
(2) Coleman Electronics has issued a 10% semi-annual coupon bond with 8 years term to maturity. The current trading price is $990.
(3) The firm has issued some preferred stock which pays an annual 10% dividend of $100 par value, and the current market price is $105.
(4) The firms stock is currently selling for $36 per share. Its last dividend (D0) was $3, and dividends are expected to grow at a constant rate of 6%. The current risk free return offered by Treasury security is 2.5%, and the market portfolios return is 12%. Coleman Electronics has a beta of 1.2. For the bond-yield-plus-risk-premium approach, the firm uses a risk premium of 3%.
(5) The firm adjusts its project WACC for risk by adding 1.5% to the overall WACC for high-risk projects and subtracting 1.5% for low-risk projects.
Colin knows that Coleman Electronics executives have favored IRR in the past for making their capital budgeting decisions. His professor at Seattle U. said NPV was better than IRR. His textbook says that MIRR is also better than IRR. He is the new kid on the block and must be prepared to defend his recommendations.
First, however, Colin must finish the analysis and write his report. To help begin, he has formulated the following questions:
I AM STRUGGLE WITH THIS QUESTION BELOW
Calculate all relevant capital budgeting measures for each project, and place your numerical solutions in Table 2.
Table 2
A | B | C | D | |
WACC | ||||
NPV | ||||
IRR | ||||
MIRR |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started