Part 1: Financial Analysis (12 points) Perform A financial analysis for a project using the format provided in chapter 4, figure 4-5. Assume that the projected costs and benefits for this project are spread over four years as follows: Estimated costs are $300,000 in year 1 and $ 40,000 each year in years 2,3, and 4. Estimated benefits are $0 in year 1 and $120,000 each year in years 2,3, and 4. Use a 7 percent discount rate, and round the discount factors to two decimal places. Use the NPV and ROI template to calculate the NPV, ROI and year in which payback occurs. Use the Payback period chart template to draw the payback chart. The templates can be found in Module 4 at the bottom of Module4 Description and Learning Objectives page on Canvas. NOTE: You need to start your analysis from year 1 not 0 as indicated NPV and ROI template. Requirement: 1. Write a paragraph explaining whether you would recommend investing in this project, based on your financial analysis. Part 2: Weighted Scoring Model (12 Points) Create a weighted scoring model to purchase a software from three vendors. The purchase selection is based five criteria: User Friendly worth 20% Technical Support worth 15% Onsite - Training worth 5% Improve Internal Processes 30% Supports user needs 30% Use Module 4 Weighted scoring model template and enter scores for three vendors. Assume that vendor A earns 90 points on User Friendly criteria, 70 points on Technical Support, and 80 on Onsite Training, 60 points on Improving Internal Pocesses, and 80 points on Support User Needs. Vendor B earns 70 points on User Friendly criteria, 80 points on Technical Support, and 70 on Onsite Training, 90 points on Improving Internal Processes, and 80 points on Supporting User Needs. Vendor C earns 40 points on User Friendly criteria, 90 points on Technical Support, and 100 on Onsite Training, 90 points on Improving Internal Processes, and 90 points on Supporting User Needs Requirement 1. Write a short paragraph explaining your final analysis, which vendor you would recommend, and justify your selection. Files Submission: You must submit Excel files for grading along with your interpretations