Question

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 $118 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 $73 million. A new modem pool can be installed today for $159 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 $18 million per year and decrease operating costs by $12 million per year. At the end of 3 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 12%. (Enter your answers in millions. For example, an answer of $13,000,000 should be entered as 13. Use minus sign to enter cash outflows, if any.)
a. What is the net cash flow at time 0 if the old equipment is replaced? (Round your answer to 2 decimal places.)
The net cash flow at time 0    $ million
b. What is the incremental cash flow in year 1? (Round your answer to 3 decimal places.)
The incremental cash flow in year 1     $ million
What is the incremental cash flow in year 2? (Round your answer to 3 decimal places.)
The incremental cash flow in year 2    $ million
What is the incremental cash flow in year 3? (Round your answer to 3 decimal places.)
The incremental cash flow in year 3    $ million
c. What is the NPV of the replacement project? (Round your answer to 2 decimal places.)
NPV    $ million
What is the IRR of the replacement project? (Round your answer to 2 decimal places.)
IRR    %
d. Now ignore straight-line depreciation and assume that both new and old equipment are in an asset class with a CCA rate of 30%. PC Shopping Network has other assets in this asset class. What is the NPV of the replacement project? For this part, assume that the new equipment will have a salvage value of $35 million at the end of 3 years. (Round your answer to 2 decimal places.)
NPV    $ million
0 0
Add a comment Improve this question Transcribed image text
Answer #1

a)

Amount in Million $

New Equipment Cash Outflow -159

Old Equipment Cash Inflow 73

Net Cash Flow - 86

The net cash flow at time 0 is - $86 million

b)

Year 2 18.0018.00 18.00 12.0012.00 12.00 Particulars Incremental Sales Incremental Cost Savings Incremental Depreciation [159/3-(118-20)/51 Total Incremental Savings Tax @ 35% Net Incremental Savings 33.40 33.4033.40 63.40 63.4063.40 (22.19)| (22.19) (22.19) 41.2141.2141.21

The incremental cash flow in year 1     $ 41.21 million

The incremental cash flow in year 2 $ 41.21 million

The incremental cash flow in year 3 $ 41.21 million

c)

Particulars Incremental Sales Incremental Cost Savings Incremental Depreciation [159/3-(118-20)/5] Total Incremental Savings Tax @ 35% Net Incremental Savings PV Factor @ 12% Present Value 2 18.0018.00 18.00 12.0012.00 12.00 1 33.40 33.40 33.40 63.40 63.40 63.40 22.19) (22.19)(22.19 41.21 41.21 41.21 0.893 0.797 0.712 36.7932.85 29.33 Net Cash Flow at Year 0 PV of Future Cashflows NPV of Replacement Project (86.00) 98.98 12.98

NPV is $ 12.98 Million

Add a comment
Know the answer?
Add Answer to:
PC Shopping Network may upgrade its modem pool. It last upgraded 2 years ago, when it...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 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 $25 million for tax purposes. The firm uses straight-line depreciation. The old equipment can be sold today for $120 million. A new modem pool can be installed today for $240 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 $30 million for tax purposes. The firm uses straight-line depreciation. The old equipment can be sold today for $90 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 $155 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 $120 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 modern pool it lar t upgraded 2 years ago, when it spent $110...

    PC Shopping Network may upgrade its modern pool it lar t upgraded 2 years ago, when it spent $110 million on equipment with an assumed Me of 5 years and an assumed salvage value of $10 million for tax purposes. The firm uses straight-ine 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 rero using...

  • 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 $88,750. A new piece of equipment can be purchased for $302,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 $23,000 2............... 76,500 14,750...

  • Bottoms Up Diaper Service is considering the purchase of a new industrial washer, It can Durchase...

    Bottoms Up Diaper Service is considering the purchase of a new industrial washer, It can Durchase the washer for $1.800 and sell its old washer for $600. The new washer will last for 6 vears and save $500 a year in expenses. The opportunity cost of capital is 19% , and the firm's tax rate is 40% a. If the firm uses straight-line depreciation to an assumed salvage value of zero over a 6-year life. what is the annual operating...

  • 12. Texelco' new modem can go into production for an initial investment in production equipment of...

    12. Texelco' new modem can go into production for an initial investment in production equipment of $4 million. The equipment will be depreciated straightline over 2 years to a value of zero. It will be sold after 2 years for $500,000. Production costs will equal $200 per modem. The modems will be sold for $375 each. The firm is setting aside working capital of $200,000 at the outset, recaptured at the end of year 2. Sales forecasts are at the...

  • I need help with the third part, please. Problem 6-21 Calculating NPV and IRR for a Replacement A firm is considering a...

    I need help with the third part, please. Problem 6-21 Calculating NPV and IRR for a Replacement A firm is considering an investment in a new machine with a price of $18.18 million to replace its existing machine. The current machine has a book value of $6.18 million and a market value of $4.68 million. The new machine is expected to have a four-year life, and the old machine has four years left in which it can be used. If...

  • 20. Problem 12.20 (Replacement Analysis) eBook The Darlington Equipment Company purchased a machine 5 years ago...

    20. Problem 12.20 (Replacement Analysis) eBook The Darlington Equipment Company purchased a machine 5 years ago at a cost of $90,000. The machine had an expected life of 10 years at the time of purchase, and it is being depreciated by the straight-line method by $9,000 per year. If the machine is not replaced, it can be sold for $15,000 at the end of its useful life. A new machine can be purchased for $180,000, including installation costs. During its...

  • Revenues generated by a new fad product are forecast as follows Revenues $50,000 20,000 10,000 5,e00 Year 1 2 3 T...

    Revenues generated by a new fad product are forecast as follows Revenues $50,000 20,000 10,000 5,e00 Year 1 2 3 Thereafter Expenses are expected to be 60 % of revenues, and working capital required in each year is expected to be 20 % of revenues in the following year. The product requires an immediate investment of $52,000 in plant and equipment a. What is the initial investment in the product? Remember working capital. ces Initial investment 62,000 b. If the...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT