H 90 70 50 20 Weighted Decision Matrix for Project Name Created by: Date: Criteria Weight Project 1 Project 2 Project 3 Project 4 A 25% 90 501 201 B 15% 901 15% 501 901 10% E 5% 20% 701 G 10% 201 501 Weighted Project Scores 100% 56 50 41.5 50 20 D 25 90 50 70 20 20 50 90 F 50 50 50 50 90 78.5 Weighted Score by Project Project 4 Project 3 Project 2 Project 1 20 40 60 80 100 Financial Analysis for Project Name Created by: Date: Note: Change the inputs, shown in green below (i.e. interest rate, number of years, costs, and benefits). Be sure to double-check the formulas based on the inputs. Discount rate 8.00% Assume the project is completed in Year 0 Year 3 Total Costs 140,000 40,000 40,000 40,000 Discount factor 1.00 0.93 0.80 0.70 Discounted costs 140,000 37,200 34,400 31,600 243,200 Benefits 0 200,000 200,000 200,000 Discount factor 1.00 0.93 0.86 Discounted benefits 0 186,000 172,000 158,000 516,000 Discounted benefits - costs (140.000) 148.800 137.600 128.400 272,800 NPV Cumulative benefits - costs (140.000) 8.800 146,400 272.800 0 1 2 0.79 ROI 112% Payback in Year 1 Assumptions Enter assumptions here Prepare a weighted decision matrix using the template named wtd_decision_matrix.xls from the templates provided below in this assignment. Ben listed in the Cloud Computing Case will use this matrix to evaluate cloud providers for this important project. Develop at least five criteria from the link above, assign weights to each criterion, assign scores, and then calculate the weighted scores for four cloud computing providers (e. g. Amazon, Microsoft, HP, etc.) Write a brief report that describes the weighted decision matrix and summarizes the results for the cloud provider you have chosen. Use the link provided above this assignment in Canvas to help you develop criteria to evaluate the cloud providers you have chosen