Question
In: Finance
Internal rate of return and modified internal rate of return. Lepton Industries has three potential projects,...
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.)
Solutions
Expert Solution
| 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% | ||||||
jeff jeffy answered 1 year agoRelated Solutions
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 $1,600,000.
Given the discount rate and the future cash flow of each project
in the following table,
Cash Flow Project M Project N Project O
Year 1 $400,000 $500,000 $900,000
Year 2 $400,000 $500,000
$700,000
Year 3 $400,000 $500,000 $500,000
Year 4 $400,000 $500,000 $300,000
Year 5 $400,000 $500,000 $100,000
Discount rate 9% 14% 17%
the difference between the internal rate of return method and the modified internal
the difference between the internal rate of return
method and the modified internal
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 12.04
percent. What is the MIRR of a project if the initial costs are
$1,680,000 and the project life is estimated as 7 years? The
project will produce the same after-tax cash inflows of 474,700 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 13.42
percent. What is the MIRR of a project if the initial costs are
$1,476,100 and the project life is estimated at 9 years? The
project will produce the same after-tax cash inflows of $627,700
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 12.40
percent. What is the MIRR of a project if the initial costs are
$1,386,400 and the project life is estimated as 9 years? The
project will produce the same after-tax cash inflows of 476,200 per
year at the end of the year.
Which of the following statements is not correct? a. The modified internal rate of return is...
Which of the following statements is
not correct?
a. The modified internal rate of return is similar to the
realized compound yield method used with bonds.
b. The modified internal rate of return attempts to correct the
reinvestment rate assumption implicit with the internal rate of
return method.
c. The modified internal rate of return takes the outflows back
to the present time and the inflows to the terminus of the
project.
d. The modified internal rate of return solves...
Describe and explain the significance of each of the following: payback period, internal rate of return (IRR), modified internal rate of return (MIRR)
Describe and explain the significance of each of the following: payback period, internal rate of return (IRR), modified internal rate of return (MIRR), net present value (NPV), and profitability index (PI). Explain. Provide examples for better clarity.
Discuss the notions of conventional and nonconventional cash flows in capital budgeting. Which investment evaluation criteria would you use for unconventional cash flows and why? Provide a fictitious unconventional cash flow example and apply the payback period, NPV, IRR, MIRR, and PI...
Describe the modified internal rate of return (MIRR) as a method for deciding the desirability of...
Describe the modified internal rate of return (MIRR) as a method
for deciding the desirability of a capital budgeting project. What
are MIRR's strengths and weaknesses?
Discuss the differences between return on investment captial method (RIC) and modified internal rate of return...
Discuss the differences between return on investment captial
method (RIC) and modified internal rate of return (MIRR) method? In
addition, list other methods for project analyze with various rate
options for economic analysis studies.
A company has a required rate of return of 15% for five potential projects. The company...
A company has a required rate of return of 15% for five
potential projects. The company has a maximum of $500,000 available
for investment and cannot raise any capital. Details about the five
projects are as follows:
Project
Initial Outlay
Net Present Value at 15%
Internal Rate
of Return
1
$500,000
$125,000
23%
2
250,000
75,000
17%
3
150,000
25,000
35%
4
100,000
50,000
25%
5
150,000
50,000
25%
The company should choose which of the following
projects?
a. Project...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- You must evaluate a proposal to buy a new milling machine. The base price is $175,000,...
- “Triangle Guessing” game in Python The program accepts the lengths of three (3) sides of a...
- THIS PROGRAM HAS TO BE WRITTEN IN C Single function to perform the parity computation on...
- Consider a buffer system consisting of Benzoic acid (pKa = 4.20) and sodium benzoate, a) Would...
- Decision Variables S T Minimize 1.8S + 2.20T Subject to: Potassium 5S + 8T >= 200...
- A neurologist needs to counsel a stroke victim and her husband about possible outcomes, treatment options,...
- Case Study: Personal Beliefs in the Workplace Don Shakow was a prominent professional who worked in...
ADVERTISEMENT