The government is undertaking a major renovation in railway infrastructure. There are four possible options (Project-01 to Project-04). Based on your instructions, the following data about the feasibility of the projects were collected. Data is in two parts. The ratings (on a scale of 1 to 10, where 1 indicates POOR and 10 indicate GOOD) on eight aspects and financial information. Conduct the feasibility analysis based on rating and using (Net Present Value) NPV method (use Discounting Rate as 10% per year). Give your recommendation for the type of project to be selected for this purpose. - The answer should be a min of 1000 words in word format.

Feasibility Operational Market Technical Economic Financial Legal and Regulatory Environmental Social Project-1 3 7 7 8 6 2 2 5 Project-2 5 6 2 2 10 5 7 2 Project-3 7 7 5 5 5 9 10 6 Project-4 7 5 3 3 4 5 7 4 Juwa olculcin I Project-01 Cashflow -45 Project-02 Cashflow-50 Project-03 Cashflow -60 Project-04 Cashflow -55 C6 15 C1 15 20 25 18 C2 15 20 25 18 C3 15 20 25 18 C4 15 20 25 18 C5 15 20 18 18