A B C D E F G H Nick Herd Investments Nick Herd Strategy Percent Purchas Curren Gain / Investmen 4 Symbol Name e Price t Price Loss t Action Percent Gain/Loss Action 5 ABC Abacus Ltd. $16.50 $15.30 Gain greater than 59Buy 6 DIG Diamond Import $53.50 $33.39 Between 5% and -5 Hold 7 III Indy Ink Inc. $12.25 $11.75 Loss greater than 59 Sell 8 EEK Erie Knives $9.75 $10.50 9 CAP Canadian Petrol Instructions: $12.50 $11.50 10 GGG Good Eggs $35.20 $36.00 - (Value: 2 points) 1. For each of the investments shown, calculate the percent gain 11 HAT Hatfield Oil $22.00 $18.00 or loss based on the difference between the purchase and current price. Format as percent 12 with two decimal places. 13 - ( Value: 8 points) 2. Use a nested IF to 14 calculate the investment action. The chart at 15 the right shows the strategy that will be used by this investment firm. 16 Problem1 - Baseball Exam Three Baseball Data Problem Two Problem Three Problem Four +