Question

Plato Pharmaceuticals Ltd. has invested $100,000 to date in developing a new type of insect repellent. The repellent is now ready for production and sale, and the marketing manager estimates that the product will sell 150,000 bottles a year for the first two years, 170,000 for year three and 200,000 for the next two years. The selling price of the insect repellent will be $6.00 a bottle and the variable costs are estimated to be $3.00 a bottle for Year one. For the next two years the selling price will be $6.50 with variable cost of $3.15 a bottle, and then selling price will be $7.00 after that with a variable cost of $3.55, and $3.80 per bottle. Fixed costs are expected to be $210,000 a year. The figure is made up of $160,000 additional fixed costs and $50,000 fixed costs relating to the existing business that will be apportioned to the new business. In order to produce the repellent, machinery and equipment costing $520,000 will have to be purchased immediately. The estimated residual (salvage) value of this machinery and equipment in five years’ time is $100,000. The business calculates depreciation following CCA rules. The business has a cost of capital of 12%. CCA 30% (50% rule applicable) of depreciation will be used, and taxes are paid at a rate of 40%. Required:

1. Create a cash flow statement for the project for the next 5 years

2. Calculate the net present value.

3. Calculate the internal rate of return.

4. Undertake sensitivity analysis to show how much the following factors would have to change before the project ceased to be feasible. a. The initial cost of machinery and equipment b. Fixed costs c. Variable costs/per bottle d. Selling Price per bottle of repellent e. The residual value of the machinery and equipment

5. Write a statement to explain which of these factors is the most sensitive one.

Answer 1

Question 1:

Cash Flow projection is provided in the exel sheet below

Question 2:

The net present value = $ 278,201

Question 3:

IRR = 28.2%