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

Cornerstones of Cost Management (Cornerstones Series)
4th Edition
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Don R. Hansen, Maryanne M. Mowen
Chapter19: Capital Investment
Section: Chapter Questions
Problem 4CE: Manzer Enterprises is considering two independent investments: A new automated materials handling...
icon
Related questions
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 Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 2 images

Blurred answer
Knowledge Booster
Capital Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Corporate Fin Focused Approach
Corporate Fin Focused Approach
Finance
ISBN:
9781285660516
Author:
EHRHARDT
Publisher:
Cengage