Question

In: Finance

Here is project Y: The cash flow in year 0 is negative $23,000. The cash flow...

Here is project Y:

The cash flow in year 0 is negative $23,000.

The cash flow in year 1 is $32,000.

The cash flow in year 2 is $26,000.

The cash flow in year 3 is negative $12,000.

Here is project Z:

The cash flow in year 0 is negative $42,000.

The cash flow in year 1 is $58,000.

The cash flow in year 2 is $39,000.

The cash flow in year 3 is negative $35,000.

Your decision rule is to choose the project that has a higher net present value.

The discount rate is 15% for both projects.

Which project will you choose? What is the net present value of that project?

Solutions

Expert Solution

Solution :

The Net Present value of Project Y = $ 16,595.63

The Net Present value of Project Z = $ 14,911.32

As per the decision rule, the project that has a higher net present value shall be chosen.

Thus, Project Y, which has higher net present value shall be chosen.

The Net Present Value of the project Y is = $ 16,595.63

Please find the attached screenshot of the excel sheet containing the detailed calculation for the solution.


Related Solutions

Consider the following two projects: Project Year 0 Cash Flow Year 1 Cash Flow Year 2...
Consider the following two projects: Project Year 0 Cash Flow Year 1 Cash Flow Year 2 Cash Flow Year 3 Cash Flow Year 4 Cash Flow Discount Rate A -100 40 50 60 N/A .15 B -73 30 30 30 30 .15 Assume that projects A and B are mutually exclusive. The correct investment decision and the best rational for that decision is to: Group of answer choices a.invest in project A since NPVB < NPVA. b.invest in project B...
There is a project with the following cash flows : Year Cash Flow 0 −$21,800 1...
There is a project with the following cash flows : Year Cash Flow 0 −$21,800 1 6,300 2 7,350 3 6,750 4 4,400 What is the payback period? Multiple Choice a. 4.00 years b. 3.32 years c. 3.74 years d. 3.56 years e. 2.79 years
There is a project with the following cash flows : Year Cash Flow 0 −$23,700 1...
There is a project with the following cash flows : Year Cash Flow 0 −$23,700 1 7,000 2 7,700 3 7,100 4 5,100 What is the payback period? Multiple Choice 2.73 years 4.00 years 3.81 years 3.63 years 3.37 years
Consider the following two mutually exclusive projects:     Year Cash Flow (X) Cash Flow (Y) 0...
Consider the following two mutually exclusive projects:     Year Cash Flow (X) Cash Flow (Y) 0 –$ 19,400 –$ 19,400 1 8,700 9,800 2 8,800 7,650 3 8,650 8,550      Calculate the IRR for each project. (Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.)     IRR   Project X %     Project Y %     What is the crossover rate for these two projects? (Do not round intermediate calculations. Enter your answer...
Consider the following two mutually exclusive projects: Year Cash Flow (X) Cash Flow (Y) 0 –$...
Consider the following two mutually exclusive projects: Year Cash Flow (X) Cash Flow (Y) 0 –$ 23,000 –$ 23,000 1 10,490 12,000 2 10,900 9,360 3 10,500 10,400 Calculate the IRR for each project. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) What is the crossover rate for these two projects? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g.,...
Consider the following two mutually exclusive projects: Year Cash Flow (X) Cash Flow (Y) 0 –$...
Consider the following two mutually exclusive projects: Year Cash Flow (X) Cash Flow (Y) 0 –$ 20,900 –$ 20,900 1 9,075 10,550 2 9,550 8,025 3 9,025 8,925 A) Calculate the IRR for each project B) What is the crossover rate for these two projects? C) What is the NPV of Projects X and Y at discount rates of 0 percent, 15 percent, and 25 percent?
you are analyzing a project and have this data : year : cash flow 0. :...
you are analyzing a project and have this data : year : cash flow 0. : -40,000 1 : 18,675 2 : 23,900 3. : 21,750 required rate of return = 13 % target payback = 2.0 years point:1+ 1.5 +1.5 + 2 compute following : a) pay back period b) discounted pay back period c) NPV D) IRR OF THIS PROJECT E) ACCEPT OR REJECT PROJECT
Here are the net cash flows for a project your company is considering: Year 0 =...
Here are the net cash flows for a project your company is considering: Year 0 = -1000 Year 1 = 250 Year 2 = 449 Year 3 = 800 Year 4 = 500 Year 5 = 500 If the payback period with interest is 3 years, for what range of interest rates is this project worth doing (start your analysis with an interest rate of 0%)? ** Kindly just don’t directly draw the table with values in it, it’ll be...
Here are the net cash flows for a project your company is considering: Year 0 =...
Here are the net cash flows for a project your company is considering: Year 0 = -1000 Year 1 = 250 Year 2 = 449 Year 3 = 800 Year 4 = 500 Year 5 = 500 If the payback period with interest is 3 years, for what range of interest rates is this project worth doing (start your analysis with an interest rate of 0%)? ** Kindly just don’t directly draw the table with values in it, it’ll be...
RAK Corp. is evaluating a project with the following cash flows:    Year Cash Flow 0...
RAK Corp. is evaluating a project with the following cash flows:    Year Cash Flow 0 –$ 28,600 1 10,800 2 13,500 3 15,400 4 12,500 5 – 9,000    The company uses a discount rate of 13 percent and a reinvestment rate of 6 percent on all of its projects.    Calculate the MIRR of the project using the discounting approach. (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.)...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT