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 |
$600,000 |
$100,000 |
||||
|
Discount rate |
9% |
14% |
18% |
||||
What is the IRR for project Q?_________%(Round to two decimal places.)
What is the MIRR for project Q?________%(Round to two decimal places.)
What is the IRR for project R?________%(Round to two decimal places.)
What is the MIRR for project R?________%(Round to two decimal places.)
What is the IRR for project S?_________%(Round to two decimal places.)
What is the MIRR for project S?________% (Round to two decimal places.)
Homework Answers
| Answer 1 | ||||||
| Calculation of IRR of project Q | ||||||
| Year | Cash flow | |||||
| 0 | -$1,700,000.00 | |||||
| 1 | $400,000.00 | |||||
| 2 | $400,000.00 | |||||
| 3 | $400,000.00 | |||||
| 4 | $400,000.00 | |||||
| 5 | $400,000.00 | |||||
| IRR of Project Q = | =IRR(B5:B10) | |||||
| IRR of Project Q = | 5.67% | |||||
| Calculation of Modified Internal rate of return (MIRR) of Project Q | ||||||
| MIRR = (Future value of cash inflows / Present value of cash outflows)^(1/n) - 1 | ||||||
| Future value of cash inflows | ||||||
| Year | Cash inflows | Future value factor @ 9% | Future value | |||
| 0 | $0.00 | 1.538623955 | $0.00 | |||
| 1 | $400,000.00 | 1.41158161 | $564,632.64 | |||
| 2 | $400,000.00 | 1.295029 | $518,011.60 | |||
| 3 | $400,000.00 | 1.1881 | $475,240.00 | |||
| 4 | $400,000.00 | 1.09 | $436,000.00 | |||
| 5 | $400,000.00 | 1 | $400,000.00 | |||
| Future value of cash inflows | $2,393,884.24 | |||||
| MIRR = ($2393884.24 / $1700000)^(1/5) - 1 | ||||||
| MIRR = 1.0709 - 1 | ||||||
| MIRR = 0.0709 | ||||||
| Modified Internal rate of return (MIRR) of project Q = 7.09% | ||||||
| Answer 2 | ||||||
| Calculation of IRR of project R | ||||||
| Year | Cash flow | |||||
| 0 | -$1,700,000.00 | |||||
| 1 | $600,000.00 | |||||
| 2 | $600,000.00 | |||||
| 3 | $600,000.00 | |||||
| 4 | $600,000.00 | |||||
| 5 | $600,000.00 | |||||
| IRR of Project R = | =IRR(B35:B40) | |||||
| IRR of Project R = | 22.50% | |||||
| Calculation of Modified Internal rate of return (MIRR) of Project R | ||||||
| MIRR = (Future value of cash inflows / Present value of cash outflows)^(1/n) - 1 | ||||||
| Future value of cash inflows | ||||||
| Year | Cash inflows | Future value factor @ 14% | Future value | |||
| 0 | $0.00 | 1.925414582 | $0.00 | |||
| 1 | $600,000.00 | 1.68896016 | $1,013,376.10 | |||
| 2 | $600,000.00 | 1.481544 | $888,926.40 | |||
| 3 | $600,000.00 | 1.2996 | $779,760.00 | |||
| 4 | $600,000.00 | 1.14 | $684,000.00 | |||
| 5 | $600,000.00 | 1 | $600,000.00 | |||
| Future value of cash inflows | $3,966,062.50 | |||||
| MIRR = ($3966062.50 / $1700000)^(1/5) - 1 | ||||||
| MIRR = 1.1846 - 1 | ||||||
| MIRR = 0.1846 | ||||||
| Modified Internal rate of return (MIRR) of Project R = 18.46% | ||||||
| Answer 3 | ||||||
| Calculation of IRR of project S | ||||||
| Year | Cash flow | |||||
| 0 | -$1,700,000.00 | |||||
| 1 | $900,000.00 | |||||
| 2 | $700,000.00 | |||||
| 3 | $500,000.00 | |||||
| 4 | $300,000.00 | |||||
| 5 | $100,000.00 | |||||
| IRR of Project S = | =IRR(B65:B70) | |||||
| IRR of Project S = | 20.37% | |||||
| Calculation of Modified Internal rate of return (MIRR) of Project S | ||||||
| MIRR = (Future value of cash inflows / Present value of cash outflows)^(1/n) - 1 | ||||||
| Future value of cash inflows | ||||||
| Year | Cash inflows | Future value factor @ 18% | Future value | |||
| 0 | $0.00 | 2.287757757 | $0.00 | |||
| 1 | $900,000.00 | 1.93877776 | $1,744,899.98 | |||
| 2 | $700,000.00 | 1.643032 | $1,150,122.40 | |||
| 3 | $500,000.00 | 1.3924 | $696,200.00 | |||
| 4 | $300,000.00 | 1.18 | $354,000.00 | |||
| 5 | $100,000.00 | 1 | $100,000.00 | |||
| Future value of cash inflows | $4,045,222.38 | |||||
| MIRR = ($4045222.38 / $1700000)^(1/5) - 1 | ||||||
| MIRR = 1.1893 - 1 | ||||||
| MIRR = 0.1893 | ||||||
| Modified Internal rate of return (MIRR) of Project S = 18.93% | ||||||
Add Answer to:
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. 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...
Internal rate of return and modified internal rate of return. Quark Industries has three potentia...
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...
Internal rate of return and modified internal rate of return. Quark Industries has three potential projects,...
Internal rate of return and modified internal rate of return. Quark Industries has three potential projects, all with an initial cost of S1,800,000. Given the discount rate and the future cash flow of each project, what are the IRRs and MIRRs of the three projects for Quark Industries? Year 1 Year 2 Year 3 Year 4 Year 5 Discount rate $500,000 $500,000 $500,000 $500,000 $500,000 7% S600,000 S600,000 S600,000 S600,000 S600,000 13% $1.000,000 $800,000 $600,000 $400,000 $200,000 16%
:, 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...
P9-13 (similar to) Question Help • Internal rate of return and modified internal rate of return....
P9-13 (similar to) Question Help • Internal 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 the following table, , what are the IRRs and MIRRs of the three projects for Quark Industries? What is the IRR for project M? 0 Data Table % (Round to two decimal places.) (Click on the following icon...
All I need help with on this question is the MIRR for all three projects. I...
All I need help with on this question is the MIRR for all three
projects. I have tried both excel and handwriting and can't seem to
get it right, so this is my last attempt. Thank you!
Since the picture seems hard to see: The values for Project M
are 400,000 years 1-5, N is 600,000 years 1-5, and O is 900,000
(Y1), 700,000 (Y2), 500,000 (Y3), 300,000 (Y4), and 100,000 (Y5).
The discount rate for M is 8%, N...
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...
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 14.44 percent. What is the MIRR of a project if the initial costs are $1,413,800 and the project life is estimated as 10 years? The project will produce the same after-tax cash inflows of 642,600 per year at the end of the year. Round the answer to two...
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 9.90 percent. What is the MIRR of a project if the initial costs are $2,125,700 and the project life is estimated as 7 years? The project will produce the same after-tax cash inflows of 504,900 per year at the end of the year. Round the answer to two...
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: Green Caterpillar Garden Supplies Inc. is analyzing a project that requires an initial investment of $2,225,000....
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...
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...
Internal rate of return and modified internal rate of return. Quark Industries has three potential projects, all with an initial cost of S1,800,000. Given the discount rate and the future cash flow of each project, what are the IRRs and MIRRs of the three projects for Quark Industries? Year 1 Year 2 Year 3 Year 4 Year 5 Discount rate $500,000 $500,000 $500,000 $500,000 $500,000 7% S600,000 S600,000 S600,000 S600,000 S600,000 13% $1.000,000 $800,000 $600,000 $400,000 $200,000 16%
:, 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...
P9-13 (similar to) Question Help • Internal 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 the following table, , what are the IRRs and MIRRs of the three projects for Quark Industries? What is the IRR for project M? 0 Data Table % (Round to two decimal places.) (Click on the following icon...
All I need help with on this question is the MIRR for all three
projects. I have tried both excel and handwriting and can't seem to
get it right, so this is my last attempt. Thank you!
Since the picture seems hard to see: The values for Project M
are 400,000 years 1-5, N is 600,000 years 1-5, and O is 900,000
(Y1), 700,000 (Y2), 500,000 (Y3), 300,000 (Y4), and 100,000 (Y5).
The discount rate for M is 8%, N...
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...
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 9.90 percent. What is the MIRR of a project if the initial costs are $2,125,700 and the project life is estimated as 7 years? The project will produce the same after-tax cash inflows of 504,900 per year at the end of the year. Round the answer to two...
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: Green Caterpillar Garden Supplies Inc. is analyzing a project that requires an initial investment of $2,225,000....
Most questions answered within 3 hours.
-
A coach uses a new technique to train gymnasts. Seven
gymnasts were randomly selected and their...
asked 1 hour ago -
While rotating the tires on your car you notice a rock [mass =
0.1 Kg] stuck...
asked 3 hours ago -
Using MARS simulator, write MIPS programs according to
the following scenarios: Receive a positive integer number...
asked 5 hours ago -
An object in front of a concave mirror has a real image that is
11.5 cm...
asked 5 hours ago -
Consider the reaction, C3 H8 + O2 --> CO2 + H2O. How many
moles of O2...
asked 7 hours ago -
You and your opponent both roll a fair die. If you both roll the
same number,...
asked 7 hours ago -
In a study of the accuracy of fast food drive-through orders,
Restaurant A had 257 accurate...
asked 7 hours ago -
Identify and describe in detail the four categories of
institutions that could be included in a...
asked 7 hours ago -
In python
class Customer:
def __init__(self, customer_id, last_name, first_name, phone_number, address):
self._customer_id = int(customer_id)
self._last_name =...
asked 7 hours ago -
What is an example of a limitation in implementing a new
ERP system and how it...
asked 7 hours ago -
In a section of 9.7cm of an artery with a radius of 2.6mm there
is a...
asked 7 hours ago -
the two carboxylic acid groups of aspartic acid have different
acidities with pKa values of 2.1...
asked 7 hours ago