Amy Cola is considering launching a new soft drink product. The beverage will be sold in a variety of different flavors and will be marketed to young adult. In evaluating the proposed project, the company has the following information:

The project is estimated to last for 4 years and will have a debt ratio for 10%.

The company will need to purchase new machinery that has an up-front cost of $40 million (incurred at Year 0). The machinery will be fully depreciated on a 4-year straight-line basis with no salvage value.

To gain more insight, Amy Cola had spent $1 million on marketing research costs.

Production of the new product will take place in a vacated facility that the company owns. It is currently empty, and Amy Cola does not intend to lease the facility.

The project will require a $4 million increase in net operating working capital (NOWC) at Year 0. After Year 0, there will be no changes in NOWC, until Year 4 when the project is completed, and the NOWC is fully recovered.

The company estimates that sales of the new drink will be $27 million each of the next four years.

Operating costs (excluding depreciation) are expected to be $11 million each year.

The companys tax rate is 20%.

The owners expect a return of 18% per year but the market interest rate charged by commercial banks are 5% per year.

Based on the information above, the company has estimated the projects free cash flows as shown in the table below and concluded that it should pursue this business opportunity as it is expected to generate a positive net present value (NPV).

Discuss whether the company has conducted the analysis correctly and what the flaws are. Revise the cash flow estimation, re-calculate the net present value (NPV), the internal rate of return (IRR), payback period and provide your recommendations.