Question

Compute the Modified IRR (MIRR) of the following cash flow schedule using the =IRR( ) Excel...

Compute the Modified IRR (MIRR) of the following cash flow schedule using the =IRR( ) Excel function
Why is your answer different than in Q4? What are you assuming about the company's project?
The discount rate is 11.9%
Time 0 1 2 3 4 5 6
CFs -200 -100 0 120 120 120 100
0 0
Add a comment Improve this question Transcribed image text
Answer #1

A B 1 Cash flows 2 YEAR -$200.00 -$100.00 $0.00 0 4 1 5 2 $120.00 6 $120.00 7 $120.00 8 5 $100.00 9 6 11.13% 10 IRR IRR(B3:B9

Add a comment
Know the answer?
Add Answer to:
Compute the Modified IRR (MIRR) of the following cash flow schedule using the =IRR( ) Excel...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

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
  • 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: Blue Llama Mining Company is analyzing a project that requires an initial investment of $2,750,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: Cute Camel Woodcraft Company is analyzing a project that requires an initial investment of $3,225,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: Green Caterpillar Garden Supplies Inc. is analyzing a project that requires an initial investment of $3,000,000....

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

    8. 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 $3,225,000....

  • 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 fiows may not necessarily generate a return equal to the IRR. Thus, the modified IRR approach makes a more reasonable assumptian other than the project's IRR. Consider the following situation: Grey FOX Avlabon Company is analyzing expected cash flaws are: project that requires an initial investment...

  • 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 $550,000. The...

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

    4. Modified internal rate of return (MIRR) Aa Aa 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...

  • 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....

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
Active Questions
ADVERTISEMENT