Read the case study. Create an excel model. Make sure you use formulas for all of your calculations – do not just plug numbers in excel. In addition to the Excel spreadsheet you must write a 1-2 page Case Executive Summary and create a Power Point presentation.
Please let me know if you have any questions.