Question

The Woodruff Corporation purchased a piece of equipment three years ago for $210,000. It has an asset depreciation range (ADR) midpoint of eight years. The old equipment can be sold for $86,500. A new piece of equipment can be purchased for $304,000. It also has an ADR of eight years. Assume the old and new equipment would provide the following operating gains (or losses) over the next six years.

Year New Equipment Old Equipment

1 $79,000 $23,500

2 78,000 17,500

3 71,500 8,500

4 58,250 6,750

5 48,500 5,500

6 44,500 -5,250

The firm has a 25 percent tax rate and a 9 percent cost of capital.

a. What is the net cost of the new equipment?

b. What is the present value of the incremental benefits?

c. What is the NPV of this replacement decision?

Answer 1

1. ADR of 8 years implies MACRS schedule of 5 years to be following for depreciation

2. Net Sales value of old equipment now:

Old equipment purchase price ( 3 years ago)	210,000
Less:
Depreciaion of year -3 (under MACRS schedule) at 20%	42,000	(210,000*20%)
Depreciaion of year -2 (under MACRS schedule) at 32%	67,200	(210,000*32%)
Depreciaion of year -1 (under MACRS schedule) at 19.2%	40,320	(210,000*19.2%)
Total depreciation from year 1 to 3	149,520
Net Book Value	60,480	(210,000-149,520)
Sale of old equipment now	86,500
Profit	26,020	(86,500-60,480)
Tax on profit	6,505	(26,020*25%)
Net Sales value of equipment now	79,995	(86,500-6,505)

