Please see attached for instructions. Calcuations should be in excel and answers

Please see attached for instructions.
Calcuations should be in excel and answers/explanation in word.