1 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 $11.90 million. This investment will consist of $2.30 million for land and $9.60 million for trucks and other equipment. The land, all trucks, and all other equipment is expected to be sold at the end of 10 years at a price of $5.12 million, $2.45 million above book value. The farm is expected to produce revenue of $2.05 million each year, and annual cash flow from operations equals $1.86 million. The marginal tax rate is 35 percent, and the appropriate discount rate is 9 percent. Calculate the NPV of this investment. (Round intermediate calculations and final answer to 2 decimal places, e.g. 15.25.) I need to know the NPV. Question 2 Bell Mountain Vineyards is considering updating its current manual accounting system with a high-end electronic system. While the new accounting system would save the company money, the cost of the system continues to decline. The Bell Mountains opportunity cost of capital is 14.7 percent, and the costs and values of investments made at different times in the future are as follows: Year Cost Value of Future Savings (at time of purchase) 0 $5,000 $7,000 1 4,550 7,000 2 4,100 7,000 3 3,650 7,000 4 3,200 7,000 5 2,750 7,000 Calculate the NPV of each choice. (Round answers to the nearest whole dollar, e.g. 5,275.) The NPV of each choice is: NPV0 = ? NPV1 = ? NPV2 = ? NPV3 = ? NPV4 = ? NPV5 = ? Suggest when should Bell Mountain buy the new accounting system? (Which Year?) Question 3: Chips Home Brew Whiskey management forecasts that if the firm sells each bottle of Snake-Bite for $20, then the demand for the product will be 15,000 bottles per year, whereas sales will be 93 percent as high if the price is raised 10 percent. Chips variable cost per bottle is $10, and the total fixed cash cost for the year is $100,000. Depreciation and amortization charges are $20,000, and the firm has a 30 percent marginal tax rate. Management anticipates an increased working capital need of $3,000 for the year. What will be the effect of the price increase on the firms FCF for the year? (Round answers to nearest whole dollar, e.g. 5,275.) At $20 per bottle the Chips FCF is $ __________ and at the new price Chips FCF is $_________. Question 4: Capital Co. has a capital structure, based on current market values, that consists of 28 percent debt, 5 percent preferred stock, and 67 percent common stock. If the returns required by investors are 10 percent, 11 percent, and 16 percent for the debt, preferred stock, and common stock, respectively, what is Capitals after-tax WACC? Assume that the firms marginal tax rate is 40 percent. (Round intermediate calculations to 4 decimal places, e.g. 1.2514 and final answer to 2 decimal places, e.g. 15.25%.) After tax WACC = _______ % If it is possible to complete in excel so I can see how the answers were generated it would be appreciated