Overland Steel operateS the coal burning steel mill in New York State. Changes in the states air quality control laws will result in this Mills incurring a $1000 a day fine (Which will be paid at the end of the year) If it continues to operate. The mill currently Operates every day of the year.

The mil was built 20 years ago at a cost of $15 million and has a remaining and undepreciated book value of $3 million. The expected remaining useful life of the mil is 30 years.

The firm can sell the mail to a developer who wants to build a Shopping Center on the site. The buyer will pay $1 million for site if the company demolishes the mill and prepares The site for the developer. The demolition insight preparation costs are estimated at $650,000.

Alternatively, the firm could install pollution control devices and other modernization devices at an initial outlay of $2.75 million. These improvements do not extend the useful life or salvage value of the plant but they do reduce net operating cost by $25,000 per year in addition to eliminating the thousand dollar per day fine. Currently the net cash flows of operating the plant are $450,000 per year before any fines.

Assume

• The market rate of interest is 14%
• There are no taxes
• The annual cash flow estimates given above are constant over the next 30 years
• At the end of the 30 years, the mil has an estimated salvage value of $2 million whether or not the pollution equipment has been installed

Required:

1. Evaluate the various courses of action available to management and make a recommendation. Support your conclusions with neatly labeled calculations where possible.

Plz help idk what this means and dont know how to solve on excel im failing accounting