29. Project Analysis. New Energy is evaluating a new biofuel facility. The plant would cost $4,000 million to build and has the potential to produce up to 40 million barrels of synthetic oil a year. The product is a close substitute for conventional oil and would sell for the same price. The mar- ket price of oil currently is fluctuating around $100 per barrel, but there is considerable uncer- tainty about future prices. Variable costs for the organic inputs to the production process are estimated at $78 per barrel and are expected to be stable. In addition, annual upkeep and mainte- nance expenses on the facility will be $100 million regardless of the production level. The plant has an expected life of 15 years, and it will be depreciated using MACRS and a 10-year recovery period. Salvage value net of cleanup costs is expected to be negligible. Demand for the product is difficult to forecast. Depending on consumer acceptance, sales might range from 25 million to 35 million barrels annually. The discount rate is 12%, and New Energy's tax bracket is 35%.

a. Find the project NPV for the following combinations of oil price and sales volume. Which source of uncertainty seems most important to the success of the project? (LO2)

b. At an oil price of $100, what level of annual sales, maintained over the life of the plant, is necessary for NPV break-even? (This will require trial and error unless you are familiar with more advanced features of Excel such as the Goal Seek command.) (LO2)

c. At an oil price of $100, what is the accounting break-even level of sales in each year? Why does it change each year? Does this notion of break-even seem reasonable to you? (LO2)

d. If each of the scenarios in the grid in part

(a) is equally likely, what is the expected NPV of the facility? (LO2)

e. Why might the facility be worth building despite your answer to part (c)? (L04)

Transcribed Image Text:

Annual sales 25 million barrels 30 million barrels 35 million barrels $80/barrel Oil Price $100/barrel $120/barrel