CWC curently has 30,000,000 share of common stock outstanding that trade at a price of $42 per share. CWC also has 500,000 bonds outstanding that currently trade at $923.38 each. CWC has no preferred stock outstanding and has an equity beta of 2.639. The risk-free rate is 3.5%, and the market is expected to return 12.52%. The firm's bonds have a 20-year life, a $1000 par value , a 10% coupon rate and pay interest semi-annually.

CWC is considering adding to to its product mix a "healthy" bottled water geared toward children. The initial outlay for the project is expected to be $3,000,000 which will be depreciated using that straight-line method to a zero salvage value, and sales are expected to be 1,250,000 units per year at a price of $1.25 per unit. variable costs are estimated to be $0.24 per unit, and fixed costs of the project are estimated at $200,000 per year. The project is expected to have a 3 year life and a terminal value of $500,000. CWC has a 34% marginal tax rate. For the purposes of this project working capital effects will be ignored. Bottled water targeted children is expected to have different risk charactersitics from the firm's surrent products. Therefore, CWC has decided to use the "pure play" approach to evaluate this project. After researching the maret, CWC managed to find two puer plat firms. These speicifics for those two firms are:

Firm	Equity Beta	D/E	Tax Rate
Fruity Water	1.72	.43	34%
Ladybug Drinks	1.84	.35	36%

QUESTION: Should the firm undertake the healthy bottled water project? As part of your analysis, include a sensitivity analysis for sales price, variable costs, fixed costs, and unit sales at +/- 10%, 20%, and 30% from the base case. ALSO PERFORM AN ANALYSIS OF THE FOLLOWING TWO SCENARIOS:

a. Best case: Selling 2,500,000 units at a price of $1.24 per unit, with variable production costs of $0.22 per unit.

b. Worst Case: Selling 950,000 units at a price of $1.32 per unit, with variable production costs of $0.27 per unit.