Spreadsheet Link What is the IRR of the following project?Cash FlowYear 0 32.0009,0001.2 10,00015,2007,8004.1) 10.8%2) 11.2%• 3) 11.7%4) 12.0%5) 12.3%234

Internal rate of return(IRR) is the rate where the net present value is zero.

Answered: Spreadsheet Link What is the IRR of 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

Details WACC 0 SGWN-O 1 2 3 4 5 6 7.80% Project A Project B -1225 395 402 423 432 489 512 -2146 592.5 603 634.5 648 733.5 768 1. Construct NPV profile table by using cashflows from Project A and B above. 2. Draw NPV profile 3. Compute crossover rate To receive EC your work has to be done in Excel.
Year Cashflow Rat2 @ 12% 0 -15600 1 6800 2 8000 3 7600 4 6400 5 -3800 ========================= what is the discounting Approach? What is the reinvesting Approach? What is the Combination Approach? Please as detailed as possible with calculations
Project X cash flows is given on the timeline below 0. 2. 3 4. Project X -$10,000 $6.500 $3,000 $3.000 $1.000 Calculate Project X NPV if WACC-9% Round your answer to the nearest hundredth, have at least two decimal digits and write it in the Answer field. Would you accept or reject the project (write in the textbox below the answer field)?
What is the project's MIRR? r = 10.00% 0 Year Cash flows O a. 22.51% O b. 11.75% O c. 17.21% O d. 14.81% O e. 15.65% -$875 1 $300 2 $320 3 $340 $360
The following are the cash flows of two projects: Project B Year Project A 0 $ (235) $ (235) 115 135 115 135 115 135 115 1234O 1 2 3 4 What are the internal rates of return on projects A and B? Note: Enter your answers as a percent rounded to 2 decimal places. Project A B IRR % %
me IRR-Mutually exclusive projects Bell Manufacturing is attempting to choose the better of two mutually exclusive projects for expanding the firm's warehouse capacity. The relevant cash flows for the projects are shown in the following table: . The firm's cost of capital is 15%. Options a. Calculate the IRR for each of the projects. Assess the acceptability of each project on the basis of the IRRS. b. Which project is preferred? a. The internal rate of return (IRR) of project X is %. (Round to two decimal places.) Is project X acceptable on the basis of IRR? (Select the best answer below.) No O Yes The internal rate of return (IRR) of project Y is %. (Round to two decimal places.) Is project Y acceptable on the basis of IRR? (Select the best answer below.) O Yes Click to select your answer(s). O Type here to search
Consider the following two projects: Projec Year 0 Year 1 Year 2 Year 3 Year 4 Cash Cash Cash Cash Cash Discount Flow Flow Flow Flow Flow Rate A -100 40 50 60 N/A 0.11 -73 30 30 30 30 0.11 The net present value (NPV) of project As closest to Select one: a. 51.2 b. 25.6 O c. 20.5 Od. 22.5
The following are a project's cash flows. What is the projects year - 110155450 cash flows - 9.70% 5. 14.660%. 8.64% 10.78% . =. 16.94% IBR? $450 $40 3 8490
11:52 Investment Appraisal (Year 2 Column 2... 35% 4. An investment has the following cash flows. What is the ARR? Year 0 -90,000 Year 1 45,000 10,000 Year 2 Year 3 30,000 30,000 Year 4 6% 7% 9% 5. Which of the following investments would you choose based on payback? Project 3 years 6 months 5 years 10 months A В ... Activity Chat Teams Assignments More
Consider projects A and B: Cash Flows (dollars) Project A Co -30,500 C1 C2 21,400 21,400 NPV at 11% +$6,148.00 B -50,500 33,500 33,500 + 6,869.53 a. Calculate IRRS for A and B. (Do not round intermediate calculations. Round your answers to 2 decimal places.) Project A B IRR % % b. Which project does the IRR rule suggest is best? O Project A ○ Project B c. Which project is really best? ○ Project A O Project B k
ch A project with an initial investment of $88000 and a profitability index of 1.239 also has an internal rate of return of 12%. The present value of net cash flows is O $71025. O $98560. O $88000. O $109032. Save for Later O Et V B 21 E 7 Attempts: 0 of 1 used Submit Answer F12
Q4. Your project has following Cashflows: Time Cashflow 0 B).19.14% C).21.08% D).21.68% 1 -25,000.00 5,000.00 35,000.00 The reinvestment rate is 10% and refinancing rate is 15%. What is MIRR?.. A).19.73% 2 10,000.00 3 - 5,000.00 4

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

Spreadsheet Link What is the IRR of the following project? Cash Flow Year 0 32.000 9,000 1. 2 10,000 15,200 7,800 4. 1) 10.8% 2) 11.2% • 3) 11.7% 4) 12.0% 5) 12.3% 234