Lab3.docx

Info icon This preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
School of Business Administration, Sonoma State University BUS 474: Computer Applications in Finance Dr. Michael Santos Lab3 How to prepare and present your labwork Please collect all your lab worksheets (pages) on the same Excel Workbook (as if it is a book that has its pages as Excel worksheets). Normally, you are provided three worksheets (Sheet 1, Sheet 2, and Sheet 3). When you need more worksheets, insert a new one. If you want to delete one, right click on the tab at the bottom of your worksheet gives you the delete option. Rename each worksheet with the section numbers (NAME, Sec1, Sec2, Sec3…etc., or NAME, S1, S2, S3…etc.,). NAME tab is used to write your name and other identification information. Please, color worksheet tabs (using right-click) so that it will be easy to distinguish them. Organization of a typical Excel workbook might look like the following: Note: Please do not forget to save your Excel workbook as “Name_Lab3” and save as in .xlsx (not .csv or .text: These text formats will not preserve your work) . Save your file (Name_Lab3.xlsx) after you complete each section below. Section1 : Inserting Pivot tables and charts Copy and paste the following data on a new worksheet and call its tab as Sec1.Data. Symbol Name Last Price Shares Market Value Weight Classificatio n AAPL APPLE COMPUTER INC $ 275.46 913.563 $ 251,650.03 5.66% MEGA-CAP ABT ABBOTT LABORATORIES $ 51.64 1,544.03 $ 79,733.66 1.79% LARGE-CAP ADP AUTOMATIC DATA PROCESSING, INC. $ 41.33 492.023 $ 20,335.29 0.46% MID-CAP AXP AMERICAN EXPRESS CO $ 41.37 1,203.21 $ 49,776.88 1.12% MID-CAP BA BOEING CO $ 62.95 731.681 $ 46,059.35 1.04% MID-CAP BAC BANK OF AMERICA CORP $ 13.41 10,033.84 $ 134,553.79 3.03% MEGA-CAP BDX BECTON DICKINSON AND CO $ 73.48 232.146 $ 17,058.08 0.38% MID-CAP BMY BRISTOL MYERS SQUIBB CO $ 27.31 1,714.84 $ 46,832.33 1.05% MID-CAP BP BRITISH PETROLEUM PLC $ 38.03 3,131.92 $ 119,106.91 2.68% MEGA-CAP CAG CONAGRA INC $ 22.09 442.764 $ 9,780.66 0.22% MID-CAP CAT CATERPILLAR INC. $ 73.17 630.472 $ 46,131.66 1.04% MID-CAP CL COLGATE PALMOLIVE CO $ 77.37 485.999 $ 37,601.72 0.85% MID-CAP CPB CAMPBELL SOUP CO $ 36.27 339.532 $ 12,314.82 0.28% MID-CAP CSCO CISCO SYSTEMS INC $ 21.90 5,711.15 $ 125,074.21 2.81% MEGA-CAP CVX CHEVRONTEXACO CORP $ 78.43 2,010.59 $ 157,690.89 3.55% MEGA-CAP DD DU PONT EI DE NEMOURS $ 43.95 906.512 $ 39,841.20 0.90% MID-CAP DIS WALT DISNEY CO $ 34.52 1,912.61 $ 66,023.19 1.49% LARGE-CAP GE GENERAL ELECTRIC CO $ 16.28 10,691.22 $ 174,053.07 3.92% MEGA-CAP 1
Image of page 1

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

View Full Document Right Arrow Icon
GIS GENERAL MILLS INC $ 36.17 651.216 $ 23,554.49 0.53% MID-CAP GS GOLDMAN SACHS GROUP, INC. $ 150.98 515.617 $ 77,847.78 1.75% LARGE-CAP HNZ HJ HEINZ CO $ 47.94 318.335 $ 15,260.98 0.34% MID-CAP HPQ HEWLETT PACKARD CO $ 39.17 2,267.74 $ 88,827.49 2% LARGE-CAP IBM INTERNATIONAL BUSINESS MACHINES $ 130.19 1,261.28 $ 164,205.79 3.69% MEGA-CAP INTC INTEL CORP $ 18.83 5,568.00 $ 104,845.44 2.36% MEGA-CAP JNJ JOHNSON AND JOHNSON $ 61.55 2,754.45 $ 169,536.09 3.81% MEGA-CAP JPM JP MORGAN CHASE AND CO INC $ 40.05 3,965.17 $ 158,804.93 3.57% MEGA-CAP K KELLOGG CO $ 50.58 377.76 $ 19,107.12 0.43% MID-CAP KO COCA COLA CO $ 57.57 2,309.46 $ 132,955.73 2.99% MEGA-CAP LLY ELI LILLY AND CO $ 35.80 1,153.14 $ 41,282.41 0.93% MID-CAP MCD MCDONALDS CORP $ 74.32 1,064.34 $ 79,101.60 1.78% LARGE-CAP MDT MEDTRONIC INC $ 33.35 1,079.89 $ 36,014.20 0.81% MID-CAP MMM 3M COMPANY $ 86.08 713.134 $ 61,386.60 1.38% LARGE-CAP MO ALTRIA GROUP INC. $ 23.52 2,083.97 $ 49,014.88 1.10% MID-CAP MOT MOTOROLA INC $ 8.39 2,333.89 $ 19,581.33 0.44% MID-CAP MRK MERCK AND COMPANY INC $ 36.33 3,073.59 $ 111,663.64 2.51% MEGA-CAP MSFT MICROSOFT CORP $ 25.22 8,653.57 $ 218,242.95 4.91% MEGA-CAP NKE NIKE, INC. $ 77.26 390.893 $ 30,200.36 0.68% MID-CAP ORCL ORACLE CORPORATION $ 27.46 5,030.66 $ 138,141.95 3.11% MEGA-CAP PEP PEPSICO INC $ 66.12 1,590.93 $ 105,192.56 2.37% MEGA-CAP PFE PFIZER INC. $ 17.06 8,038.28 $ 137,133.02 3.08% MEGA-CAP PG PROCTER AND GAMBLE CO $ 60.97 2,837.46 $ 172,999.82 3.89% MEGA-CAP SLB SCHLUMBERGER LIMITED $ 58.10 1,369.24 $ 79,552.61 1.79% LARGE-CAP SLE SARA LEE CORP $ 14.08 639.247 $ 9,000.59 0.20% MID-CAP T AT&T CORP $ 28.17 5,909.00 $ 166,456.53 3.74% MEGA-CAP TWX TIME WARNER, INC. $ 31.25 1,124.22 $ 35,131.75 0.79% MID-CAP TXN TEXAS INSTRUMENTS, INC.
Image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern