You are considering outsourcing customer service to a foreign company. You have the following information about the financial implications of outsourcing over the next 4 years.

Going ahead with outsourcing has the following implications:

You will need to buy communications equipment worth $8 million at time 0 which will be depreciated straight line over the next 4 years assuming no salvage value (i.e. to zero). The first depreciation is at time 1.

You will be able to sell the used communications equipment at time 4 for $3 million.

The foreign company will charge you $5 million at the end of each year for providing your customer service.

You expect that the foreign company will not be able to provide quite as good customer service as your current customer service department. You therefore expect that operating revenues will be $50 million per year (at time 1, 2, 3, 4) without outsourcing but only $49 million per year with outsourcing.

You will be able to sell the office building which is currently used by the customer service department for $8 million today. The office building has been fully depreciated.

The required level of working capital is $2 million for the period of time 1 to 3 and this will drop to 0 at time 4.

In contrast, not going ahead with the outsourcing has the following implications:

The operating costs of the customer service department will be $8 million at the end of each year.

You will be able to sell the office building used by the customer service department for $9 million in 4 years.

The required level of working capital is $4 million for the period of time 1 to 3 and this will drop to 0 at time 4.

Your firm's tax rate is 40% and its opportunity cost of capital is 10%.

a) Determine the appropriate cash flows of the decision to outsource and to keep customer service in house.

b) Calculate the NPV of the net cash flows and conclude whether the firm should outsource or not.

input data 0 1 2 3 4 2 outsource 3 revenues 4 building (sale) 5 equipment (sale) 5 costs - to the firm 7 depr BEBIT tax Unlevered NI 1 WC 2 equipment (buy) 3 depr 1 FCF 5 5 cost of capital 7 PV (FCF) 3 NPV 2 0 1 2 3 4 in-house 1 revenues 2 building (sale) 3 Costs 4 EBIT 5 tax S NI 7 WC 3 FCF cost of capital 1 PV (FCF) 2 NPV 3 1 Incremental NPV 5