Question

In: Finance

Lindsey was recently hired by Swift Ltd. as a junior budget analyst. She is working for...

Lindsey was recently hired by Swift Ltd. 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.

Lindsey has a B.S. in accounting from CWU (2014) and passed the CPA exam (2017). She has been in public accounting for several years. During that time she earned an MBA from Seattle U. She would like to be the CFO of a company someday--maybe Swift Ltd.-- and this is an opportunity to get onto that career track and to prove her ability.

As Lindsey 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 Lindsey 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

        (22,500,000)

        (24,000,000)

        (23,000,000)

        (21,000,000)

1

           9,600,000

           7,700,000

           8,200,000

           7,500,000

2

           9,600,000

           8,400,000

           8,200,000

           6,900,000

3

           4,500,000

           9,800,000

           6,500,000

           5,400,000

4

           4,500,000

           4,900,000

           5,900,000

           4,500,000

Risk

Average

Average

High

Low

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

Swift Ltd. has the following capital structure, which is considered to be optimal:

Debt  

30%

Preferred Equity

15%

Common Equity

55%

100%

   

Cost of Capital

Lindsey 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 35%.

(2) Swift Ltd. has issued a 8% semi-annual coupon bond with 14 years term to maturity. The current trading price is $960.

(3) The firm has issued some preferred stock which pays an annual 8.5% dividend of $50 par value, and the current market price is $52.

(4) The firm’s stock is currently selling for $35 per share. Its last dividend (D0) was $2.00, and dividends are expected to grow at a constant rate of 5%. The current risk free return offered by Treasury security is 2.8%, and the market portfolio’s return is 10.80%. Swift Ltd. has a beta of 1.1. For the bond-yield-plus-risk-premium approach, the firm uses a risk premium of 3.5%.

(5) The firm adjusts its project WACC for risk by adding 2.5% to the overall WACC for high-risk projects and subtracting 2.5% for low-risk projects.

Lindsey knows that Swift Ltd. 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, Lindsey must finish the analysis and write her report. To help begin, she has formulated the following questions:

  1. What is the firm’s cost of debt?
  1. What is the cost of preferred stock for Swift Ltd.?
  1. 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?

  1. What is Swift Ltd.’s overall WACC?
  1. Do you think the firm should use the single overall WACC as the hurdle rate for each of its projects? Explain.
  1. What is the WACC for each project? Place your numerical solutions in Table 2.
  1. 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

  1. Comment on the commonly used capital budgeting measures. What is the underlying cause of ranking conflicts? Which criterion is the best one, and why?
  1. Which of the projects are unacceptable and why?
  1. Rank the projects that are acceptable, according to Lindsey’s criterion of choice.
  1. Which project should Lindsey recommend and why? Explain why each of the projects not chosen was rejected.

Instructions

1.Your answers should be Word processed, submitted via Canvas.

2.Questions 5, 8, 9, and 11 are discussion questions.

3.Place your numerical solutions in Table 2.

4.Show your steps for calculation questions.

Solutions

Expert Solution

AFTER TAX COST OF DEBT
Debt
Face value of each Bond $1,000
Coupon Rate 8.00%
Pmt Semi annual Coupon Payment=1000*8%*(1/2) $40.00
Nper Number of payments 28 (14 years*2)
Pv Current marke Value of each Bond $960.00
Fv Amount to paid at maturity $1,000
RATE Semi annual Yield To Maturity 4.25% (Using RATE function of excel with Nper=28,Pmt=40,Pv=-960,Fv=1000)
Annual Interest Rate=4.25*2 8.49%
Cb After Tax Cost of Bond =8.49*(1-Tax Rate)=8.49*(1-0.35)= 5.52%
COST OF PREFERENCE SHARES
Annual Dividend=8.5%*50 $4.25
Market Price=$52 $52
Required Annual return =4.25/52 8.17%
Cp Cost of Preference Shares= 8.17%
Common Shares:
CAPM EQUATION:Rs=Required Return of stock
Rs=Rf+Beta*(Rm-Rf)
Rf=riskfree rate=2.8%, Rm=Market return=10.8%, Beta=1.1 9.328 10.078
Rs=2.8+1.1*(10.8-2.8)= 11.60%
1 Ce1 Cost of Equity Using CAPM equation 11.60%
COST OF EQUITY USING DCF APPROACH
Current Dividend=D0=$2, Growth rate g=5%=0.05
D1=Next year dividend =D0*(1+g)=2*1.05=$2.10
P0=Current Price =$35
Required Annual return =R=(D1/P0)+g=(2.1/35)+0.05= 11.00%
2 Ce2 Cost of Equity Using DCF approach 11.00%
3 Ce3 Cost of Equity Using bond yield plus risk premium=8.49+3.5= 11.99%
We consider the maximum value for WACC Calculation
Wb Weight of Debt in the capital structure 0.3
We Weight of Common Equity in the capital structure 0.55
Wp Weight of Preference Equity in the capital structure 0.15
After Tax Weighted average Cost of Capital:
WACC=Wb*Cb+Wp*Cp+We*Ce3= 9.48%
WACC   for Project A 9.48%
WACC   for Project B 9.48%
WACC   for Project C=9.48+2.5 11.98%
WACC   for Project D=9.48-2.5 6.98%


