From the data spreadsheet provided below, you need to select 7 ratios for the company. The variables (or series) in the companys sheet contains the same series, in quarterly data. You want to note the start and end dates of each series. Table 6.1 below provides a list of all ratio series in each companys file along with their name. You want to note that there may be missing or limited data.
While developing an analysis of financial ratios, you should develop several relevant graphs using the dataset available to you where you explain the recent evolution of the corresponding ratios. You are to analyze your graphs with respect to: Seasonal Adjustment, Long-Term Trend, and Structural Breaks
Table 6.1 Data Dictionary and Deere Company Example 1 1.1 1.2 1.3 1.4 1.5 1.6 3 3.1 3.2 3.3 5 5.1 5.2 Profitability Ratios Return on Asset ROA% Return on Equity ROE% Return on Investment % (ROI) EBITDA Margin % Calculated Tax Rate % CTR Revenue per Employee RPE Debt Management LT Debt to Equity LTDE Total Debt to Equity DE Interest Coverage IC Per Share Cash Flow per Share CFPS Book Value per Share BVPS 2 2.1 2.2 2.3 4 4.1 4.2 4.3 4.4 4.5 4.6 4.7 Liquidity Ratios Quick Ratio QR Current Ratio CR Net Current Assets % TANCATA Asset Management Total Asset Turnover TAT Receivables Turnover RT Inventory Jurnover JT Accounts Payable Turnover APT Accrued Expenses Turnover AET Property Plant & Equip Turnover PPET Cash & Equivalents Jurnover. CET QTR 05/08/2005 roa_cost roe_cost roi_cost ebitda_cost ctr_cost quick_cost crt_cost nca_cost Itde_cost tde_cost interest_cost tat_cost receivables_cost inventory_cost apt_cost aet_cost ppe_cost cet_cost cfs_cost bvs_cost 5.49 14 3.56 37.9 0.63 1.25 0.08 0.12 3.14 161.18 11.35 6.88 18.07 4.48 18.49 10.43 13.03 15.57 0.08 0.09 22.74 18.8 14.63 3.85 3.4 3.85 28.9 37.86 36.11 6.94 5.53 7.45 5.94 1.22 1.19 1.17 10.45 14.2 0.06 0.07 10.12 8.95 7.98 7 4.95 19.06 08/28/2005 11/20/2005 02/12/2006 05/07/2006 09/03/2006 11/26/2006 19.37 0.07 0.06 0.02 19.3 19.66 11.19 15.8 3.52 38.93 1.11 0.06 11.87 16.14 35.89 1.05 2.36 0.02 0.06 6.27 5.73 19.78 19.7 11.36 15.94 37.35 0.99 -0.45 0.02 0.06 0.96 -2.17 0.02 0.07 3.61 3.39 3.34 3.2 3.76 3.39 36.72 37.06 1.13 5.65 0.25 12.21 16.56 11.27 14.65 14.19 16.79 13.1 15.72 16.09 0.26 35.98 156.04 139.48 149.15 150.28 132.73 104.9 93.86 90.11 96.47 90.09 93.39 96.4 105.25 93.55 88.44 1.09 3.79 0.24 0.26 3.27 3.31 3.53 3.35 3.51 3.42 3.61 3.4 3.41 3.38 3.54 3.45 3.59 3.42 3.51 3.27 3.37 35.34 1.06 2.9 0.25 0.25 12.82 42.27 13.04 43.6 12.38 43.8 13.2 45.43 13.06 42.31 13.53 44.9 12.15 43.94 12.51 45.28 12.55 43.34 12.94 45.58 12.17 45.81 12.81 47.49 13.06 46.12 13.76 48.02 45.21 45.07 13.25 41.54 13.48 42.5 12.78 41.75 13.67 44.14 13.35 41.76 13.19 41.28 6.84 3.59 27.59 1.26 28.75 7.42 27.14 2.61 34.66 3.97 36.67 3.86 38.46 3.07 26.92 8.07 22.47 3.91 24.88 2.71 29.42 5.82 28.22 9.12 27.53 3.1 29.47 -0.39 29.75 8.63 23.73 6.86 23.37 4.37 22.19 7.46 6.02 19.7 3.83 38.12 1.05 2.42 0.24 0.26 7.06 7.15 7.64 7.06 7.25 7.07 7.4 7.07 7.17 7.07 7.38 7.11 7.31 6.93 7.12 6.59 6.82 6.83 7.33 6.97 7.03 14.2 17.85 3.71 36.59 1.06 2.61 0.24 0.25 14.16 17.16 02/18/2007 5.97 05/13/2007 5.2 09/02/2007 6.2 11/25/2007 5.61 02/17/2008 05/11/2008 08/31/2008 11/23/2008 02/15/2009 05/10/2009 08/30/2009 11/22/2009 02/14/2010 05/09/2010 08/29/2010 3.71 34.46 1.07 2.84 0.24 12.67 16.12 3.55 37.25 1.06 2.68 0.25 12.87 11.56 3.28 37.97 3.34 0.24 13.49 15.23 13.45 9.81 3.3 38.91 3.89 0.23 84.43 12.51 16.22 36.14 4.8 0.22 92.26 11.35 14.95 3.73 3.6 3.63 36.02 0.21 3.31 89.33 12.38 16.06 35.65 0.2 90.49 21.01 18.08 7.97 12.35 16.47 3.81 34.39 3.48 3.27 3.3 0.2 87.35 12.97 17.23 3.96 36.11 0.2 92.39 20.62 4.56 6.12 6.19 5.48 4.98 4.34 5.63 5.09 5.55 5.63 5.9 i 0.5 0.54 0.49 0.36 0.35 0.52 - 0.41 0.43 0.46 - 0.38 0.46 0.48 - 0.49 0.57 0.6 1.08 1.09 1.11 1.13 1.17 1.18 1.16 5.72 7 7.82 6.91 0.26 0.27 0.26 0.24 0.23 0.21 0.21 0.2 0.2 53.55 1847.52 17.6 22.21 23.41 16.32 26 25.18 21.36 21.35 26.46 11.86 11.14 11.75 11.63 11.93 10.81 11.16 11.32 11.88 11.28 11.71 11.99 12.79 11.31 11.75 11.65 11.91 11.27 12.3 12.34 12.25 19.56 19.27 19.73 20.15 20.6 20.95 21.25 20.43 21.01 21.78 22.98 23.55 24.19 24.68 24.98 5.44 5.84 5.34 5.8 5.08 6.17 6.06 6.8 6.4 8.14 11/21/2010 02/13/2011 05/08/2011 08/28/2011 11/20/2011 02/12/2012 05/06/2012 09/02/2012 11/25/2012 02/17/2013 05/12/2013 09/01/2013 11/24/2013 02/16/2014 05/11/2014 08/31/2014 11/23/2014 02/15/2015 05/10/2015 6.68 08/30/2015 7.47 11/22/2015 6.06 02/14/2016 6.99 05/08/2016 7.15 08/28/2016 7.57 11/20/2016 6.8 02/12/2017 6.2 05/07/2017 8.54 09/03/2017 7.83 6.75 6.67 5.9 6.3 6.4 6.91 6.37 7.62 12.31 17.31 13.27 19.12 11.96 17.36 13 11.63 17.57 16.66 14.18 19.51 13.52 19.02 14.98 21.02 14.45 19.99 20.87 22.1 19.38 20.68 19.94 18.88 16.75 18.12 17.7 19.24 17.62 19.23 18.83 20.79 17.48 19.24 23.03 23.36 21.57 22.4 23.58 22.57 19.43 19.76 21.72 22.58 21.05 22.88 21.53 22.93 19.69 21.51 18.33 21.21 27.23 26.8 27.27 28.41 3.71 3.77 3.62 3.78 3.58 3.7 3.71 3.95 3.63 3.89 3.92 3.9 3.62 3.71 3.77 4.01 3.89 4.15 4.14 4.29 3.88 4.07 4.27 4.4 4.12 3.82 4.47 4.47 34.13 35.6 36.14 35.23 40.69 34.29 34.89 35.54 34.83 25.03 34.83 34.8 34.6 35.03 33.84 35.08 35.17 30.23 35.04 32.7 36.09 34.01 34.25 33.53 34.4 35.6 26.84 34.32 0.55 0.6 0.57 - 0.52 0.55 0.57 - 0.48 0.53 0.57 0.51 0.56 0.57 - 0.55 0.48 0.48 0.42 0.41 0.43 - 0.4 0.4 0.34 1.18 1.22 1.13 1.14 1.13 1.16 1.18 1.1 1.09 1.16 1.17 1.19 1.17 1.2 1.19 1.22 1.2 0.99 1.05 1.05 1.03 1.01 0.97 0.98 0.97 0.93 0.81 0.99 7.89 9.3 5.84 6.19 6.01 7.09 7.99 4.66 4.33 7.1 7.85 8.53 7.86 8.71 8.7 9.62 9.06 -0.57 2.68 2.27 1.59 0.3 -1.35 -1.08 -1.62 -3.93 -11.61 -0.49 0.19 0.19 0.1 0.1 0.11 0.11 0.11 0.11 0.11 0.48 0.47 0.46 0.44 0.43 0.42 0.41 0.41 0.38 0.46 0.46 0.45 0.44 0.34 0.34 0.33 0.23 0.29 0.61 0.19 0.19 0.18 0.18 0.19 0.19 0.11 0.11 0.11 0.48 0.47 0.46 0.44 0.43 0.42 0.41 0.41 0.49 0.57 0.58 0.56 0.45 0.44 0.43 0.43 0.41 0.4 0.62 27.63 33.11 32.71 36.29 33.94 46 155.75 63.27 213 61.5 72.2 53 44.53 80.44 67 64.18 64.17 97.44 43.21 42.81 33.35 40.76 53.63 56.71 53.06 56.27 161.33 48.33 3.35 3.5 3.4 3.42 3.43 3.6 3.51 3.6 3.65 3.7 3.54 3.51 3.47 3.58 3.49 3.52 3.45 3.5 3.38 3.48 3.43 3.61 3.51 3.55 3.5 3.58 3.52 3.61 89.46 86.35 86.83 96.01 96.54 96.24 91.95 96.69 93.64 87.33 85.99 90.68 92.67 95.69 95.02 102.31 97.45 94.12 91.39 96.4 91.58 87.06 84.5 93.37 88.8 83.58 81.99 89.66 11.66 12.21 12.54 12.34 11.54 12.03 12.15 12.24 11.81 12.02 12.01 11.93 11.01 11.38 11.7 11.94 11.23 11.41 11.31 11.4 10.64 11.02 11.29 11.53 10.72 11.13 11.26 11.5 12.71 42.42 13.77 45.05 14.03 43.82 13.76 37.88 13.31 37.82 14.35 45.72 14.23 44.02 13.53 38.37 12.78 34.42 13.29 35.06 13.74 33.52 13.52 33.81 12.74 34.06 13.52 34.56 13.95 33.3 13.74 33.67 12.78 33.38 13.19 33.91 13.19 32.09 13.02 32.31 12.2 33.7 13.16 36.47 13.64 34.6 14.49 32.69 13.12 32.88 13.09 36.51 35.19 13.79 13.63 36.54 7.17 7.52 7.34 7.43 7.57 8.02 7.72 7.73 7.86 8.11 7.77 7.72 7.73 7.99 7.75 7.87 7.88 8.04 7.57 7.65 7.57 7.67 7.15 7.11 7.14 7.5 7.19 7.27 7.21 24.05 25.57 7.22 24.1 8.06 22.7 7.02 22.57 6.64 22.92 5.8 21.13 10.85 23.76 5.18 27.76 11.05 26.01 4.22 21.22 13.43 20.98 4.2 23.27 9.32 23.26 7.04 20.63 14.73 20.18 6.27 19.94 11.17 20.16 8.88 20.75 12.14 23.64 7.64 24 8.04 28.18 7.82 27.31 18.41 28.84 -1.26 29.84 27.71 4.88 27.09 27.02 15.9 28.57 12.85 25.67 26.5 27.33 27.64 27.36 28.19 29.05 28.59 29.13 23.17 23.98 24.8 25.52 26.18 26.95 28.11 28.06 23.19 24.08 24.24 24.67 25.04 26.25 27.61 27.25 28.34 22.56 24.65 11/26/2017 02/18/2018 05/13/2018 09/02/2018 11/25/2018 02/17/2019 05/12/2019 7.34 7.8 8.32 8.45 7.87 8.92 9.1 25.45 23.62 26.68 24.65 27.27 25.13 27.26 24.85 25.67 21.18 28.59 26.14 27.78 23.59 4.06 4.08 4.37 4.26 3.64 4.42 4.21 30.45 27.69 28.85 27.33 16.9 25.84 18.43 0.41 0.41 0.44 - 0.43 0.41 0.43 0.98 1 1.01 1.02 1.02 0.96 0.98 -1.18 -0.04 0.71 0.89 1.1 -1.87 -1.25 0.58 0.55 0.53 0.51 0.49 0.35 0.33 0.58 0.55 0.53 0.51 0.49 0.47 0.45 50.05 63.5 66.69 144.6 105.44 561 3.65 3.67 3.59 3.6 3.6 3.55 3.49 92.42 80.55 78.25 88.74 87.98 81.16 81.62 11.4 11.41 11.48 11.63 11.45 11.33 11.59 12.8 37.22 13 36.84 13.54 36.25 13.19 37.16 12.51 37.58 12.9 36.79 13.7 36.15 7.5 7.6 7.36 7.45 7.7 7.69 7.43 27.01 19.9 27.39 1.08 26.39 20.85 24.26 11.55 23.75 21.54 23.92 -2.16 23.06 20.79 25.22 26.78 27.69 29.21 29.89 31.5 32.94 Table 6.1 Data Dictionary and Deere Company Example 1 1.1 1.2 1.3 1.4 1.5 1.6 3 3.1 3.2 3.3 5 5.1 5.2 Profitability Ratios Return on Asset ROA% Return on Equity ROE% Return on Investment % (ROI) EBITDA Margin % Calculated Tax Rate % CTR Revenue per Employee RPE Debt Management LT Debt to Equity LTDE Total Debt to Equity DE Interest Coverage IC Per Share Cash Flow per Share CFPS Book Value per Share BVPS 2 2.1 2.2 2.3 4 4.1 4.2 4.3 4.4 4.5 4.6 4.7 Liquidity Ratios Quick Ratio QR Current Ratio CR Net Current Assets % TANCATA Asset Management Total Asset Turnover TAT Receivables Turnover RT Inventory Jurnover JT Accounts Payable Turnover APT Accrued Expenses Turnover AET Property Plant & Equip Turnover PPET Cash & Equivalents Jurnover. CET QTR 05/08/2005 roa_cost roe_cost roi_cost ebitda_cost ctr_cost quick_cost crt_cost nca_cost Itde_cost tde_cost interest_cost tat_cost receivables_cost inventory_cost apt_cost aet_cost ppe_cost cet_cost cfs_cost bvs_cost 5.49 14 3.56 37.9 0.63 1.25 0.08 0.12 3.14 161.18 11.35 6.88 18.07 4.48 18.49 10.43 13.03 15.57 0.08 0.09 22.74 18.8 14.63 3.85 3.4 3.85 28.9 37.86 36.11 6.94 5.53 7.45 5.94 1.22 1.19 1.17 10.45 14.2 0.06 0.07 10.12 8.95 7.98 7 4.95 19.06 08/28/2005 11/20/2005 02/12/2006 05/07/2006 09/03/2006 11/26/2006 19.37 0.07 0.06 0.02 19.3 19.66 11.19 15.8 3.52 38.93 1.11 0.06 11.87 16.14 35.89 1.05 2.36 0.02 0.06 6.27 5.73 19.78 19.7 11.36 15.94 37.35 0.99 -0.45 0.02 0.06 0.96 -2.17 0.02 0.07 3.61 3.39 3.34 3.2 3.76 3.39 36.72 37.06 1.13 5.65 0.25 12.21 16.56 11.27 14.65 14.19 16.79 13.1 15.72 16.09 0.26 35.98 156.04 139.48 149.15 150.28 132.73 104.9 93.86 90.11 96.47 90.09 93.39 96.4 105.25 93.55 88.44 1.09 3.79 0.24 0.26 3.27 3.31 3.53 3.35 3.51 3.42 3.61 3.4 3.41 3.38 3.54 3.45 3.59 3.42 3.51 3.27 3.37 35.34 1.06 2.9 0.25 0.25 12.82 42.27 13.04 43.6 12.38 43.8 13.2 45.43 13.06 42.31 13.53 44.9 12.15 43.94 12.51 45.28 12.55 43.34 12.94 45.58 12.17 45.81 12.81 47.49 13.06 46.12 13.76 48.02 45.21 45.07 13.25 41.54 13.48 42.5 12.78 41.75 13.67 44.14 13.35 41.76 13.19 41.28 6.84 3.59 27.59 1.26 28.75 7.42 27.14 2.61 34.66 3.97 36.67 3.86 38.46 3.07 26.92 8.07 22.47 3.91 24.88 2.71 29.42 5.82 28.22 9.12 27.53 3.1 29.47 -0.39 29.75 8.63 23.73 6.86 23.37 4.37 22.19 7.46 6.02 19.7 3.83 38.12 1.05 2.42 0.24 0.26 7.06 7.15 7.64 7.06 7.25 7.07 7.4 7.07 7.17 7.07 7.38 7.11 7.31 6.93 7.12 6.59 6.82 6.83 7.33 6.97 7.03 14.2 17.85 3.71 36.59 1.06 2.61 0.24 0.25 14.16 17.16 02/18/2007 5.97 05/13/2007 5.2 09/02/2007 6.2 11/25/2007 5.61 02/17/2008 05/11/2008 08/31/2008 11/23/2008 02/15/2009 05/10/2009 08/30/2009 11/22/2009 02/14/2010 05/09/2010 08/29/2010 3.71 34.46 1.07 2.84 0.24 12.67 16.12 3.55 37.25 1.06 2.68 0.25 12.87 11.56 3.28 37.97 3.34 0.24 13.49 15.23 13.45 9.81 3.3 38.91 3.89 0.23 84.43 12.51 16.22 36.14 4.8 0.22 92.26 11.35 14.95 3.73 3.6 3.63 36.02 0.21 3.31 89.33 12.38 16.06 35.65 0.2 90.49 21.01 18.08 7.97 12.35 16.47 3.81 34.39 3.48 3.27 3.3 0.2 87.35 12.97 17.23 3.96 36.11 0.2 92.39 20.62 4.56 6.12 6.19 5.48 4.98 4.34 5.63 5.09 5.55 5.63 5.9 i 0.5 0.54 0.49 0.36 0.35 0.52 - 0.41 0.43 0.46 - 0.38 0.46 0.48 - 0.49 0.57 0.6 1.08 1.09 1.11 1.13 1.17 1.18 1.16 5.72 7 7.82 6.91 0.26 0.27 0.26 0.24 0.23 0.21 0.21 0.2 0.2 53.55 1847.52 17.6 22.21 23.41 16.32 26 25.18 21.36 21.35 26.46 11.86 11.14 11.75 11.63 11.93 10.81 11.16 11.32 11.88 11.28 11.71 11.99 12.79 11.31 11.75 11.65 11.91 11.27 12.3 12.34 12.25 19.56 19.27 19.73 20.15 20.6 20.95 21.25 20.43 21.01 21.78 22.98 23.55 24.19 24.68 24.98 5.44 5.84 5.34 5.8 5.08 6.17 6.06 6.8 6.4 8.14 11/21/2010 02/13/2011 05/08/2011 08/28/2011 11/20/2011 02/12/2012 05/06/2012 09/02/2012 11/25/2012 02/17/2013 05/12/2013 09/01/2013 11/24/2013 02/16/2014 05/11/2014 08/31/2014 11/23/2014 02/15/2015 05/10/2015 6.68 08/30/2015 7.47 11/22/2015 6.06 02/14/2016 6.99 05/08/2016 7.15 08/28/2016 7.57 11/20/2016 6.8 02/12/2017 6.2 05/07/2017 8.54 09/03/2017 7.83 6.75 6.67 5.9 6.3 6.4 6.91 6.37 7.62 12.31 17.31 13.27 19.12 11.96 17.36 13 11.63 17.57 16.66 14.18 19.51 13.52 19.02 14.98 21.02 14.45 19.99 20.87 22.1 19.38 20.68 19.94 18.88 16.75 18.12 17.7 19.24 17.62 19.23 18.83 20.79 17.48 19.24 23.03 23.36 21.57 22.4 23.58 22.57 19.43 19.76 21.72 22.58 21.05 22.88 21.53 22.93 19.69 21.51 18.33 21.21 27.23 26.8 27.27 28.41 3.71 3.77 3.62 3.78 3.58 3.7 3.71 3.95 3.63 3.89 3.92 3.9 3.62 3.71 3.77 4.01 3.89 4.15 4.14 4.29 3.88 4.07 4.27 4.4 4.12 3.82 4.47 4.47 34.13 35.6 36.14 35.23 40.69 34.29 34.89 35.54 34.83 25.03 34.83 34.8 34.6 35.03 33.84 35.08 35.17 30.23 35.04 32.7 36.09 34.01 34.25 33.53 34.4 35.6 26.84 34.32 0.55 0.6 0.57 - 0.52 0.55 0.57 - 0.48 0.53 0.57 0.51 0.56 0.57 - 0.55 0.48 0.48 0.42 0.41 0.43 - 0.4 0.4 0.34 1.18 1.22 1.13 1.14 1.13 1.16 1.18 1.1 1.09 1.16 1.17 1.19 1.17 1.2 1.19 1.22 1.2 0.99 1.05 1.05 1.03 1.01 0.97 0.98 0.97 0.93 0.81 0.99 7.89 9.3 5.84 6.19 6.01 7.09 7.99 4.66 4.33 7.1 7.85 8.53 7.86 8.71 8.7 9.62 9.06 -0.57 2.68 2.27 1.59 0.3 -1.35 -1.08 -1.62 -3.93 -11.61 -0.49 0.19 0.19 0.1 0.1 0.11 0.11 0.11 0.11 0.11 0.48 0.47 0.46 0.44 0.43 0.42 0.41 0.41 0.38 0.46 0.46 0.45 0.44 0.34 0.34 0.33 0.23 0.29 0.61 0.19 0.19 0.18 0.18 0.19 0.19 0.11 0.11 0.11 0.48 0.47 0.46 0.44 0.43 0.42 0.41 0.41 0.49 0.57 0.58 0.56 0.45 0.44 0.43 0.43 0.41 0.4 0.62 27.63 33.11 32.71 36.29 33.94 46 155.75 63.27 213 61.5 72.2 53 44.53 80.44 67 64.18 64.17 97.44 43.21 42.81 33.35 40.76 53.63 56.71 53.06 56.27 161.33 48.33 3.35 3.5 3.4 3.42 3.43 3.6 3.51 3.6 3.65 3.7 3.54 3.51 3.47 3.58 3.49 3.52 3.45 3.5 3.38 3.48 3.43 3.61 3.51 3.55 3.5 3.58 3.52 3.61 89.46 86.35 86.83 96.01 96.54 96.24 91.95 96.69 93.64 87.33 85.99 90.68 92.67 95.69 95.02 102.31 97.45 94.12 91.39 96.4 91.58 87.06 84.5 93.37 88.8 83.58 81.99 89.66 11.66 12.21 12.54 12.34 11.54 12.03 12.15 12.24 11.81 12.02 12.01 11.93 11.01 11.38 11.7 11.94 11.23 11.41 11.31 11.4 10.64 11.02 11.29 11.53 10.72 11.13 11.26 11.5 12.71 42.42 13.77 45.05 14.03 43.82 13.76 37.88 13.31 37.82 14.35 45.72 14.23 44.02 13.53 38.37 12.78 34.42 13.29 35.06 13.74 33.52 13.52 33.81 12.74 34.06 13.52 34.56 13.95 33.3 13.74 33.67 12.78 33.38 13.19 33.91 13.19 32.09 13.02 32.31 12.2 33.7 13.16 36.47 13.64 34.6 14.49 32.69 13.12 32.88 13.09 36.51 35.19 13.79 13.63 36.54 7.17 7.52 7.34 7.43 7.57 8.02 7.72 7.73 7.86 8.11 7.77 7.72 7.73 7.99 7.75 7.87 7.88 8.04 7.57 7.65 7.57 7.67 7.15 7.11 7.14 7.5 7.19 7.27 7.21 24.05 25.57 7.22 24.1 8.06 22.7 7.02 22.57 6.64 22.92 5.8 21.13 10.85 23.76 5.18 27.76 11.05 26.01 4.22 21.22 13.43 20.98 4.2 23.27 9.32 23.26 7.04 20.63 14.73 20.18 6.27 19.94 11.17 20.16 8.88 20.75 12.14 23.64 7.64 24 8.04 28.18 7.82 27.31 18.41 28.84 -1.26 29.84 27.71 4.88 27.09 27.02 15.9 28.57 12.85 25.67 26.5 27.33 27.64 27.36 28.19 29.05 28.59 29.13 23.17 23.98 24.8 25.52 26.18 26.95 28.11 28.06 23.19 24.08 24.24 24.67 25.04 26.25 27.61 27.25 28.34 22.56 24.65 11/26/2017 02/18/2018 05/13/2018 09/02/2018 11/25/2018 02/17/2019 05/12/2019 7.34 7.8 8.32 8.45 7.87 8.92 9.1 25.45 23.62 26.68 24.65 27.27 25.13 27.26 24.85 25.67 21.18 28.59 26.14 27.78 23.59 4.06 4.08 4.37 4.26 3.64 4.42 4.21 30.45 27.69 28.85 27.33 16.9 25.84 18.43 0.41 0.41 0.44 - 0.43 0.41 0.43 0.98 1 1.01 1.02 1.02 0.96 0.98 -1.18 -0.04 0.71 0.89 1.1 -1.87 -1.25 0.58 0.55 0.53 0.51 0.49 0.35 0.33 0.58 0.55 0.53 0.51 0.49 0.47 0.45 50.05 63.5 66.69 144.6 105.44 561 3.65 3.67 3.59 3.6 3.6 3.55 3.49 92.42 80.55 78.25 88.74 87.98 81.16 81.62 11.4 11.41 11.48 11.63 11.45 11.33 11.59 12.8 37.22 13 36.84 13.54 36.25 13.19 37.16 12.51 37.58 12.9 36.79 13.7 36.15 7.5 7.6 7.36 7.45 7.7 7.69 7.43 27.01 19.9 27.39 1.08 26.39 20.85 24.26 11.55 23.75 21.54 23.92 -2.16 23.06 20.79 25.22 26.78 27.69 29.21 29.89 31.5 32.94
