Question

is considering an investment with an initial cost of $236,000. In Year 4, the project will require an additional investment and finally, the project will be shut down in Year 7. The annual cash flows for Years 1 to 7, respectively, are projected as $64,000, $87,000, $91,000, −$48,000, $122,000, $154,000, and −$30,000. If all negative cash flows are moved to Time 0 using a discount rate of 13 percent, what is the project's modified IRR?

Answer 1

Answer:

18.54%

Explanation:

The computation of the project modified IRR is shown below:

Here we use the spreadsheet for determining the IRR

but before that we need to find out the cash inflows

Years       Amount (in dollars)

Year 0: = - $278,191.12

              ($236,000 - $48,000 ÷ 1.13^4 -$30,000 ÷ 1.13^7)

Year 1: 64000

Year 2: 87000

Year 3: 91000

Year 4: 0

Year 5: 122000

Year 6: 154000

Year 7: 0

Now we use the excel

=IRR({-$278,191.12,$64,000,$87,000,$91,000,$0,$122,000,$154,000,0})

= 18.54%