Question
Hi! Please help with this question...I tried plugging these into Excel, but I guess something was missing on my IRR?? We are looking for the
Hi! Please help with this question...I tried plugging these into Excel, but I guess something was missing on my IRR??
We are looking for the IRR and MIRR of M, N, and O! Thanks so much.
Internal rate of return and modified internal rate of
return.
Quark Industries has three potential projects, all with an initial cost of
$1 comma 800 comma 0001,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?
| Cash Flow | Project M | Project N | Project O |
| |||
| Year 1 | $500 comma 000500,000 | $600 comma 000600,000 | $1 comma 000 comma 0001,000,000 | ||||
| Year 2 | $500 comma 000500,000 | $600 comma 000600,000 | $800 comma 000800,000 | ||||
| Year 3 | $500 comma 000500,000 | $600 comma 000600,000 | $600 comma 000600,000 | ||||
| Year 4 | $500 comma 000500,000 | $600 comma 000600,000 | $400 comma 000400,000 | ||||
| Year 5 | $500 comma 000500,000 | $600 comma 000600,000 | $200 comma 000200,000 | ||||
| Discount rate | 77% | 1313% | 1616% | ||||
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Financial Analysis And Modeling Using Excel And VBA
Authors: Chandan Sengupta
2nd Edition
047027560X, 978-0470275603
