Please don't solve this on excel I will appreciate if someone solve step by step calculation wise thx

The BASF Chemical Corporation has managed to earn a consistently high rate of return on its investments. The secret of its success has been the strategic and timely development, manufacturing, and marketing of innovative chemical products that have been used in various industries. Currently, the management of the company is considering the manufacture of new packaging material for electronic products. The Company's Research and Development teams have come up with two alternatives a Plant 1, which would have a lower startup cost, and Plant 2, which would cost more to produce initially but would have greater economies of scale. At the initial presentation, the project leaders of both teams presented their cash flow projections and provided sufficient documentation in support of their proposals. However, since the products are mutually exclusive, the firm can only fund one proposal. To resolve this dilemma, Saood, the Assistant Treasurer, and a recent graduate from a prestigious university, has been assigned the task of analyzing the costs and benefits of the two proposals and presenting his findings to the board of directors. Saood knows that this will be an uphill task since the board members are not all on the same page when it comes to financial concepts. The Board has historically had a strong preference for using rates of return as its decision criteria. On occasions, it has also used the payback period approach to decide between competing projects. However, Saood is convinced that the net present value (NPV) method is least flawed and when used correctly will always add the most value to a company's wealth. After obtaining the cash flow projections for each plant (see Tables I), and crunching out the numbers, Saood realizes that the hill is going to be steeper than he thought. The various capital budgeting techniques, when applied to the two series of cash flows, provide inconsistent results. The project with the higher NPV has a longer payback period, as well as a lower Accounting Rate of Return (ARR) and internal Rate of Return (IRR). Saood scratches his head, wondering how he can convince the Board that the IRR, ARR, and Payback Period can often lead to incorrect decisions. # Table -1- Cashflow Estimation Year 1 Plant 1 Year 0 Year 2 Year 3 Year 4 Year 5 Net Income $160,000 $180,000 $320,000 $465,000 $530,000 Depreciation (Straight-tine) $210,000 $240,000 $205,000 $205,000 190,000 Net Cash Flow $1,000,000 $370,000 $420,000 $525,000 $670,000 $720,000 Plant 2 Net Income $430,000 $235,000 $150,000 $50,000 $50,000 Depredation {Straight - line) $165,000 $175,000 $185,000 $160,000 $160,000 Net Cash Flow $900,000 $595,000 $410,000 $335,000 $210,000 $210,000 Required 1. Calculate the two projects' IRR. How should Saood convince the Board that the IRR measure could be misleading? 2. Calculate the NPV for the two projects and explain the relevance using 10% as the discount rate. How should Saood convince the Board that the NPV method is the way to go