Question

A thumbs up will be given: Table 1 t A B C D 0       (14,900,000)...

A thumbs up will be given:

Table 1

t

A

B

C

D

0

      (14,900,000)

      (17,900,000)

      (16,600,000)

       (19,700,000)

1

         4,980,000

         5,990,000

         3,850,000

          6,400,000

2

         4,980,000

         6,210,000

         4,990,000

          5,880,000

3

         4,510,000

         6,250,000

         6,860,000

          6,800,000

4

         4,510,000

         4,700,000

         4,990,000

          6,650,000

Risk

High

Average

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

Imagine Software Inc. has the following capital structure, which is considered to be optimal:

Debt  

35%

Preferred Equity

15%

Common Equity

50%

100%

   

Cost of Capital

Max 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 firm’s tax rate is 40%.

(2) Imagine Software Inc. has issued a 9% semi-annual coupon bond with 7 years term to maturity. The current trading price is $988.

(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 $94.

(4) The firm’s stock is currently selling for $76.5 per share. Its last dividend (D0) was $2.80, and dividends are expected to grow at a constant rate of 7.5%. The current risk free return offered by Treasury security is 3.1%, and the market portfolio’s return is 10%. Imagine Software Inc. has a beta of 1.25. For the bond-yield-plus-risk-premium approach, the firm uses a risk premium of 2.8%.

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

Max knows that Imagine Software Inc. 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, Max must finish the analysis and write his report. To help begin, he has formulated the following questions:

  1. What is the firm’s cost of debt?
  1. What is the cost of preferred stock for Imagine Software Inc.?
  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 Imagine Software Inc.’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 Max’s criterion of choice.
  1. Which project should Max recommend and why? Explain why each of the projects not chosen was rejected.

Instructions:

Questions 5, 8, 9, and 11 are discussion questions, Place your numerical solutions in Table 2, show all calculation steps

Homework Answers

Answer #1

What is the firm’s cost of debt?
Pre-tax cost=RATE(7*2,9%*1000/2,-988,1000)*2=9.24%

After-tax cost=RATE(7*2,9%*1000/2,-988,1000)*2*(1-40%)=5.54%

What is the cost of preferred stock for Imagine Software Inc.?
=8.5%*100/94=9.04%

Cost of common equity
(1) What is the estimated cost of common equity using the CAPM approach?
=3.1%+1.25*(10%-3.1%)=11.73%

(2) What is the estimated cost of common equity using the DCF approach?
=2.80*(1+7.5%)/76.5+7.5%=11.43%

(3) What is the estimated cost of common equity using the bond-yield-plus-risk-premium approach?
=RATE(7*2,9%*1000/2,-988,1000)*2+2.8%=12.04%

(4) What is the final estimate for rs?
=(11.73%+11.43%+12.04%)/3=11.73%

What is Imagine Software Inc.’s overall WACC?
=35%*5.54%+15%*9.04%+50%*11.73%=9.16%

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
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 test (2008). She has been in public accounting for 2 years. During that time, she earned an MBA from Seattle U. She would...
Capital Budgeting: 1. T/F If the NPV<0, the WACC > the IRR 2.T/F Salvage value is...
Capital Budgeting: 1. T/F If the NPV<0, the WACC > the IRR 2.T/F Salvage value is added back in to the last years projects cash flows 3. T/F NPV is considered to be the superior method for choosing capital budget projects 4. T/F If projects are mutually exclusive, if one has a higher IRR choose that project over the NPV decision. Cost of Capital 5. T/F external equity (new stock issuance) is less expensive since it will have a flotation...
4. Internal rate of return (IRR) The internal rate of return (IRR) refers to the compound...
4. Internal rate of return (IRR) The internal rate of return (IRR) refers to the compound annual rate of return that a project generates based on its up-front cost and subsequent cash flows. Consider the case of Blue Llama Mining Company: Blue Llama Mining Company is evaluating a proposed capital budgeting project (project Sigma) that will require an initial investment of $800,000. The company has been basing capital budgeting decisions on a project’s NPV; however, its new CFO wants to...
Mannheim Biotechnology Limited is expanding the business by considering investing in some profitable projects. Stevenson, a...
Mannheim Biotechnology Limited is expanding the business by considering investing in some profitable projects. Stevenson, a project manager of Mannheim was asked to estimate the cost of capital and evaluate the following projects year 0 1 2 3 4 Project A (100.00) 10.00 50.00 40.00 20.00 Project B (200.00) 80.00 90.00 85.00 10.00 Project C (300.00) 105.00 90.00 110.00 20.00 Albert, the Chief Financial Officer (CFO) of Mannheim has provided him some relevant information. The current bond price of Mannheim’s...
1.) The cost of raising capital through retained earnings is __________ (greater than, less than) the...
1.) The cost of raising capital through retained earnings is __________ (greater than, less than) the cost of raising capital through issuing new common stock. 2.) The current risk-free rate of return is 3.80% and the current market risk premium is 6.10%. Blue Hamster Manufacturing Inc. has a beta of 1.56. Using the Capital Asset Pricing Model (CAPM) approach, Blue Hamster’s cost of equity is __________ (13.99%, 17,32%, 14.65%, 13.32%) 3.) Fuzzy Button Clothing Company is closely held and, as...
Blue Llama Mining Company is evaluating a proposed capital budgeting project (project Delta) that will require...
Blue Llama Mining Company is evaluating a proposed capital budgeting project (project Delta) that will require an initial investment of $1,500,000. Blue Llama Mining Company has been basing capital budgeting decisions on a project’s NPV; however, its new CFO wants to start using the IRR method for capital budgeting decisions. The CFO says that the IRR is a better method because percentages and returns are easier to understand and to compare to required returns. Blue Llama Mining Company’s WACC is...
Nike's management team is considering two projects, a golf club project and a helmet project. A....
Nike's management team is considering two projects, a golf club project and a helmet project. A. Using the table below, calculate firm’s weighted average cost of capital: Nike: % of debt in capital structure 25% % of equity in capital structure 75% Before-tax required cost of debt 6% Tax rate 30% Cost of equity 11% B. Capital Budgeting Project information: Golf club project Helmet project Upfront costs (10,000,000) (8,000,000) Annual cash flows Year 1 $0 $3,000,000 Year 2 $0 $3,000,000...
Internal rate of return. For each of the projects shown in the following table, calculate the...
Internal rate of return. For each of the projects shown in the following table, calculate the internal rate of return (IRR). Then indicate, for each project, the maximum cost of capital that the firm could have and still find the IRR acceptable. Project A Project B Project C Project D Initial investment -$90,000 -$490,000 -$20,000 -$240,000 Year Cash inflows 1 $20,000 $150,000 $7,500 $120,000 2 25,000 150,000 7,500 100,000 3 30,000 150,000 7,500 80,000 4 35,000 150,000 7,500 60,000 5...
2Assume that you are a new analyst hired to evaluate the capital budgeting projects of the...
2Assume that you are a new analyst hired to evaluate the capital budgeting projects of the company which is considering investing in two CPEC projects, “Expansion Zone North” and “Expansion Zone East”. The initial cost of each project is Rs. 10,000. Company discount all projects based on WACC. Further, all the projects are equally risky projects and the company uses only debt and common equity for financing these projects. It can borrow unlimited amounts at an interest rate of rd...
Blue Llama Mining Company is evaluating a proposed capital budgeting project (project Delta) that will require...
Blue Llama Mining Company is evaluating a proposed capital budgeting project (project Delta) that will require an initial investment of $1,600,000. Blue Llama Mining Company has been basing capital budgeting decisions on a project’s NPV; however, its new CFO wants to start using the IRR method for capital budgeting decisions. The CFO says that the IRR is a better method because percentages and returns are easier to understand and to compare to required returns. Blue Llama Mining Company’s WACC is...