Your employer is considering a capital project that involves installing a new manufacturing line at a cost of $1,880,000. The line will be installed area of the factory that was refurbished in 2017. At that time, the refurbishment cost $950,000. If it is not employed by this project, that area of the factory will remain unused. The new manufacturing line, if built, will be depreciated on a straight-line basis over five years, to a salvage value of $0. If implemented, the project will cause an immediate increase in Inventory of $260,000. It will also cause immediate increases in Accounts Receivable of $290,000, Accounts Payable of $160,000, and Long-Term Debt of $1.2million.

If implemented, the project is expected to generate annual sales of $3,375,000 by the end of the first year. Sales are expected to increase 6% per year. COGS expense is expected to be of $1,599,600 during the first year. Thereafter, COGS is expected to remain at a constant percentage of Sales. Because operating efficiency is expected to improve each year, SG&A expense is expected to remain at $950,000 for each of the five years of the project. At the end of the project's five-year life, production will cease, and the manufacturing line will be sold for an estimated $140,000. At that time, Inventory, Accounts Receivable and Accounts Payable will return to their pre-project levels.

If the project is implemented, it will likely cannibalize sales of an existing product. The net impact of the cannibalization is expected to be a $225,000 annual reduction in pre-tax profits.

Your employer's tax rate is 21%. The firm has 2 million shares of common stock outstanding. The firm requires a 14% rate of return on capital projects.

work out a discounted cash flow analysis to determine whether your employer should implement this capital project. Your analysis should reveal answers to each of the following questions. Highlight the cells that answer the following questions:

1. What is the initial investment amount (Year 0)?
2. What are the total cash flows each year (Years 1-5)
3. What is the NPV?
4. What is the IRR?

Please include the excel formulas