Question

In: Finance

PC Shopping Network may upgrade its modem pool. It last upgraded 2 years ago, when it...

PC Shopping Network may upgrade its modem pool. It last upgraded 2 years ago, when it spent $95 million on equipment with an assumed life of 5 years and an assumed salvage value of $18 million for tax purposes. The firm uses straight-line depreciation. The old equipment can be sold today for $80 million. A new modem pool can be installed today for $150 million. This will have a 3-year life and will be depreciated to zero using straight-line depreciation. The new equipment will enable the firm to increase sales by $25 million per year and decrease operating costs by $10 million per year. At the end of 0 years, the new equipment will be worthless. Assume the firm’s tax rate is 35% and the discount rate for projects of this sort is 10%.

a. What is the net cash flow at time 0 if the old equipment is replaced? (Negative amounts should be indicated by a minus sign. Do not round intermediate calculations. Enter your answer in millions rounded to 2 decimal places.)

(95-18)/5=15.4 Annual depreciation

95-(2x15.4)=64.2 Book value at time of sale

b. What are the incremental cash flows in years 1, 2, and 3? (Do not round intermediate calculations. Enter your answer in millions rounded to 2 decimal places.)

Incremental cash flow = 34.86 million per year

  

c. What are the NPV and IRR of the replacement project? (Do not round intermediate calculations. Enter the NPV in millions rounded to 2 decimal places. Enter the IRR as a percent rounded to 2 decimal places.)

Solutions

Expert Solution

Answers:

a. The Net Cash Flow at the year 0 when the old equipment is replaced shall consist of Cash Inflow from sale of old equipment and Cash Outflow for purchase of new equipment; that is

$ 80 million cash inflow and $ 150 million cash outflow;

thus, net cash flow = $ 150 million - $ 80 million = $ 70 million net cash outflow at year 0

Note: here we have ignored taxation on gain on sale of old equipment; if we need to calculate 35% tax on gain on sale of old equipment than net cash outflow shall increase by 35% of (sale value - book value) = 35% of (80-64.20) = $ 5.53 million

Or we can say that the Net Cash outflow shall be $ 70 + 5.53 = $ 75.53 million

b. Incremental cash flows in year 1, 2 and 3 shall consist of increase in sales by $ 25 million annually + decrease in operating cost by $ 10 million annually + increased tax saving on incremental depreciation due to purchase of new equipment - after tax terminal value that is salvage value of old equipment

Note: Incremental depreciation = Annual Depreciation of new equipment - Annual Depreciation of old equipment = $ 50 million - $ 15.40 million = $ 34.60 million

Saving in tax due to increased depreciation = 35% of $ 34.60 = $ 12.11 million

After tax terminal value of old equipment = 18*(1-0.35) = $ 11.70 million

So,

Total Incremental Cash Inflow = 25 + 10 + 12.11 - 11.70 = $ 35.41 annually

c. NPV and IRR for replacement project:

NPV of replacement project = Present Value of Cash Inflow for years 1,2,3 - Present Value of Incremental cash outflow for year 0 when old equipment is sold

Present Value of Incremental Cash Outflow at year 0 = $ 70 million (if we ignore taxation on gain)

Present Value of Incremental Cash inflow for years 1,2,3 = Annual Incremental Cash Inflow * Present Value Annuity Factor at 6% for 3 years = $ 35.41 million * [(1/1.06)^1 + (1/1.06)^2 + (1/1.06)^3] = $ 35.41 million*2.6730119494616 = $ 94.651353 or $ 94.65 million

So, NPV = 94.65 million - $ 70 million = $ 24.65 million

or NPV = 94.65 - 75.53 = $ 19.12 million

IRR is the rate of return at which NPV is zero. That is at IRR, NPV = $70 million (if we ignore taxation on sale of equipment)

That means we need a Present Value Annuity Factor for 3 years that has a value of $ 70 million / $ 35.41 million = 1.9768

or 75.53/35.41 = 2.13301 if we consider tax on gain on sale of equipment

On seeing the Present Value Annuity Table for 3 years we find that 2.13301 comes for approx 19.20% and 1.9768 comes for approx 24.15%

So, IRR = 19.20% if we consider tax on gain on sale of equipment

and IRR = 24.15% if we ignore tax on gain on sale of old equipment


Related Solutions