Related Solutions

Colin was recently hired by Coleman Electronics as a junior budget analyst. He is working 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 XXX (2015) and passed the CPA exam (2017). He has been in public accounting for several years. During that time he earned an MBA from Seattle U. He would like to...
Phil was recently hired by Select Network Inc. as a junior budget analyst. He is working...
Phil was recently hired by Select Network Inc. 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.   Phil has a B.S. in accounting from CWU (2007) and passed the CPA exam (2008). He has been in public accounting for 2 years. During that time he earned an MBA from Seattle U. He would like...
Phil was recently hired by Select Network Inc. as a junior budget analyst. He is working...
Phil was recently hired by Select Network Inc. 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.   Phil has a B.S. in accounting from CWU (2007) and passed the CPA exam (2008). He has been in public accounting for 2 years. During that time he earned an MBA from Seattle U. He would like...
Ronald was recently hired by Highland Equipment Inc. as a junior budget analyst. He is working...
Ronald was recently hired by Highland Equipment Inc. 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. Ronald has a B.S. in accounting from CWU (2016) and passed the CPA exam (2018). He has been in public accounting for several years. During that time he earned an MBA from Seattle U. He would like...
Hailey just started her first job at Whatcom Co. as a junior budget analyst. She is...
Hailey just started her first job at Whatcom Co. 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. Hailey has a B.S. in accounting from WWU (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...
You were recently hired by a firm as a project analyst.
You were recently hired by a firm as a project analyst. The owner of the firm is unfamiliar with financial analysis and wants to know only what the expected dollar return is per dollar spent on a given project. Which financial method of analysis will provide the information that the owner requests? a. Internal rate of return b. Modified internal rate of return c. Net present value d. Profitability index e. Payback
Assume that you were recently hired at Lilo Plc as a junior accountant and were asked...
Assume that you were recently hired at Lilo Plc as a junior accountant and were asked to help prepare the financial reports for the year ended 31 December 2019. In addition, the head of the accounting department wanted to assess your knowledge about the financial statements, hence, requested you to prepare a report. The company’s trial balance is shown below, together with the guide on the format and content of the report: Debit (£) Credit (£) Sales 72,813 Purchases 35,108...
Suppose that you are working for Amenia Ltd. as a junior management accountant. The previous accounting...
Suppose that you are working for Amenia Ltd. as a junior management accountant. The previous accounting staff has collected the following data for the company’s last year of operations: Sales volume (units) 150,000 Sales revenue: $2,400,000 Direct materials: $578,000 Direct labour: $415,000 Manufacturing overhead*: $540,000 Selling expenses**: $360,000 Administrative expenses***: $420,000 Note that: *70 variable and 30% fixed **40% variable and 60% fixed ***20% variable and 80% fixed The managing director has asked that you undertake a cost-volume-profit (CVP) analysis...
FIN 370 AOL ASSIGNMENT CASE ANALYSIS: The Case of the Junior Analyst Name:_______________________ Colin was recently...
FIN 370 AOL ASSIGNMENT CASE ANALYSIS: The Case of the Junior Analyst Name:_______________________ 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 exam (2017). He has been in public accounting for several years. During...
Mary Smith, a CFA candidate, was recently hired for an analyst position at the Bank of...
Mary Smith, a CFA candidate, was recently hired for an analyst position at the Bank of Ireland. Her first assignment is to examine the competitive strategies employed by various French wineries. Smith’s report identifies four wineries that are the major players in the French wine industry. Key characteristics of each are cited in the table below. In the body of Smith’s report, she includes a discussion of the competitive structure of the French wine industry. She notes that over the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT