Williams Corp. makes chrome wheels that are sold through mail order and auto supply stores nationally. They are considering the construction of a new manufacturing plant in South Dakota to increase their capacity by 25%. This new capacity will be needed to meet the demand from a large national auto parts chain.

The plant will be able to manufacture 20,000 sets of chrome wheels a year when at full capacity. They will sell the wheels for $120 a set. The COGS (excluding depreciation) is projected to be 60% of sales or $72 per set. They expect that fixed operating expenses (all of which are incremental new expenses) will be $90,000 a year. The land will cost $200,000 today and can not be depreciated. The plant and equipment will cost $2,300,000 today and will be depreciated for tax purposes on a straight line basis (10% per year) to a value of zero over 10 years.

They expect to be able to sell 10,000 sets in year 1 and they expect sales to grow by 4% per year. At the end of ten years they will close the plant and expect to be able to sell it and the land at that time for $1,200,000 before taxes. The project is expected to require an initial investment of $180,000 in Accounts Receivable & Inventory less Accounts Payable and Accrued Expenses or Net Operating Working Capital (NOWC). In subsequent years the year end investment in NOWC is expected to be 15% of next years sales.

The opportunity cost of capital for Williams Corp. is 10.2% and their marginal income tax rate is 35%. Calculate the NPV and IRR of the project. Should Williams invest in the new plant?

Simple Project NPV Template
Assumptions
OCC =	0.0%
Tax Rate =	0%
Unit Sales =	-
Price per Unit=	$-
% Cost of Sales =	0%
Sales Growth =	0%
Annual Operating Expenses =	$-
NOWC as a % of Sales =	0%