Reference no: EM13976067

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. Year 1 Year 2 Year 3 Year 4 Expected benefits $300,000 $250,000 $200,000 $150,000 Option B requires $700,000 initially and is expected to produce cash inflows as follows Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Expected benefits $200,000 $200,000 $200,000 $180,000 $180,000 $180,000 The 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 or techniques such as net present value, internal rate of return, net annual worth, payback period, etc. The relevant market interest rate is 14% annually, and interests are calculated at the end of each period (i.e., at the end 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 the file to the Blackboard course website. The exam will be evaluated based on the following: Category Description Scores Precision The numbers and formulas are correct 20 Flexibility Formulas/functions are used appropriately 20 Relevancy Decisions are relevant. 10 Total 50 This exam should be submitted to the Blackboard course website by the end of February 19, 2016.