Examine the analysis provided below. (a) Select your own imaginary / hypothetical engineering project example with the same structure as below (e.g. 5 yr horizon with 0% to 50% rate assumptions. What is your project example? Develop your own spreadsheet analysis with your own numbers) and show the result similar to what has been provided below. Your numbers will be different. (b) Create a graph in your spreadsheet showing % on x-axis and PW on y-axis. (c) describe what such a graph would demonstrate to your management and how it would be interpreted in business terms.

Question 5 In year 0 of project A, your company is required to make $1M investment but in year 1, 2, 3, 4, 5, and 6 the investment level is only $250K per year. Benefits are forecasted to start in year 3 and continue for the next 20 years varying by each year. Breakeven period is somewhere between year 6 and 7. There is another project alternative (call it project B) that is known but not pursued because the payback period is after year 10 and so the current engineering manager assigned to conduct the economic analysis did not consider this alternative. (a) Should the company invest the time and effort in conducting an analysis for the alternative project? Why or Why not? (b) Create a spreadsheet to show a reasonable analysis for the 20-year period. Use numbers provided and make-up numbers that have not been provided to you as part of this question. Question 6 Examine the analysis provided below. (a) Select your own imaginary / hypothetical engineering project example with the same structure as below (e.g. 5 yr horizon with 0% to 50% rate assumptions. What is your project example? Develop your own spreadsheet analysis with your own numbers) and show the result similar to what has been provided below. Your numbers will be different. (b) Create a graph in your spreadsheet showing % on X-axis and PW on y-axis. (c) describe what such a graph would demonstrate to your management and how it would be interpreted in business terms. Question 5 In year 0 of project A, your company is required to make $1M investment but in year 1, 2, 3, 4, 5, and 6 the investment level is only $250K per year. Benefits are forecasted to start in year 3 and continue for the next 20 years varying by each year. Breakeven period is somewhere between year 6 and 7. There is another project alternative (call it project B) that is known but not pursued because the payback period is after year 10 and so the current engineering manager assigned to conduct the economic analysis did not consider this alternative. (a) Should the company invest the time and effort in conducting an analysis for the alternative project? Why or Why not? (b) Create a spreadsheet to show a reasonable analysis for the 20-year period. Use numbers provided and make-up numbers that have not been provided to you as part of this question. Question 6 Examine the analysis provided below. (a) Select your own imaginary / hypothetical engineering project example with the same structure as below (e.g. 5 yr horizon with 0% to 50% rate assumptions. What is your project example? Develop your own spreadsheet analysis with your own numbers) and show the result similar to what has been provided below. Your numbers will be different. (b) Create a graph in your spreadsheet showing % on X-axis and PW on y-axis. (c) describe what such a graph would demonstrate to your management and how it would be interpreted in business terms