The Alpha Dog Company manufactures and distributes a variety of pet$-$related products. In response to customer feedback relating to the fragile nature of many commercially available dog leashes, the company$$s product development team has recently introduced a prototype of a new, virtually indestructible dog leash. The development of the prototype cost $$250,000$ in research and development costs. The product development team has presented their proposal to Adam Smith, the company$$s president and CEO.

Adam has asked you, as the chief financial officer, to prepare an analysis of the proposal and to provide a decision regarding whether or not to pursue to proposal.

Your first step in the analysis was to commission a market survey to assess the potential demand for the new product. You hired a consulting firm, Williams and Connelly, at a flat rate of $$100,000$ to conduct this market research. The results of their study indicate that potential consumers would be willing to pay upwards of $$75$ per dog leash, on the presumption that it truly is indestructible. It is further estimated that Alpha will have this segment of the market virtually all to itself for $5$ years, at which time it is believed the market will have become saturated and that sales of the new leash will cease. The market study indicates that unit sales volume for this period will be as follows;

Year Unit Sales

$110,000$

$215,000$

$325,000$

$420,000$

$55,000$

After assessing the market demand potential, your turn to the head of your manufacturing department, John Williams, to consider the operating costs of producing the new dog leash. John believes that it will be necessary to purchase some new manufacturing equipment for the new product. After calling several potential suppliers, John thinks that the best deal on the necessary equipment will cost Alpha $$1\mathrm{.}5$ million. For tax purposes, this equipment will be classified under the $3-$years MACRS classification. John also estimated that the variable costs of production, such as raw materials and labor, will cost about $$35$ per unit and that the fixed costs of production will run another $$150,000$ per year. Finally, John thinks that a reasonable estimate of the resale value of the production equipment will be about $$300,0005$ years from now.

Next, you consult with Alpha$$s marketing department to evaluate any potential impact on existing leash models. Janet Mellon, the head of the market department, thinks that the introduction of this new and improved product will take some sales away from its current top$-$of$-$the$-$line dog leash. If Alpha does not go ahead with the new product introduction, it is believed that its existing dog leash will sell for $$45$ per leash and that unit sales volume will be $8,000$ units per year for the next $5$ years. The production costs of the existing model have been established as $$15$ per unit in variable costs and fixed production costs of $$200,000$ per year. If Alpha were to go ahead with the new leash project, is has been estimated that unit sales of its existing product will decline to $5,000$ units per year for the next $5$ years. Additionally, Janet thinks that, in order to reach this sales volume, it will be necessary to reduce the selling price of the existing leash by $$5$ per unit.

Finally, based on Alpha$$s past experience with new product introductions, you estimate that, at inception of the project, Alpha will need to invest $$400,000$ in inventory to support the anticipated sales volume. Of this amount, $$200,000$ will be financed by taking on additional short$-$term liabilities $($i$.$e$.$ buying inventory on credit$).$ It is assumed that this working capital investment will be fully recovered at the end of the project$$s $5-$year horizon. Alpha pays income taxes at a marginal rate of $40\%$ and assigns a required return of $10\%$ to new product proposals.

$1)$ Adam has asked you to prepare a forecast of the cash flows to be generated from this project to be used in his final evaluation. Be sure to determine operating cash flow, capital expenditures, changes in net working capital, and cash flow from assets $($CFA$)$ for each year.

Fill in template attached.

Revenue with

Year $1$ Year $2$ Year $3$ Year $4$ Year $5$

New Product

Existing Product

Total

Revenue without

Year $1$ Year $2$ Year $3$ Year $4$ Year $5$

Existing Product

Incremental Revenue

Variable costs with

Year $1$ Year $2$ Year $3$ Year $4$ Year $5$

New Product

Existing Product

Total

Variable costs without

Year $1$ Year $2$ Year $3$ Year $4$ Year $5$

Existing Product

Incremental Variable Costs

Income Statement $($pro forma$)$

Year $1$ Year $2$ Year $3$ Year $4$ Year $5$

Revenue

Variable Costs

Fixed Costs

Depreciation

EBIT

Taxes

Net Income

Cash Flow

Today Year $1$ Year $2$ Year