hello please help me solve this problem with steps. there are other answers with the solution to this problem on this platform but they are wrong. ill give a thumbs up thanks !

Citco Company is considering investing up to $500,000 in a sustainability enhancing project. Its managers have narrowed their choices to three potential projects Project A would redesign the production process to recycle raw materials waste back into the production cycle, saving on direct materials costs and reducing the amount of waste sent to the landfill. Project B would remodel an office building, utilizing solar panels and natural materials to create a more energy-efficient and healthy work environment Project C would build a new training center in an underserved community, providing jobs and economic security for the local community Required: 1. Assuming the cost of capital is 12%, complete the table below by computing the payback period, NPV, profitability index, and internal rate of return. (Future Value of $1. Present Value of $1. Future Value Annuity of $1. Present Value Annuity of $1) (Use appropriate factor(s) from the tables provided. Do not round intermediate calculations. Negative amounts should be indicated by a minus sign. Round your "NPV" answers to the nearest whole dollar amounts. Round your "Pr" and "IRR" answers to 2 decimal places.) Project (Redesign production process) $ (500.000) $ 100,000 Project B (Remodel office building) 5 (420,000) $ 60,000 Project (New training facility) $ (320,000) $ 80,000 8 years 10 years 6 years $ 80.000 $ 75,000 $ 30,000 Required investment Annual cost savings Project life Salvage value Payback period NPV @ 12% Profitability Index @12% Internal rate of return years years years 2. Based strictly on the economic analysis, in which project should they invest? O Project A Project B DRA