One of two methods will produce solar panels for electric power generation. Method 1
will have an initial cost of $550,000, an annual operating cost of $160,000 per year, and
a $125,000 salvage value after its three-year life. Method 2 will cost $830,000 with an
annual operating cost of $120,000, and a $240,000 salvage value after its five-year life.
The company has asked you to determine which method is economically better, but it
wants the analysis done over a three-year planning period. The salvage value of Method 2
will be 35% higher after 3 years than it is after 5 years. If the company’s MARR is 10%
per year, which method should the company select?
Problem 5.15
An environmental engineer is considering three methods for disposing of a non-
hazardous chemical sludge: land application, fluidized-bed incineration, and private
disposal contract. The estimates for each method are estimated. (a) Determine which has
the least cost on the basis of an annual worth comparison at 10% per year. (b) Determine
the equivalent present worth value of each alternative using its AW value.
Problem 5.16
BP Oil is in the process of replacing sections of its Prudhoe Bay, Alaska oil transit
pipeline. This will reduce corrosion problems, while allowing higher line pressures and
flow rates to downstream processing facilities. The installed cost is expected to be about
$170 million. Alaska imposes a 22.5% tax on annual profits (net revenue over costs),
which are estimated to average $85 million per year for a 20 year period. Use tabulated
factors and a spreadsheet to answer the following: (a) At a corporate MARR of 10% per
year, does the project AW indicate it will make at least the MARR? (b) Recalculate the
AW at MARR values increasing by 10% per year, that is, 20%, 30%, etc. At what
required return does the project become financially unacceptable?
Problem 5.17
Equipment needed at a Valero Corporation refinery for the conversion of corn stock to
ethanol, a cleaner burning gasoline additive, will cost $175,000 and have net cash flows
of $35,000 the first year, increasing by $10,000 per year over the life of 5 years. (a) Use a
spreadsheet (and tabulated factors, if instructed to do so) to calculate the AW amounts at
different MARR values to determine when the project switches from financially justified
to unjustified. (b) Develop a spreadsheet chart that plots AW versus interest rate.
Problem 5.18
The TT Racing and Performance Motor Corporation wishes to evaluate two alternative
machines for NASCAR motor tune-ups. (a) Use the AW method at 9% per year to select
the better alternative. (b) Use spreadsheet single-cell functions to find the better
alternative.