I need to calculate NPV for the following problems, pls help me?

(A) A company鈥檚 board of directors is considering the introduction of new product which was developed by the company. The research and development costs are estimated to be 鈧?00,000 on a market research study to assess the potential market for the product. Based on this study it is estimated that the company will be able to sell 12,000 units at a price of 鈧?4 next year, with the unit sales expanding by an additional 10% a year in subsequent years. The product is expected to be withdrawn from the market after 5 years. The direct costs of production are estimated to be 鈧?3 a unit. The overheads attributable to the production will amount to 鈧?5,000 pr annum. Manufacture of the product requires an initial investment in machinery amount to 鈧?60,000, which will be depreciated on a straight line basis over its useful life of 7 years. It is anticipated that the machinery will have resale value of 鈧?26,000 at the end of the products working life. The project would also require the use of an existing storage facility that would have been rented out for 鈧?,000 per annum if it were not used for the project. The company plans to invest in working capital. It is estimated that debtors and creditors will offset each other, but an investment in stock worth 鈧?2,000 is required in the beginning of the project and this requirement is expected to grow by 12% in the preceding year. Working capital requirement will no increase further for the rest of the projects life. The company requires a 10% after tax rate of return on such investments and the corporate tax rate is 32%.

(i) Determine the net present value of the proposed investment
(ii) Consider the sensitivity of the NPV to a 10% increase in the price of the product.

I have been calculating and have been receiving different answers. Tq

NPV is net present value.

This means you have to reduce all future values 'down' to today's value.

Unfortunately this is not possible because future opportunity cost of Capital is not specified, nor is the rate of inflation .. also there seems to be some invalid assumptions re: future corporate tax rate ..

I note some new machinery is mentioned - whist I assume the recruitment and training of the workforce is included in the production overhead there is no mention of additional overhead costs (eg. retraining or Redundancy) at the end of production (if the machinery is to be sold off it seems likely that the skilled workforce will no longer be required).


Finally (assuming the product consists of some type of electric or electronic equipment), under the WEEE directives, the Company is responsible for the final disposal of the product at end of life .. there seems to be no mention of these costs.

NB> it is mentioned that " ... considering the introduction of new product which was developed by the company ..." = if the development is already completed, then the development costs should be ignored when calculating NPV (since these costs, along with the market survey costs, have already been spent, there is no decision that can be made to 'unspend' such costs .. they should all be factored into general overhead)

stick the data in excel and press the magic button - the help screen tells you all about the function- I won't do the sums for you but when I learn't to do this we had to do it with basic calculators with no npv function

Yes shows my age