1. The submission is to be one Excel file. The problem has multiple parts. Your answers should be clearly marked by part number.
2. All calculations are to be shown.
3. You should utilize Excel formulas, where applicable. Formatting is essential.
4. The case includes a text submission. You can prepare the memo in Word and then cut and paste your narrative into your excel worksheet or insert a text box into your worksheet and type your narrative into the text box.