In: Accounting
Nautical Creations is one of the largest producers of miniature ships in a bottle. An especially complex part of one of the ships needs special production equipment that is not useful for other products. The company purchased this equipment early in 2016 for $200,000. It is now early in 2020, and the manager of the Model Ships Division, Jeri Finley, is thinking about purchasing new equipment to make this part. The current equipment will last for six more years with zero disposal value at that time. It can be sold immediately for $20,000. The following are last year's total manufacturing costs, when production was 7,200 ships: Direct materials $25,920 Direct labor 26,640 Variable overhead 11,880 Fixed overhead 30,960 Total $95,400 The cost of the new equipment is $130,000. It has a six year useful life with an estimated disposal value at that time of $35,000. The sales representative selling the new equipment stated, "The new equipment will allow direct labor and variable overhead combined to be reduced by a total of $1.95 per unit." Finley thinks this estimate is accurate, but also knows that a higher quality of direct material will be necessary with the new equipment, costing $0.15 more per unit. Fixed overhead costs will decrease by $3,400. Finley expects production to be 7,600 ships in each of the next six years. Assume a discount rate of 3%.
What is the difference in net present values if Nautical Creations buys the new equipment instead of keeping their current equipment?
Caluclation of Diffrential NPV if nautical creation buys the equipment | |||||||
Year | Cash Inflow/(Outflow) | PV Factor @3% | Present value | Remarks for cash flow column | |||
0 | (110,000) | 1.000 | (110,000) | (=New Equipment cost $130000- salvage value of old equipment $20000 = 110000) | |||
1 | 10,280 | 0.971 | 9,981 | (Saving in material cost - excess material cost )* No. of ships produced - Excess fixed overhead ; (1.95-0.15)*7600 -3400 | |||
2 | 10,280 | 0.943 | 9,690 | (Saving in material cost - excess material cost )* No. of ships produced - Excess fixed overhead ; (1.95-0.15)*7600 -3400 | |||
3 | 10,280 | 0.915 | 9,408 | (Saving in material cost - excess material cost )* No. of ships produced - Excess fixed overhead ; (1.95-0.15)*7600 -3400 | |||
4 | 10,280 | 0.888 | 9,134 | (Saving in material cost - excess material cost )* No. of ships produced - Excess fixed overhead ; (1.95-0.15)*7600 -3400 | |||
5 | 10,280 | 0.863 | 8,868 | (Saving in material cost - excess material cost )* No. of ships produced - Excess fixed overhead ; (1.95-0.15)*7600 -3400 | |||
6 | 10,280 | 0.837 | 8,609 | (Saving in material cost - excess material cost )* No. of ships produced - Excess fixed overhead ; (1.95-0.15)*7600 -3400 | |||
6 | 35,000 | 0.837 | 29,312 | salvage value of new equipment | |||
Net Present Value | (24,999) | ||||||
NPV = -24999 | |||||||