5/4/2010 Portfolio Summary

posted May 6, 2010, 5:24 AM by Abdulkader Alriyashi   [ updated May 6, 2010, 9:01 AM ]
  • You will be given an assignment to work on ( check the attached file)
  • To get a full credit, you must do the following,
    1. Type in the given data to an excel sheet
    2. Maintain the same design as the given data ( Font size, column width, etc )
    3. Find the proper formulas or functions for the empty columns. Use the following guidelines,
      • Initial cost = Shares * Initial price per share
      • Current value = Shares * Current price per share
      • Gain / Loss = current value – initial cost
      • Percent gain/loss = (Gain or Loss ) / Initial cost
      • Total = Sum(  ,   ,   .....)
      • Average = average (,    ,    ,...   )
      • Highest = Max(,   ,   ,...   )
      • Lowest = min(,   ,   ,...   )
Ċ
Abdulkader Alriyashi,
May 6, 2010, 6:19 AM
Comments