PC Shopping Network may upgrade its modem pool. It last upgraded 2 years ago, when it...
PC Shopping Network may upgrade its modem pool. It last upgraded 2 years ago, when it spent $85 million on equipment with an assumed life of 5 years and an assumed salvage value of $25 million for tax purposes. The firm uses straight-line depreciation. The old equipment can be sold today for $70 million. A new modem pool can be installed today for $150 million. This will have a 3-year life and will be depreciated to zero using straight-line depreciation....
PC Shopping Network may upgrade its modem pool. It last upgraded 2 years ago, when it...
PC Shopping Network may upgrade its modem pool. It last upgraded 2 years ago, when it spent $115 million on equipment with an assumed life of 5 years and an assumed salvage value of $15 million for tax purposes. The firm uses straight-line depreciation. The old equipment can be sold today for $80 million. A new modem pool can be installed today for $150 million. This will have a 3-year life and will be depreciated to zero using straight-line depreciation....
PC Shopping Network may upgrade its modem pool. It last upgraded 2 years ago, when it...
PC Shopping Network may upgrade its modem pool. It last upgraded 2 years ago, when it spent $155 million on equipment with an assumed life of 5 years and an assumed salvage value of $25 million for tax purposes. The firm uses straight-line depreciation. The old equipment can be sold today for $110 million. A new modem pool can be installed today for $180 million. This will have a 3-year life and will be depreciated to zero using straight-line depreciation....
PC Shopping Network may upgrade its modem pool. It last upgraded 2 years ago, when it...
PC Shopping Network may upgrade its modem pool. It last upgraded 2 years ago, when it spent $110 million on equipment with an assumed life of 5 years and an assumed salvage value of $20 million for tax purposes. The firm uses straight-line depreciation. The old equipment can be sold today for $80 million. A new modem pool can be installed today for $150 million. This will have a 3-year life and will be depreciated to zero using straight-line depreciation....
PC Shopping Network may upgrade its modem pool. It last upgraded 2 years ago, when it...
PC Shopping Network may upgrade its modem pool. It last upgraded 2 years ago, when it spent $155 million on equipment with an assumed life of 5 years and an assumed salvage value of $25 million for tax purposes. The firm uses straight-line depreciation. The old equipment can be sold today for $110 million. A new modem pool can be installed today for $180 million. This will have a 3-year life and will be depreciated to zero using straight-line depreciation....
PC Shopping Network may upgrade its modem pool. It last upgraded 2 years ago, when it...
PC Shopping Network may upgrade its modem pool. It last upgraded 2 years ago, when it spent $90 million on equipment with an assumed life of 5 years and an assumed salvage value of $17 million for tax purposes. The firm uses straight-line depreciation. The old equipment can be sold today for $80 million. A new modem pool can be installed today for $150 million. This will have a 3-year life and will be depreciated to zero using straight-line depreciation....
PC Shopping Network may upgrade its modem pool. It last upgraded 2 years ago, when it...
PC Shopping Network may upgrade its modem pool. It last upgraded 2 years ago, when it spent $75 million on equipment with an assumed life of 5 years and an assumed salvage value of $10 million for tax purposes. The firm uses straight-line depreciation. The old equipment can be sold today for $80 million. A new modem pool can be installed today for $180 million. This will have a 3-year life and will be depreciated to zero using straight-line depreciation....
PC Shopping Network may upgrade its modem pool. It last upgraded 2 years ago, when it...
PC Shopping Network may upgrade its modem pool. It last upgraded 2 years ago, when it spent $115 million on equipment with an assumed life of 5 years and an assumed salvage value of $15 million for tax purposes. The firm uses straight-line depreciation. The old equipment can be sold today for $80 million. A new modem pool can be installed today for $150 million. This will have a 3-year life and will be depreciated to zero using straight-line depreciation....
PC Shopping Network may upgrade its modem pool. It last upgraded 2 years ago, when it...
PC Shopping Network may upgrade its modem pool. It last upgraded 2 years ago, when it spent $110 million on equipment with an assumed life of 5 years and an assumed salvage value of $10 million for tax purposes. The firm uses straight-line depreciation. The old equipment can be sold today for $80 million. A new modem pool can be installed today for $150 million. This will have a 3-year life and will be depreciated to zero using straight-line depreciation....
PC Shopping Network may upgrade its modem pool. It last upgraded 2 years ago, when it...
PC Shopping Network may upgrade its modem pool. It last upgraded 2 years ago, when it spent $105 million on equipment with an assumed life of 5 years and an assumed salvage value of $11 million for tax purposes. The firm uses straight-line depreciation. The old equipment can be sold today for $80 million. A new modem pool can be installed today for $150 million. This will have a 3-year life and will be depreciated to zero using straight-line depreciation....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT