Assignment 1 NPV This is an individual assignment. Please complete Exercise 1 and 2. Submit to Assignment 1 51$ng by due date (see schedule for due dates). 7 ' 1. Perform a nailcjajanalysis for a project using the format discussed in the course. Assume the I projected costs and benefits for this project are spread over five years as follows: Estimated costs are $130,000 in Year 1 and $25,000 each year in Years 2, 3, 4, and 5. Estimated benefits are $0 in Year 1 and $75,000 each year in Years 2, 3, 4, and 5. Use an 12% discount rate. Use the NPV template pr0vided (modify to suit your answer) and clearly display the NPV, ROI, and year in which payback occurs. Write a paragraph explaining whether you would recommend investing in this project based on your financial, analysis. Explain your answer referring to the NPV, ROI and payback for this project. 2. Create a weighted scoring model to determine which project to select. Assume the criteria are cost, strategic value, risk, and lll; with weights of 10%, 40%, 20%, and 30%, respectively. Enter values for Project I as 90, 70, 85, and 50; Project 2 as 75, 80, 90, and 70; and Project 3 as 80 for each criterion. Use the weighted scoring model discussed in lecture material, create the model, calculate the weighted sc0re, and graph the results. Which project would you select? Why? Submit both exercises in one file (Excel or Word file) that contains both answer. Document must be professionally generated. Include your name, course name, assignment number and date at the top of the spreadsheet