In: Finance
Princess Cruise Lines owns five cruise ships that operate continuously in the Caribbean Sea.
As the chief financial officer, you are considering the purchase of a new machine to remove barnacles from the bottom of the ships when they are in dry dock.
Princess currently owns a machine which will provide this same function, but the machine is old (3 years old) and tends to break down a lot. This machine can be sold today for $160,000, and yes, you’ll pay some gains taxes on it. The equipment was purchased three years ago for $2,600,000 and is being depreciated over a three-year period using the MACRS method.
The new machine will cost $3,500,000, has shipping costs of $18,000 (this is added to the depreciable basis), and also will require $37,000 in working capital to support the new machine’s operation. The equipment will be depreciated using 3-year MACRS and will have an expected salvage value of $120,000 at the end of its expected economic life of four years. The working capital will also be recouped at this time.
The annual operating expense savings associated with the machine are expected to be $1,000,000 per year for the next four years. Assume a 25% tax rate. Assume any negative taxes can be immediately used as a tax credit, which makes negative taxes functionally = a positive cash flow.
The NPV of the new machine in Negative $122,099. and IRR is 7.62%
Based on the above calculations. The new barnacle removing machine should not be purchased.
Workings:
The same with Excel Formulas shown: