Question

Capital Investment, Discount Rates, Intangible and Indirect Benefits, Time Horizon, Contemporary Manufacturing Environment

Mallette Manufacturing, Inc., produces washing machines, dryers, and dishwashers. Because of increasing competition, Mallette is considering investing in an automated manufacturing system. Since competition is most keen for dishwashers, the production process for this line has been selected for initial evaluation. The automated system for the dishwasher line would replace an existing system (purchased one year ago for $6 million). Although the existing system will be fully depreciated in nine years, it is expected to last another 10 years. The automated system would also have a useful life of 10 years.

The existing system is capable of producing 100,000 dishwashers per year. Sales and production data using the existing system are provided by the Accounting Department:

Sales per year (units)	100,000
Selling price	$300
Costs per unit:
Direct materials	80
Direct labor	90
Volume-related overhead	20
Direct fixed overhead	40*

*All cash expenses with the exception of depreciation, which is $6 per unit. The existing equipment is being depreciated using straight-line with no salvage value considered.

The automated system will cost $34 million to purchase, plus an estimated $20 million in software and implementation. (Assume that all investment outlays occur at the beginning of the first year.) If the automated equipment is purchased, the old equipment can be sold for $3 million.

The automated system will require fewer parts for production and will produce with less waste. Because of this, the direct material cost per unit will be reduced by 25 percent. Automation will also require fewer support activities, and as a consequence, volume-related overhead will be reduced by $4 per unit and direct fixed overhead (other than depreciation) by $17 per unit. Direct labor is reduced by 60 percent. Assume, for simplicity, that the new investment will be depreciated on a pure straight-line basis for tax purposes with no salvage value. Ignore the half-life convention.

The firm’s cost of capital is 12 percent, but management chooses to use 20 percent as the required rate of return for evaluation of investments. The combined federal and state tax rate is 40 percent.

The present value tables provided in Exhibit 19B.1 and Exhibit 19B.2 must be used to solve the following problems.

Required:

1. Compute the net present value for the old system and the automated system.

Old system	$
New system	$

Which system would the company choose?
Old system

2. Repeat the net present value analysis of Requirement 1, using 12 percent as the discount rate.

Old system	$
New system	$

3. Upon seeing the projected sales for the old system, the marketing manager commented: “Sales of 100,000 units per year cannot be maintained in the current competitive environment for more than one year unless we buy the automated system. The automated system will allow us to compete on the basis of quality and lead time. If we keep the old system, our sales will drop by 10,000 units per year.” Repeat the net present value analysis, using this new information and a 12 percent discount rate.

Old system

$

4. An industrial engineer for Mallette noticed that salvage value for the automated equipment had not been included in the analysis. He estimated that the equipment could be sold for $4 million at the end of 10 years. He also estimated that the equipment of the old system would have no salvage value at the end of 10 years. Repeat the net present value analysis using this information, the information in Requirement 3, and a 12 percent discount rate.

New system	Increases	to	NPV = $
Old system	Unchanged	to	NPV = $

Answer 1

a)
Old system
Year	Sales revenue = 100,000 x $300	Less : Cost = 100,000 x (80+90+20+40 - 6)	EBIT	Tax	Net Income	Add: Depreciation = $100000 x $6	Net Operating Cash Flow	PV @ 20%	Present Value
0								1	0
1	$30,000,000.00	$23,000,000.00	$7,000,000.00	$2,800,000.00	$4,200,000.00	$600,000.00	$4,800,000.00	0.8333	$4,000,000.00
2	$30,000,000.00	$23,000,000.00	$7,000,000.00	$2,800,000.00	$4,200,000.00	$600,000.00	$4,800,000.00	0.6944	$3,333,333.33
3	$30,000,000.00	$23,000,000.00	$7,000,000.00	$2,800,000.00	$4,200,000.00	$600,000.00	$4,800,000.00	0.5787	$2,777,777.78
4	$30,000,000.00	$23,000,000.00	$7,000,000.00	$2,800,000.00	$4,200,000.00	$600,000.00	$4,800,000.00	0.4823	$2,314,814.81
5	$30,000,000.00	$23,000,000.00	$7,000,000.00	$2,800,000.00	$4,200,000.00	$600,000.00	$4,800,000.00	0.4019	$1,929,012.35
6	$30,000,000.00	$23,000,000.00	$7,000,000.00	$2,800,000.00	$4,200,000.00	$600,000.00	$4,800,000.00	0.3349	$1,607,510.29
7	$30,000,000.00	$23,000,000.00	$7,000,000.00	$2,800,000.00	$4,200,000.00	$600,000.00	$4,800,000.00	0.2791	$1,339,591.91
8	$30,000,000.00	$23,000,000.00	$7,000,000.00	$2,800,000.00	$4,200,000.00	$600,000.00	$4,800,000.00	0.2326	$1,116,326.59
9	$30,000,000.00	$23,000,000.00	$7,000,000.00	$2,800,000.00	$4,200,000.00	$600,000.00	$4,800,000.00	0.1938	$930,272.16
10	$30,000,000.00	$22,400,000.00	$7,600,000.00	$3,040,000.00	$4,560,000.00	$0.00	$4,560,000.00	0.1615	$736,465.46
								NPV	$20,085,104.67
