Question

The Widget Project By Gary Moore, PH.D., J.D. After extensive research and development, Your company has recently developed a new Widget and must decide whether to make the investment necessary to produce and marketing it. The widget is superior to current widgets in the marketplace. Research and Development costs have been $20 million so far. The product would be put on the market at the beginning of this year. We anticipate that test marketing the project will cost $1 million dollars. The plant will be in a building that we bought for $2 million dollars 30 years ago but a competitor who would like to buy our business offered us $3.5 million for the property a year ago. The property has a current book value of 5 million dollars due to renovation we did 5 years ago. We tried to sell the building this year for 4.5 million, but received no offers. As a Financial Analyst you have been called in to do that evaluation of the project and to provide a recommendation. The Company must invest $300 million in new money for equipment. The equipment can be sold for $55 million at the end of five years. The appropriate deprecation schedule for the new equipment is the seven year MACRS depreciation schedule (yr 1- 14.3%, yr 2- 24.5%, yr 3-17.5%, yr 4 12.5%, yr 5 8.9%). The immediate initial working capital requirement is 27 million dollars. Thereafter the net working capital will be 15 percent of sales. General Administrative expenses are expected to be $32 million a year the first year and expected to increase with inflation each year. Annual expected inflation is expected to be 3.25 percent. The widgets are expected to sell at 48 dollars while the cost to produce each widget is 23 dollars. The market for widgets is currently 36 million and is expected to increase by 1 percent each year. Our estimated share will be 10 percent and increase by ½ a percent each year of the project. We expect to be able to pass any effects of inflation to our customers since the market is not overly competitive. The company’s tax rate is 22 percent. The project is expected to end in 5 years. You are to use at least three discount rates to evaluate the project. Calculate the NPV and IRR for the project using discount rates of 6%, 8%, and 10% Most S&P500 companies have a cost of capital in that range. Develop the initial cash flow, on-going cash flows (use the top down method), and finally figure out the salvage cash flow. After you determine all cash flows use the NPV and IRR excel solver functions. Should the company accept the project?

Answer 1

Answer:

this is very long question