Objectives (Outcome #3 ); This assignment is designed to re-enforce your knowledge and skills in using project selection techniques, including computerized tools, such as MS Excel. This is an individual assignment and collaborations of any kind will not be tolerated, and will be investigated and penalized as necessary. Problem Data: Table 1: Cash Flows (Note: cash flows accur at the end of each vear) Task: A. Given the above table with cash flows (in thousands of dollars) for three projects, build an Frcel medel to compute and find each of the following selection criteria for each proisct (discounting rate =789 : 1) NPV 2) IRR 3) ROI (discounting approach) 4) Payback period (discounting appreach, whole numberivear) B. Based on your calculation results in (A) above, determine whether each project, eonsidered independently, is feasible/acceptable or not, using each of the following decision rules: a. NPV: only positive values are accepted b. IRR: Cost of capital is 7% c. ROI: RRR=10% d. Payback: maximum 3 years Create a table as below to summarize your answer to Part B: C. Based on your results in parts (A) and (B) above, rank the three projects from 1 to 3 according to their financial desirability (i.e. \#I best, \#2 second best, etc.) Notes: 1. Since cash flows occur at the end of the year, parberk mure he e whole number, with no fraction. 2. Your solution must include the Excel Model in Part (A), the decision table in Part (B), and the answer to Part (C). 3. The assignment must be submitted by uploading it to Blackboard to the "Assign_No- F " link, on the "Submissions" folder, under the "Assignments" main folder. 4. Upload a Word or PDF format only of your solution to Blackboard by midnight Thursday February 02, 2023