Question

In: Finance

A company has a proposed 2-year project with the cash flows shown below and would like...

A company has a proposed 2-year project with the cash flows shown below and would like to calculate the NPV of this project so that they can decide whether to pursue the project or not. The company has a target capital structure of 60% equity and 40% debt. The beta for this firms stock is 1.2, the risk-free rate is 4.6, and the expected market risk premium is 6.1%. The bonds for this company pay interest semiannually and have a coupon interest rate of 6%, 13 years to maturity, a face value of $1,000, and a current price of 922.67. If the corporate tax rate is 36%, what is the NPV of the proposed project for this firm? (Answer to the nearest dollar, but do not use a dollar sign).

  

Years

Cash Flows

0

-5,000

1

2,000

2

3,000

Solutions

Expert Solution

First we need to calculate WACC:

Target Capital structure:

Equity = 60% equity and

Debt = 40%

Cost of equity:

Cost of equity = Risk free rate + Beta * Market risk premium

= 4.6% + 1.2 * 6.1%

= 11.92%

Cost of equity = 11.92%

Cost of debt:

Face value = $1,000

Current price = $922.67

Semiannual coupon = 1000 * 6% / 2 = $30

Time to maturity = 13 years =13* 2 = 26 semiannual periods

To get semiannual cost of debt we will use RATE function

= RATE (nper, pmt, pv, fv, type)

= RATE (26, 30, -922.67, 1000, 0)

= 3.4556%

Before tax cost of debt = 3.4556% * 2 = 6.911%

WACC:

WACC = Cost of equity * weight of equity + Cost of debt * (1 - tax rate) * weight of debt

= 11.92% * 60% + 6.911% * (1 - 36%) * 40%

= 8.92%

WACC = 8.92%

NPV:

NPV calculations:


Related Solutions

A company has a proposed 2-year project with the cash flows shown below and would like...
A company has a proposed 2-year project with the cash flows shown below and would like to calculate the NPV of this project so that they can decide whether to pursue the project or not. The company has a target capital structure of 60% equity and 40% debt. The beta for this firms stock is 1.6, the risk-free rate is 4.5, and the expected market risk premium is 6%. The bonds for this company pay interest semiannually and have a...
A company has a proposed 2-year project with the cash flows shown below and would like...
A company has a proposed 2-year project with the cash flows shown below and would like to calculate the NPV of this project so that they can decide whether to pursue the project or not. The company has a target capital structure of 60% equity and 40% debt. The beta for this firms stock is 1.3, the risk-free rate is 4.6, and the expected market risk premium is 5.5%. The bonds for this company pay interest semiannually and have a...
A company has a proposed 2-year project with the cash flows shown below and would like...
A company has a proposed 2-year project with the cash flows shown below and would like to calculate the NPV of this project so that they can decide whether to pursue the project or not. The company has a target capital structure of 60% equity and 40% debt. The beta for this firms stock is 1.6, the risk-free rate is 4.9, and the expected market risk premium is 6.4%. The bonds for this company pay interest semiannually and have a...
42. A company has a proposed 2-year project with the cash flows shown below and would...
42. A company has a proposed 2-year project with the cash flows shown below and would like to calculate the NPV of this project so that they can decide whether to pursue the project or not. The company has a target capital structure of 60% equity and 40% debt. The beta for this firms stock is 1.4, the risk-free rate is 4.5, and the expected market risk premium is 6.4%. The bonds for this company pay interest semiannually and have...
QUESTION 42 A company has a proposed 2-year project with the cash flows shown below and...
QUESTION 42 A company has a proposed 2-year project with the cash flows shown below and would like to calculate the NPV of this project so that they can decide whether to pursue the project or not. The company has a target capital structure of 60% equity and 40% debt. The beta for this firms stock is 0.8, the risk-free rate is 4.8, and the expected market risk premium is 6%. The bonds for this company pay interest semiannually and...
Sigma Company is examining the cash flows of the capital budgeting project shown below. The project...
Sigma Company is examining the cash flows of the capital budgeting project shown below. The project is expected to cost $400,000. Sigma has a required rate of return of 12%, and a maximum acceptable payback period of 3 years. 0 1 2 3 4 5    ($400,000) $150,000 $150,000 $200,000 $100,000 $100,000 a. Calculate the NPV of the project. Based on the NPV analysis, should Sigma accept the project? Why or why not? b. Calculate the payback period of the...
The net cash flows for project X, Y and Z are shown below. Each project has...
The net cash flows for project X, Y and Z are shown below. Each project has an initial cost of $100, and the company uses a 10% cost of capital (i.e., the discount rate = 10%) for each project. Which project is most sensitive to the change of the cost of capital? End of Year Net Cash Flow From Project X Y Z 1 $110 0 0 2 0 $121 0 3 0 0 $133.1 X Y Z All the...
Dundee Co. is considering Project “X” whose cash flows are shown below: Year 0 1 2...
Dundee Co. is considering Project “X” whose cash flows are shown below: Year 0 1 2 3 CF -$1,200 $600 $550 $300 The company’s capital structure is distributed equally between debt, preferred stock and common stock. It has also the following information: 1- After tax cost of debt: 2% 2- Preferred stocks are selling at $120 per share and pay a dividend of $5 per share 3- Common stocks are selling at $40 per share, pay a year-end dividend of...
Dundee Co. is considering Project “X” whose cash flows are shown below: Year 0 1 2...
Dundee Co. is considering Project “X” whose cash flows are shown below: Year 0 1 2 3 CF -$1,200 $600 $550 $300 The company’s capital structure is distributed equally between debt, preferred stock and common stock. It has also the following information: 1- After tax cost of debt: 2% 2- Preferred stocks are selling at $120 per share and pay a dividend of $5 per share 3- Common stocks are selling at $40 per share, pay a year-end dividend of...
A company has the following mutually exclusive investment alternatives. The cash flows are shown below. Year...
A company has the following mutually exclusive investment alternatives. The cash flows are shown below. Year Project A Project B 0 -$1,000 -$1,000 1 600 300 2 600 600 3 600 900 If the cost of capital is 10%, which investment(s) should the company select? Both Project A and Project B Project B with a NPV of $444.78 Project B with a NPV of $276.31 Project A with a NPV of $493.11 Project A with a NPV of $253.64
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT