You want to start an organic garlic farm. The farm costs $210,000, to be paid in full immediately. Year 1 cash inflow will be $25,000, after which the inflows are expected to grow at a 5% annual rate until the end of year 5 when you anticipate selling the farm for $260,000 (at the end of year 5 you get both the cash inflow from operations and from selling the farm). What is the IRR of your 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.]

Question

You want to start an organic garlic farm. The farm costs $210,000, to be paid in full immediately. Year 1 cash inflow will be $25,000, after which the inflows are expected to grow at a 5% annual rate until the end of year 5 when you anticipate selling the farm for $260,000 (at the end of year 5 you get both the cash inflow from operations and from selling the farm). What is the IRR of your 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.]

Expert Answer

Want to see the step-by-step answer?

Check out a sample Q&A here.

Want to see this answer and more?

Experts are waiting 24/7 to provide step-by-step solutions in as fast as 30 minutes!*

*Response times may vary by subject and question complexity. Median response time is 34 minutes for paid subscribers and may be longer for promotional offers.
Tagged in
Business
Finance

Capital Budgeting

Related Finance Q&A

Find answers to questions asked by students like you.

Q: IF you deposit $300 each quarter into an account earning 3.2% compunded quarterly, how many years wi...

A: Quarterly payment (PMT) is $300. Annual rate of return is 3.2% and Rate of return per quarter is 0.0...

Q: CJ and Danny have incorporated and obtained a $100,000 loan in their corporate name. The loan is pay...

A: A lawful entity, ordinarily an organization that respects responsibility is characterized as being s...

Q: Capital budgeting is the decision making process used in the acquisition of long term physical asset...

A: It is a decision making process which is used by the firm about the acquisition of long term physica...

Q: Can someone give an example of global minimum-variance portfolio?

A: The question is based on the concept of global minimum-variance portfolio, the idea of  a minimum va...

Q: What is the NPV of a project that costs $111,000 today and is expected to generate annual cash inflo...

A: NPV refers to net present value of an investment or a project. It is used to analyze the profitabili...

Q: A general partnership may be formed by Group of answer choices either oral or written agreement. ...

A: A general partnership is formed when two or more person agreed to share assets, profit share and fin...

Q: A project will produce cash inflows of $3,200 a year for 4 years with a final cash inflow of $5,700 ...

A: Net present value is computed by discounting all the cash inflows and outflows. The net inflow or ou...

Q: To minimize collection float, a firm should do which of the following?I. Deposit its collections at ...

A: Collection float is the time gap between the moment the payer deducts its payment from the account’s...

Q: Can someone explain and give an example of markowitz portfolio theory?

A: The question is based on the concept of Markowitz portfolio theory also called Modern portfolio theo...