Les10 Excel Bookwork Formulas

Les10 Excel Bookwork Formulas - 21.18 11,860.80 Total...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Treasurer: Juan Castillo castillo_juan37@hotmail.com Silver Dollars Stock Club Portfolio Summary Stock Symbol Shares Apple Computers AAPL 12/1/2004 440  $64.59   $28,419.60   $82.99   $36,515.60  T 12/16/2006 870  28.71   24,977.70   27.99   24,351.30  Citigroup C 1/17/2004 960  49.46   47,481.60   44.68   42,888.00  Google GOOG 2/20/2004 920  390.32   359,094.40   492.55   453,146.00  Comcast CMCSA 2/11/2002 380  33.62   12,775.60   41.39   15,728.20  Home Depot HD 11/14/2005 770  34.54   26,595.80   31.72   24,424.40  IBM IBM 9/14/2004 990  74.08   73,339.20   81.47   80,655.30  Merck MRK 1/14/2005 950  42.13   40,018.75   38.34   36,423.00  Sprint Nextel Symbol 9/10/2003 560  17.79   9,962.40 
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 21.18 11,860.80 Total $622,665.05 $725,992.60 Average 760 $81.69 $69,185.01 $95.81 $80,665.84 Highest 990 $390.32 $359,094.40 $492.55 $453,146.00 Lowest 380 $17.79 $9,962.40 $21.18 $11,860.80 Date Acquired Initial Price Per Share Initial Cost Current Price Per Share Current Value Treasurer: Juan Castillo castillo_juan37@hotmail.com Gain/Loss $8,096.00 28.49% (626.40)-2.51% (4,593.60)-9.67% 94,051.60 26.19% 2,952.60 23.11% (2,171.40)-8.16% 7,316.10 9.98% (3,595.75)-8.99% 1,898.40 19.06% $103,327.55 16.59% $11,480.84 8.61% $94,051.60 28.49%-$4,593.60-9.67% Percent Gain/Loss...
View Full Document

Page1 / 2

Les10 Excel Bookwork Formulas - 21.18 11,860.80 Total...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online