A Company is considering two mutually exclusive projects whose expected net cash flows are in the table below. The company's WACC is 15%. What is the NPV for Project Y? What is the NPV for Project Z? What is the IRR for Project Y? What is the IRR for Project Z? Which Project, if any, should you choose? Time Project Y Project Z 0 $(420.00) $(950.00) | $(572.00) $270.00 2 $(189.00) $270.00 3 $(130.00) $270.00 4 $1,300.00 $ 270.00 5 $720.00 $270.00 6 $980.00 $270.00 7 $(225.00) $270.00 Please show in excel I think im getting the wrong values

A Company is considering two mutually exclusive projects whose expected net cash flows are in the table below. The company's WACC is 15%. What is the NPV for Project Y? What is the NPV for Project Z? What is the IRR for Project Y? What is the IRR for Project Z? Which Project, if any, should you choose? Time Project Y Project Z 0 $(420.00) $(950.00) | $(572.00) $270.00 2 $(189.00) $270.00 3 $(130.00) $270.00 4 $1,300.00 $ 270.00 5 $720.00 $270.00 6 $980.00 $270.00 7 $(225.00) $270.00 Please show in excel I think im getting the wrong values

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 13P

See similar textbooks

Similar questions

A Company is considering two mutually exclusive projects whose expected net cash flows are in the table below. The company's WACC is 15%. What is the NPV for Project Y? What is the NPV for Project Z? What is the IRR for Project Y? What is the IRR for Project Z? Which Project, if any, should you choose? Time Project Y Project Z 0 S (420.00) S(950.00) 1 S(572.00) $270.00 2 S(189.00) S270.00 3 S(130.00) $270.00 4 $1,300.00 $270.00 5 $720.00 $270.00 6 $980.00 $270.00 7 $(225.00) $270.00 Pleaseshow in excel I think im getting the wrong values
You have the chance to participate in a project that produces the following cash flows: Cash Flows ($) C0 C1 C2 −3,600 5,400 −10,800 If the opportunity cost of capital is 10%, what is the NPV of the project? Would you accept the offer?
Consider the following two mutually exclusive projects:Year Cash Flow (X) Cash Flow (Y)0 -$365,000 -$38,0001 25,000 16,0002 65,000 12,0003 65,000 17,0004 425,000 15,000Whichever project you choose, if any, you require a 13 percent return on your investment. i. Which investment will you choose if you use the payback decision criteria? Justify your answer.ii. Which investment will you choose if you use the NPV decision criteria? Justify your answer.iii. Which project will you choose ultimately based on your answers above?
Better plc is comparing two mutually exclusive projects, whose details are given below.The company’s cost of capital is 12 per cent.Project A Project B£m £mYear 0 (150) (152)Year 1 40 80Year 2 50 80Year 3 60 50Year 4 60 40Year 5 80 30(a). Using the net present value method, which project should be accepted?(b). Using the internal rate of return method, which project should be accepted?(c). If the cost of capital increases to 20 per cent in year 5, would your advice change? Hello.i have the solution you send me but i am trying to understand where did you get the calculations for in the worknotes tabel. I did my own calculation but i dont get the same answer. For example for year 2 for project A you have 39.8597 How did you get to that without using the formula in excel. I need to write down the actual numbers. I got 22.3214 some im not sure how you got to that number. Can you help me please? Thank you
Better plc is comparing two mutually exclusive projects, whose details are given below.The company’s cost of capital is 12 per cent.Project A Project B£m £mYear 0 (150) (152)Year 1 40 80Year 2 50 80Year 3 60 50Year 4 60 40Year 5 80 30(a). Using the net present value method, which project should be accepted?(b). Using the internal rate of return method, which project should be accepted?(c). If the cost of capital increases to 20 per cent in year 5, would your advice change? Hello.i have the solution you send me but i am trying to understand where did you get the calculations for in the worknotes tabel. I still cant calculate the IRR.i really dont understand how to do it. Can you help me please by using the numbers in the tabel so i can understand what is that you are adding or taking away please? I know how to calculate the NPV but not the IRR. I have went over and over this IRR but i still dont understand how you calculate it using the pv and the npv.i dont wanna use excel.
Better plc is comparing two mutually exclusive projects, whose details are given below.The company’s cost of capital is 12 per cent.Project A Project B£m £mYear 0 (150) (152)Year 1 40 80Year 2 50 80Year 3 60 50Year 4 60 40Year 5 80 30(a). Using the net present value method, which project should be accepted?(b). Using the internal rate of return method, which project should be accepted?(c). If the cost of capital increases to 20 per cent in year 5, would your advice change? Hello.i have the solution you send me but i am trying to understand where did you get the calculations for in the worknotes tabel. I still cant calculate the IRR.i really dont understand how to do it. Can you help me please by using the numbers in the tabel so i can understand what is that you are adding or taking away please? I know how to calculate the NPV but not the IRR
Better plc is comparing two mutually exclusive projects, whose details are given below.The company’s cost of capital is 12 per cent.Project A Project B£m £mYear 0 (150) (152)Year 1 40 80Year 2 50 80Year 3 60 50Year 4 60 40Year 5 80 30(a). Using the net present value method, which project should be accepted?(b). Using the internal rate of return method, which project should be accepted?(c). If the cost of capital increases to 20 per cent in year 5, would your advice change?
Better plc is comparing two mutually exclusive projects, whose details are given below.The company’s cost of capital is 12 per cent.Project A Project B£m £mYear 0 (150) (152)Year 1 40 80Year 2 50 80Year 3 60 50Year 4 60 40Year 5 80 30(a). Using the net present value method, which project should be accepted?(b). Using the internal rate of return method, which project should be accepted?(c). If the cost of capital increases to 20 per cent in year 5, would your advice change? Hello.i have the solution you send me but i am trying to understand where did you get the calculations for in the worknotes tabel. I did my own calculation but i dont get the same answer. Could you show mw the calculation but not in excel please, i need the calculation by formula manually
You must analyze two projects, X and Y. Each project costs $1,000, and the firm’s WACC is 10%. The expected net cash flows are as follows. Which project should be accepted if they are mutually exclusive? Year: 0 1 2 3 4 Project X: -$1,000 $500 $400 $300 $100 Project Y: -$1,000 $100 $300 $400 $675 Which answers? Y only X only None X and Y
Consider an investment project with the cash flows given in the table below. Compute the IRR for this investment. Is the project acceptable at MARR = 10%? The IRR for this project is %. (Round to one decimal place.) n 0 1 2 3 Cash Flow -$35,000 15,000 14,520 13,990
A firm evaluates all of its projects by using the NPV decision rule. Year Cash Flow 0 −$ 28,000 1 24,000 2 13,000 3 6,000 a. At a required return of 28 percent, what is the NPV for this project? b. At a required return of 35 percent, what is the NPV for this project?
Consider the following two mutually exclusive investment projects:Project Cash Flowsn A B 0 -$4,000 -$8,5001 $400 $11,5002 $7,000 $400Assume that the MARR = 15%.(a) Using the NPW criterion, which project would you select?(b) On the same chart, sketch the PW(i) function for each alternative fori = 0% and 50%. For what range of i would you prefer Project B?