New System
Year	Sales revenue = 100,000 x $300	Less : Cost = 100,000 x $135	Depreciation = $54000000/10	EBIT	Tax	Net Income	Add: Depreciation = $100000 x $6	Net Operating Cash Flow	PV @ 20%	Present Value
0								-$50,040,000.00	1	-$50,040,000.00
1	$30,000,000.00	$12,900,000.00	$5,400,000.00	$11,700,000.00	$4,680,000.00	$7,020,000.00	$5,400,000.00	$12,420,000.00	0.8333	$10,350,000.00
2	$30,000,000.00	$12,900,000.00	$5,400,000.00	$11,700,000.00	$4,680,000.00	$7,020,000.00	$5,400,000.00	$12,420,000.00	0.6944	$8,625,000.00
3	$30,000,000.00	$12,900,000.00	$5,400,000.00	$11,700,000.00	$4,680,000.00	$7,020,000.00	$5,400,000.00	$12,420,000.00	0.5787	$7,187,500.00
4	$30,000,000.00	$12,900,000.00	$5,400,000.00	$11,700,000.00	$4,680,000.00	$7,020,000.00	$5,400,000.00	$12,420,000.00	0.4823	$5,989,583.33
5	$30,000,000.00	$12,900,000.00	$5,400,000.00	$11,700,000.00	$4,680,000.00	$7,020,000.00	$5,400,000.00	$12,420,000.00	0.4019	$4,991,319.44
6	$30,000,000.00	$12,900,000.00	$5,400,000.00	$11,700,000.00	$4,680,000.00	$7,020,000.00	$5,400,000.00	$12,420,000.00	0.3349	$4,159,432.87
7	$30,000,000.00	$12,900,000.00	$5,400,000.00	$11,700,000.00	$4,680,000.00	$7,020,000.00	$5,400,000.00	$12,420,000.00	0.2791	$3,466,194.06
8	$30,000,000.00	$12,900,000.00	$5,400,000.00	$11,700,000.00	$4,680,000.00	$7,020,000.00	$5,400,000.00	$12,420,000.00	0.2326	$2,888,495.05
9	$30,000,000.00	$12,900,000.00	$5,400,000.00	$11,700,000.00	$4,680,000.00	$7,020,000.00	$5,400,000.00	$12,420,000.00	0.1938	$2,407,079.21
10	$30,000,000.00	$12,900,000.00	$5,400,000.00	$11,700,000.00	$4,680,000.00	$7,020,000.00	$5,400,000.00	$12,420,000.00	0.1615	$2,005,899.34
									NPV	$2,030,503.30
Costs per unit:
Direct materials = $80 x (1-25%)	60
Direct labor = $90 x (1-60%)	36

Costs per unit:
Direct materials = $80 x (1-25%)	60
Direct labor = $90 x (1-60%)	36
Volume-related overhead ($20 -4)	16
Direct fixed overhead= 40- 17-6	17
Total cost per unit	129
Net outlay = $54,000,000 – $3,000,000 - $960,000	$50,040,000.00
Year 0: Tax savings on loss from sale of old machine = 0.4×($6,000,000 – $600,000 – $3,000,000) =	$960,000.00
Old system	$20,085,104.67
New system	$2,030,503.30
The company should keep the old system