PLEASE SHOW EXCEL FUNCTION / WORK

PLEASE SHOW EXCEL FUNCTION / WORK

1 - Your firm bought a new sanding machine for its factory floor two years ago for $40,000. The current market value (Year O) of the machine is $10,000 and you believe that it will last 5 more years (Years -5). When you're done with the machine, you can sell it for scrap and receive $1,000. However, your firm is now considering buying a more advanced sander for $80,000. The more advanced machine also last 5 more years. The new machine will have a salvage value of $5,000. The more advanced sander will increase revenues by $50,000 a year and save the company $10,000 in labor costs each year when compared to the old machine. The appropriate discount rate for this project is 12% and the company's tax rate is 35%. Use straight-line depreciation (including the appropriate salvage values). What is the NPV of replacing the old machine? Be sure you take into account the sale of the old machine (including the tax consequences of the sale) in Year 0. This problem is really all about carefully calculating the cash flows associated with this decision each year. Build a mini-income statement for each year and then take that income and turn it into free cash flow by taking into account depreciation