Dow Chemical has been presented with an investment opportunity which will yield end of year cash...

Dow Chemical has been presented with an investment opportunity which will yield end of year cash flows of $3,350 per year in Years 1 through 4, $3,450 per year in Years 5 through 9, and $8,800 in Year 10. This investment will cost the firm $6,850 today, and the firm's required rate of return is 7 percent. What is the NPV for this investment? Group of answer choices $19,762.30 $–1,976.23 $21,738.53 $17,786.07 $23,714.76

Bristol Myers Squibb has been presented with an investment opportunity which will yield end of year cash flows of $3,650 per year in Years 1 through 4, $2,900 per year in Years 5 through 9, and $10,150 in Year 10. This investment will cost the firm $14,144 today, and the firm's required rate of return is 14 percent. What is the IRR for this investment? Group of answer choices 8.88% 22.20% –2.22% 2.22% 15.54%

General Motors estimates that its required rate of return is 18 percent. The company is considering two mutually exclusive projects whose after-tax cash flows are as follows: Year Project S Project L 0 ($320) ($985) 1 650 (450) 2 435 805 3 360 375 4 (410) 455 What is the modified internal rate of return (MIRR) of each project? Group of answer choices MIRRS = 40.55%; MIRRL = 6.35% MIRRS = 38.10%; MIRRL = 9.73% MIRRS = 40.96%; MIRRL = 10.25% MIRRS = 47.11%; MIRRL = 7.58% MIRRS = 27.45%; MIRRL = 11.78%

Solutions

Expert Solution

1. To find the NPV use NPV function in EXCEL

=NPV(rate,Year1 to Year10 cashflows)-Initial cost

=NPV(7%,Year1 to Year10 cashflows)-6850

NPV=$19,762.30 (Option A is correct)

required rate of return	7%
	Cashflows
Year0	-6850
Year1	3350
Year2	3350
Year3	3350
Year4	3350
Year5	3450
Year6	3450
Year7	3450
Year8	3450
Year9	3450
Year10	8800

NPV	19762.30

2. We have to use IRR function in EXCEL

=IRR(Year0 to year10 cashflows)

IRR= 22.20% (Option B is correct)

	Cashflows
Year0	-14144
Year1	3650
Year2	3650
Year3	3650
Year4	3650
Year5	2900
Year6	2900
Year7	2900
Year8	2900
Year9	2900
Year10	10150

IRR	22.20%

3. Use MIRR function in the EXCEL

=MIRR(Year0 to Year10 cashflows,finance rate,reinvest rate)

finance rate=reinvest rate=18%

=MIRR(Year0 to Year10 cashflows,18%,18%)

Finance rate	18%
reinvest rate	18%
	Project S	Project L
Year0	-320	-985
Year1	650	-450
Year2	435	805
Year3	360	375
Year4	-410	455

MIRR	40.96%	10.25%

Option C is correct

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

The Terug Corporation has been presented with an investment opportunity which will yield end-of-year cash flows...

The Terug Corporation has been presented with an investment opportunity which will yield end-of-year cash flows of $30,000 per year in Years 1 through 4, $35,000 per year in Years 5 through 9, and $40,000 in Year 10. This investment will cost the firm $150,000 today, and the firm's cost of capital is 10 percent. What are the NPV, IRR and MIRR values for this investment? a. NPV $135,984; IRR 17.07%; MIRR 11.27% b. NPV $18,023; IRR 16.24%: MIRR 13.27%...

Home Depot has been presented with an investment opportunity that will yield end-of-year cash flows of...

Home Depot has been presented with an investment opportunity that will yield end-of-year cash flows of $45,000 per year in years 1 through 4, $38,000 per years 5 through 9, and $42,000 in year 10. This investment will cost the firm $185,000 today, and the firm's cost of capital is 6%. What is the NPV for this investment? Please include formula and numbers used.

3. The Tassel Ltd. has been presented with an investment opportunity which will yield end of...

3. The Tassel Ltd. has been presented with an investment opportunity which will yield end of year revenue of $20,000 per year in Years 1 through 4, $25,000 per year in Years 5 through 9, and $3 4. Using the information in Q3, if the tax rate is 30%, and Tassel uses prime-cost approach for depreciations with the salvage value of $20,000, do you think Tassel should implement this investment and why? Please demonstrate your answer by showing your capital...

The Seattle Corporation has been presented with an investment opportunity which will yield cash flows of...

The Seattle Corporation has been presented with an investment opportunity which will yield cash flows of $30,000 per year in Years 1 through 4, $35,000 per year in Years 5 through 9, and $40,000 in Year 10. This investment will cost the firm $100,000 today, and the firm's cost of capital is 10%. Assume cash flows occur evenly during the year. The discounted payback period is A. 3.72 years. B. 4.26 years. C. 5.23 years. D. 4.35 years.

The OMEGA Corporation has been presented with an investment opportunity that will yield cash flows of...

The OMEGA Corporation has been presented with an investment opportunity that will yield cash flows of $60,000 per year in Years 1 through 4, $70,000 per year in Years 5 through 9, and $80,000 in Year 10. This investment will cost the firm $300,000 today, and the firm’s cost of capital is 10 percent. Assume cash flows occur evenly during the year, 1/365th each day. What is the payback period for this investment? a. 5.23 years b. 4.86 years c....

1. A company has been presented with the two investment opportunity. Project 1: The investment outlay...

1. A company has been presented with the two investment opportunity. Project 1: The investment outlay is expected to be $130,000 in Year 0. After that, the project is expected to earn operating cash flows of $40,000 per year for the next 4 years. Project 2: The investment outlay is expected to be $125,000 in Year 0. After that, the project is expected to earn operating cash flows of $37,000 per year for the next 4 years. If your cost...

You are presented with an investment opportunity that will give you the following stream of cash...

You are presented with an investment opportunity that will give you the following stream of cash flows: nothing for the next 5 years; at the following year, an amount of $3,000 per year until year 10; and then an amount of $8,000 per year until year 25. If your required rate of return (APR) is 12% compounded annually, what is the present value today of these cash flows?

You are presented with an investment opportunity that will give you the following stream of cash...

You are presented with an investment opportunity that will give you the following stream of cash flows: nothing for the next 2 years; at the following year, an amount of $5,000 per year until year 14; and then an amount of $8,000 per year until year 22. If your required rate of return (APR) is 9% compounded annually, what is the present value today of these cash flows?

You are presented with an investment opportunity that will give you the following stream of cash flows:

You are presented with an investment opportunity that will give you the following stream of cash flows: nothing for the next 5 years; at the following year, an amount of $2,000 per year until year 13; and then an amount of $10,000 per year until year 23. If your required rate of return (APR) is 8% compounded annually, what is the present value today of these cash flows?Do not use the $ sign. Use commas to separate thousands. Use to...

Assume an investment opportunity which provides the following cash flows: 15,000$ in one year, 9,000$ in...

Assume an investment opportunity which provides the following cash flows: 15,000$ in one year, 9,000$ in two years, 8,750$ in three years, 12,000$ in four years and 5,000$ in five years. If the relevant required rate of return for this investment is 8%, what is the investment’s value in year three?

Subjects