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 firms tax rate is 21% MARR is 17%. Any other value not stated (For example, O&M Costs) are equal to zero.

Given the information; Determine the end of year cash flows for years 0 through 5. Compute the Net Present Worth for this 5-year project.

Income Statement and Cash Flow Statement 0 1 2 3 4 5 21% Income statement tax rate Revenues Expenses O&M 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 Income Statement and Cash Flow Statement 0 1 2 3 4 5 21% Income statement tax rate Revenues Expenses O&M 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