Please use table to show work thanks!

Your company is considering the purchase of a new computer network for warehouse management that will be needed for 4 years. The network costs $65,000 and installation/site preparation costs $3,000. It has an expected life of 4 years and estimated salvage value of $2,000. This is classified as a 5-year MACRS class. The company will borrow the full amount of initial investment (i.e. network costs and installation/site preparation costs). The bank loan interest rate is 6% APR compounded annually and the company will repay the loan in 4 equal annual payments. Expected annual savings is $23,000 due to less inventory lost and better customer service from this improved tracking system. There will be annual maintenance and update expenses of $5,000. There is $500 working capital needed that will be fully recovered at the end of the project. The company's tax rate is 21%. The company's minimum attractive rate of return is 14% a) Determine this project's cash flows over the project life. Use the project cash flow table available in Canvas Module "Week 10:...." to record your values. Show supporting calculations in detail for the following: 1. Financing activities for all years -- also use the loan principal and interest table available in Canvas Module "Week 10:...." for summarizing answers for all years. 2. All depreciation values 3. All tax values (including all tax calculations associated with salvage). Additionally, for Year 1, show all "simple calculations of Taxable income, income tax, net income, and net cash flow. You do not need to show your work for these specific calculations in other years. b) Based on present worth analysis of the net cash flows from this project, is your project acceptable and state why. 0 1 2 3 4 5 6 7 Income Statement Revenues Expenses Labor Material Overhead Depreciation Debt interest Taxable income Income taxes Net income Cash Flow Statement Operating activities Net income Depreciation Investment activities Investment Working capital Salvage Gains tax Financing activities Borrowed funds Principal repayment Net cash flow Your company is considering the purchase of a new computer network for warehouse management that will be needed for 4 years. The network costs $65,000 and installation/site preparation costs $3,000. It has an expected life of 4 years and estimated salvage value of $2,000. This is classified as a 5-year MACRS class. The company will borrow the full amount of initial investment (i.e. network costs and installation/site preparation costs). The bank loan interest rate is 6% APR compounded annually and the company will repay the loan in 4 equal annual payments. Expected annual savings is $23,000 due to less inventory lost and better customer service from this improved tracking system. There will be annual maintenance and update expenses of $5,000. There is $500 working capital needed that will be fully recovered at the end of the project. The company's tax rate is 21%. The company's minimum attractive rate of return is 14% a) Determine this project's cash flows over the project life. Use the project cash flow table available in Canvas Module "Week 10:...." to record your values. Show supporting calculations in detail for the following: 1. Financing activities for all years -- also use the loan principal and interest table available in Canvas Module "Week 10:...." for summarizing answers for all years. 2. All depreciation values 3. All tax values (including all tax calculations associated with salvage). Additionally, for Year 1, show all "simple calculations of Taxable income, income tax, net income, and net cash flow. You do not need to show your work for these specific calculations in other years. b) Based on present worth analysis of the net cash flows from this project, is your project acceptable and state why. 0 1 2 3 4 5 6 7 Income Statement Revenues Expenses Labor Material Overhead Depreciation Debt interest Taxable income Income taxes Net income Cash Flow Statement Operating activities Net income Depreciation Investment activities Investment Working capital Salvage Gains tax Financing activities Borrowed funds Principal repayment Net cash flow