Homework Help Question & Answers

Internal rate of return and modified internal rate of return. Quark Industries has three potentia...

Internal rate of return and modified internal rate of return. Quark Industries has three potential projects, all with an init

Need help solving all parts thanks. Please show how answer was found.

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 fow of each project, what are the IRRs and MIRRs of the three projects for Quark Industries? M Cash Flow Year 1 Year 2 Year 3 Year 4 Year 5 Discount rate $600,000 $800,000 $800,000 $600,000 $600,000 8% Project N 700,000 $700,000 $700,000 $700,000 $700,000 12% Project O $1,200,000 $1,000,000 SB00,000 S600,000 $400,00 18%
0 0
Next > < Previous
ReportAnswer #1

IRR:

The interest rate which makes the net present worth of the project 0.

It can be calculated using IRR function in excel using the cash flows provided. Assume the Investment as a cash flow in Year 0 with a negative sign as the money goes out of your hand. In excel use syntax IRR (Values) where values signify the range of cash flow

Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Discount rate Project M|Project N Project O -2200000-2200000-2200000 600000 700000

MIRR:

MIRR measures the return on a project and compares it with other potential project

It is calculated using MIRR function in excel where the syntax is MIRR (Values, finance rate, reinvest rate). Here the finance rate and reinvest rate refers to the discount rates of the project

Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Discount rate Project M|Project N Project O -2200000-2200000-2200000 600000 700000

Know the answer?
Add Answer of:
Internal rate of return and modified internal rate of return. Quark Industries has three potentia...
Your Answer: Your Name: What's your source?
Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Internal rate of return and modified internal rate of return. Quark Industries has three potential​ projects, all with a...

    Internal rate of return and modified internal rate of return. Quark Industries has three potential​ projects, all with an initial cost of ​$2,300,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​ M? Project N $800,000 Project M Project O Cash Flow Year 1 $600,000 $1,200,000 $1,000,000 Year 2 $600,000 $800,000 $600,000 $800,000 $800,000...

  • :, what are the IRRs Internal rate of return and modified internal rate of return. Quark...

    :, what are the IRRs Internal rate of return and modified internal rate of return. Quark Industries has three potential projects, all with an initial cost of $1,800,000. Given the discount rate and the future cash flow of each project in the following table, 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...

  • Internal rate of return and modified internal rate of return. Lepton Industries has three potential​ projects, all with...

    Internal rate of return and modified internal rate of return. Lepton Industries has three potential​ projects, all with an initial cost of ​$1,700,000. Given the discount rate and the future cash flows of each​ project, what are the IRRs and MIRRs of the three projects for Lepton​ Industries?   Cash Flow Project Q Project R Project S   Year 1 ​ $400,000 ​$600,000 ​$900,000   Year 2 ​$400,000 ​$600,000 ​$700,000   Year 3 ​$400,000 ​$600,000 ​$500,000   Year 4 ​$400,000 ​$600,000 ​$300,000   Year 5 ​$400,000...

  • 5. Quark Industries has four potential projects, all with an initial cost of $2,000,000. The capital budget for the...

    5. Quark Industries has four potential projects, all with an initial cost of $2,000,000. The capital budget for the year will allow Quark Industries to accept only one of the four projects. Given the discount rates and the future cash flows of each project, determine which project Quark should accept Cash Flow Year 1 Year 2 Year 3 Project M $500,000 $500,000 $500,000 $500,000 $500,000 6% Project N $600,000 $600,000 $600,000 $600,000 $600,000 9% Project $1,000,000 $ 800,000 $ 600,000...

  • Dropdown options first 2 blanks: (internal rate of return IRR, required rate of return, modified internal...

    Dropdown options first 2 blanks: (internal rate of return IRR, required rate of return, modified internal rate of return MIRR) Dropdown options 3rd blank: (NPV method, IRR method) If projects are mutually exclusive, only one project can be chosen. The internal rate of return (IRR) and the net present value (NPV) methods will not always choose the same project. If the crossover rate on the NPV profile is below the horizontal axis, the methods will agree. always Projects Y and...

  • . Modified internal rate of return (MIRR) The IRR evaluation method assumes that cash flows from...

    . Modified internal rate of return (MIRR) The IRR evaluation method assumes that cash flows from the project are reinvested at the same rate equal to the IRR. However, in reality the reinvested cash flows may not necessarily generate a return equal to the IRR. Thus, the modified IRR approach makes a more reasonable assumption other than the project’s IRR. Consider the following situation: Grey Fox Aviation Company is analyzing a project that requires an initial investment of $600,000. The...

  • 4. Modified internal rate of return (MIRR) The IRR evaluation method assumes that cash flows from...

    4. Modified internal rate of return (MIRR) The IRR evaluation method assumes that cash flows from the project are reinvested at the same rate equal to the IRR. However, in reality the reinvested cash flows may not necessarily generate a return equal to the IRR. Thus, the modified IRR approach makes a more reasonable assumption other than the project's IRR. Consider the following situation: Grey Fox Aviation Company is analyzing a project that requires an initial investment of $2,500,000. The...

  • 4. Modified internal rate of return (MIRR) The IRR evaluation method assumes that cash flows from...

    4. Modified internal rate of return (MIRR) The IRR evaluation method assumes that cash flows from the project are reinvested at the same rate equal to the IRR. However, in reality the reinvested cash flows may not necessarily generate a return equal to the IRR. Thus, the modified IRR approach makes a more reasonable assumption other than the project’s IRR. Consider the following situation: Grey Fox Aviation Company is analyzing a project that requires an initial investment of $2,500,000. The...

  • 4. Modified internal rate of return (MIRR) The IRR evaluation method assumes that cash flows from...

    4. Modified internal rate of return (MIRR) The IRR evaluation method assumes that cash flows from the project are reinvested at the same rate equal to the IRR. However, in reality the reinvested cash flows may not necessarily generate a return equal to the IRR. Thus, the modified IRR approach makes a more reasonable assumption other than the project’s IRR. Consider the following situation: Grey Fox Aviation Company is analyzing a project that requires an initial investment of $600,000. The...

  • Tall Trees, Inc. is using the modified internal rate of return (MIRR) when evaluating projects. The...

    Tall Trees, Inc. is using the modified internal rate of return (MIRR) when evaluating projects. The company is able to reinvest cash flows received from the project at an annual rate of 11.30 percent. What is the MIRR of a project if the initial costs are $1,397,200 and the project life is estimated as 9 years? The project will produce the same after-tax cash inflows of 594,400 per year at the end of the year.

Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
Share Your Knowledge

Post an Article
Post an Answer
Post a Question with Answer

Self-promotion: Authors have the chance of a link back to their own personal blogs or social media profile pages.