None Data table (Click on the following icon in order to copyits contents into a spreadsheet.) \table[[Project, Year 0,Year 1, Year 2, Year 3, Year 4], [A, -$50, $25, $18, $20, $17You are choosing between two projects. The cash flows for the projects are given in the following table ($ million):a. What are the IRRS of the two projects?b. If your discount rate is 5.1%, what are the NPVs of the two projects?c. Why do IRR and NPV rank the two projects differently?a. What are the IRRS of the two projects?The IRR for project A is %. (Round to two decimal places.)

The above answer can be explained as under - Here, the IRR is being calculated using the excel…

Answered: Data table (Click on the following icon…

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

Determine the future value of the following single amounts. Note: Use tables, Excel, or a financial calculator. Round your final answers to nearest whole dollar amount. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) 1. 2. 3 4. Invested Amount 15,000 20,000 30,000 50,000 $ $ $ U $ i = 6% 8% 12% 4% n = 12 10 20 12 Future Value
6. You are choosing between two projects. The cash flows for the projects are given in the following Data table ($ million): Project Year 0 Year 1 Year 2 Year 3 Year 4 A −$48 $27 $19 $22 $15 B −$100 $22 $39 $48 $62 The IRR for project A is __________________________%. (Round to one decimal place.) The IRR for project B is____________________________%.(Round to one decimal place.) If your discount rate is 5.4%, the NPV for project A is $_______________million.(Round to two decimal places.) If your discount rate is 5.4%, the NPV for project B is $______________ million.(Round to two decimal places.) NPV and IRR rank the two projects differently because they are measuring different things. ___________________is measuring value creation, while ___________________is measuring return on investment. Because returns do not scale with different levels of investment, the two measures may give different rankings when…
You are choosing between two projects. The cash flows for the projects are given in the following table ($ million): a. What are the IRRs of the two projects? b. If your discount rate is 4.7%, what are the NPVs of the two projects? c. Why do IRR and NPV rank the two projects differently? Data table (Click on the following icon in order to copy its contents into a spreadsheet.) Year 0 Project A Year 1 - -$51 $27 B - $101 $22 Year 2 $21 $42 Year 3 $20 Year 4 $13 $51 $59 - ☑
Solve the below problem. (DONOT use CHATGPT else will report to cheggs) You are the CFO at Infosys Itd which is considering the following two mutually exclusive projects. All amounts are in INT Year Cashflow (Project A) Cashflow (Project B) -50,00,000 -42,00,000 0 1 21,00,000 18,00,000 2 18,00,000 8,00,000 3 15,00,000 6,00,000 4 10,00,000 13,00,000 5 7,50,000 21,00,000 Whichever project we choose, we require a 16 percent return on our investment. a. If we apply the payback criterion, which investment is to be chosen? b. If we apply the discounted payback criterion, which investment is to be chosen? why? c. If we apply the NPV criterion, which investment will be chosen? why? d. Based on the answers in (a) through (c) which project will be finally chosen? why?
Calculate the NPV of each project. (Use the NPV function in Excel to solve this problem.) Which of the two projects would you fund if the decision is based only on financial information and you could only choose one of the projects? Omega Alpha Year Inflow YO 0 Y1 0 Outflow 207,000 110,000 Netflow Year Inflow Outflow Netflow (207,000) YO 0 217,000 (217,000) (110,000) Y1 7,000 190,000 (183,000) Y2 150,000 0 150,000 Y2 150,000 0 150,000 Y3 220,000 30,000 190,000 Y3 220,000 30,000 190,000 Y4 161,000 0 161,000 Y4 191,000 0 191,000 Y5 205,000 48,000 157,000 Y5 205,000 38,000 167,000 Y6 197,000 0 197,000 Y6 197,000 0 197,000 Y7 100,000 30,000 70,000 Y7 100,000 30,000 70,000 Total 1,033,000 425,000 608,000 Total 1,070,000 505,000 565,000 The NPV for Omega is The NPV for Alpha is The better project is
You have 3 projects with the following cash flows: (Click on the following icon in order to copy its contents into a spreadsheet.) Year 1 4 Project 1 Project 2 Project 3 - $151 $21 $40 $59 $81 - 827 7,008 - 6,502 21 40 59 80 - 243 a. For which of these projects is the IRR rule reliable? b. Estimate the IRR for each project (to the nearest 1%). c. What is the NPV of each project if the cost of capital is 5%? 20%? 50%? a. For which of these projects is the IRR rule reliable? (Select from the drop-down menus.) The IRR rule is reliable for V. Unless all of the cash flows of the project precede the ones, the IRR rule may give the wrong answer and should not be used. Furthermore, there may be multiple IRRS or the IRR may not exist. b. Estimate the IRR for each project (to the nearest 1%). The IRR for project 1 is %. (Round to the nearest integer.) The IRR for project 2 is %. (Round to the nearest integer.) The IRR for project 3 is %. (Round to the nearest integer.) c. What is the NPV of each…
A*) You are hired as financial manager in Abis Investment Co., you made cash flow projection for two different projects. You are asked to estimate the feasibility of the projects by using the following investment criteria: NPV, IRR, MIRR and BCR. They are mutually exclusive. Show all your calculation. The details of that projects are given below: Year 0 1 2 3 4 5 Project A -1,000 1,200 4600 1,800 -8,000 5,000 Project B -2,000 1,000 3600 800 8,000 500 Discount rates 12% 13% 12% 14% 15% 11%
You are given three investment alternatives to analyze. The cash flows from these three investments are as follows: Investment End of Year A B C 1 $ 11,000 $ 16,000 2 11,000 3 11,000 4 11,000 5 11,000 $ 11,000 6 11,000 48,000 7 11,000 8 11,000 9 11,000 10 11,000 16,000 (Click on the icon in order to copy its contents into a spreadsheet.) Assuming an annual discount rate of 15 percent, find the present value of each investment. Question content area bottom Part 1 a. What is the present value of investment A at an annual discount rate of 15 percent? $ enter your response here (Round to the nearest cent.)
Consider the cash flow of the two projects depicted in Table 3. If WiseGuy Inc. uses payback period rule to choose projects, which of the projects (Project A or Project B) will rank highest? TABLE 3 Project A Project B Time 0. -11,000. -10,000 Time 1. 3,000. 4,000 Time 2. 8,000. 3,000 Time 3. 3,000. 10,000 A) Project A B) Project B C) Project A and Project B have the same ranking. D) It cannot calculate a payback period without a discount rate. 7 Consider the cash flow of the two projects depicted in Table 3. If WiseGuy Inc. uses IRR rule to choose projects, which of the projects (Project A or Project B) will rank highest? A) Project A B) Project B C) Project A and Project B have the same ranking. D) It cannot calculate a payback period without a discount rate.
Profitability index. Given the discount rate and the future cash flow of each project listed in the following table, . use the Pl to determine which projects the company should accept. What is the Pl of project A? i Data Table (Round to two decimal places.) (Click on the following icon o in order to copy its contents into a spreadsheet.) Cash Flow Project A -%241,900,000 $150,000 $350,000 Project B Year 0 $2,300,000 $1,150,000 $950 000 $750,000 $550,000 Year 1 Year 2 Year 3 $550,000 Year 4 $750,000 $950,000 4% Year 5 $350.000 Discount rate 18% Print Done
Consider two mutually exclusive projects, A and B, whose costs and cash flows are shown in the following table: Year Project A Project B 1 $(15,000) $(22,840) 2 9,000 8,000 3 8,000 8,000 4 2,500 8,000 5 3,000 8,000 Calculate the cross over rate. Please use equations not just excel
NPV profile of a project. Given the following cash flow of Project L-2, draw the NPV profile. Hint. Be sure to use a discount rate of zero for one intercept (y-axis) and solve for the IRR for the other intercept ( x-axis). (Click on the following icon ◻ in order to copy its contents into a spreadsheet.) Year 0=-$300,000 Year 1=$50,000 Year 2=$79,000 Year 3=$118,000 Year 4=$130,000 What is the NPV of Project L-2 where zero is the discount rate? $ (Round to the nearest dollar.) What is the IRR of Project L-2? % (Round to two decimal places.) Which of the graphs below best fits the NPV profile of the project? Click on the magnifying glass icon to see an enlarged version of each graph. (Select the best response.) B. D.

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