Garage, Inc., has identified the following two mutually exclusive projects.a. What is the IRR for each project?b. If the required return is 11 percent, what is the NPV for each project?c. What is the crossover rate between these two projects?Year 0Year 1Year 2Year 3Year 4Required returnSSSSSA(43,500)21,40018,50013,8007,600$ESSASALA$$$$B(43,500)6,40014,70022,80025,20011%Complete the following analysis. Do not hard code values in your calculations.You must use the built-in Excel functions to answer this question. Complete the following analysis. Do not hard code values in your calculations.You must use the built-in Excel functions to answer this question.Cash flow A IRRCash flow B IRRCash flow A NPVCash flow B NPVYear 0Year 1Year 2Year 3Year 4Crossover rateDifference in cash flows+

In order to determine if a project is financially feasible and viable or not we make use of capital…

Garage, Inc., has identified the following two mutually exclusive projects. a. What is the IRR for each project? b. If the required return is 11 percent, what is the NPV for each project? c. What is the crossover rate between these two projects? Year 0 Year 1 Year 2 Year 3 Year 4 Required return SSSSS $ $ A (43,500) 21,400 18,500 13,800 7,600 $ $ $ 14,700 22,800 25,200 555 $ B (43,500) 6,400 $ 11%

Garage, Inc., has identified the following two mutually exclusive projects. a. What is the IRR for each project? b. If the required return is 11 percent, what is the NPV for each project? c. What is the crossover rate between these two projects? Year 0 Year 1 Year 2 Year 3 Year 4 Required return SSSSS $ $ A (43,500) 21,400 18,500 13,800 7,600 $ $ $ 14,700 22,800 25,200 555 $ B (43,500) 6,400 $ 11%

Intermediate Financial Management (MindTap Course List)

13th Edition

ISBN:9781337395083

Author:Eugene F. Brigham, Phillip R. Daves

Publisher:Eugene F. Brigham, Phillip R. Daves

Chapter12: Capital Budgeting: Decision Criteria

Section: Chapter Questions

Problem 10P: Project S has a cost of $10,000 and is expected to produce benefits (cash flows) of $3,000 per year...

See similar textbooks

Similar questions

Consider the following two mutually exclusive projects: Year Cash Flow(A) -$ 63,000 39,000 33,000 22,500 14,600 Cash Flow(B) -$ 63,000 25,700 29,700 35,000 24,700 4 1-What is the IRR for each project? Project A Project B % % 2.IF you apply the IRR decision rule, which project should ti 3.Assume the required return is 14 percent. What is the NP Project A Project B 0123
Consider the following two projects, X and Y: Period Project X Project Y 0 $(100,000) $(120,000) 1 $22,000 $0 2 $22,000 $0 3 $22,000 $0 4 $22,000 $0 5 $45,000 $175,000 Regarding the internal rate of return, which of the following statements is correct? The internal rate of return of Project Y is greater than the internal rate of return of Project X. The internal rate of return of Project X is equal to the internal rate of return of Project Y. O The internal rate of return of Project X is greater than the internal rate of return of Project Y. The internal rate of return of Projects X and Y cannot be determined based on this information.
es The Michner Corporation is trying to choose between the following two mutually exclusive design projects: Year Cash Flow (1) Cash Flow (II) -$ 0 1 2 3 Project I Project II 67,000 30,500 30,500 30,500 a-1.If the required return is 11 percent, what is the profitability index for both projects? (Do not round Intermediate calculations and round your answers to 3 decimal places, e.g., 32.161.) a. If the company applies the profitability index decision rule, which project should the 2. firm accept? Project I Project II 17,700 9,550 9,550 9.550 O Project I O Project II b- What is the NPV for both projects? (A negative answer should be Indicated by a 1. minus sign. Do not round Intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) b- If the company applies the NPV decision rule, which project should it take? 2. O Project I O Project II
An interior design studio is trying to choose between the following two mutually exclusive design projects: Year 0 1 2 3 Cash Flow Cash Flow (0) -$64,000 31,000 31,000 31,000 a-1 If the required return is 10 percent, what is the profitability index for both projects? (Round your answers to 3 decimal places. (e.g., 32.161)) Project I Project II -$18,000 9,700 9,700 9,700 Profitability Index a-2 If the company applies the profitability index decision rule, which project should the firm accept? O Project I O Project II Project I Project II b-1 What is the NPV for both projects? (Round your answers to 2 decimal places. (e.g., 32.16)) O Project I Project II NPV b-2lf the company applies the NPV decision rule, which project should it take?
The Michner Corporation is trying to choose between the following two mutually exclusive design projects: Year Cash Flow (I) 0 -$ 82,000 1 37,600 2 37,600 37,600 Cash Flow (II) -$ 21,700 11, 200 11,200 11, 200 a-1. If the required return is 10 percent, what is the profitability index for each project? Note: Do not round intermediate calculations and round your answers to 3 decimal places, e.g., 32.161. a-2. If the required return is 10 percent and the company applies the profitability index decision rule, which project should the firm accept? b-1. If the required return is 10 percent, what is the NPV for each project? Note: Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16. b-2. If the company applies the NPV decision rule, which project should it take? a-1. Project I Project II a-2. Project acceptance b-1. Project I Project II b-2. Project acceptance
The Michner Corporation is trying to choose between the following two mutually exclusive design projects: S Year Cash Flow (I) Cash Flow (II) 0 -$ 84,000 -$ 42,000 1 33,900 12,600 2 3 31,500 25,500 44,000 50,000 a-1. If the required return is 17 percent, what is the profitability index for each project? Note: Do not round intermediate calculations and round your answers to 3 decimal places, e.g., 32.161. a-2. If the company applies the profitability index decision rule, which project should it take? b-1. If the required return is 17 percent, what is the NPV for each project? Note: Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16. b-2. If the company applies the net present value decision rule, which project should it take? a-1. Project I a-2. Project II b-1. Project I Project II b-2. Project II Project I
The Michner Corporation is trying to choose between the following two mutually exclusive design projects: Cash Flow (II) -$ 51,000 12,300 32,500 23,500 Year 0 1 2 3 Cash Flow (I) -$ 85,000 34,900 45,000 28,000 a-1. If the required return is 10 percent, what is the profitability index for each project? Note: Do not round intermediate calculations and round your answers to 3 decimal places, e.g., 32.161. a-2. If the company applies the profitability index decision rule, which project should it take? b-1. If the required return is 10 percent, what is the NPV for each project? Note: Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16. b-2. If the company applies the net present value decision rule, which project should it take? a-1. Project I Project II a-2. b-1. Project I Project II b-2. Answer is not complete. Project II Project I 1.058
The Michner Corporation is trying to choose between the following two mutually exclusive design projects: Year Cash Flow (1) Cash Flow (II) 0 123 -$ 73,000 33,000 33,000 3 33,000 -$ 17,100 9,250 9,250 9,250 a-1.If the required return is 11 percent, what is the profitability index for both projects? (Do not round intermediate calculations and round your answers to 3 decimal places, e.g., 32.161.) Project I Project II - If the company applies the profitability index decision rule, which project should the 2. firm accept? O Project I O Project II b- What is the NPV for both projects? (A negative answer should be indicated by a 1. minus sign. Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) Project I Project II
The following information is available on two mutually exclusive projects. Project Year 0 Year 1 Year 2 Year 3 Year 4 A -$700 $200 $300 $400 $500 B -$700 $600 $300 $200 $100 If the required rate of return is 10%, which project should be selected using the internal rate of return (IRR) method? Group of answer choices A B
Consider the following two mutually exclusive projects: Year Cash Flow (X) Cash Flow (Y) 0 $20,000 $20,000 1 8,850 10,100 23 9,100 7,800 8,800 8,700 Calculate the IRR for each project. (Round your answers to 2 decimal places. (e.g., 32.16)). IRR Project X Project Y % % What is the crossover rate for these two projects? (Round your answer to 2 decimal places. (e.g., 32.16)). Crossover rate %
The Michner Corporation is trying to choose between the following two mutually exclusive design projects: Year Cash Flow (1) Cash Flow (II) -$ -$ 0 55,000 1 25,000 2 25,000 3 25,000 a-1. If the required return is 10 percent, what is the profitability index for both projects? (Do not round intermediate calculations and round your answers to 3 decimal places, e.g., 32.161.) Project I Project II 18,900 10,150 10,150 10,150 a- If the company applies the profitability index decision rule, which project should the 2. firm accept? Project I O Project II Project I Project II 1. b- What is the NPV for both projects? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.)
The Michner Corporation is trying to choose between the following two mutually exclusive design projects: Year Cash Flow (I) Cash Flow (II) 0 -$ 76,000 -$ 34,000 1 29,000 11,000 23,500 17,500 2 3 36,000 42,000 a-1. If the required return is 12 percent, what is the profitability index for each project? Note: Do not round intermediate calculations and round your answers to 3 decimal places, e.g., 32.161. a-2. If the company applies the profitability index decision rule, which project should it take? b-1. If the required return is 12 percent, what is the NPV for each project? Note: Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16. b-2. If the company applies the net present value decision rule, which project should it take? a-1. Project I a-2. Project II b-1. Project I b-2. Project II