Business

FinanceQ&A LibraryYou 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.]Start your trial now! First week only $4.99!*arrow_forward*

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

Tagged in

Business

Finance

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