Exam 1 Hands-On PartIET 320 Project Management (Spring 2016)Read the instructions carefully to compl

Exam 1 Hands-On PartIET 320 Project Management (Spring 2016)Read the instructions carefully to complete this exam.A project manager in an organization analyzed some alternative options for a project. Option A initially requires$600,000, and is expected to generate cash inflows as follows.Expected benefitsYear 1$300,000Year 2$250,000Year 3$200,000Year 4$150,000Option B requires $700,000 initially and is expected to produce cash inflows as followsExpected benefitsYear 1$200,000Year 2$200,000Year 3$200,000Year 4$180,000Year 5$180,000Year 6$180,000The president of the organization wants to know which option is more economical.Assume that you are the project manager who needs to evaluate the options with financial models ortechniques such as net present value, internal rate of return, net annual worth, payback period, etc. Therelevant market interest rate is 14% annually, and interests are calculated at the end of each period (i.e., at theend of each year).Create an electronic spreadsheet file (e.g., Microsoft Excel) to complete the analysis with the information given.Save the file as Exam01YourName.xlsx (e.g., Exam01TomJones.xlsx if your name is Tom Jones) and submit thefile to the Blackboard course website.The exam will be evaluated based on the following:CategoryPrecisionFlexibilityRelevancyTotalDescriptionThe numbers and formulas are correctFormulas/functions are used appropriatelyDecisions are relevant.Scores20201050This exam should be submitted to the Blackboard course website by the end of February 19, 2016.