Please read case and answer all questions Make sure you are good at case analysi

Please read case and answer all questions
Make sure you are good at case analysis and do Excel calculation
Please read the case and case questions before you pick up this assignment.
Basic format: A suggested basic format is as follows: (1) brief one-paragraph executive summary including your main findings, recommendation and rationale; (2) details of your analysis, including the reasons for your recommendations and the key assumptions (and justifications for these) used in your analysis; (3) and supporting exhibits/calculations.
Length: Case write-ups – four pages of text. You may attach as many supporting calculations and tables as you wish. These supporting tables and spreadsheets should contain clearly labeled assumptions and formulae.