finance case analyze 1

Using Excel to answer the question.