Please post with excel file to show work and make a spreadsheet

As a financial manager of Sunlight, Inc., a company that produces and sells window glass, you have been recently asked to analyze alternatives to replacing an old furnace. In the glass-making process, before glass is formed, the glass batch - a mix of glass ingredients, which include silicon dioxide, sodium oxide, calcium oxide, and other additives - is melted at high temperature. The process can be both energy and time consuming, depending on the furnace and the volume of production. The furnace the company currently uses has been installed 4 years ago at the cost of $1M, and nears the end of its useful life in December this year. After December, it can no longer be operated, because there is no possibility to refurbish it and in any way prolong its useful life. The annual depreciation on the old furnace was $200,000 per year, so at the end of its life it will have book value of $200,000. Unfortunately, there are no buyers for the old furnace and the company has to scrap it. The old furnace has been rather inefficient, however. The annual energy cost associated with the furnace has averaged $250,000 per year, and it required six employees to operate it at the annual cost of $50,000 per employee. In addition, the inefficient design of the old furnace required time to heat the glass batch up. The chief operating officer estimated that the inefficiency resulted in productivity loss equivalent to one week worth of delays per year. As regards new furnaces, the company has two alternatives. The first alternative is an electric furnace that costs $600,000 to buy and install. It has a useful life of 6 years. However, due to the relatively high costs of electricity, annual operating costs are estimated to be $140,000 per year in electricity and $20,000 per year in operator salaries. You determined that it is possible to use the accelerated depreciation schedule for the electric furnace and depreciate it straight-line over five years to the salvage value of zero. In fact, at the end of its useful life, you expect the electric furnace to have no value. The second alternative is a gas furnace that costs $900,000 to buy and install. It has a useful life of 7 years. Because natural gas is relatively cheap, annual operating costs are estimated to be $100,000 per year in electricity but, due to the relative complexity of the machine, two operators will be needed at the total cost of $30,000 per year for the two. You determined that the company can depreciate the gas furnace straight-line over seven years to its salvage value. At the end of its useful life, the gas furnace is expected to be sold for $100,000. In addition to these costs, the gas furnace will require an increase in inventories of 150,000 to hold a supply of liquid gas tanks during the operation of the machine. These inventories will be recovered at the end of the useful life of the machine. For the most recent fiscal year, total sales for the company reached $10,000,000, costs of goods were $7,000,000, and days of sales in inventories are 35 (using 350 days as the number of working days per year). The company faces a corporate tax rate of 20%, and you estimated that the discount rate which should be used for this project is 10% per year. 1) What should the company do? 2) Assume that the company can extend the useful life of the gas furnace by another three years by refurbishing it in year 7 at a cost of $150,000, which can be expensed fully (treated as a pre-tax cost rather than depreciated over the useful life of three years) in year 7 . What should the company do? 3) Assume that the company has a third alternative, which is to outsource the operations of a furnace to an external contractor, which has operations nearby and can provide all service with respect to the operations of the furnace at an annual cost of $350,000 before tax. What should the company do if it has the outsourcing alternative? Hint: for comparison purposes, set the duration (the life of the outsourcing contact, "useful life") of the outsourcing alternative to the duration of the preferred internal alternative (gas vs electric). As a financial manager of Sunlight, Inc., a company that produces and sells window glass, you have been recently asked to analyze alternatives to replacing an old furnace. In the glass-making process, before glass is formed, the glass batch - a mix of glass ingredients, which include silicon dioxide, sodium oxide, calcium oxide, and other additives - is melted at high temperature. The process can be both energy and time consuming, depending on the furnace and the volume of production. The furnace the company currently uses has been installed 4 years ago at the cost of $1M, and nears the end of its useful life in December this year. After December, it can no longer be operated, because there is no possibility to refurbish it and in any way prolong its useful life. The annual depreciation on the old furnace was $200,000 per year, so at the end of its life it will have book value of $200,000. Unfortunately, there are no buyers for the old furnace and the company has to scrap it. The old furnace has been rather inefficient, however. The annual energy cost associated with the furnace has averaged $250,000 per year, and it required six employees to operate it at the annual cost of $50,000 per employee. In addition, the inefficient design of the old furnace required time to heat the glass batch up. The chief operating officer estimated that the inefficiency resulted in productivity loss equivalent to one week worth of delays per year. As regards new furnaces, the company has two alternatives. The first alternative is an electric furnace that costs $600,000 to buy and install. It has a useful life of 6 years. However, due to the relatively high costs of electricity, annual operating costs are estimated to be $140,000 per year in electricity and $20,000 per year in operator salaries. You determined that it is possible to use the accelerated depreciation schedule for the electric furnace and depreciate it straight-line over five years to the salvage value of zero. In fact, at the end of its useful life, you expect the electric furnace to have no value. The second alternative is a gas furnace that costs $900,000 to buy and install. It has a useful life of 7 years. Because natural gas is relatively cheap, annual operating costs are estimated to be $100,000 per year in electricity but, due to the relative complexity of the machine, two operators will be needed at the total cost of $30,000 per year for the two. You determined that the company can depreciate the gas furnace straight-line over seven years to its salvage value. At the end of its useful life, the gas furnace is expected to be sold for $100,000. In addition to these costs, the gas furnace will require an increase in inventories of 150,000 to hold a supply of liquid gas tanks during the operation of the machine. These inventories will be recovered at the end of the useful life of the machine. For the most recent fiscal year, total sales for the company reached $10,000,000, costs of goods were $7,000,000, and days of sales in inventories are 35 (using 350 days as the number of working days per year). The company faces a corporate tax rate of 20%, and you estimated that the discount rate which should be used for this project is 10% per year. 1) What should the company do? 2) Assume that the company can extend the useful life of the gas furnace by another three years by refurbishing it in year 7 at a cost of $150,000, which can be expensed fully (treated as a pre-tax cost rather than depreciated over the useful life of three years) in year 7 . What should the company do? 3) Assume that the company has a third alternative, which is to outsource the operations of a furnace to an external contractor, which has operations nearby and can provide all service with respect to the operations of the furnace at an annual cost of $350,000 before tax. What should the company do if it has the outsourcing alternative? Hint: for comparison purposes, set the duration (the life of the outsourcing contact, "useful life") of the outsourcing alternative to the duration of the preferred internal alternative (gas vs electric)