Question

In: Accounting

Archer Daniels Midland Company is considering buying a new farm that it plans to operate for...

Archer Daniels Midland Company is considering buying a new farm that it plans to operate for 10 years. The farm will require an initial investment of $12 million. This investment will consist of $2 million for land and $10 million for trucks and other equipment. The land, all trucks, and all other equipment are expected to be sold at the end of 10 years for a price of $ million, which is $2 million above book value. The farm is expected to produce revenue of $2 million each year, and annual cash flow from operations equals $1.8 million. the marginal tax rate is 35 percent, and the appropriate discount rate is 10 percent. Calculate the NPV of this investment.

PLEASE RESPOND USING EXCEL AND SHOW HOW YOU GOT YOUR ANSWER.

Solutions

Expert Solution

Initial Investment: $2 million for land and $10 million for trucks and other equipments
Life of Investment: 10 years
Cash proceeds of the investments at the end of 10 years: $5 million
Book value of the investments at the end of 10 years: Cash proceed – profit = $5 million - $2 million = $3 million
Depreciation: value of initial investment – book value at the end of 10 years =
$12 million-$3million=$9 million
Therefore, Depreciation charged every year = $9 million / 10 years = $0.9 million
Marginal tax rate: 35%
Appropriate discount rate: 10%
Revenue inflows per year: Expected revenue per year + annual cash flow for operation =
$2 million + $1.8million = $ 2.8 million
After-tax salvage value: Cash proceed – (Cash proceed – book value)*tax rate =
$5 million – ($5million - $3million)*35% = $5million - $2million*35% = $5million – $0.7 million =
$4.3 million
Discount=∑ 1/〖(1+10%)〗^n, where n= number of years

Solution:-
All amounts are in million USD.


Related Solutions

Archer Daniels Midland Company is considering buying a new farm that it plans to operate for...
Archer Daniels Midland Company is considering buying a new farm that it plans to operate for 10 years. The farm will require an initial investment of $12.1 million. This investment will consist of $2.3 million for land and $9.80 million for trucks and other equipment. The land, all trucks, and all other equipment are expected to be sold at the end of 10 years for a price of $5.1 million, which is $2.0 million above book value. The farm is...
Oriole Company is considering buying a new farm that it plans to operate for 10 years....
Oriole Company is considering buying a new farm that it plans to operate for 10 years. The farm will require an initial investment of $12.10 million. This investment will consist of $2.00 million for land and $10.10 million for trucks and other equipment. The land, all trucks, and all other equipment are expected to be sold at the end of 10 years for a price of $5.00 million, which is $2.40 million above book value. The farm is expected to...
Ivanhoe Company is considering buying a new farm that it plans to operate for 10 years....
Ivanhoe Company is considering buying a new farm that it plans to operate for 10 years. The farm will require an initial investment of $12.15 million. This investment will consist of $2.85 million for land and $9.30 million for trucks and other equipment. The land, all trucks, and all other equipment are expected to be sold at the end of 10 years for a price of $5.20 million, which is $2.30 million above book value. The farm is expected to...
CF and NPV for a project: Midland Ltd is considering buying a new farm that it...
CF and NPV for a project: Midland Ltd is considering buying a new farm that it plans to operate for 10 years. The farm will require an initial investment of $12,000,000. The investment will consist of $2,000,000 for land and $10,000,000 for trucks and other equipment. The land, all trucks, and all other equipment are expected to be sold at the end of 10 years at a price of $5 million, $2 million above book value. The farm is expected...
Problem 1: You are the manager of Archer-Daniels Midland Company (ADM). ADM uses corn to produce...
Problem 1: You are the manager of Archer-Daniels Midland Company (ADM). ADM uses corn to produce high fructose corn syrup (HFCS) and corn oil (e.g., Mazola). Assume that the production of corn oil is positively related to the production of HFCS. Write out a cost function and show that there are cost complementarity and economies of scope in the production of HFCS and corn oil. Problem 2: Given the solution to problem 1, assume that you would like to increase...
You're the manager of Archer-Daniels Midland Company (ADM). ADM uses corn to produce high fructose corn...
You're the manager of Archer-Daniels Midland Company (ADM). ADM uses corn to produce high fructose corn syrup (HFCS) and corn oil (e.g., Mazola). Assume that the production of corn oil is positively related to the production of oil. Write out a cost function and show that there are cost complementarity and economies of scope in the production of HFCS and corn oil. Based on the solution to the last question, assume that you would like to increase production of HFCS...
This question is about the Archer Daniels Midland price fixing scandal. Answer the first three parts...
This question is about the Archer Daniels Midland price fixing scandal. Answer the first three parts before watching the video. Read in your book the introduction to the chapter titled “Price fixing and repeated games”. You can use any additional sources to answer the following questions. a. Write a few lines describing the company Archer Daniels Midland. Where are they located, what kind of products do they sell. b. What is “price fixing”, why do some countries including the US...
Consider additional data for Archer-Daniels-Midland for fiscal years ending June 30, 2010 and 2011, in millions:...
Consider additional data for Archer-Daniels-Midland for fiscal years ending June 30, 2010 and 2011, in millions: Fiscal Year End (in millions)                June 30, 2011             June 30, 2010 Sales                          $80,676                       $61,682 Cost of goods sold      $76,376                      $57,839 Fiscal Year End (in millions)                June 30, 2011             June 30, 2010 Accounts receivable   $9,816                        $6,122 Inventories                 $12,055                       $7,871 Accounts payable      $11,165                      $8,115 Calculate the DSO, DIO, and DPO for fiscal years ending June...
Green Valley Farms is considering either leasing or buying some new farm equipment. The lessor will...
Green Valley Farms is considering either leasing or buying some new farm equipment. The lessor will charge $23,000 a year lease. The purchase price is $63,000. The equipment has a 3-year life after which time it will be worthless. Green Valley Farms uses straight-line depreciation, has a 32 percent tax rate, borrows money at 9 percent, and has sufficient tax loss carryovers to offset any potential taxable income the firm might have over the next five years. What is the...
31. Suppose a company is considering buying a new copier. The new machine is less labor...
31. Suppose a company is considering buying a new copier. The new machine is less labor intensive, and would save somewhat on the wage bill. A clerical assistant, working 10 hours a week (for 50 weeks a year), would not be needed any longer. This assistant, including all benefits and other compensation costs, costs $20 an hour. A. What is the annual wage savings? B. Suppose that the machine would last for 5 years. It requires a maintenance agreement, which...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT