The CEO of superman sports company Russell warren was a mechanical engineer. He developed a sound technique of making baseball bats and pounded the company. Under his leadership, the company had gained a national reputation. Recently, however, a new machine was developed in the industry, which would allow manufacturers to call the aluminum baseball bats with a specific compound giving them a satin finish and making them more durable and powerful. The prototype has been presented to the respective regulatory authorities and has been approved. Julian Jackson, the head of the design group, has tested the new product and researched the relevant cost and production process issues that would entail.

Julianne Moore are dead that decides the initial price tag of $350,000 for one of those machines, users would have to incur shipping, handling, and installation costs of $4500 and annual fixed operating costs of about $20,000 per machine. Currently, the company incurs fixed operating costs of $28,000 for its coating and finishing process. Initial marketing survey results indicated that the company would be able to increase sales of its newly designed baseball bats by about 10% per year in the first year of introduction and thereafter at a rate of 5% per year compared with forecasted ales growth of 3% per year for the current type of baseball bats. During the most recent year, the Company sold 220,000 baseball bats at an average price of 12.50 per unit. The newly designed bat was expected to sell for $13 per unit.

Material, labor, general, and administrative costs were expected to remain constant at $10 per unit. The increased sales and production requirements would entail an increase in accounts receivable of $54,000, an increase in accounts payable of $30,000, and an increase in the inventory of $20,000. It was assumed that any increase in net working capital would be recovered at the end of the useful life of the machine, which was estimated to be 5 years. The existing machine was purchased 5 years ago for $225,000. Currently, it could be sold for $100,000, with the price expected to decline to about $10,000 after 5 more years of use. Depreciation on the existing machine was being calculated using a ten year straight line schedule with the assumption of no residual salvage value. The new machine was expected to last for 5 years the same as the remaining life of the old machine. The new machine would qualify as a 5 year class life asset under MARCS depreciation rates and was expected to have a market value of approximately $20,000 at the end of its economic life. The companys marginal tax rate is 22% and its weighted average costs of capital (required rate of return) is estimated at 15%. Part of the costs of replacing the existing machine would be financed by a bank loan that would require an annual interest expense of 10% on the outstanding balance.

To assist Russell Warren making the decision whether or not to go with the new technology, please prepare a capital budgeting report and address the following questions

1. What are the relevant cash flows that should be used to analyze this project?

2. Please calculate OCF, NCS, and change in NWC

3. Based on the forecast of the cash flows, could you calculate the net present value, internal rate of return, profitability index, payback period, discounted payback period of the project?