i. Retrieve the data and submit the Excel file with the data by e-mail. To check if
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A 1 Symbol Description 2 AAL B C D E F G H K L Quantity Currency LastPrice PricePaid DayChange ProfitLoss MarketValue ProfitLoss Percentage 4 3 AEO AMZN 5 BA 6 BBWI American Airlines Group Inc American Eagle Outfitters Inc. Amazon.com Inc. Boeing Co. Bath & Body Works Inc 50 USD 14.68 15.96 1 USD 22.29 22.54 -0.22 -0.71 -64 -0.25 734 22.29 -8.02 -1.11 200 USD 175.35 160.363333 -1.47 2,997.33 35070 9.35 235 USD 198.49 212.34 -4.54 -3,254.75 46645.15 -6.52 1177 USD 44.76 42.44 0.97 2,730.64 52682.52 5.47 7 BURL Burlington Stores Inc 254 USD 216.25 196.89 -5.01 4,917.44 54927.5 9.83 8 CBS Paramount Global - Ordinary Shares - Class B 1 USD 10.93 13.46 0.13 -2.53 10.93 -18.8 9 COST Costco Wholesale Corp 72 USD 725.56 687.09 -60.03 2,769.84 52240.32 5.6 10 CVX Chevron Corp. 100 USD 149.88 152.37 0.51 -249 14988 -1.63 11 DAL Delta Air Lines, Inc. 1 USD 42.24 40.54 -0.54 1.7 42.24 4.19 12 DIS Walt Disney Co (The) 200 USD 110.32 96.97 0.14 2,670.00 22064 13.77 13 EBAY EBay Inc. 100 USD 50.37 42.5 -0.14 787 5037 18.52 14 EL Estee Lauder Cos., Inc. - Ordinary Shares - Class A 100 USD 149.5 134.52 1.33 1,498.00 14950 11.14 15 FIS Fidelity National Information Services, Inc. 100 USD 69.65 62.65 0.5 700 6965 11.17 16 GOOG Alphabet Inc - Ordinary Shares - Class C 50 USD 136.29 145.42 1.05 -456.5 6814.5 -6.28 17 GPS Gap, Inc. 2713 USD 20.92 18.42 1.59 6,782.50 56755.96 13.57 18 HSY Hershey Company 257 USD 194.56 191.48 2.04 791.56 50001.92 1.61 19 HUM 20 INTC Humana Inc. Intel Corp. 50 USD 339.35 367.94 -1.37 -1,429.50 16967.5 -7.77 350 USD 44 43.3071429 -2.15 242.5 15400 1.6 21 KO Coca-Cola Co 100 USD 59.52 59.56 0.08 -4 5952 -0.07 22 LCID Lucid Group Inc 100 USD 3.1 3.02 -0.02 8 310 2.65 23 LYFT Lyft Inc - Ordinary Shares Cls A 10 USD 18.31 16.99 0.26 13.2 183.1 7.77 24 MCD McDonald's Corp 10 USD 292.55 283.57 1.44 89.8 2925.5 3.17 25 MSFT Microsoft Corporation 125 USD 406.22 392.73 -2.92 1,686.25 50777.5 3.43 26 NFLX NetFlix Inc 50 USD 604.82 567.86 -3.69 1,848.00 30241 6.51 27 NIO NIO Inc - ADR 50 USD 5.8 5.42 0.03 19 290 7.01 28 NKE Nike, Inc. - Ordinary Shares - Class B 485 USD 99.16 102.95 0.97 -1,838.15 48092.6 -3.68 A 1 Symbol Description 2 AAL B C D E F G H K L Quantity Currency LastPrice PricePaid DayChange ProfitLoss MarketValue ProfitLoss Percentage 4 3 AEO AMZN 5 BA 6 BBWI American Airlines Group Inc American Eagle Outfitters Inc. Amazon.com Inc. Boeing Co. Bath & Body Works Inc 50 USD 14.68 15.96 1 USD 22.29 22.54 -0.22 -0.71 -64 -0.25 734 22.29 -8.02 -1.11 200 USD 175.35 160.363333 -1.47 2,997.33 35070 9.35 235 USD 198.49 212.34 -4.54 -3,254.75 46645.15 -6.52 1177 USD 44.76 42.44 0.97 2,730.64 52682.52 5.47 7 BURL Burlington Stores Inc 254 USD 216.25 196.89 -5.01 4,917.44 54927.5 9.83 8 CBS Paramount Global - Ordinary Shares - Class B 1 USD 10.93 13.46 0.13 -2.53 10.93 -18.8 9 COST Costco Wholesale Corp 72 USD 725.56 687.09 -60.03 2,769.84 52240.32 5.6 10 CVX Chevron Corp. 100 USD 149.88 152.37 0.51 -249 14988 -1.63 11 DAL Delta Air Lines, Inc. 1 USD 42.24 40.54 -0.54 1.7 42.24 4.19 12 DIS Walt Disney Co (The) 200 USD 110.32 96.97 0.14 2,670.00 22064 13.77 13 EBAY EBay Inc. 100 USD 50.37 42.5 -0.14 787 5037 18.52 14 EL Estee Lauder Cos., Inc. - Ordinary Shares - Class A 100 USD 149.5 134.52 1.33 1,498.00 14950 11.14 15 FIS Fidelity National Information Services, Inc. 100 USD 69.65 62.65 0.5 700 6965 11.17 16 GOOG Alphabet Inc - Ordinary Shares - Class C 50 USD 136.29 145.42 1.05 -456.5 6814.5 -6.28 17 GPS Gap, Inc. 2713 USD 20.92 18.42 1.59 6,782.50 56755.96 13.57 18 HSY Hershey Company 257 USD 194.56 191.48 2.04 791.56 50001.92 1.61 19 HUM 20 INTC Humana Inc. Intel Corp. 50 USD 339.35 367.94 -1.37 -1,429.50 16967.5 -7.77 350 USD 44 43.3071429 -2.15 242.5 15400 1.6 21 KO Coca-Cola Co 100 USD 59.52 59.56 0.08 -4 5952 -0.07 22 LCID Lucid Group Inc 100 USD 3.1 3.02 -0.02 8 310 2.65 23 LYFT Lyft Inc - Ordinary Shares Cls A 10 USD 18.31 16.99 0.26 13.2 183.1 7.77 24 MCD McDonald's Corp 10 USD 292.55 283.57 1.44 89.8 2925.5 3.17 25 MSFT Microsoft Corporation 125 USD 406.22 392.73 -2.92 1,686.25 50777.5 3.43 26 NFLX NetFlix Inc 50 USD 604.82 567.86 -3.69 1,848.00 30241 6.51 27 NIO NIO Inc - ADR 50 USD 5.8 5.42 0.03 19 290 7.01 28 NKE Nike, Inc. - Ordinary Shares - Class B 485 USD 99.16 102.95 0.97 -1,838.15 48092.6 -3.68
Expert Answer:
Related Book For
Posted Date:
Students also viewed these finance questions
-
Carol Harris, Ph.D, CPA, is a single taxpayer and she lives at 674 Yankee Street, Durham, NC 27409. Her Social Security number is 793-52-4335. Carol is an Associate Professor of Accounting at a local...
-
CANMNMM January of this year. (a) Each item will be held in a record. Describe all the data structures that must refer to these records to implement the required functionality. Describe all the...
-
The information listed below refers to the employees of Lemonica Company for the year ended December 31, 2016. The wages are separated into the quarters in which they were paid to the individual...
-
1. You and a friend agree to meet at your favorite restaurant between 5:00 P.M. and 6:00 P.M. The one who arrives first will wait 15 minutes for the other, and then will leave (see figure). What is...
-
Starbucks is a coffee company-a big coffee company. During a 10-year period, the number of Starbucks locations grew from 165 to over 8,800 stores in 50 countries. The following is adapted from...
-
Which of the following clauses will stop the loop when the value in the intPopulation variable is less than the number 5000? a. Do While intPopulation >= 5000 b. Do Until intPopulation < 5000 c. Loop...
-
Go to the St. Louis Federal Reserve FRED database, and find data on real GDP (GDPC1), potential GDP (GDPPOT), and the unemployment rate (UNRATE) from 1960 to the most recent period. For the...
-
Jane Leeves declared voluntary Chapter 7 bankruptcy. The trustee included the following property in her bankruptcy estate: Janes wedding ring Janes computer for her consulting business that she...
-
It took 6 seconds for the sound of a whistle to reach an observer 5400 feet away from the whistle. At what rate did the sound travel in feet per minute?
-
Which one of the four functions of management includes the coordination of activities to meet organizational goals?
-
The following T-account (in billions of dollars) depicts an intervention by the Federal Reserve in the foreign exchange market: a) Did the Federal Reserve buy or sell U.S. dollars? b) What is the...
-
For each of the following cases, determine which would be the preferred macroeconomic model to analyze business fluctuations. a) Most wages are the result of collective bargaining and are therefore...
-
Oil leaks from offshore drilling platforms in the Gulf of Mexico have resulted in stricter regulations on this type of oil extraction. a) Discuss the effects of such regulations on the user cost of...
-
In Keyness liquidity preference theory, what variables determine the demand for real money balances? How does the demand for real money balances respond to changes in each of these variables?
-
Suppose a country is rapidly making the transition from an agricultural-based economy to an economy in which most of GDP comes from manufacturing. a) How do you think structural unemployment will be...
-
Write a C function that takes three arguments: a character and two integers. The character is to be printed. The first integer specifies the number of times that the character is to be printed on a...
-
The vapor pressure of the liquid NH, is measured at different temperatures. The following vapor pressure data are obtained. Temperature, K P, mmHg 217.1 223.4 234.7 588.1 Calculate the enthalpy of...
-
Compound interest Treasury notes authorized in 1863 and 1864 after they were purchased could be used as currency with the added bonus that they could be redeemed three years after they were issued....
-
For the quadrilaterals named in Problems 3539, answer yes or no to indicate whether each of the following properties is satisfied: a.Opposite sides are parallel. b.Opposite sides have equal length....
-
Completely reduce the fractions in Problems 718. 78 a. 455 b. 75 500
-
Parents with a child in subsidized childcare in the province of Qubec, Canada, pay a basic amount and, depending on family income, may pay an additional amount. As of January 1, 2017, families with a...
-
A firm in the state of Karnataka in India can source one of its factors of production either within the state, \(F_{K}\), or from the neighboring state of Maharashtra, \(F_{M}\). Assume the quality...
-
A firm has the cost curve \(C(q)=25+q^{2}\). Show how the firm's average cost varies with output. Is there a minimum average cost and, if so, at what level of output is average cost minimized?
Study smarter with the SolutionInn App