In: Finance
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?
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 |
Related SolutionsThe 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
ADVERTISEMENT
Latest Questions
ADVERTISEMENT
|