Cascade water company (CWC) currently has 30,000,000 shares of common stock out-standing that trade at a price of $42 per share. CWC also has 500,000 bonds outstanding that currently trade at $923.38 per share. 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 firms bonds have a 20-year life, a $1,000 par value, a 10% coupon rate and pay interest semi-annually.

CWC is considering adding to its product mix a healthy bottled water geared toward children. The initial outlay of the product is expected to be $3,000,000, which will be depreciated using the straight-line method to a zero salvage value and sales are expected to be 1,250,000 per year at a price of $1.25 per unit. Variable costs are expected 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 (excluding the operational cash flows in year 3) of $500,000. CWC has a 34% marginal tax rate. For the purpose of this project, working capital effects will be ignored. Bottled water targeted at children is expected to have different risk characteristics form the firms current projects. Therefore, CWC has decided to use the pure play approach to evaluate this project. After researching the market, CWC managed to find two pure-play firms. The specifics for those two firms are:

Firm	Equity Beta	D/E	Tax Rate
Fruity Water	1.72	0.43	34%
Ladybug Drinks	1.84	0.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:

Best Case: selling 2,500,000 units at a price of $1.24 each, with a variable production costs of $0.22 per unit

Worst case: selling 950,000 units at a price of $1.32 per unit, with variable production costs of $0.27 per unit