Please do the calculations in Excel. No credit will be given if you only provide the final answer for problems that require calculations and/or explanations. The problems must be done in Excel, using the format similar to the template provided in the ppt.

.