Reference no: EM132614956

Spoonfey Ltd is a manufacturer of cutlery.

• The firm's managers have asked you to evaluate a project proposal to diversify into manufacturing nailfiles.
• A new machine to mould the plastic on to the end of the nailfiles would need to be purchased at a cost of $150 000.
• Freight and insurance for the new machine will cost $3500 and installation will cost a further $1200.
• The files would be pressed on existing equipment.
• The files would be produced by introducing a night shift, so will not displace any current production capacity.
• The existing machine would be modified at a cost of $20 000.
• If the new project goes ahead, Spoonfey will need to increase the raw materials inventory by $2500.
• The finished goods inventory would need to be $4500 higher than its current level.
• Spoonfey will supply 30-day terms to the distributors of the nailfiles and this is expected to result in an increase of $60 000 in accounts receivable.
• The increase in accounts receivable will occur during the first week of production for the project.
• Spoonfey has arranged credit with suppliers of the plastic that will be used in the production process.
• This is expected to result in an increase of $15 000 to accounts payable.
• Spoonfey Ltd has set a 5-year life for the proposed nailfile project.

Spoonfey's management have given you the following forecasts of operating cash flows:

1. Sales of nailfiles for the first year are $120 000. The estimated growth rate for sales is 2% p.a. for the second and subsequent years of the project.
2.  Raw materials are estimated at 15% of sales.
3. Labour costs for the project will be $30 000 per annum.
4. Spoonfey's annual electricity bill is $50 000.

1. The electricity cost for the nailfile project is expected to be 12% of sales.

2. At the end of 5 years, Spoonfey will terminate the nailfile project.

3. It is expected that the plastic moulding machine that was purchased for the project will be sold for $30 000.

4. Removal costs of $650 are expected for the moulding machine.

5. The modifications to the machine used for pressing the metal part of the files will not affect the future use of that machine and will remain in place.

6. The increase in net working capital will be returned to the firm at the end of the project.

Required

Question 1: Construct a table of the annual cash flows for Spoonfey's nailfile project and calculate the NPV of the project using a discount rate of 12%.