use this data sheet to solve the problem

. 2) A firm is undertaking a project with the following details provided. The project costs $2 million and has a five-year service life. It generates revenues of $600,000 annually. The project is classified under a 7-year property under the MACRS rule. At the end of the fifth year, any assets held for the project will be sold. The expected salvage value will be 15% of the initial $2M project cost. The firm will finance 30% of the project money from an outside source with an annual interest rate of 12%. The firm is required to repay the loan with five equal annual payments. The firm's tax rate is 21% MARR is 17% Given the information, o Determine the end of year cash flows for years 0 through 5 o Compute the Net Present Worth for this 5-year project . Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 #5: 384 NPW Problem 1 Problem 2 Income Statement and Cash Flow Statement 2 3 4 5 21% Income statement tax rate Revenues Expenses OEM Labor Material Overhead Depreciation Debt Interest Taxable income Income taxes Net income Cash Flow Statement Operating activities Net Income Depreciation Investment activities Investment Salvage Gains tax Working capital Financing activities Borrowed funds Principal repayment Net Cash Flow NPV NPV(manually IRR