Beacon Chemicals plc is considering buying some equipment to produce a chemical
ID: 2812675 • Letter: B
Question
Beacon Chemicals plc is considering buying some equipment to produce a chemical named X14. The new equipment’s capital cost is estimated at GHC100,000. If its purchase is approved now, the equipment can be bought and production can commence by the end of this yaer. GHC50,000 has already been spent on research and development work. Estimates of revenue and costs arising from the operation of the new equipment appear below:
Year 1
Year 2
Year 3
Year 4
Year 5
Sales price (GHC per litre)
100
120
120
100
80
Sales volume (litres)
800
1,000
1,200
1,000
800
Variable cost (GHC per litre)
50
50
40
30
40
Fixed costs (GHC000)
30
30
30
30
30
If the equipment is bought, sales of some existing products will be lost, and this will result in a loss of contribution of GHC15,000 a year over its life.
The accountant has informed you that the fixed costs include depreciation of GHC20,000 a year on the new equipment. They also include an allocation of GHC10,000 for fixed overheads. A separate study has indicated that if the new equipment were bought, additional overheads, excluding depreciation, arising from producing the chemical would be GHC8,000 a year. Production would require additional working capital of GHC30,000.
For the purposes of your initial calculations ignore taxation.
Required:
Deduce the relevant annual cash flows associated with buying the equipment.
Deduce the payback period.
Calculate the net present value using a discount rate of 8%.
Hint: You should deal with the investment in working capital by treating it as a cash outflow at the start of the project and an inflow at the end.
Year 1
Year 2
Year 3
Year 4
Year 5
Sales price (GHC per litre)
100
120
120
100
80
Sales volume (litres)
800
1,000
1,200
1,000
800
Variable cost (GHC per litre)
50
50
40
30
40
Fixed costs (GHC000)
30
30
30
30
30
Explanation / Answer
from the given data , Payback cann't be calculated as , the payback will be higher than 5 years.
Net Cash Flow Y0 Y1 Y2 Y3 Y4 Y5 Net Capital Costs New equipment cost (GHC 100,000) Cost of research (GHC 50,000) Cash outflow (GHC 150,000) Additionl working capital (GHC 30,000) Total Cost (GHC 180,000) Operating and Maintenance Costs fixed costs include depreciation of (GHC 20,000) (GHC 20,000) (GHC 20,000) (GHC 20,000) (GHC 20,000) Fixed overheads (GHC 10,000) (GHC 10,000) (GHC 10,000) (GHC 10,000) (GHC 10,000) AdditionalFixed overheads (GHC 8,000) (GHC 8,000) (GHC 8,000) (GHC 8,000) (GHC 8,000) Loss on existing product (GHC 15,000) (GHC 15,000) (GHC 15,000) (GHC 15,000) (GHC 15,000) Total Costs (GHC 53,000) (GHC 53,000) (GHC 53,000) (GHC 53,000) (GHC 53,000) Revenue and Operating Benefits Sales vol (in litres) 800 1000 1200 1000 800 Price per litre GHC 100 GHC 120 GHC 120 GHC 100 GHC 80 Sales GHC 80,000 GHC 120,000 GHC 144,000 GHC 100,000 GHC 64,000 Variable cost per litre GHC 50 GHC 50 GHC 40 GHC 30 GHC 40 Total variable cost (GHC 40,000) (GHC 50,000) (GHC 48,000) (GHC 30,000) (GHC 32,000) Terminal cash GHC 30,000 Benefits and Revenue GHC 40,000 GHC 70,000 GHC 96,000 GHC 70,000 GHC 62,000 Net benfit Before Taxes (GHC 180,000) (GHC 13,000) GHC 17,000 GHC 43,000 GHC 17,000 GHC 9,000 Discounted Cash Flow (@8%) (GHC 180,000) (GHC 12,037.04) GHC 14,574.76 GHC 34,134.79 GHC 12,495.51 GHC 6,125.25 NPV (GHC 124,707)Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.