MUST SHOW ALL WORK IN EXCEL MUST UPLOAD EXCEL TO THE DROPBOX, NO ATTACHMENTS. XYZ Co is looking at four different opportunities. Each opportunity requires the same initial investment of $110,000. Below is the cashflow for each investment: YearOpportunityOpportunity 20 pportunity 3Opportunity 4 1 Evaluate opportunities 1-4 by the following: a) payback period (show years and months as applicable) b) net present value (use a 10% discount rate) - Round your answers to the nearest dollar (no decimals) c) internal rate of return - required rate is 15% Rank each opportunity by each evaluation technique (a,b,c), rank them 14. 1 being the best opportunity and 4 being the worst