Question

1) You want to start an organic garlic farm. The farm costs $190,000, to be paid...

1) You want to start an organic garlic farm. The farm costs $190,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 $300,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.]

2) You own a 10-acre vineyard and earn income by selling your grapes to wineries. Your vineyard is currently planted to Merlot grapes, but you are thinking of replanting with Syrah grapes because they are commanding a higher market price per ton. Merlot fetches $1500 per ton but Syrah sells for $2800 per ton, those prices are expected to remain stable, and you produce 50 tons per year. Either way, you plan to sell the vineyard 5 years from today (at the end of the year) for 4-times (4x) the annual income (in year 5) from the sale of grapes (that is, you'll get the income from grape sales and then sell the vineyard for 4 times that amount at the end of year 5). However, if you were to switch to Syrah, switching will cost you $111,000 today and the vines won’t produce any grapes until the end of year 4 (that is, years 1 - 3 will have no sales if you plant Syrah, but years 4 and 5 will). The applicable discount rate is 9% per year. What is the NPV of switching? Round to the nearest cent. ​[Hint: Create a timeline showing the incremental annual cash flows from switching and find their NPV. Some cash flows will be negative (first 3 years) and some will be positive (years 4 and 5)]

Homework Answers

Answer #1

1]

Cash outflow in year 0 = cost of farm = $190,000

Cash inflow in years 1 to 4 =  cash inflow from operations

Cash inflow in year 5 =  cash inflow from operations + selling price of farm

IRR is 21.78%

IRR is 21.78%

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
You own a 10-acre vineyard and earn income by selling your grapes to wineries. Your vineyard...
You own a 10-acre vineyard and earn income by selling your grapes to wineries. Your vineyard is currently planted to Merlot grapes, but you are thinking of replanting with Syrah grapes because they are commanding a higher market price per ton. Merlot fetches $1800 per ton but Syrah sells for $2600 per ton, those prices are expected to remain stable, and you produce 50 tons per year. Either way, you plan to sell the vineyard 5 years from today (at...
You own a 10-acre vineyard and earn income by selling your grapes to wineries. Your vineyard...
You own a 10-acre vineyard and earn income by selling your grapes to wineries. Your vineyard is currently planted to Merlot grapes, but you are thinking of replanting with Syrah grapes because they are commanding a higher market price per ton. Merlot fetches $1500 per ton but Syrah sells for $2800 per ton, those prices are expected to remain stable, and you produce 50 tons per year. Either way, you plan to sell the vineyard 5 years from today (at...
You own a 10-acre vineyard and earn income by selling your grapes to wineries. Your vineyard...
You own a 10-acre vineyard and earn income by selling your grapes to wineries. Your vineyard is currently planted to Merlot grapes, but you are thinking of replanting with Syrah grapes because they are commanding a higher market price per ton. Merlot fetches $1700 per ton but Syrah sells for $2700 per ton, those prices are expected to remain stable, and you produce 50 tons per year. Either way, you plan to sell the vineyard 5 years from today (at...
You own a 10-acre vineyard and earn income by selling your grapes to wineries. Your vineyard...
You own a 10-acre vineyard and earn income by selling your grapes to wineries. Your vineyard is currently planted to Merlot grapes, but you are thinking of replanting with Syrah grapes because they are commanding a higher market price per ton. Merlot fetches $1400 per ton but Syrah sells for $2900 per ton, those prices are expected to remain stable, and you produce 5 tons per year per acre (so 50 tons per year total). Either way, you plan to...
You own a 10-acre vineyard and earn income by selling your grapes to wineries. Your vineyard...
You own a 10-acre vineyard and earn income by selling your grapes to wineries. Your vineyard is currently planted to Merlot grapes, but you are thinking of replanting with Syrah grapes because they are commanding a higher market price per ton. Merlot fetches $1500 per ton but Syrah sells for $2800 per ton, those prices are expected to remain stable, and you produce 5 tons per year per acre (so 50 tons per year total). Either way, you plan to...
You own a 10-acre vineyard and earn income by selling your grapes to wineries. Your vineyard...
You own a 10-acre vineyard and earn income by selling your grapes to wineries. Your vineyard is currently planted to Merlot grapes, but you are thinking of replanting with Syrah grapes because they are commanding a higher market price per ton. Merlot fetches $2000 per ton but Syrah sells for $2400 per ton, those prices are expected to remain stable, and you produce 5 tons per year per acre (so 50 tons per year total). Either way, you plan to...
Your first job out of college will pay you $84,000 in year 1 (exactly one year...
Your first job out of college will pay you $84,000 in year 1 (exactly one year from today). You estimate that your salary will grow at 6% per year for 45 years (compounded annually), when you'll stop working. If the applicable discount rate is 12%, what is the present value of these future earnings today? Round to the nearest cent. You own a 10-acre vineyard and earn income by selling your grapes to wineries. Your vineyard is currently planted to...
1) What is the NPV of a project that costs $89,000 today and is expected to...
1) What is the NPV of a project that costs $89,000 today and is expected to generate annual cash inflows of $18,000 for the next 8 years. Cost of capital (discount rate) is 13%. Round to the nearest cent. 2) What is the Profitability Index of a project that costs $22,000 today and is expected to generate annual cash inflows of $5,000 for the following 7 years. Cost of capital is 9%. Round to two decimal places. 3) A project...
We are thinking of investing in a piece of equipment that costs $190,000. It should generate...
We are thinking of investing in a piece of equipment that costs $190,000. It should generate the following income and expenses each year for five years, and have no salvage at the end of its five years of estimated life. Revenue 250,000 Cost of Goods sold -130,000 Gross Profit 120,000 Selling and admin (includes $15,000 of depreciation) -85,000 Net income per year 35,000 a. What is the cash flow per year, of the investment? b. What is the Net Present...
PROJECT A PROJECT B Initial Outlay minus−​$5000050,000minus −​$7000070,000 Inflow year 1      1200012,000      1300013,000 Inflow year 2     ...
PROJECT A PROJECT B Initial Outlay minus−​$5000050,000minus −​$7000070,000 Inflow year 1      1200012,000      1300013,000 Inflow year 2      1200012,000      1300013,000 Inflow year 3      1200012,000      1300013,000 Inflow year 4      1200012,000      1300013,000 Inflow year 5     12 00012,000      1300013,000 Inflow year 6     12 00012,000      1300013,000 ​(​NPV, ​PI, and IRR calculations​) You are considering two independent​ projects, project A and project B. The initial cash outlay associated with project A is ​$50 comma 000​, and the initial cash outlay associated with project B is ​$70 comma...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT