project management: NPV

Please supply an Excel workbook (.XLSX format) with a sheet for each problem. Explain your steps, do the calculations correctly, and explain your answers all in the Excel sheet!

Beyond the correct answers, someone being able to make sense of how you got to your results is a critical part of the assignment. Please take a look at the rubric below for any questions about how grades are determined.

RUBRIC:

Problem Set #1 Criteria Question 1: Answer Question 1: Clarity Question 2: Answer Question 2: Clarity 15 pts Full Marks Has both correct numerical answer and correct reasoning 10 to >5.0 pts Full Marks Fields are clearly labeled, calculating cells are in locations that make sense, and a peer or manager reviewing the document could easily understand your calculations, results and methods 15 pts Full Marks 10 to =5.0 pts Full Marks Fields are clearly labeled, calculating cells are in locations that make sense, and a peer or manager reviewing the document could easily understand your calculations, results and methods 5 to 2.5 pts Good You have used the correct method, however it is presented and calculated ina confusing manner that would require a peer or manager to discuss to understand. 5 to >2.5 pts Good You have used the correct method, however it is presented and calculated ina confusing manner that would require a peer or manager to discuss to understand. Ratings 8 pts Partial Correct numerical answer but lack or has incorrect reasoning. 2.5 to >0.0 pts Poor Your methodology is not the correct technique for calculating the result. This may or may not get to the correct answer, however, it is not in a way that cannot be easily replicated to alter for additional analysis. Opts No Marks 2.5 to >0.0 pts Poor Your methodology is not the correct technique for calculating the result. This may or may not get to the correct answer, however, it is not in a way that cannot be easily replicated to alter for additional analysis. 0 pts No Marks 15 pts 0 pts No Marks There is no method or the method used doesnot 10 pts translate to the resulting answer. 15 pts 0 pts No Marks There is no method or the method used doesnot 10 pts translate to the resulting answer. Question oa: Answer Question 3: Clarity Question 4; Answer PART A Question 4: Answer PART B Question 4: Clarity Correct numerical answer but lacks or has incorrect reasoning 15 pts & pts Full Marks Partial 10 to =5.0 pts Full Marks Fields are clearly labeled, calculating cells are in locations that make sense, and a peer or manager reviewing the document could easily understand your calculations, results and methods 15 pts Full Marks 15 pts Full Marks 15 to =7.5 pts Full Marks Fields are clearly labeled, calculating cells are in locations that make sense, and a peer or manager reviewing the document could easily understand your calculations, results and methods 5 to >2.5 pts Good You have used the correct method, however it is presented and calculated in a confusing manner that would require a peer or manager to discuss to understand. 7.5 to >3.75 pts Good You have used the correct method, however it is presented and calculated in a confusing manner that would require a peer or manager to discuss to understand. 2.5 to >0.0 pts Poor Your methodology is not the correct technique for calculating the result. This may or may not get to the correct answer, however, it is not ina way that cannot be easily replicated to alter for additional analysis. 0 pts No Marks 0 pts No Marks 3.75 to >0.0 pts Poor Your methodology is not the correct technique for calculating the result. This may or may not get to the correct answer, however, it is not in a way that cannot be easily replicated to alter for additional analysis. 0 pts No Marks 15 pts 0 pts No Marks There is no method or the method used doesnot 10 pts translate to the resulting answer. 15 pts 15 pts 0 pts No Marks There is no method or the method used does 15 pts not translate to the resulting answer. Total Points: 120