Heather was recently hired by Galaxy Media Group as a junior budget analyst. She
ID: 2656053 • Letter: H
Question
Heather was recently hired by Galaxy Media Group as a junior budget analyst. She is working for the Venture Capital Division and has been given for capital budgeting projects to evaluate. She must give her analysis and recommendation to the capital budgeting committee.
Heather has a B.S. in accounting from CWU (2007) and passed the CPA exam (2008). She has been in public accounting for 2 years. During that time she earned an MBA from Seattle U. She would like to be the CFO of a company someday--maybe Galaxy Media Group-- and this is an opportunity to get onto that career track and to prove her ability.
As Heather looks over the financial data collected, she is trying to make sense of it all. She already has the most difficult part of the analysis complete -- the estimation of cash flows. Through some internet research and application of finance theory, she has also determined the firm’s beta.
Here is the information that Heather has accumulated so far:
The Capital Budgeting Projects
She must choose one of the four capital budgeting projects listed below:
Table 1
t
A
B
C
D
0
(18,550,000)
(19,500,000)
(16,600,000)
(18,200,000)
1
5,500,000
4,500,000
6,660,000
8,800,000
2
5,500,000
7,980,000
6,660,000
7,500,000
3
5,800,000
7,220,000
4,700,000
5,800,000
4
5,800,000
6,500,000
4,700,000
3,200,000
Risk
Average
Low
Avarege
High
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 $22 million and the projects are mutually exclusive.
Capital Structures
Galaxy Media Group has the following capital structure, which is considered to be optimal:
Debt
35%
Preferred Equity
10%
Common Equity
55%
100%
Cost of Capital
Heather knows that in order to evaluate the projects she will have to determine the cost of capital for each of them. She has been given the following data, which he believes will be relevant to her task.
(1)The firm’s tax rate is 38%.
(2) Galaxy Media Group has issued a 9% semi-annual coupon bond with 10 years term to maturity. The current trading price is $980.
(3) The firm has issued some preferred stock which pays an annual 8.5% dividend of $100 par value, and the current market price is $92.
(4) The firm’s stock is currently selling for $38 per share. Its last dividend (D0) was $1.5, and dividends are expected to grow at a constant rate of 7%. The current risk free return offered by Treasury security is 1.5%, and the market portfolio’s return is 9.8%. Galaxy Media Group has a beta of 1.25. For the bond-yield-plus-risk-premium approach, the firm uses a risk premium of 2.5%.
(5) The firm adjusts its project WACC for risk by adding 2.3% to the overall WACC for high-risk projects and subtracting 2% for low-risk projects.
Heather knows that Galaxy Media Group executives have favored IRR in the past for making their capital budgeting decisions. Her professor at Seattle U. said NPV was better than IRR. Her textbook says that MIRR is also better than IRR. She is the new kid on the block and must be prepared to defend her recommendations.
First, however, Heather must finish the analysis and write her report. To help begin, she has formulated the following questions:
What is the firm’s cost of debt?
What is the cost of preferred stock for Galaxy Media Group?
Cost of common equity
(1) What is the estimated cost of common equity using the CAPM approach?
(2) What is the estimated cost of common equity using the DCF approach?
(3) What is the estimated cost of common equity using the bond-yield-plus-risk-premium approach?
(4) What is the final estimate for rs?
What is Galaxy Media Group’s overall WACC?
Do you think the firm should use the single overall WACC as the hurdle rate for each of its projects? Explain.
What is the WACC for each project? Place your numerical solutions in Table 2.
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
Comment on the commonly used capital budgeting measures. What is the underlying cause of ranking conflicts? Which criterion is the best one, and why?
Which of the projects are unacceptable and why?
Rank the projects that are acceptable, according to Heather’s criterion of choice.
Which project should Heather recommend and why? Explain why each of the projects not chosen was rejected.
t
A
B
C
D
0
(18,550,000)
(19,500,000)
(16,600,000)
(18,200,000)
1
5,500,000
4,500,000
6,660,000
8,800,000
2
5,500,000
7,980,000
6,660,000
7,500,000
3
5,800,000
7,220,000
4,700,000
5,800,000
4
5,800,000
6,500,000
4,700,000
3,200,000
Risk
Average
Low
Avarege
High
Explanation / Answer
As per rules I will answer the first 4 sub parts of the question
1: Cost of debt = YTM of bond
Using financial calculator
PMT= 9%*1000/2 = 45
N= 10*2 = 20
PV= -980
FV= 1000
YTM= I/Y= 4.6558%
Annual pre tax Cost of debt = 4.6558%*2 = 9.3117%
After tax cost of debt = 9.3117*(1-Tax) = 5.77%
2: Cost of preferred stock= Dividend/ Price
= 8.5%*100 / 92
=9.24%
3: Cost of equity using CAPM
=Rf+ beta*(Market returns- Rf)
= 1.5%+ 1.25*(9.8%-1.5%)
=11.875%
4: Cost of equity using DCF
Price= D1/(k-g)
K= D1/Price + g
= 1.5*107%/ 38 + 7%
=11.22%
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.