None NPV versus IRR (LO1, 5) Consider the following two mutually exclusive projects:Year0Cash Flow (X)-$20,000Cash Flow (Y)-$20,0001238,8509.1008.80010.1007,8008.700Sketch the NPV profiles for X and Y over a range of discount rates from 0 to 25%. What is the crossover rate for these twoprojects?

In excel NPV will be computed using the NPV function. The syntax is: NPV(rate, value 1, value…

Answered: NPV versus IRR (LO1, 5) Consider the…

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

Following projects, A and B are mutually exclusive. Use a discount rate of 7.6 percent to solve the following. Year 1 2. 3 4 5. Project A -11000 4000 3000 4000 4000 2000 Project B -15000 5000 4000 5000 7000 3000 Calculate the NPV and IRR, and select the project.
NPV versus IRR [LO1, 5] Consider the following two mutually exclusive projects: Year Cash Flow (X) Cash Flow (Y) O -$30,000 -$30,000 1 13,700 15,600 2 14,200 12,200 3 13,400 13,300 Page 313 Sketch the NPV profiles for X and Y over a range of discount rates from zero to 25 percent. What is the crossover rate for these two projects?
7. IRR (S5.3) Calculate the IRR (or IRRS) for the following project: Co C₁ +3,500 -3,000 For what range of discount rates does the project have a positive NPV? +4,000 C3 -4,000
Project Analysis. Assume that you are evaluating the following three mutually exclusive projects: A. Complete the following analyses. (For the last two lines, Terminal Value, please write in the dollar amount of the terminal value.) B. Compare and explain the conflicting rankings of the NPVs and TRRs versus the IRRs. C. Using different discount rates, is it possible to get different rankings within the NPV calculation? Why or why not? D. If 10 percent is the required return, which project is preferred? E. Which is the fairer representation of these two projects, TRR or IRR? Why?
Q9. Find the NPV, payback period and profit index for both projects, if the discountrate is 11%: Year Project A Project B -200 -200 1 80 100 2 80 100 80 100 80 Which mutually exclu sive project would you select and why?
Construct NPV profiles for Projects A and B. Round your answers to the nearest cent. Do not round your intermediate calculations. Negative value should be indicated by a minus sign. Discount Rate NPV Project A NPV Project B 0% $ $ 5 $ $ 10 $ $ 12 $ $ 15 $ $ 18.1 $ $ 23.01 $ $ The exel sheet is down below for the entirre question! Calculate the crossover rate where the two projects' NPVs are equal. Round your answer to two decimal places. Do not round your intermediate calculations. % What is each project's MIRR at a WACC of 18%? Round your answer to two decimal places. Do not round your intermediate calculations. Project A: % Project Acceptance: WACC 13.00% Accept #N/A WACC 18.00% NPVA $2.66 NPVB $53.19 Accept #N/A NPV Profiles:…
Consider the following two mutually exclusive projects: If the discount rate is 10%, what are the NPV of Project A and the IRR of Project B? Cash Flows ($) Project C0 C1 C2 C3 A -90 +60 +50 0 B -100 0 0 +140 Multiple Choice Then NPV for project A is $5.9 and the IRR for project B is 11.9% Then NPV for project A is $8 and the IRR for project B is 9% Then NPV for project A is $20 and the IRR for project B is 11.9% Then NPV for project A is $5.9 and the IRR for project B is 11.9%
Consider the following two mutually exclusive projects: Year Cash Flow (X) Cash Flow (Y) 0 1 2 3 -$20,000 8,850 9,100 8,800 2 Instruction: Sketch the NPV profiles for X and Y over a range of discount rates from 0% to 25%. What is the crossover rate for these two projects (when both projects have the same NPV)? Show your steps. -$20,000 10,100 7,800 8,700 A▾ B I = 18 1
Answer this question as it is pertaining to two MUTUALLY EXCLUSIVE projects on the following figure. At what discount rate will you be indifferent to these two projects under the NPV rule? Group of answer choices 0% 8% 11% 14%
3) could you use the Figure below that shows the net present value profile of two projects Y and W to answer the following questions: What is the internal rate of return on project Y? Determine the “approximate” discount rate at which you would be indifferent between the two projects Find the “approximate” net present value of project W when the discount rate is 4%.
A2. (PaybackandNPV)Threeprojectshavethecashflowsgivenhere.Thecostofcapitalis10%. a. Calculate the paybacks for all three projects. Rank the projects from best to worst based on their paybacks. Calculate the NPVs for all three projects. Rank the projects from best to worst based on their NPVs c. Why are these two sets of rankings different? YEAR 0 1 2 3 4 5Project 1 −10 4 3 2 1 5 Project 2 −10 1 2 3 4 5 Project 3 −10 4 3 2 1 10
PRINTED NAME _____________________________________________ Project X Project Y PB (payback) DPB (Discounted Payback) NPV $ PI IRR% MIRR% EAA (NUS) $ CROSSOVER RATE % NPV $ (using crossover rate) If the projects are INDEPENDENT, which would you choose? WHY? _____________________________________________________________ If the projects are MUTUALLY EXCLUSIVE, which would you choose? WHY? _____________________________________________________________ When you would be INDIFFERENT between the projects? WHY? _____________________________________________________________ SIGNATURE _____________________________________________________

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS