Scenario

Assume that you are an adviser at LATECH Ltd, which is analysing the introduction of a new gameconsole named NEUROPOWER. This system can be connected with human brain functions, and is still very much controversial for claimed but yet to be confirmed adverse impacts on human behaviour after prolonged application. Health conscious groups are also lobbying against introduction of such games with probable detrimental effects.

The Project Manager of LATECH Ltd needs a detailed analysis of this exciting NEUROPOWER project. She comes into your office, drops a consultant's report on your desk, and complains, 'We paid these consultants $1 million for this report, and I am not sure their financial analysis makes sense, though their estimations seem to be correct. Before we spend $60 million on buying new equipment needed for this project, look it over and give me your opinion.' You open the report and find the following information and estimates:

The project will continue for the next seven years, and by that time more reliable information on possible adverse impacts of using NEUROPOWER will be available. It is projected that equipment will have an economic life of 10 years. After buying the equipment, it requires renovation of the production bay at LATECH Ltd and installation of the equipment at a total cost of $2 million. These renovation and installation costs are to be considered as capital expenditures. A staff training cost of $200,000 is to be incurred initially at the start of the project.

The equipment will be procured from Germany and LATECH Ltd has to pay 8% import duty on purchase price, whereas the supplier will pay transportation costs of $90,000. These property, plant and equipment (PPE) would be depreciated over their useful life of 10 years using a tax allowable straight line rate of 10%. However, the company is planning to sell the equipment at the end of the project for an estimated price of $12 million.

Consultants estimate that 96,000 NEUROPOWER consoles can be sold in the first year with an expected increase by 25% in each year for the next two years; afterwards, sales are expected to decrease by 20% in each year until the end of the project, due to a number of actions by the competitors in the market. Annual fixed operating cost, excluding depreciation, will be $1 million. Variable operating costs will be 50% of sales. Beginning selling price per console will be $500, which will be dropped by 10% in the fourth year for the rest of the project life.

Existing facilities to be used for the NEUROPOWER project are coming from another production line that earns net $21,000 per month. That production line will be discontinued on the commencement of the NEUROPOWER project. For the duration of the project, LATECH is also planning to take the service of a market analyst at a cost of $9,000 per month.

It is also estimated that the new production line will require an initial increase in investment for $970,000 in stock (inventories) and $910,000 in debtors (accounts receivable) that are offset by an increase in creditors of $480,000 (accounts payable). There will be no further investment in net working capital (NWC) until its final recovery at the end of project life.

The company uses required rate of return considering its weighted average cost of capital (WACC) that varied from 16% to 22% in recent times. The analyst is confused about the rate to be effective for the project; however, she has decided to use 16% required rate to evaluate this project. Corporate tax rate is 30%. The required discounted payback period is five years.

1. A table of cash flows (show all digits, do not convert amounts to $ in million or thousand) (show appropriate formulas)