Ask Question
5 April, 18:30

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

+1
Answers (1)
  1. 5 April, 22:12
    0
    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%
Know the Answer?
Not Sure About the Answer?
Get an answer to your 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 ...” in 📙 Business if there is no answer or all answers are wrong, use a search bar and try to find the answer among similar questions.
Search for Other Answers