comer of the data table below in order to copy is contents into a speeadsheet) 2. Calculse the NPV for esch propect over is ife The net present value for project X is $ (Round to the nearest cirl) The net present value for project Y ia: (Plound to the nearest cent) The net present value for project Z is s (Phound so ne nearest cent) Rank the projects in descending order on the basis of NPV. Rank the projects below. (Selecs trom the drop-down menus) b. Use the annualired net prosent value (ANPY) approach to evaluate and rank the projects in descending onder on the basis of ANPV. The ANPV for project X io s (Round to the nearest cent.) The ANPV for project Y is $ (Round to the neurest cent) comer of the data table below in order to copy is contents into a speeadsheet) 2. Calculse the NPV for esch propect over is ife The net present value for project X is $ (Round to the nearest cirl) The net present value for project Y ia: (Plound to the nearest cent) The net present value for project Z is s (Phound so ne nearest cent) Rank the projects in descending order on the basis of NPV. Rank the projects below. (Selecs trom the drop-down menus) b. Use the annualired net prosent value (ANPY) approach to evaluate and rank the projects in descending onder on the basis of ANPV. The ANPV for project X io s (Round to the nearest cent.) The ANPV for project Y is $ (Round to the neurest cent)