Internal rate of return and modified internal rate of return. Quark Industries has three potential projects, all with an initial cost of $2,100,000. Given the discount rate and the future cash flow of each project in the following table, E, what arethe IRRS and MIRRS of the three projects for Quark Industries?What is the IRR for project M?% (Round to two decimal places.)What is the MIRR for project M?Data table% (Round to two decimal places.)What is the IRR for project N?(Click on the following icon g in order to copy its contents into a spreadsheet.)% (Round to two decimal places.)Cash FlowProject MProject NProject OWhat is the MIRR for project N?Year 1$500,000$700,000$1,100,000Year 2$500,000$700,000$900,000% (Round to two decimal places.)Year 3$500,000$700,000$700,000Year 4$500,000$700,000$500,000What is the IRR for project O?Year 5$500,000$700,000$300,000% (Round to two decimal places.)Discount rate8%11%16%What is the MIRR for project O?% (Round to two decimal places.)PrintDone

The given problem can be solved using IRR and MIRR function in excel.

Answered: Internal rate of return and modified…

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

ternal rate of return and modified internal rate of return. Quark Industries has three potential projects, all with an initial cost of $1,900,000. Given the discount rate and the future cash flow of each project in what are the IRRS and MIRRS of the three projects for Quark Industries? Vhat is the IRR for project M? %3D Data Table % (Round to two decimal places.) (Click on the following icon in order to copy its contents into a spreadsheet.) Projoct O $1,000,000 S800,000 $600,000 $400,000 $200 000 15% Project M $500,000 $500.000 Cash Flow Project N Year 1 $600,000 $600.000 S600.000 S600.000 $600.000 11% Year 2 Year 3 $500.000 $500,000 S500,000 Year 4 Year 5 Discount rate 7%
Internal rate of return and modified internal rate of return. Quark Industries has three potential projects, all with an initial cost of $2,500,000. Given the discount rate and the future cash flow of each project in the following table, BB, what are the IRRS and MIRRS of the three projects for Quark Industries? What is the IRR for project M? % (Round to two decimal places.) Data table (Click on the following icon in order to copy its contents into a spreadsheet.) Cash Flow Project M Project N Project O Year 1 $600,000 $800,000 $1,300,000 Year 2 $600,000 $800,000 $1,100,000 Year 3 $600,000 $800,000 $900,000 Year 4 $600,000 $800,000 $700,000 Year 5 $600,000 $800,000 $500,000 Discount rate 9% 12% 17% Print Done - X
Profitability index. Given the discount rate and the future cash flow of each project listed in the following table, use the PI to determine which projects the company should accept. What is the PI of project B?(Round to two decimal places.) Cash Flow Project A Project B Year 0 −$1,800,000 −$2,400,000 Year 1 $500,000 $1,200,000 Year 2 $600,000 $1,100,000 Year 3 $700,000 $1,000,000 Year 4 $800,000 $900,000 Year 5 $900,000 $800,000 Discount rate 5% 17%
Internal rate of return and modified Internal rate of return. Quark Industries has three potential projects, all with an initial cost of $2,200,000. Given the discount rate and the future cash flow of each project in the following table, what are the IRRs and MIRRs of the three projects for Quark Industries? What is the IRR for project M7 % (Round to two decimal places.) GITE
Profitability index. Given the discount rate and the future cash flow of each project listed in the following table, , use the PI to determine which projects the company should accept. ..... What is the Pl of project A? (Round to two decimal places.)
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
Internal rate of return and modified internal rate of return For the project shown in the following table,, calculate the internal rate of return (IRR) and modified internal rate of return (MIRR). If the cost of capital is 12.13%, indicate whether the project is acceptable according to IRR and MIRR. The project's IRR is %. (Round to two decimal places.) Data table (Click on the icon here in order to copy the contents of the data table below into a spreadsheet.) Initial investment (CF) Year (t) 1 2 3 4 5 Print $70,000 Cash inflows (CFt) $15,000 $25,000 $25,000 $15,000 $10,000 Done X
Internal Rate of Return. Lepton Industries has three potential projects, all with an initial cost of $2,100,000. Given the discount rates and the future cash flows of each project, what are the IRRs of the three projects for Lepton Industries? Cash Flow Year 1 Year 2 Year 3 Year 4 Year 5 Project Q $500,000 $500,000 $500,000 $500,000 $500,000 What is the IRR for Project Q? % (Round to two decimal places.) What is the IRR for Project R? % (Round to two decimal places.) What is the IRR for Project S? % (Round to two decimal places.) Project R $700,000 $700,000 $700,000 $700,000 $700,000 Project S $1,100,000 $900,000 $700,000 $500,000 $300,000 GTD
A project has the following cash flows set out below. What is the profitability index of this project if the relevant discount rate is 2 percent? Enter your final answer to two decimal places. Year Cash flow 0 -1,745 1 537 2 2,066 3 3,912
不 Data table 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.6% 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 one decimal place.) (Click on the following icon in order to copy its contents into a spreadsheet.) Project A Year 0 - $49 Year 1 $24 B - $99 $18 Year 2 $21 $40 Print Done Year 3 Year 4 $19 $14 $50 $61
K Internal rate of return and modified internal rate of return For the project shown in the following table,, calculate the internal rate of return (IRR) and modified internal rate of return (MIRR). If the cost of capital is 13.04%, indicate whether the project is acceptable according to IRR and MIRR. The project's IRR is %. (Round to two decimal places.) Data table (Click on the icon here in order to copy the contents of the data table below into a spreadsheet.) Initial investment (CFO) Year (t) $80,000 Cash inflows (CF₂) 1 $10,000 2345 $25,000 $10,000 $15,000 $45,000 Print Done -
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

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