Question

You want to start an organic garlic farm. The farm costs $190,000, to be paid in full immediately. Year 1 cash flows will be $25,000, and grow at 5% a year into year 5 when you decide to sell the farm at the end of the year for $260,000 (in year 5 you get cash flows from selling both the garlic and the farm). Assuming these estimates are all correct, what is the IRR of the garlic farm investment? Round to the tenth of a percent (e.g. 5.6%=5.6). ​[Hint: You'll want to solve this in Excel using the IRR function or Goal Seek. Make sure the IRR cell is set to show decimals.]

Answer 1

Answer:

internal rate of return 31.8%

Explanation:

on excel we will list each cash flow:

Y0 -190,000

Y1   25,000

Y2    37500 (Y1 x (1+g) = 25,000 x 1.05)

Y3 56250    (37,500 x 1.05)

Y4 84375     (56,250 x 1.05)

Y5 386562.5 (84,375 x 1.05 + 260,000 from the sale)

we now write =IRR( and select the cells then, press enter

the IRR function return: 31.8503%

we round into 1 percent 31.8%