Question

How do I get the Modified IRR (MIRR)? Please complete this worksheet.1 2 B DE F H EXAMPLE IRR DISCOUNT RATE CASH FLOWS IRR NOW YEAR O 1 2 3 4 5 CF -100000 10000 12,500 14,000 18,550 181250 pv fa

0 0
Add a comment Improve this question Transcribed image text
Answer #1

MIRR can be found using the excel function MIRR

Enter the below formula in cell J13

=MIRR(B16:G16,I13,I13)

Add a comment
Know the answer?
Add Answer to:
How do I get the Modified IRR (MIRR)? Please complete this worksheet. 1 2 B DE...
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
  • How do I get the Internal Rate of Return (IRR)? Please complete this worksheet. E G...

    How do I get the Internal Rate of Return (IRR)? Please complete this worksheet. E G H 1 - 2 DISCOUNT RATE IRR 5 EXAMPLE 1 CASH FLOWS NOW I YEAR O CF -800 50 pv factor 2 100 3 300 4 305 5 320 6 7 8 pvcf NPV 10 11 12 13 EXAMPLE 2 DISCOUNT RATE CASH FLOWS IRR 14 NOW YEAR O -100000 1 10000 3 14,000 12,500 18,550 181250 15 16 17 18 CF pv factor...

  • 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: 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: Grey Fox Aviation Company is analyzing a project that requires an initial investment of $550,000. The...

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

    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 $400,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: 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: 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 flows may not necessarily generate a retun equal to the IRR. Thus, the modified IRR approach makes a more reasonable assumption other than the project's IRR Consider the following situation: Celestial Crane Cosmetics is analyzing a project that requires an initial investment of $600,000. The project's...

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

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
ADVERTISEMENT