For lab 1: part 2: You will return to the final solutions that you generated in your Net Present Value workbook. In this portion of the lab, you will be answering follow-up questions. The goal is...

CHECK FILE: THIS ASSIGNMENT NEEDS TO BE RE-ASSIGNED TO THE PREVIOUS EXPERT THAT WORKED ON MY LAB 1 ASSIGNMET. EXPERT NAME WAS PRINCE..


For lab 1: part 2: You will return to the final solutions that you generated in your Net Present Value workbook. In this portion of the lab, you will be answering follow-up questions. The goal is to explain your results in a detailed way. Answer the following questions: 1. There was an excel function that was utilized to create a set of rules around the number of years that we wished to remain constant for marginal profit. It had an IF(TRUE, IF (TRUE, FALSE)) structure. This function was specifically used to calculate the projected marginal profit across the 20-year projection when we believed certain years would have the same profit. This is sometimes called a nested IF statement. Provide a detailed description of this function and how it works in this particular lab. Can you think of any other way to generate the same results? 2. What is sensitivity analysis? How was it used in this scenario? In your own words, describe this concept and its relationship to business analytics. 3. Excel has many built in functions. In this particular lab we reviewed the NPV function. Imagine you are explaining this to a new hire at your future company who has never heard of this term. How would you explain this idea? 4. In your final solution, how would you describe the relationship between the years and the marginal profit. Imagine the years as the x-axis and the marginal profit as the y-axis. Is there a mathematical way to describe this relationship and the curve that is provided? 5. Conduct one modification to the workbook and explain how your results changed from your original solution and/or worked problems. The attention on this question is to accurately and concisely explain your adjustment and how it impacts the business results that are being considered. Provide your responses in a zipped file that contains a word document with your write up and the excel sheet for question #5.