Please write your report as Chris Simpkins’ memo to the NG&GP’s director. The memo should answer the questions in Problem 3-9. You should also attach an Excel file to support Chris’ findings. This project analyzes future cash flows and I expect you to demonstrate your knowledge of sensitivity analysis tools studied in this class, including simulation software like Crystal Ball.
Like every business memo, it should address the problem and recommend solution at the very beginning. Imagine that its reader is a very busy executive, who has to make a decision based on your recommendation. As a busy person, the decision maker probably will read only first couple of paragraphs. What should you tell this person in these paragraphs? What do you actually recommend and why? The remaining part of the memo should provide justification of your recommendations. It should be assertive, convincing and show that you master the topic.
About timing of your memo: you can choose the date of your memo yourself (it’s not necessary to date it with the current date). Please make sure that this date is consistent with your analysis and data. It is important!