3. Yearly Operating Gains

	Operating gains (before tax)	Operating gains (after tax) = (Operating gains (before tax) *(100% - 25%)
Years	New Equipment	Old Equipment	Incremental (New Equipment - Old Equipment)	New Equipment	Old Equipment	Incremental (New Equipment - Old Equipment)
1	79,000	23,500	55,500	59,250	17,625	41,625
2	78,000	17,500	60,500	58,500	13,125	45,375
3	71,500	8,500	63,000	53,625	6,375	47,250
4	58,250	6,750	51,500	43,688	5,063	38,625
5	48,500	5,500	43,000	36,375	4,125	32,250
6	44,500	(5,250)	49,750	33,375	(3,938)	37,313

4. Yearly depreciation and tax shield on depreciation

	New Equipment	Old Equipment
Years	Rate	Depreciation (New equipment cost of $304,000*Rate)	Tax shield (Depreciation * 25%)	Rate	Depreciation (New equipment cost of $210,000*Rate)	Tax shield (Depreciation * 25%)
1	20.00%	60,800	15,200	11.52%	24,192	6,048
2	32.00%	97,280	24,320	11.52%	24,192	6,048
3	19.20%	58,368	14,592	5.76%	12,096	3,024
4	11.52%	35,021	8,755
5	11.52%	35,021	8,755
6	5.76%	17,510	4,378

5. Discount factor at 9%

Year 1 = 1/(100%+9%)^1 = 0.917

Year 2 = 1/(100%+9%)^2 = 0.842

Year 3 = 1/(100%+9%)^3 = 0.772

Year 4 = 1/(100%+9%)^4 = 0.708

Year 5 = 1/(100%+9%)^5 = 0.650

Year 6 = 1/(100%+9%)^6 = 0.596

6. Calculation of Net-Present Value

		Cash-flows		Present value of cash-flows (Cash-flows * Present Value factor at 9%
Years	Particulars	New Equipment	Old Equipment	Present Value factor at 9%	New Equipment	Old Equipment	Incremental (New equipment - Old equipment)
0	Purchase cost	(304,000)	-	1.000	(304,000)	-	(304,000)
0	Sale of old equipment	79,995	-	1.000	79,995	-	79,995
0	Initial Outlay	(224,005)	-	1.000	(224,005)	-	(224,005)
1	Operating Gains (after tax)	59,250	17,625	0.917	54,358	16,170	38,188
2	58,500	13,125	0.842	49,238	11,047	38,191
3	53,625	6,375	0.772	41,408	4,923	36,486
4	43,688	5,063	0.708	30,949	3,586	27,363
5	36,375	4,125	0.650	23,641	2,681	20,960
6	33,375	(3,938)	0.596	19,900	(2,348)	22,248
1	Tax shield on Depreciation	15,200	6,048	0.917	13,945	5,549	8,396
2	24,320	6,048	0.842	20,470	5,090	15,379
3	14,592	3,024	0.772	11,268	2,335	8,933
4	8,755	-	0.708	6,202	-	6,202
5	8,755	-	0.650	5,690	-	5,690
6	4,378	-	0.596	2,610	-	2,610
	Total Present Value			jeff jeffy Next > < Previous Related Solutions The Woodruff Corporation purchased a piece of equipment three years ago for $230,000. It has an... The Woodruff Corporation purchased a piece of equipment three years ago for $230,000. It has an asset depreciation range(ADR) midpoint of 8 years. The old equipment can be sold for $90,000. A new piece of equipment can be purchased for$320,000. It also has an ADR of 8 years. Assume the old and new equipment would provide the following operating gains (or losses) over the next 6 years. Year New Equipment Old Equipment 1 $80,000 $25,000 2 76,000 16,000 3 70,000... The Woodruff Corporation purchased a piece of equipment three years ago for $233,000. It has an... The Woodruff Corporation purchased a piece of equipment three years ago for $233,000. It has an asset depreciation range(ADR) midpoint of 8 years. The old equipment can be sold for $94000. A new piece of equipment can be purchased for $335,500. It also has an ADR of 8 years. Assume the old and new equipment would provide the following operating gains(or losses) over the next six years: Year New Equipment Old Equipment 1 $78,750 $26,000 2 $76,250 $14,500 3 $68,250... The Woodruff Corporation purchased a piece of equipment three years ago for $245,000. It has an... The Woodruff Corporation purchased a piece of equipment three years ago for $245,000. It has an asset depreciation range (ADR) midpoint of eight years. The old equipment can be sold for $87,750. A new piece of equipment can be purchased for $336,000. It also has an ADR of eight years. Assume the old and new equipment would provide the following operating gains (or losses) over the next six years. New Equipment   Old Equipment   $78,250 $24,000 $74,750 $17,000 $70,000 $8,000 $60,750... The Woodruff Corporation purchased a piece of equipment three years ago for $248,000. It has an... The Woodruff Corporation purchased a piece of equipment three years ago for $248,000. It has an asset depreciation range (ADR) midpoint of eight years. The old equipment can be sold for $93,250. A new piece of equipment can be purchased for $324,000. It also has an ADR of eight years. Assume the old and new equipment would provide the following operating gains (or losses) over the next six years:    Year New Equipment Old Equipment 1............... $81,500 $24,000 2............... 76,000... The Woodruff Corporation purchased a piece of equipment three years ago for $230,000. It has an... The Woodruff Corporation purchased a piece of equipment three years ago for $230,000. It has an asset depreciation range (ADR) midpoint of eight years. The old equipment can be sold for $85,500. A new piece of equipment can be purchased for $322,000. It also has an ADR of eight years. Assume the old and new equipment would provide the following operating gains (or losses) over the next six years:    Year New Equipment Old Equipment 1............... $78,750 $23,000 2............... 77,500... The Woodruff Corporation purchased a piece of equipment three years ago for $238,000. It has an... The Woodruff Corporation purchased a piece of equipment three years ago for $238,000. It has an asset depreciation range (ADR) midpoint of eight years. The old equipment can be sold for $85,250. A new piece of equipment can be purchased for $340,000. It also has an ADR of eight years. Assume the old and new equipment would provide the following operating gains (or losses) over the next six years:    Year New Equipment Old Equipment 1............... $78,250 $25,500 2............... 75,000... The Woodruff Corporation purchased a piece of equipment three years ago for $229,000. It has an... The Woodruff Corporation purchased a piece of equipment three years ago for $229,000. It has an asset depreciation range (ADR) midpoint of eight years. The old equipment can be sold for $86,000. A new piece of equipment can be purchased for $315,500. It also has an ADR of eight years. Assume the old and new equipment would provide the following operating gains (or losses) over the next six years:    Year New Equipment Old Equipment 1............... $82,000 $24,250 2............... 75,750... The Woodruff Corporation purchased a piece of equipment three years ago for $221,000. It has an... The Woodruff Corporation purchased a piece of equipment three years ago for $221,000. It has an asset depreciation range (ADR) midpoint of eight years. The old equipment can be sold for $92,250. A new piece of equipment can be purchased for $334,000. It also has an ADR of eight years. Assume the old and new equipment would provide the following operating gains (or losses) over the next six years:    Year New Equipment Old Equipment 1............... $81,000 $23,500 2............... 75,000... The Woodruff Corporation purchased a piece of equipment three years ago for $240,000. It has an... The Woodruff Corporation purchased a piece of equipment three years ago for $240,000. It has an asset depreciation range (ADR) midpoint of eight years. The old equipment can be sold for $89,000. A new piece of equipment can be purchased for $320,500. It also has an ADR of eight years. Assume the old and new equipment would provide the following operating gains (or losses) over the next six years:    Year New Equipment Old Equipment 1............... $81,250 $27,000 2............... 77,500... The Woodruff Corporation purchased a piece of equipment three years ago for $245,000. It has an... The Woodruff Corporation purchased a piece of equipment three years ago for $245,000. It has an asset depreciation range (ADR) midpoint of eight years. The old equipment can be sold for $88,750. A new piece of equipment can be purchased for $340,500. It also has an ADR of eight years. Assume the old and new equipment would provide the following operating gains (or losses) over the next six years:    Year New Equipment Old Equipment 1............... $79,750 $26,500 2............... 76,000... ADVERTISEMENT Subjects Accounting Advanced Math Anatomy and Physiology Biology Chemistry Civil Engineering Computer Science Economics Electrical Engineering Finance History Math Mechanical Engineering Operations Management Physics Psychology Statistics and Probability Nursing Other ADVERTISEMENT Latest Questions Given the following solubilities in grams/100ml of water (these are the amounts that stay in solution... A portfolio to the right of the market portfolio on the CML is ___________.   a lending... Mini case study – Scottish Parliament: the £431m question Scotland’s new parliament building cost more than... If you start with 3.0×10^10 I−131 atoms, how many are left after approximately 1month? I−131 has... An unidentified covalent molecular compound contains only carbon, hydrogen, and oxygen. When 7.40 mg of this... Discuss the risk-benefit analysis, please provide examples of its application. On June 30, 2018, Georgia-Atlantic, Inc., leased warehouse equipment from Builders, Inc. The lease agreement calls... ADVERTISEMENT About @ 2020 WizEdu