Perform a financial analysis for a project using the format discussed in the course. Assume theprojected costs and benefits for this project are spread over four years as follows: Estimated costs are$130,000 in Year 1 and $15,000 each year in Years 2, 3,4, and 5. Estimated benefits are $0 in Year 1 and$90,000 each year in Years 2, 3, 4, and 5. Use an 8% discount rate. Use the NPV template provided(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 yourfinancial 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 financials, with weights of 10%, 40%, 20%, and30%, respectively. Enter valuesfor 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 modeldiscussed in lecture material,create themodel, calculate the weightedscore, and graph the results.Which project would you select?
#Sales Offer!| Get upto 25% Off: