Question: Excel File Lab 5-1 Data.xlsx Global Company Key Data Date Data Year - Fiscal Ticker Symbol Assets - Total Net Income (Loss) Sales (Net) Standard

Excel File Lab 5-1 Data.xlsx

Global Company KeyData DateData Year - FiscalTicker SymbolAssets - TotalNet Income (Loss)Sales (Net)Standard Industry Classification Code
1161042018013120170190A1201.007-124.9592370.1185621
145977201812312018AAP9040.648423.8479580.5545531
30059201801312017AEO1816.313204.1633795.5495600
64768201812312018AMZN162648100732328875961
63643201801312017ANF2325.6927.0943492.695651
61839201809302018APU3925.818190.5222822.9785900
11872201809302018ARKR84.7374.655159.995812
186858201809302018ARMK13720.102567.88515789.6335812
4072201807312018ASNA3570.5-39.76578.35621
23809201808312018AZO9346.981337.53611221.0775531
25338201802282017BBBY7040.806424.85812349.3015700
2184201801312017BBY130491000421515731
4759201809302018BDL67.2653.677113.4975812
145041201812312018BGFV419.561-3.531987.5815940
165557201803312017BGI93.28711.699114.3785944
166684201801312017BGRP723.479-214.311891.5525961
12123201801312017BIG1651.726189.8325270.985331
33718201801312017BJ3273.85650.30112754.5895399
25234201801312017BKE538.11689.707913.385651
28924201804302017BKS1749.568-125.483662.285940
23208201804302017BNED1039.211-252.5662203.6175940
21898201803312017BOOT587.94128.879677.9495661
18675201801312017BURL2812.829384.8526110.0435600
142129201801312017BWTL20.3040.47527.4235412
2807201804302017CASY3469.927317.9037472.1245412
2818201801312017CATO516.0768.54849.9815621
63904201812312018CBD13651.409314.10412757.3995411
25108201801312017CBK119.364-22.024365.9065621
3570201807312018CBRL1527.355247.623030.4455812
27981201801312017CHS1087.6051012282.3795621
179624201803312017CJJD73.813-17.0696.1135912
165914201812312018CMG2265.518176.5534864.9855812
66586201812312018CNXN805.35564.5922699.4895961
156614201801312017CONN1900.7996.4631515.695731
29028201808312018COST4083031341415765399
13602201804302017CRMT455.58436.469537.5285500
163051201801312017CTRN327.07114.574755.2415651
7241201812312018CVS196456-5941945795912
3964201801312017DDS3673.169221.3246422.6765311
27936201801312017DEST162.582-21.597405.4435621
4016201801312017DG12516.9111538.9623470.9675331
150139201801312017DKS4203.939323.4458590.4725940
26335201801312017DLTH223.10223.351471.4475961
31587201801312017DLTR16332.81714.322245.55331
174222201812312018DNKN3456.581229.9061321.6175812
160211201812312018DPZ907.385361.9723432.8675812
31846201805312017DRI5469.65968080.15812
24171201801312017DSW1413.61367.3042799.7945661
13381201801312017DXLG240.405-18.826467.9765651
3007201806302018EAT1347.34125.8823135.4175812
24234201801312017EVLV249.2580.143648.225961
184323201801312017EXPR1187.60719.3662138.035600
24430201809302018EZPW1246.9239.059813.5155900
24157201812312018FCFS2107.974153.2061780.8585900
13962201807312018FGP1363.281-254.5812073.1425900
25357201802282017FINL675.03214.4141838.9565661
171141201801312017FIVE695.708102.4511278.2085331
11584201801312017FL396128477825661
122519201806302018FLWS570.88940.7911151.9215961
22155201812312018FND1234.091116.1871709.8485211
187041201801312017FRAN185.2415.561471.6785621
12403201801312017FRED597.565-150.1851805.4055331
5109201801312017GCO1315.353-111.8392907.0165661
145049201801312017GME5041.634.79224.65734
185645201812312018GNC1527.8569.782353.5235400
65718201812312018GPI5001.075157.77211600.2835500
4990201801312017GPS7989848158555651
22543201809302018GTIM60.95-1.03499.245812
5680201801312017HD4452986301009045211
63763201801312017HIBB461.84635.03968.2195940
26144201801312017HOME1373.28931.812950.5285700
5523201812312018HVT440.17930.307817.8365712
111103201809302018HZO640.53839.3121177.3715500
30262201803312017IFMK48.942-0.791136.6895411
12972201809302018IMKTA1824.91197.3654092.8055411
13092201809302018JACK823.397121.371869.695812
8446201801312017JCP8413-116125065311
19744201812312018JD30411.441-362.2767175.1785961
30435201801312017JILL597.55755.365698.1455621
7922201801312017JWN8115437154785651
100760201801312017KGFHY14682.393688.21516538.4455211
148391201801312017KIRK299.1975.296634.1175990
64410201802282017KMX17486.272664.11217977.1915500
6502201801312017KR3719719071226625411
25283201801312017KSS13340859190955311
6733201801312017LB8149983126325621
19581201801312017LE1124.13528.1951406.6775961
66261201809302018LIVE141.5245.923199.6335700
6829201801312017LOW352913447686195211
166213201809302018LQDT201.832-11.615224.5145961
6831201808312018LUB199.989-33.568365.1965812
4611201801312017M193811547248375311
153311201809302018MBPFY6363.839135.6782807.4995810
7154201812312018MCD32811.25924.321025.25812
7316201801312017MIK2300.215390.4985361.965945
34411201803312017MOGU570.341-88.985155.1525961
18498201812312018MUSA2360.8213.6125245500
17746201803312017NEEB64.269-0.91178.6925900
186501201803312017NGL6151.122-70.87517282.7185900
11922201809302018NGVC307.08312.661849.0425400
31227201812312018NTRI204.23758.593691.0395961
24076201801312017OLLI1038.199127.5941077.0325331
28180201812312018ORLY7980.7891324.4879536.4285531
63847201812312018PAG10904.547122785.15500
65406201803312017PETS134.83637.283273.85912
8579201802282017PIR772.31911.6261798.5225700
60923201801312017PLAY1197.03120.9491139.7915810
65430201801312017PLCE940.22884.6981870.2755600
65343201808312018PSMT1216.39274.3283166.7025331
28397201812312018PZZA570.9471.6461573.3165812
164471201812312018QSR2014161253575812
9155201802282017RAD8989.327943.4721528.9685912
111873201801312017RH1732.8662.182443.3815712
61418201809302018RICK330.56621.713165.7485810
31266201809302018RLLMF198.863-4.571281.4515961
9248201801312017ROST5722.0511362.75314134.7325651
160571201801312017RTW302.9565.675926.8685621
63000201812312018RUSHA3201.35139.0625506.195500
163891201812312018RUTH254.61341.68452.3345812
65831201812312018SAH3796.80751.659951.635500
175900201809302018SBH2097.414258.0473932.5655990
25434201809302018SBUX24156.44518.324719.55812
27938201801312017SCVL415.5818.9331019.1545661
102089201808312018SDXAY17737.154755.68623688.6195812
32688201807312018SFIX481.58544.91226.5055961
17934201812312018SFM1675.614158.5365207.3365411
61735201809302018SGU729.97155.5051677.8375900
6307201801312017SHLDQ7262-383167025311
12976201801312017SHOS412.688-95.0571719.9515700
15520201801312017SIG5839.6519.362535944
25186201801312017SMRT480.932-24.3241330.8335651
23697201808312018SONC531.13471.205423.595812
62501201809302018SPH2101.19976.5341344.4135900
16009201801312017SPWH379.66117.742809.6715940
63874201801312017SSI806.406-37.3231592.2755651
10380201806302018SSY26.176-1.59352.8725912
65482201801312017STRZ6.9980.12926.5255812
18842201803312017TCS749.36919.428857.2285700
3813201801312017TGT389992934718795331
13646201801312017TIF5468.1370.14169.85944
178973201801312017TITN760.308-7.0491202.9385500
11672201801312017TJX14058.0152607.94835864.6645651
25167201801312017TLRD1999.95596.7033304.3465600
187575201801312017TLYS290.11114.7576.8995600
29736201812312018TSCO3085.262532.3577911.0465200
13861201812312018TTS297.6310.442357.2545700
11944201806302018TUES376.256-21.9381006.3325331
12421201801312017TWMC247.906-42.553442.8565735
178704201801312017ULTA2908.687555.2345884.5065990
29150201801312017URBN1952.78108.2633616.0145651
18492201806302018VEND31.976-19.5360.8915900
170761201812312018VIPS6333.776309.51412289.3265961
11178201807312018VLGEA481.5925.081612.0155411
21540201812312018W1890.85-504.086779.1745961
11264201808312018WBA6812450241315375912
3708201812312018WEN4292.035460.1151589.9365812
105104201812312018WMMVY15598.8231870.28931393.7035331
11259201801312017WMT20452298624967855331
11511201801312017WSM2785.749259.5455292.3595961
65417201812312018YUM4130154256885812
162988201801312017ZUMZ499.5126.802927.4015651
Excel File Lab 5-1 Data.xlsx Global Company Key
Required Information [The following information applies to the questions displayed below.] NOTE: Throughout this lab, every time a screenshot Is requested, use your computer's screenshot tool, and paste each screenshot to the same Word document. Label each screenshot In accordance to what is noted In the lab. This document with all of the screenshots Included should be uploaded through Connect as a Word or PDF document when you have reached the final step of the lab. In this lab, you will: Required: 1. Compute descriptive statistics for the assets, sales, and income for the retail industry in 2018. 2. Calculate return on assets, and create a histogram showing the performance across the dataset. Ask the Question: What was the distribution of assets and ROA In 2018 for the retail industry? Master the Data: The reported results of financial performance are included in the dataset for the retail Industry. Software needed . Excel Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4) Data: Excel File Lab 5-1 Data.xIsx Perform the Analysis: Refer to Lab 5-1 in the text for instructions and steps for each the of lab parts. Share the Story: Once we have completed the computation of the descriptive statistics and created the histogram, we are ready to show management where the target retail company of Interest landed within the distribution for the whole industry. Upload one Word or PDF document containing all of your screenshots for this Lab using the button below. 1. Take a screenshot of your summary statistics of total assets, and label it "Lab 5-1 Submission 1." 2. Take a screenshot of your ROA histogram, and label it "Lab 5-1 Submission 2."

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Q:

Excel File Lab 5-1 Data.xlsx Global Company Key Data Date Data Year - Fiscal Ticker Symbol Assets - Total Net Income (Loss) Sales (Net) Standard Industry Classification Code 116104 20180131 2017...

Q:

turnover ... sales (same thing) roi ... income / total assets sales margin total proft / sales income Global Company Key Data Date Data Year - Fiscal Industry Format Level of Consolidation - Company...

Q:

Global Company Key Data Date Data Year - Fiscal Industry Format Level of Consolidation - Company Annual Descriptor Population Source Data Format Ticker Symbol ISO Currency Code Assets - Total Common...

Q:

Global Company Key Data Date Data Year - Fiscal Industry Format Level of Consolidation - Company Annual Descriptor Population Source Data Format Ticker Symbol ISO Currency Code Assets - Total Common...

Q:

Global Company Key Data Date Data Year - Fiscal Company Name Standard Industry Classification Code Assets - Total Cash and Short-Term Investments Current Liabilities - Total Liabilities and...

Q:

Population Source Level of Consolidation - Company Annual Descript Data Format STD STD STD ISO Currency Code USD USD USD CAD STD USD Global Company Key Data Date Data Year - Fisca Industry Forn 6821...

Q:

please answer the 5 question and based on the data what is return on sales formula? PDF document when you have reached the final step of the lab. In this lab, you will: Required: 1. Compute...

Q:

Please provide a page and a half paper to answer the following question: Major factors company should be aware of/evaluate regarding future investments projects. Use the attachments to answer the...

Q:

Company Chosen is Amazon. Section 3, Materiality and Risk The senior partner wants to confirm your understanding of key concepts. Summarize each concept 90-175-words each. Materiality Misstatement...

Q:

Download the most recent financial statements of Medtronic and Boston Scientific.From the attached ratio sheet pick 6 relevant ratios and compare the two companies.Then from the ratios you selected...

Q:

Calculate the following and explain the answers with favorable or Unfavorable. 1) Complete the Flexible budget sheet. 2) Profit Variance? 3) Total Revenue Variance 4) Revenue Volume Variance? 5)...

Q:

Arnett Gertrude, a widow with no children, lived with her sister and her nephew Jack Scriber. When Gertrude was diagnosed with cancer, she added Scriber as an authorized signatory to her checking...

Q:

10-8 Investigating variances from standard is a. always done. b. done if the variance is inside an acceptable range. c. not done if the variance is expected to recur. d. done if the variance is...

Q:

Determine the major differences between U.S. GAAP and IFRS disclosure reporting requirements related to each separately reportable operating segment. Next, give your opinion as to whether either U.S....