Question: Using the ETF Data.xlsx workbook from the chapter.. 3. Using the ETF Data.xlsx workbook from the chapter: a. Using Get & Transform, clean up the

Using the ETF Data.xlsx workbook from the chapter..

Using the ETF Data.xlsx workbook from the chapter.. 3. Using the ETFData.xlsx workbook from the chapter: a. Using Get & Transform, clean upthe data as described in the chapter, and keep only the FundName, Symbol, Asset Class, Total Return 2016, Total Return 2015, and Total

3. Using the ETF Data.xlsx workbook from the chapter: a. Using Get & Transform, clean up the data as described in the chapter, and keep only the Fund Name, Symbol, Asset Class, Total Return 2016, Total Return 2015, and Total Return 2014 fields. b. Create calculated columns in the original data that calculate the 2014 to 2016 total return for each ETF and for each Asset Class. Be sure to properly account for compounding of returns. Create a pivot table to show the average three-year total return for each asset class, and sort the pivot table from the highest return category to the lowest. Which asset class did the best? Worst? Create a pivot bar chart that shows the returns of the top 3 best performing asset classes over the last three years. Create another pivot table from this dataset, and then a calculated field that shows each ETF's three-year return minus the asset class three-year return. Which fund did best compared to its asset class over the three-year period? Which did the worst? AutoSave OFF $ u . Copy of ETF Data Home Insert Draw Page Layout Formulas Data Review View Share Comments H A V Ruler Formulawar Zoom 100% " la E B E Split - Wadian Headings 100 Zoom to 100% Zomin 100% Zoom to Selection New Window Arrunge Freeze Freeze Freeze First All Penes Too Row Column Switch Unhide Windows View Record Use Relative Macros Macro References Normal Page Break Page Custom dan Preview Layout View Gridines F14 X x 09/27/2003 ETF Sin.: IN-ETF, Yax-EINI ANDR Adukorshares Adisorsharcs 1 E Normal View 1 AGUSINICA DOSY Wight ADR ETF Sheras MSI AI SRINAS Jaron + ishares SCI ADAM ETF LHANH Fuster Garney Hacks NA NO Lunch bulu Fral Tech D n 07:20-20-D 7121,2010 Global Ex U.S. 11.1. 2014 Astarlo 02/262008 328 2028 Global ANXH Cle Eq. Eq. ADRA ELLAS Eq. Primares resto Fowwishers I Pumhares Iveco Fawn Share Eules EH ADRE NA NO HUAN ANAN HAN UNA NO AVANO 11.12.2002 11/12/2002 Rais Pelic 11.3.202 11/1.1 2002 Develserne 11.12.2002 11/19/2002 Eorging Markets 11/13:2002 111.3 2002 E 0414.2006 4115 2008 Global 2009 M e East Amca ELDES Equity NANO NGF Deutsche Bank P UNA NO ED2 03 41162020 Global U 220S 192R 2023 Nath UHISH 120022003 12499 2 og Slabs NA NA 11/12/2007 11/16/2007 Mais Paolo 6 BLDAS A GO ADR Index Fund TULORS Developed Narkete 100 NDR Index Tund BLDR Energne Markets BO ADR Index Fund 2 DURS Eumenict ADR-dex Fund 10 de Agriculture Blert ETN L1 VanEc Vectors teica Index ETF 12 Ce Agriculue Doule Best ETN 13 cagriculure Long ETN 10 SN Care U.S. Are Bens ETF LS Pronares Ultra Slver IR SH EY Pure ETF LT IShares la 50 ETF IX V.than Axel Fuel 19 J.P. Morgan Noria MLP Index ETN 20 A HOPEF 21 Global X FTSE Andean 40 ETF 13 Sheras Cere Aggie Alication ETT 23 iShares Core Conaerative Alocasian ETF 24 Shares are cr e ation TT 25 iShares Care Growth Allocation ETF 26 Global X MSCI Arcanina ETF 27 Globe X Southea Aia ETF 28 Vasdom Australia & New Zealand Debt Fund 29 Wadan DC'd Fun 30 VisdomTree Asia Pacifica Japan Fund Al Capsi 40120220344022039 North America Global X ANAND v I NANO WWUAN UNAN NAN UNA NO HNAN HUAN AN Back Rock 11.04.2003 11.07.2003 Global 114.2003 11072CO3 lb 0211720-1 272019 Aals Peric 06/20.2008 0:25 2050 Asia-Paclic GNANO |E4. NANO Creylus Corporation Asla Capilu Melor Capla Manape NA Valsdam Bucky Cuplu OG 16:2200 0416:2306 11/17/2009 W2036 als Pacilla 521.20.8 E ur Parka 11/17/2009 North America PowerShares WAND Bency Cuplu 32 PowerShares Buis Amona Bond Portfolo 33 Puth B y Cation Sales Tuin Porn ETN 34 iPath Pure Ecla Broad Commodity ETN 15 ETRALS 2HIHM; Long Vile Frau Businex n n h indwa EIN 36 ETRACS Linked to Wa Faman Dewetement Comodar Index ETN 17 H He istuting EIN 04/20/23 1 4212011 Global ANAND ETRICS Eq. UNAN Eq. 04/27/2011 4/28/2011 Global GR10. 2016 erila. 04/08/2010 4/0B2010 North America 1207361111.1111 memnaMarket 0412.20- 4122010 Energing Marko /2012007 2007 North America 04 08:20- 0 0 10 North America 142307 4110/2007 North America 01.22.200B 124 2028 Global 11/12.2007 11/16 2007 Emerging Markets WANI UNA NO HAN -2011 NAVO Vanguard Equity NA NANO Ira Pemes Barclays Capita 912042014211201 Saba 10 Frat Tuat BICK Index Find 11 SPOR Tomberg Parca 1-3 on TWITT 42 Poarea Urban Nailocher 13 Vanguard Inlamadiate Tarm Band Index Fund 44 Van Ee Varios Carina ETF 43 Shares SC BRIC ETF 46 Puh enrir au Parles 47 IFath Pure Bela Precious Melas ETN 4X Vanguard Long Tim Bond Inches Fund 49 Vanguard Tocal Bond Market Index Fund 90 SPOR H Bercy Bar ETF 51 Unhed States Beni Cl F.nd LP 52 Ch WINE Date Star EIN 53 ce Base Micials Short ETN 54 C XH D ITA EI 55 R X Brazi Consumer ETF Sheet1 + VH NAND HUAN VANO 090120T 4/102097 North America 06/23.2307 5302037 North PHEN 06/02.2010 6/02 2010 Global ENO NANO US Commodky Funds Dusche Ren Deutsche Bank US Commodity Funds DHUISH X-TMISH. | c tri NA BCS 225 22 OG 16:2003 6/TI208 Global 17:2990 2010 AT 2.0 F072010 Linensis 1.0 No WNUA NI Epey | || | AutoSave $ u- Copy of ETF Data Home Insert Draw Page Layout Formulas Data Review View Share Comments H R uler Formula Bar Zoom 100% " E B 5 Split E F E Normal Page Break Page Custom Preview Layout Views Gridlines Headings Zoom to 100% Zoom to Selection New Window Arrange Freeze Freeze Freeze First All Panes Top Row Column Switch Unhide Windows View Record Use Relative Macros Macro References F14 - X V fx 09/22/2003 on Thurn 1- r a Sutvik Dorsey, W & Associates Shnchen Depository Pcosists Tecelaka h Se 14,409,37G m -Yr 20.57465100 els alum 28. G OZO 5 284,283,340 2 .93652280 20.37648000 30.77474820 Large Care Depos tary R 20.228.40 -14.006490 1.33508060 2 . 036170 30.030D Y 0 8 ze and Style STA! 8 zo and Style Syaan yle 8 ze and Style Sya and he 32 and pls Sze and Style Ariculture Sze and Style AlieuuN Noriculture BAS Deposit Robi De Rere Depository Role Door Receita 120,471,000 2.49614400 -2.39 23.97417820 -12. 0 3.43814400 Lance Cas Broud Market Brabase Optimized 9.22675370 91.225769 14. 50 75.000 -3.20675370 Broad Market Optimized 1.951,753 4.89734000 -20.92073000 4.9879900 NA Nak Ve 38 77479 20.02452400 B3.649 100 390.601,016 30.1392200 29.59700400 303922000 NA AGHI Large Cas 304. GT 1.60 12.16EOCOS 7.4190630 8.7442460 ular Compi 3.772 200.00 18.23940300 8.0000 13.43948330 Distributions Dentele Market Cap 8 zo and Style Brood based 4.18033800 30.52867202 22.654054.0 72.000 Aasot Alocation Tocal Market Tlak Targe: Rak Tangelas Targe: Rak 128 HZ,471 273,001,714 2.17440090 13 297000 23.6B103620 24.0300 3.7440030 Aasot Alocation Proprietary Proprietary NY Das Fixed Asset 735,904,618 0.88403 FAO 20.11091603 38.GADEO 22.0000 0.83409550 26 Crwylus Corporation Aler Cupils Han Malo Cala Manga 151 629.60 32,858, 770 HDvided 58.000 MENN Broad Market Hot Disickins Yield Total Market Enyora Markus -5.77002140 4.9310CO 2.3492130 6.41909000 4.01702100 1.041O Delcords 0.00170 BAXIN-Ewing Park Broad Malurile 28. TEGO 64.2104E0CO 22.000 ! 15.744,961 35.662,411 Broad Market 28 243000000 16900 30.0300 Prva Euly Private Equity 3.93748290 2.0B962430 WHEN D Worker cap ha: NASDWO Llated 29.85344400 -10.51 303. 7 00 .0300 11000 96.0200 433,330,000 57.03054300 71.38444600 1.030144330 8 zo and Style Tocal Market Brood-based Market Cap 7,207,34 11.77827100 2 56253910 29.88126400 11.77927100 14.0200 13 KNO Investment Grade Canum daieas Total Market NASDMO - Liated AT Vaus Market Cap 10.225320,575 17, 190,250 163 709 910 .75074600 18 5271500 -13.96843200 6.-248900 BE.0200 6.7807460 M" ADANA Boad Market Broad Matures 12 5439140 ONA 51 Sirge Asset NA Irul. Als Ird.stdal Malas Calcu Frort Month Clinical Optimized CRUTH CAPUT 19.21.204 2.755,572 1.614.997 Fucd 61.58404800 01.12149776 12. 865 380. -28 54/2/310 26.3472740 17.62780300 0 0. 202020 46.97201000 6.G7051820 -83.7490CDOU 33.749000 34.07 177400 -10.3725100 17.62790330 75.0000 TG.0200 55 ANS Rao Tr Comitee 4.1016101 0.259222 TADOR A2821024 Shaal AutoSave OFF $ u . Copy of ETF Data Home Insert Draw Page Layout Formulas Data Review View Share Comments H A V Ruler Formula War Zoom 100% uld B Split E 5 Normal Page Break Page Custom Preview Layout Views Gridines Headings 100 Zoom to 100% Zoom to Selection New Window Arrange Freeze Freeze Freeze First All Penes Too Row Column Switch Unhide Windows View Record Usc Relative Macros Macro References F14 fx 09/22/2003 A AC AD 441AI AJ AK AL AM AN 400 THIN 12 2:18 1.-26000 Tellum 21112 X 5 Yr Alps Yr bent 5 Yr; V T 125.000 19.19006200 Tin Iurn 20113 16.820 37200 16.55256700 -5.79044700 1.0463 - 14.00649900 1.1795 -12.88.63600 -272875000 3.46853180 -516101190 -3.25132900 -7.23423000 13.41282920 21.91261220 13.10C1709 24.110 1090 18.18607000 20.97500 19.54707800 15.7544ABCO 12.5241700 .21497080 16.60 ECO 3.78451870 G.GIGOSO 13.05409900 3.2875370 3100 - 1950 10.6510430 76.0000 17. GBC8310 20. 2810 0.30140065 16.33013300 30.13922000 5.529415 68.41GOUCO 63.7622000 213.TO 9.76424500 5.92241600 16. BOTITS02 4.9749CO BE4973GEO 37.623 19.43946300 28.41 0670 10.06442300 1.0523 1.5123 3,762,457 72.0000 4.18039000 27.02313600 -0.76345205 2014021120 9.57321002 -12.64415400 16.146492001 4.84997090 9.17440090 407743450 0.3205 0.253 01.24. 65,937 0.1588270 97806420 290191950 0.83404920 18.49715000 1.72887770 0.622 211,959 11.05412300 2.52ECO 4.00618300 10.13326000 9.21931300 2 20037700 0.4737 0.1432 -1.1 4,024 9.44926400 11.406702 7.4776170 9399940 G.9934 14.44400 278877900 9.49262500 0.449B70EG 23.77715100 8.02573000 -7.67 56270 6.9.19 17.42892700 11.00250509 T7117110 104.76588209 27671 2.945 942,00 -57.03094300 94.78505000 9.0787EBCO 93.1273GOO 2.6534 3.1747 -11.77827100 -0.01297491 - 17543400 - 1192327 27.0877780 -0. TJU -28. 69115600 1.3120 - 1010 00904 13. 1.635,076 4.25082140 -0.0210310 -52.151300CO - 1.15291490 $1.000O 2.72902450 9.10289200 5.3304300 663.234 1.14745000 -5.87647800 22 S100 0.023 1.42AI -25.25576500 -120245730 09.00 16.22479300 15,310772802 30.121 2,714,2 19.6617300 7.39L11100 28.03 GECO G.27946490 4.41081529 1.1 1089940 7.67863280 0.0162 0.2782 1.907,844 94.0000 16.B27E0E0D 12.256DBCO 7.450G3900 0.9342 G0.25347500 2447R HOT 11.21839300 212,640 1,21 76.0000 25.00000000 4.210 34.0747400 -10 71001 -17.62730300 0.253724 PO2224 + 20.78602400 551 6.551792690 17.907GBG 0.0870 -1712C1971 1K .2479281901.6512 RATA20 NORA 1.6539 1.712 17.0000 Sheet1 3. Using the ETF Data.xlsx workbook from the chapter: a. Using Get & Transform, clean up the data as described in the chapter, and keep only the Fund Name, Symbol, Asset Class, Total Return 2016, Total Return 2015, and Total Return 2014 fields. b. Create calculated columns in the original data that calculate the 2014 to 2016 total return for each ETF and for each Asset Class. Be sure to properly account for compounding of returns. Create a pivot table to show the average three-year total return for each asset class, and sort the pivot table from the highest return category to the lowest. Which asset class did the best? Worst? Create a pivot bar chart that shows the returns of the top 3 best performing asset classes over the last three years. Create another pivot table from this dataset, and then a calculated field that shows each ETF's three-year return minus the asset class three-year return. Which fund did best compared to its asset class over the three-year period? Which did the worst? AutoSave OFF $ u . Copy of ETF Data Home Insert Draw Page Layout Formulas Data Review View Share Comments H A V Ruler Formulawar Zoom 100% " la E B E Split - Wadian Headings 100 Zoom to 100% Zomin 100% Zoom to Selection New Window Arrunge Freeze Freeze Freeze First All Penes Too Row Column Switch Unhide Windows View Record Use Relative Macros Macro References Normal Page Break Page Custom dan Preview Layout View Gridines F14 X x 09/27/2003 ETF Sin.: IN-ETF, Yax-EINI ANDR Adukorshares Adisorsharcs 1 E Normal View 1 AGUSINICA DOSY Wight ADR ETF Sheras MSI AI SRINAS Jaron + ishares SCI ADAM ETF LHANH Fuster Garney Hacks NA NO Lunch bulu Fral Tech D n 07:20-20-D 7121,2010 Global Ex U.S. 11.1. 2014 Astarlo 02/262008 328 2028 Global ANXH Cle Eq. Eq. ADRA ELLAS Eq. Primares resto Fowwishers I Pumhares Iveco Fawn Share Eules EH ADRE NA NO HUAN ANAN HAN UNA NO AVANO 11.12.2002 11/12/2002 Rais Pelic 11.3.202 11/1.1 2002 Develserne 11.12.2002 11/19/2002 Eorging Markets 11/13:2002 111.3 2002 E 0414.2006 4115 2008 Global 2009 M e East Amca ELDES Equity NANO NGF Deutsche Bank P UNA NO ED2 03 41162020 Global U 220S 192R 2023 Nath UHISH 120022003 12499 2 og Slabs NA NA 11/12/2007 11/16/2007 Mais Paolo 6 BLDAS A GO ADR Index Fund TULORS Developed Narkete 100 NDR Index Tund BLDR Energne Markets BO ADR Index Fund 2 DURS Eumenict ADR-dex Fund 10 de Agriculture Blert ETN L1 VanEc Vectors teica Index ETF 12 Ce Agriculue Doule Best ETN 13 cagriculure Long ETN 10 SN Care U.S. Are Bens ETF LS Pronares Ultra Slver IR SH EY Pure ETF LT IShares la 50 ETF IX V.than Axel Fuel 19 J.P. Morgan Noria MLP Index ETN 20 A HOPEF 21 Global X FTSE Andean 40 ETF 13 Sheras Cere Aggie Alication ETT 23 iShares Core Conaerative Alocasian ETF 24 Shares are cr e ation TT 25 iShares Care Growth Allocation ETF 26 Global X MSCI Arcanina ETF 27 Globe X Southea Aia ETF 28 Vasdom Australia & New Zealand Debt Fund 29 Wadan DC'd Fun 30 VisdomTree Asia Pacifica Japan Fund Al Capsi 40120220344022039 North America Global X ANAND v I NANO WWUAN UNAN NAN UNA NO HNAN HUAN AN Back Rock 11.04.2003 11.07.2003 Global 114.2003 11072CO3 lb 0211720-1 272019 Aals Peric 06/20.2008 0:25 2050 Asia-Paclic GNANO |E4. NANO Creylus Corporation Asla Capilu Melor Capla Manape NA Valsdam Bucky Cuplu OG 16:2200 0416:2306 11/17/2009 W2036 als Pacilla 521.20.8 E ur Parka 11/17/2009 North America PowerShares WAND Bency Cuplu 32 PowerShares Buis Amona Bond Portfolo 33 Puth B y Cation Sales Tuin Porn ETN 34 iPath Pure Ecla Broad Commodity ETN 15 ETRALS 2HIHM; Long Vile Frau Businex n n h indwa EIN 36 ETRACS Linked to Wa Faman Dewetement Comodar Index ETN 17 H He istuting EIN 04/20/23 1 4212011 Global ANAND ETRICS Eq. UNAN Eq. 04/27/2011 4/28/2011 Global GR10. 2016 erila. 04/08/2010 4/0B2010 North America 1207361111.1111 memnaMarket 0412.20- 4122010 Energing Marko /2012007 2007 North America 04 08:20- 0 0 10 North America 142307 4110/2007 North America 01.22.200B 124 2028 Global 11/12.2007 11/16 2007 Emerging Markets WANI UNA NO HAN -2011 NAVO Vanguard Equity NA NANO Ira Pemes Barclays Capita 912042014211201 Saba 10 Frat Tuat BICK Index Find 11 SPOR Tomberg Parca 1-3 on TWITT 42 Poarea Urban Nailocher 13 Vanguard Inlamadiate Tarm Band Index Fund 44 Van Ee Varios Carina ETF 43 Shares SC BRIC ETF 46 Puh enrir au Parles 47 IFath Pure Bela Precious Melas ETN 4X Vanguard Long Tim Bond Inches Fund 49 Vanguard Tocal Bond Market Index Fund 90 SPOR H Bercy Bar ETF 51 Unhed States Beni Cl F.nd LP 52 Ch WINE Date Star EIN 53 ce Base Micials Short ETN 54 C XH D ITA EI 55 R X Brazi Consumer ETF Sheet1 + VH NAND HUAN VANO 090120T 4/102097 North America 06/23.2307 5302037 North PHEN 06/02.2010 6/02 2010 Global ENO NANO US Commodky Funds Dusche Ren Deutsche Bank US Commodity Funds DHUISH X-TMISH. | c tri NA BCS 225 22 OG 16:2003 6/TI208 Global 17:2990 2010 AT 2.0 F072010 Linensis 1.0 No WNUA NI Epey | || | AutoSave $ u- Copy of ETF Data Home Insert Draw Page Layout Formulas Data Review View Share Comments H R uler Formula Bar Zoom 100% " E B 5 Split E F E Normal Page Break Page Custom Preview Layout Views Gridlines Headings Zoom to 100% Zoom to Selection New Window Arrange Freeze Freeze Freeze First All Panes Top Row Column Switch Unhide Windows View Record Use Relative Macros Macro References F14 - X V fx 09/22/2003 on Thurn 1- r a Sutvik Dorsey, W & Associates Shnchen Depository Pcosists Tecelaka h Se 14,409,37G m -Yr 20.57465100 els alum 28. G OZO 5 284,283,340 2 .93652280 20.37648000 30.77474820 Large Care Depos tary R 20.228.40 -14.006490 1.33508060 2 . 036170 30.030D Y 0 8 ze and Style STA! 8 zo and Style Syaan yle 8 ze and Style Sya and he 32 and pls Sze and Style Ariculture Sze and Style AlieuuN Noriculture BAS Deposit Robi De Rere Depository Role Door Receita 120,471,000 2.49614400 -2.39 23.97417820 -12. 0 3.43814400 Lance Cas Broud Market Brabase Optimized 9.22675370 91.225769 14. 50 75.000 -3.20675370 Broad Market Optimized 1.951,753 4.89734000 -20.92073000 4.9879900 NA Nak Ve 38 77479 20.02452400 B3.649 100 390.601,016 30.1392200 29.59700400 303922000 NA AGHI Large Cas 304. GT 1.60 12.16EOCOS 7.4190630 8.7442460 ular Compi 3.772 200.00 18.23940300 8.0000 13.43948330 Distributions Dentele Market Cap 8 zo and Style Brood based 4.18033800 30.52867202 22.654054.0 72.000 Aasot Alocation Tocal Market Tlak Targe: Rak Tangelas Targe: Rak 128 HZ,471 273,001,714 2.17440090 13 297000 23.6B103620 24.0300 3.7440030 Aasot Alocation Proprietary Proprietary NY Das Fixed Asset 735,904,618 0.88403 FAO 20.11091603 38.GADEO 22.0000 0.83409550 26 Crwylus Corporation Aler Cupils Han Malo Cala Manga 151 629.60 32,858, 770 HDvided 58.000 MENN Broad Market Hot Disickins Yield Total Market Enyora Markus -5.77002140 4.9310CO 2.3492130 6.41909000 4.01702100 1.041O Delcords 0.00170 BAXIN-Ewing Park Broad Malurile 28. TEGO 64.2104E0CO 22.000 ! 15.744,961 35.662,411 Broad Market 28 243000000 16900 30.0300 Prva Euly Private Equity 3.93748290 2.0B962430 WHEN D Worker cap ha: NASDWO Llated 29.85344400 -10.51 303. 7 00 .0300 11000 96.0200 433,330,000 57.03054300 71.38444600 1.030144330 8 zo and Style Tocal Market Brood-based Market Cap 7,207,34 11.77827100 2 56253910 29.88126400 11.77927100 14.0200 13 KNO Investment Grade Canum daieas Total Market NASDMO - Liated AT Vaus Market Cap 10.225320,575 17, 190,250 163 709 910 .75074600 18 5271500 -13.96843200 6.-248900 BE.0200 6.7807460 M" ADANA Boad Market Broad Matures 12 5439140 ONA 51 Sirge Asset NA Irul. Als Ird.stdal Malas Calcu Frort Month Clinical Optimized CRUTH CAPUT 19.21.204 2.755,572 1.614.997 Fucd 61.58404800 01.12149776 12. 865 380. -28 54/2/310 26.3472740 17.62780300 0 0. 202020 46.97201000 6.G7051820 -83.7490CDOU 33.749000 34.07 177400 -10.3725100 17.62790330 75.0000 TG.0200 55 ANS Rao Tr Comitee 4.1016101 0.259222 TADOR A2821024 Shaal AutoSave OFF $ u . Copy of ETF Data Home Insert Draw Page Layout Formulas Data Review View Share Comments H A V Ruler Formula War Zoom 100% uld B Split E 5 Normal Page Break Page Custom Preview Layout Views Gridines Headings 100 Zoom to 100% Zoom to Selection New Window Arrange Freeze Freeze Freeze First All Penes Too Row Column Switch Unhide Windows View Record Usc Relative Macros Macro References F14 fx 09/22/2003 A AC AD 441AI AJ AK AL AM AN 400 THIN 12 2:18 1.-26000 Tellum 21112 X 5 Yr Alps Yr bent 5 Yr; V T 125.000 19.19006200 Tin Iurn 20113 16.820 37200 16.55256700 -5.79044700 1.0463 - 14.00649900 1.1795 -12.88.63600 -272875000 3.46853180 -516101190 -3.25132900 -7.23423000 13.41282920 21.91261220 13.10C1709 24.110 1090 18.18607000 20.97500 19.54707800 15.7544ABCO 12.5241700 .21497080 16.60 ECO 3.78451870 G.GIGOSO 13.05409900 3.2875370 3100 - 1950 10.6510430 76.0000 17. GBC8310 20. 2810 0.30140065 16.33013300 30.13922000 5.529415 68.41GOUCO 63.7622000 213.TO 9.76424500 5.92241600 16. BOTITS02 4.9749CO BE4973GEO 37.623 19.43946300 28.41 0670 10.06442300 1.0523 1.5123 3,762,457 72.0000 4.18039000 27.02313600 -0.76345205 2014021120 9.57321002 -12.64415400 16.146492001 4.84997090 9.17440090 407743450 0.3205 0.253 01.24. 65,937 0.1588270 97806420 290191950 0.83404920 18.49715000 1.72887770 0.622 211,959 11.05412300 2.52ECO 4.00618300 10.13326000 9.21931300 2 20037700 0.4737 0.1432 -1.1 4,024 9.44926400 11.406702 7.4776170 9399940 G.9934 14.44400 278877900 9.49262500 0.449B70EG 23.77715100 8.02573000 -7.67 56270 6.9.19 17.42892700 11.00250509 T7117110 104.76588209 27671 2.945 942,00 -57.03094300 94.78505000 9.0787EBCO 93.1273GOO 2.6534 3.1747 -11.77827100 -0.01297491 - 17543400 - 1192327 27.0877780 -0. TJU -28. 69115600 1.3120 - 1010 00904 13. 1.635,076 4.25082140 -0.0210310 -52.151300CO - 1.15291490 $1.000O 2.72902450 9.10289200 5.3304300 663.234 1.14745000 -5.87647800 22 S100 0.023 1.42AI -25.25576500 -120245730 09.00 16.22479300 15,310772802 30.121 2,714,2 19.6617300 7.39L11100 28.03 GECO G.27946490 4.41081529 1.1 1089940 7.67863280 0.0162 0.2782 1.907,844 94.0000 16.B27E0E0D 12.256DBCO 7.450G3900 0.9342 G0.25347500 2447R HOT 11.21839300 212,640 1,21 76.0000 25.00000000 4.210 34.0747400 -10 71001 -17.62730300 0.253724 PO2224 + 20.78602400 551 6.551792690 17.907GBG 0.0870 -1712C1971 1K .2479281901.6512 RATA20 NORA 1.6539 1.712 17.0000 Sheet1

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!