please have numbers in an attached excel file

Spreadsheet Exercise Damon Corporation, a sports equipment manufacturer, a in use that was originally purchased 3 years ago for firm has machine currently Once remova depreciates the machine under MACRs using a 5-year recovery period. will be $70,000. expected net selling price for the present machine Damon can buy a new machine for a net price of $160,000 (ncluding installation costs $15,000). The proposed machine will be depreciated under MACRS using a 5-year recovery period. If the firm acquires the new machine its working capital needs will change Accounts receivable will ncrease $15,000, inventory will increase $19,000, and accounts payable wi increase $16,000. Earnings before depreciation, interest, and taxes (EBDIT) he present machine are expected to be $95,000 for each of the successive 5 years. For the proposed machine, the expected EBDIT for each of the next 5 years are $105,000 $110,000, $120,000,$120,000, and $120,000, respectively. The corporate tax ratem for the firm is 40% (Table 4.2 on page 120 contains the applicable MACRS depreciation percentages.) Damon expects to be able to liquidate the proposed machine at the end of its 5-year usable life for $24,000 (after paying removal and cleanup costs). The present machine is expected to net$8,000 upon liquidation at the end of same period. Damon expects to recover its net working capital investment upon termination of the project. The firm is subject to a tax rate of 40% TO DO create a spreadsheet similar to Tables 11.1, 11.5, 11.7, and 11.9 to answerthe following a. Create a spreadsheet to calculate the initial investment b. create a spreadsheet to prepare a depreciation schedule for both the proposed and the present ma depreciation remaining. Remember that the present machine has only 3 years of c. Create a spreadsheet to calculate the operating cash flows for Damon corporation for both the proposed and the present machine. d. Create a spreadsheet calculate the terminal cash flow associated with the project to Question Data original purchase price 3 years ago Net selling price of the existing machine Cost of new machine (including installation costs) Installation costs Salvage value of new machine (after 5 years) Salvage value of existing machine (after 5 years) Changes to working capital: Increase in accounts receivable Increase in inventory Increase in accounts payable EBDIT for the present machine next 5 years EBDIT for the proposed machine for next five years