(EXCEL) P11-24 Risk-adjusted discount rates: Basic Country Wallpapers is considering investing in one of three mutually...

(EXCEL)

P11-24 Risk-adjusted discount rates: Basic Country Wallpapers is considering investing in one of three mutually exclusive projects, E, F, and G. The firm’s cost of capital, r, is 15%, and the risk-free rate, R_F, is 10%. The firm has gathered the basic cash flow and risk index data for each project as shown in the following table.

	Project (j)
	E	F	G
Initial investment (CF₀)	−$15,000	−$11,000	−$19,000
Year (t)	Cash inflows (CF_t)
1	$6,000	$6,000	$ 4,000
2	6,000	4,000	6,000
3	6,000	5,000	8,000
4	6,000	2,000	12,000
Risk index (RI_j)	1.80	1.00	0.60

Find the net present value (NPV) of each project, using the firm’s cost of capital. Which project is preferred in this situation?
The firm uses the following equation to determine the risk-adjusted discount rate, RADR_j, for each project j:

RADRj=RF+[RIj×(r−RF)]RADRj = RF + [RIj × (r − RF)]

where
- R_F = risk-free rate of return
- RI_j = risk index for project j
- r = cost of capital
Substitute each project’s risk index into this equation to determine its RADR.
Use the RADR for each project to determine its risk-adjusted NPV. Which project is preferable in this situation?
Compare and discuss your findings in parts a and c. Which project do you recommend that the firm accept?

Solutions

Expert Solution

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

Risk-adjusted discount rates: Basic Country Wallpapers is considering investing in one of three mutually exclusive projects,...

Risk-adjusted discount rates: Basic Country Wallpapers is considering investing in one of three mutually exclusive projects, E, F, and G. The firm’s cost of capital, r, is 15%, and the risk-free rate, RF, is 10%. The firm has gathered the basic cash flow and risk index data for each project as shown in the following table. Project (j) E F G Initial investment (CF0) −$15,000−$15,000 −$11,000−$11,000 −$19,000−$19,000 Year (t) Cash inflows (CFt) 1 $6,000 $6,000 $ 4,000 2 6,000 4,000 6,000...

An investment company is considering investing into one of the following stocks with the risk and...

An investment company is considering investing into one of the following stocks with the risk and return characteristics given below: Risk free rate = 5.1% Average market rate = 7% Stock Exp. Rate Beta A 18% 1,5 B 16% 1,3 C 18% 1,85 D 6% 0,9 E 5.5% 0,7 F 5.8% 0.7 Required: 1. Determine which stocks are overvalued and which are undervalued in comparison with market fair determination of required returns. Provide your reason why you think they are...

(Risk-adjusted NPV) The Hokie Corporation is considering two mutually exclusive projects. Both require an initial outlay...

(Risk-adjusted NPV) The Hokie Corporation is considering two mutually exclusive projects. Both require an initial outlay of $13, 000 and will operate for 7 years. Project A will produce expected cash flows of $4,000 per year for years 1 through 7, whereas project B will produce expected cash flows of $5,000 per year for years 1 through 7. Because project B is the riskier of the two projects, the management of Hokie Corporation has decided to apply a required rate...

(Risk-adjusted NPV) The Hokie Corporation is considering two mutually exclusive projects. Both require an initial outlay...

(Risk-adjusted NPV) The Hokie Corporation is considering two mutually exclusive projects. Both require an initial outlay of $10 comma 000 and will operate for 5 years. Project A will produce expected cash flows of $5 comma 000 per year for years 1 through 5, whereas project B will produce expected cash flows of $6 comma 000 per year for years 1 through 5. Because project B is the riskier of the two projects, the management of Hokie Corporation has decided...

(Risk-adjusted NPV) The Hokie Corporation is considering two mutually exclusive projects. Both require an initial outlay...

(Risk-adjusted NPV) The Hokie Corporation is considering two mutually exclusive projects. Both require an initial outlay of $13,000 and will operate for 9 years. Project A will produce expected cash flows of $5,000 per year for years 1 through 9, whereas project B will produce expected cash flows of $6,000 per year for years 1 through 9. Because project B is the riskier of the two projects, the management of Hokie Corporation has decided to apply a required rate of...

Which of the following is not one of the three types of Country Risk? A. Military...

Which of the following is not one of the three types of Country Risk? A. Military Risk B. Political Risk C. Economic Risk D. Ideological Risk Which of the following publishes the Country Limitation Schedule? A. Coface Insurance B. Commerce Department C. ExIm Department D. Aon Insurance Which of the following provides risk ratings for banks worldwide? A. D&B Hoovers B. Nielsen C. ExIm Bank D. Fitch Which of the following does not offer company background checks A. Dun & Bradstreet B. Coface C. US Exporters Association...

Stephens, Inc. is considering investing in one of two mutually exclusive 4-year projects. Project A requires...

Stephens, Inc. is considering investing in one of two mutually exclusive 4-year projects. Project A requires equipment with a cost of $140,000 and increases net income by $5,000, $10,000, $20,000 and $30,000 in years 1-4, respectively. Project B requires equipment with a cost of $200,000 and increases cash flow by $70,000 per year in years 1-4. Both projects have a 4-year life and the equipment will be depreciated using straight-line depreciation. What is the NPV of project A at a...

Three zero coupon risk-free discount bonds of one, two and three year term to maturity are...

Three zero coupon risk-free discount bonds of one, two and three year term to maturity are selling for, respectively, $950, $890 and $800. What would be the selling price today of a 10% coupon bond of 3 year maturity (maturity value $1,000)?

Subjects