Question

Please create your own Excel file to conduct scenario analysis illustrated below:

Suppose you have been hired as a financial consultant to Cape Cod Fishing, Inc. (CCF), a large firm that is the market share leader in manufacturing fishing products. The company is looking at setting up a manufacturing plant to produce a new line of fishing bait, which specially formulated for attracting bluefin tuna. To illustrate, suppose the company can sell 87,300 cans of bait per year at a price of $39.18 per can. It costs the company about $23.40 per can to make fishing bait, and a new product such as this one typically has only a 6-year life (perhaps because the customer base dwindles rapidly). We require a 9 percent return on new products. Fixed costs for the project, including such things as rent on the production facility, will run $827,000 per year. The tax rate is 24 percent. Suppose the projections are given for price, quantity, variable costs, and fixed costs are all accurate to within ±10 percent. Calculate the most likely case, best-case, and worst-case net present value (NPV) figures.

All necessary information is provided to solve the problem.

please show your work

Answer 1