Seating Unlimited, Inc is considering producing a specialty lawn chair for the next Olympics, which will occur in two years. The new production line will require a $100,000 investment in fixed assets, which will fall into the MACRS 5-year class. The firm`s market research department anticipates sufficient demand for the lawn chairs for only three years. At the conclusion of the project, the fixed assets can be sold for $25,000. The market research team believes one of three states of nature will occur, depending on the level of interest in the Olympics. The three states are high, average, or low consumer interest in the Olympics. The firm has estimated unit sales, the sales price, and variable costs for each state;

When consumer interest is Low

Unit sales= 50,000

Sales Price per unit= $6.25

Variable cost per unit= $3.50

When consumer interest is average

Unit sales= 100,000

Sales Price per unit= $8.00

Variable cost per unit= $3.50

When consumer interest is high

Unit sales= 150,000

Sales Price per unit= $10.00

Variable cost per unit= $5.00

Note that the level of consumer interest remains constant over the estimated life of the project (if interest is low in first year, interest will be low for the remaining periods). The project will have fixed costs of $150,000 per year. Project net working capital requirements are estimated to be 20 % of year one expected sales. The firm has a 7% cost of capital and tax rate of 39%.Create a worksheet for each scenario; calculate annual project cash flows.

What is the NPV for each scenario? Based on your results, should the firm undertake the project?