Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Anyone that's good at finding the modified internal rate of return (reinvstment approach), please tell me what I did wrong?

Ok, so the rate for the project is 9.5%, and I have to use the reinvestment approach. H ere are the cash flows as follows:

YR 0 = -150,000.00

YR 1 = 65,000.00

YR 2 = 52,500.00

YR 3 = 48,000.00

YR 4 = 45,000.00

YR 5 = -28,000.00

I found the future value of years 1-4 in terms of year 5 and here they are:

YR 1 = -93447.96

YR 2 = -68928.95

YR 3 = -57553.20

YR 4 = -49275.00

I added them all to -28,000.00 and got -297,205.11. Therefore, all cash flows are 0 except for year 0 and 5. But when I put this in my calculator (the way you would find IRR of course), I got an error message, because both year 0 and the combined cash flows for year 5 (-297,205.11) are negative. I just need someone to tell me where I messed up.

1 Answer

Relevance
  • ?
    Lv 6
    7 years ago

    The formula for MIRR is

    MIRR = (FV positive cash flows/-PV negative cash flows)^(1/n) -1

    Your calculation of FV is correct.

    For the PV you need to discount the 28000 back 5 years

    28000/1.095^5 = 17786.37

    Together with the 150000

    PV of negative cash flows= 150000+17786.37 = 167786.37`

    MIRR = (FV positive cash flows/-PV negative cash flows)^(1/n) -1

    MIRR = (269205.11/-167786.37)^(1/5) -1

    MIRR = 9.9171%

Still have questions? Get your answers by asking now.