financial analysis on a project

complete financial analysis on a project using Figure 2-5 of your textbook as a guide. The projected project costs and benefits for are spread over four years: • Cost Estimate: $110,000 in Year 1 and $30,000 each year in Years 2, 3, and 4. (Tip: You should change the years in the template file from 0, 1, 2, 3, and 4 to 1, 2, 3, and 4. The discount factors will automatically be recalculated.) • Expected Benefits: $0 in Year 1 and $90,000 each year in Years 2, 3, and 4. Use an 9 percent discount rate. • Use this template to calculate NPV, ROI and, and year in which payback occurs.• Additionally, provide a short summary of the findings and whether or not you recommend investing in the project. Use the weighted scoring model to prioritize possible projects. The criteria weights are as follows: 15% (cost), 40% (value), 20% (risk), 25% (viability). Project 1 values are 90, 70, 85, 50; Project 2 values are 75, 80, 90, 70; Project 3 values are 80 for each criterion. Use this template to create weighted scoring model. Provide a short summary of the findings and which project you recommend proceeding with first.Search the internet to find an example of how organizations group projects into programs. What are the benefits to doing so?What are the five levels of project portfolio management and why is the first step the most important?