Good morning, I would need some help for this assignments:

TEXT:

The New Economy Transport Company (NETCO) was formed in 1959 to carry cargo and passengers between ports in the Pacific Northwest and Alaska. By 2015 its fleet had grown to four vessels, including a small dry-cargo vessel, the Vital Spark.

The Vital Spark is 25 years old and badly in need of an overhaul. Peter Handy, the finance director, has just been presented with a proposal that would require the following expenditures:

Overhaul engine and generators $340,000

Replace radar and other electronic equipment 75,000

Repairs to hull and superstructure 310,000

Painting and other repairs 95,000

TOT. = $820,000

Mr. Handy believes that all these outlays could be depreciated for tax purposes in the seven-year MACRS class.

NETCO's chief engineer, McPhail, estimates the postoverhaul operating costs as follows:

Fuel $ 450,000

Labor and benefits 480,000

Maintenance 141,000

Other 110,000

TOT. = $1,181,000

These costs generally increase with inflation, which is forecasted at 2.5% a year.

The Vital Spark is carried on NETCO's books at a net depreciated value of only $100,000, but could probably be sold "as is," along with an extensive inventory of spare parts, for $200,000. The book value of the spare parts inventory is $40,000. Sale of the Vital Spark would generate an immediate tax liability on the difference between sale price and book value.

Overhaul of the Vital Spark would take it out of service for several months. The overhauled vessel would resume commercial service next year. Based on past experience, Mr. Handy believes that it would generate revenues of about $1.4 million next year, increasing with inflation thereafter.

But the Vital Spark cannot continue forever. Even if overhauled, its useful life is probably no more than 10 years, 12 years at the most. Its salvage value when finally taken out of service will be trivial.

NETCO is a conservatively financed firm in a mature business. It normally evaluates capital investments using an 11% cost of capital. This is a nominal, not a real, rate. NETCO's tax rate is 35%.

QUESTIONS:

in the spreadsheet about the computation of the NpPV, how do I have to take into account the part I put in italics?

Do I have to consider it as an opportunity cost, thus something that increase my initial investments? (i.e. by undertaking the investments, i cannot sell the ship, thus i am loosing the opportunity to gain that amount). In this case, what about the salvage value?

Or instead it has to do with changes in working capital? in this case, i am not sure how to acount for it over the period.

Please, help me. i do not need the whole spreadsheet, just some clarification about this issue. thanks