Security Valuation Project

Anonymous
timer Asked: Feb 9th, 2019
account_balance_wallet $9.99

Question Description

First read the instructions and make sure you understand the concepts .. there are 8 problems must be done by the excel ... check out the uploaded files ..

Unformatted Attachment Preview

Security Valuation Project Estimate American Express’ Required Rate of Return and Intrinsic Value Per Share Please follow the posted template and submit your projects via e-mail. Your Excel spreadsheet should be active, which means that I should be able to see your formulas by clicking on the appropriate cells. Please name your project as “Firstname Lastname” (without quotes) and submit it to the e-mail thread. Download weekly data for Jabil Circuit (symbol: JBL) from January 4, 2010, to January 4, 2019. Do the same thing for Depository Receipts from Standard and Poor’s (S&P). S&P’s Depository Receipts have symbol SPY and are commonly called “spiders.” We will use SPY as the market portfolio. Problems: 1. 2. 3. 4. Calculate the weekly return on JBL by dividing the adjusted close in any particular week by the adjusted closing price the previous week and subtracting 1. Calculate the weekly return on the SPY the same way. Paste the returns on the S&P and the returns on JBL into a single spreadsheet. (To do so, use the “Paste-Special-Values” sequence in Excel). Calculate the correlation coefficient between JBL returns and SPY returns. You will run a regression in Excel using the returns on JBL as the dependent, or Y variable, and returns on the SPY as the independent, or X variable. You can use the data analysis function under the tools menu (you may have to first click “Add ins” under the tools menu and then check the box labeled “Analysis Toolpak”). Click “Tools-Data Analysis Regression” to set up the regression. Type in the cell range containing JBL returns for the input Y range, and type in the cell range containing the SPY returns for the input X range. Leave all the other boxes unchecked. You have just estimated JBL’s beta, which is the coefficient of the X variable in the regression output. 5. Estimate JBL’s required rate of return using a risk-free rate of 0.5% and a market risk premium of 1.5%. 6. Estimate JBL’s dividend growth rate (g) using the formula g = ROE × b, where b is the retention ratio. Remember that b = 1- Dividend Payout Ratio. Use the value of “Dvd Payout Ratio” for 2018Y in the “11) Profitability” tab under “5) Ratios.” Convert the dividend payout ratio to a decimal. Use the ROE value in the same location, and convert it to a decimal. 7. Find the most recent annual dividend paid by JBL as of the most recent date in the date range and assume that the dividend growth rate will remain constant. What would be JBL’s intrinsic stock price according to the Constant Dividend Growth Model? 8. Answer the following questions by comparing your computed stock price from Problem 7 to JBL’s closing price as of the most recent date in the raw data. Is JBL’s current stock price overvalued or undervalued? Why? If you already hold JBL in your portfolio, should you sell it or keep holding it? Why? If you do not already hold JBL, should you buy it or not? Why? 2/6/2019 2/1/2019 1/25/2019 1/18/2019 1/11/2019 1/4/2019 27.2475 JBL 26.57 25.83 25.42 24.55 23.95 12/28/2018 12/21/2018 12/14/2018 12/7/2018 24.49 23.4 21.84 23.26 11/30/2018 11/23/2018 11/16/2018 11/9/2018 11/2/2018 24.97 24.64 24.99 25.29 26.13 10/26/2018 10/19/2018 10/12/2018 10/5/2018 23.63 23.93 23.73 25.72 9/28/2018 9/21/2018 9/14/2018 9/7/2018 27.08 29.86 29.5 29.15 8/31/2018 8/24/2018 8/17/2018 8/10/2018 8/3/2018 29.56 28.1 27.67 28.08 28.54 7/27/2018 7/20/2018 7/13/2018 7/6/2018 28.05 28.56 28.67 28.22 6/29/2018 6/22/2018 6/15/2018 6/8/2018 6/1/2018 27.66 28.3 27.73 29.25 28.68 5/25/2018 28.21 1/4/2019 2531.94 S&P 12/28/2018 12/21/2018 12/14/2018 12/7/2018 2485.74 2416.62 2599.95 2633.08 11/30/2018 11/23/2018 11/16/2018 11/9/2018 11/2/2018 2760.17 2632.56 2736.27 2781.01 2723.06 10/26/2018 10/19/2018 10/12/2018 10/5/2018 2658.69 2767.78 2767.13 2885.57 9/28/2018 9/21/2018 9/14/2018 9/7/2018 2913.98 2929.67 2904.98 2871.68 8/31/2018 8/24/2018 8/17/2018 8/10/2018 8/3/2018 2901.52 2874.69 2850.13 2833.28 2840.35 7/27/2018 7/20/2018 7/13/2018 7/6/2018 2818.82 2801.83 2801.31 2759.82 6/29/2018 6/22/2018 6/15/2018 6/8/2018 6/1/2018 2718.37 2754.88 2779.66 2779.03 2734.62 5/25/2018 5/18/2018 5/11/2018 5/4/2018 2721.33 2712.97 2727.72 2663.42 4/27/2018 4/20/2018 2669.91 2670.14 5/18/2018 5/11/2018 5/4/2018 27.93 27.61 27.44 4/27/2018 4/20/2018 4/13/2018 4/6/2018 26.67 27.94 29.23 27.95 3/30/2018 3/23/2018 3/16/2018 3/9/2018 3/2/2018 28.73 28.59 31.37 28.19 27 2/23/2018 2/16/2018 2/9/2018 2/2/2018 26.61 26.37 25.44 25.28 1/26/2018 1/19/2018 1/12/2018 1/5/2018 26.53 27.39 27.66 27.19 12/29/2017 12/22/2017 12/15/2017 12/8/2017 12/1/2017 26.25 26.7 27.87 27.88 28.58 11/24/2017 11/17/2017 11/10/2017 11/3/2017 29.78 29.22 28.61 28.02 10/27/2017 10/20/2017 10/13/2017 10/6/2017 28.44 27.96 28.24 29.79 9/29/2017 9/22/2017 9/15/2017 9/8/2017 9/1/2017 28.55 29.44 30.72 30.44 31.34 4/13/2018 4/6/2018 2656.3 2604.47 3/30/2018 3/23/2018 3/16/2018 3/9/2018 3/2/2018 2640.87 2588.26 2752.01 2786.57 2691.25 2/23/2018 2/16/2018 2/9/2018 2/2/2018 2747.3 2732.22 2619.55 2762.13 1/26/2018 1/19/2018 1/12/2018 1/5/2018 2872.87 2810.3 2786.24 2743.15 12/29/2017 12/22/2017 12/15/2017 12/8/2017 12/1/2017 2673.61 2683.34 2675.81 2651.5 2642.22 11/24/2017 11/17/2017 11/10/2017 11/3/2017 2602.42 2578.85 2582.3 2587.84 10/27/2017 10/20/2017 10/13/2017 10/6/2017 2581.07 2575.21 2553.17 2549.33 9/29/2017 9/22/2017 9/15/2017 9/8/2017 9/1/2017 2519.36 2502.22 2500.23 2461.43 2476.55 8/25/2017 8/18/2017 8/11/2017 8/4/2017 2443.05 2425.55 2441.32 2476.83 7/28/2017 2472.1 8/25/2017 8/18/2017 8/11/2017 8/4/2017 30.3 29.67 29.22 30.72 7/28/2017 7/21/2017 7/14/2017 7/7/2017 30.57 30.74 30.49 29.29 6/30/2017 6/23/2017 6/16/2017 6/9/2017 6/2/2017 29.19 30.09 28.46 31.04 30.86 5/26/2017 5/19/2017 5/12/2017 5/5/2017 29.32 28.58 28.95 28.95 4/28/2017 4/21/2017 4/14/2017 4/7/2017 29.02 28.95 28.24 28.72 3/31/2017 3/24/2017 3/17/2017 3/10/2017 3/3/2017 28.92 28.74 28.8 26.33 25.96 2/24/2017 2/17/2017 2/10/2017 2/3/2017 26.23 25.91 25.44 24.39 1/27/2017 1/20/2017 1/13/2017 1/6/2017 23.88 23.2 23.58 23.34 12/30/2016 12/23/2016 12/16/2016 12/9/2016 12/2/2016 23.67 24.11 24.15 21.62 20.5 7/21/2017 7/14/2017 7/7/2017 2472.54 2459.27 2425.18 6/30/2017 6/23/2017 6/16/2017 6/9/2017 6/2/2017 2423.41 2438.3 2433.15 2431.77 2439.07 5/26/2017 5/19/2017 5/12/2017 5/5/2017 2415.82 2381.73 2390.9 2399.29 4/28/2017 4/21/2017 4/14/2017 4/7/2017 2384.2 2348.69 2328.95 2355.54 3/31/2017 3/24/2017 3/17/2017 3/10/2017 3/3/2017 2362.72 2343.98 2378.25 2372.6 2383.12 2/24/2017 2/17/2017 2/10/2017 2/3/2017 2367.34 2351.16 2316.1 2297.42 1/27/2017 1/20/2017 1/13/2017 1/6/2017 2294.69 2271.31 2274.64 2276.98 12/30/2016 12/23/2016 12/16/2016 12/9/2016 12/2/2016 2238.83 2263.79 2258.07 2259.53 2191.95 11/25/2016 11/18/2016 11/11/2016 11/4/2016 2213.35 2181.9 2164.45 2085.18 11/25/2016 11/18/2016 11/11/2016 11/4/2016 21.62 20.41 21.65 20.45 10/28/2016 10/21/2016 10/14/2016 10/7/2016 21.42 21.68 21.26 21.78 9/30/2016 9/23/2016 9/16/2016 9/9/2016 9/2/2016 21.82 21.89 22.48 20.69 21.42 8/26/2016 8/19/2016 8/12/2016 8/5/2016 21.08 21.08 20.84 20.72 7/29/2016 7/22/2016 7/15/2016 7/8/2016 7/1/2016 20.35 20.37 20.57 18.76 18.62 6/24/2016 6/17/2016 6/10/2016 6/3/2016 18.53 18.95 18.86 19.43 5/27/2016 5/20/2016 5/13/2016 5/6/2016 19.03 17.58 16.88 17.04 4/29/2016 4/22/2016 4/15/2016 4/8/2016 4/1/2016 17.36 17.96 17.88 17.97 19.2 3/25/2016 3/18/2016 3/11/2016 18.94 19.59 21.72 10/28/2016 10/21/2016 10/14/2016 10/7/2016 2126.41 2141.16 2132.98 2153.74 9/30/2016 9/23/2016 9/16/2016 9/9/2016 9/2/2016 2168.27 2164.69 2139.16 2127.81 2179.98 8/26/2016 8/19/2016 8/12/2016 8/5/2016 2169.04 2183.87 2184.05 2182.87 7/29/2016 7/22/2016 7/15/2016 7/8/2016 7/1/2016 2173.6 2175.03 2161.74 2129.9 2102.95 6/24/2016 6/17/2016 6/10/2016 6/3/2016 2037.41 2071.22 2096.07 2099.13 5/27/2016 5/20/2016 5/13/2016 5/6/2016 2099.06 2052.32 2046.61 2057.14 4/29/2016 4/22/2016 4/15/2016 4/8/2016 4/1/2016 2065.3 2091.58 2080.73 2047.6 2072.78 3/25/2016 3/18/2016 3/11/2016 3/4/2016 2035.94 2049.58 2022.19 1999.99 2/26/2016 2/19/2016 2/12/2016 2/5/2016 1948.05 1917.78 1864.78 1880.05 3/4/2016 21.73 2/26/2016 2/19/2016 2/12/2016 2/5/2016 20.84 20.7 19.06 19.91 1/29/2016 1/22/2016 1/15/2016 1/8/2016 1/1/2016 19.91 19.23 19.3 19.84 23.29 12/25/2015 12/18/2015 12/11/2015 12/4/2015 23.9 23.52 23.84 25.93 11/27/2015 11/20/2015 11/13/2015 11/6/2015 25.48 25.21 23.49 24.24 10/30/2015 10/23/2015 10/16/2015 10/9/2015 10/2/2015 22.98 23.13 23.06 22.52 21.92 9/25/2015 9/18/2015 9/11/2015 9/4/2015 21.88 20.01 19.77 19.01 8/28/2015 8/21/2015 8/14/2015 8/7/2015 19.47 18.59 19.77 19.7 7/31/2015 7/24/2015 7/17/2015 7/10/2015 7/3/2015 20.25 19.48 20.01 20.51 21.1 6/26/2015 6/19/2015 21.98 22.6 1/29/2016 1/22/2016 1/15/2016 1/8/2016 1/1/2016 1940.24 1906.9 1880.33 1922.03 2043.94 12/25/2015 12/18/2015 12/11/2015 12/4/2015 2060.99 2005.55 2012.37 2091.69 11/27/2015 11/20/2015 11/13/2015 11/6/2015 2090.11 2089.17 2023.04 2099.2 10/30/2015 10/23/2015 10/16/2015 10/9/2015 10/2/2015 2079.36 2075.15 2033.11 2014.89 1951.36 9/25/2015 9/18/2015 9/11/2015 9/4/2015 1931.34 1958.03 1961.05 1921.22 8/28/2015 8/21/2015 8/14/2015 8/7/2015 1988.87 1970.89 2091.54 2077.57 7/31/2015 7/24/2015 7/17/2015 7/10/2015 7/3/2015 2103.84 2079.65 2126.64 2076.62 2076.78 6/26/2015 6/19/2015 6/12/2015 6/5/2015 2101.49 2109.99 2094.11 2092.83 5/29/2015 5/22/2015 5/15/2015 2107.39 2126.06 2122.73 6/12/2015 6/5/2015 24.14 24.23 5/8/2015 5/1/2015 2116.1 2108.29 5/29/2015 5/22/2015 5/15/2015 5/8/2015 5/1/2015 24.57 24.57 24.31 23.38 22.96 4/24/2015 4/17/2015 4/10/2015 4/3/2015 2117.69 2081.18 2102.06 2066.96 3/27/2015 3/20/2015 3/13/2015 3/6/2015 2061.02 2108.1 2053.4 2071.26 2/27/2015 2/20/2015 2/13/2015 2/6/2015 2104.5 2110.3 2096.99 2055.47 1/30/2015 1/23/2015 1/16/2015 1/9/2015 1/2/2015 1994.99 2051.82 2019.42 2044.81 2058.2 12/26/2014 12/19/2014 12/12/2014 12/5/2014 2088.77 2070.65 2002.33 2075.37 11/28/2014 11/21/2014 11/14/2014 11/7/2014 2067.56 2063.5 2039.82 2031.92 10/31/2014 10/24/2014 10/17/2014 10/10/2014 10/3/2014 2018.05 1964.58 1886.76 1906.13 1967.9 9/26/2014 9/19/2014 9/12/2014 9/5/2014 1982.85 2010.4 1985.54 2007.71 8/29/2014 8/22/2014 2003.37 1988.4 4/24/2015 4/17/2015 4/10/2015 4/3/2015 3/27/2015 3/20/2015 3/13/2015 3/6/2015 23.69 23.07 23.91 23.14 22.9 23.65 21.73 21.74 2/27/2015 2/20/2015 2/13/2015 2/6/2015 21.97 22.39 22.27 21.24 1/30/2015 1/23/2015 1/16/2015 1/9/2015 1/2/2015 20.61 20.79 21.07 21.75 21.62 12/26/2014 12/19/2014 12/12/2014 12/5/2014 22.33 21.44 19.51 20.71 11/28/2014 11/21/2014 11/14/2014 11/7/2014 20.75 20.62 20.71 21.13 10/31/2014 10/24/2014 10/17/2014 10/10/2014 10/3/2014 20.95 19.43 18.49 18.2 19.98 9/26/2014 20.6 9/19/2014 9/12/2014 9/5/2014 21.34 21.5 21.39 8/15/2014 8/8/2014 8/1/2014 1955.06 1931.59 1925.15 8/29/2014 8/22/2014 8/15/2014 8/8/2014 8/1/2014 21.58 21.41 20.55 19.92 20.05 7/25/2014 7/18/2014 7/11/2014 7/4/2014 1978.34 1978.22 1967.57 1985.44 7/25/2014 7/18/2014 7/11/2014 7/4/2014 20.77 20.8 20.72 21.05 6/27/2014 6/20/2014 6/13/2014 6/6/2014 1960.96 1962.87 1936.16 1949.44 6/27/2014 6/20/2014 6/13/2014 6/6/2014 20.91 20.48 19.79 19.48 5/30/2014 5/23/2014 5/16/2014 5/9/2014 5/2/2014 1923.57 1900.53 1877.86 1878.48 1881.14 5/30/2014 5/23/2014 5/16/2014 5/9/2014 5/2/2014 18.82 18.5 17.76 17.52 17.6 4/25/2014 4/18/2014 4/11/2014 4/4/2014 1863.4 1864.85 1815.69 1865.09 4/25/2014 4/18/2014 4/11/2014 4/4/2014 17.64 17.6 17.23 18.44 3/28/2014 3/21/2014 3/14/2014 3/7/2014 1857.62 1866.52 1841.13 1878.04 3/28/2014 3/21/2014 3/14/2014 3/7/2014 17.76 17.72 17.73 18.39 2/28/2014 2/21/2014 2/14/2014 2/7/2014 1859.45 1836.25 1838.63 1797.02 1/31/2014 1/24/2014 1/17/2014 1/10/2014 1/3/2014 1782.59 1790.29 1838.7 1842.37 1831.37 12/27/2013 12/20/2013 12/13/2013 12/6/2013 1841.4 1818.32 1775.32 1805.09 11/29/2013 1805.81 2/28/2014 2/21/2014 2/14/2014 2/7/2014 18.51 18.48 18.49 18.01 1/31/2014 1/24/2014 1/17/2014 1/10/2014 1/3/2014 17.97 17.96 18.01 17.02 17.19 12/27/2013 12/20/2013 12/13/2013 12/6/2013 17.01 16.12 19.07 20.42 11/22/2013 11/15/2013 11/8/2013 11/1/2013 1804.76 1798.18 1770.61 1761.64 11/29/2013 11/22/2013 11/15/2013 11/8/2013 11/1/2013 20.27 19.62 19.82 20.51 20.71 10/25/2013 10/18/2013 10/11/2013 10/4/2013 1759.77 1744.5 1703.2 1690.5 9/27/2013 9/20/2013 9/13/2013 9/6/2013 1691.75 1709.91 1687.99 1655.17 8/30/2013 8/23/2013 8/16/2013 8/9/2013 8/2/2013 1632.97 1663.5 1655.83 1691.42 1709.67 7/26/2013 7/19/2013 7/12/2013 7/5/2013 1691.65 1692.09 1680.19 1631.89 6/28/2013 6/21/2013 6/14/2013 6/7/2013 1606.28 1592.43 1626.73 1643.38 5/31/2013 5/24/2013 5/17/2013 5/10/2013 5/3/2013 1630.74 1649.6 1667.47 1633.7 1614.42 4/26/2013 4/19/2013 4/12/2013 4/5/2013 1582.24 1555.25 1588.85 1553.28 3/29/2013 3/22/2013 3/15/2013 3/8/2013 3/1/2013 1569.19 1556.89 1560.7 1551.18 1518.2 10/25/2013 10/18/2013 10/11/2013 10/4/2013 22.52 22.52 21.99 22.11 9/27/2013 9/20/2013 9/13/2013 9/6/2013 21.42 23.11 23.67 23 8/30/2013 8/23/2013 8/16/2013 8/9/2013 8/2/2013 22.82 23.39 23.36 23.63 23.39 7/26/2013 7/19/2013 7/12/2013 7/5/2013 22.6 22.25 21.95 20.93 6/28/2013 6/21/2013 6/14/2013 6/7/2013 20.38 20.23 19.42 19.44 5/31/2013 5/24/2013 5/17/2013 5/10/2013 5/3/2013 20.06 19.25 20.05 19.28 18.23 4/26/2013 4/19/2013 4/12/2013 4/5/2013 17.31 16.57 18.01 18.31 3/29/2013 3/22/2013 3/15/2013 3/8/2013 3/1/2013 18.48 18.56 19.25 18.89 18.47 2/22/2013 2/15/2013 2/8/2013 2/1/2013 19.07 19.77 19.36 19.36 1/25/2013 1/18/2013 1/11/2013 1/4/2013 19.94 19.63 19.92 19.44 12/28/2012 12/21/2012 12/14/2012 12/7/2012 18.61 19.39 17.51 18.37 11/30/2012 11/23/2012 11/16/2012 11/9/2012 11/2/2012 19 18.95 17.63 17.62 17.4 10/26/2012 10/19/2012 10/12/2012 10/5/2012 17.28 17.19 17.03 18.05 9/28/2012 9/21/2012 9/14/2012 9/7/2012 18.72 21.55 22.7 21.9 8/31/2012 8/24/2012 8/17/2012 8/10/2012 8/3/2012 22.78 23.27 23.16 22.67 22.02 7/27/2012 7/20/2012 7/13/2012 21.22 20.55 19.02 2/22/2013 2/15/2013 2/8/2013 2/1/2013 1515.6 1519.79 1517.93 1513.17 1/25/2013 1/18/2013 1/11/2013 1/4/2013 1502.96 1485.98 1472.05 1466.47 12/28/2012 12/21/2012 12/14/2012 12/7/2012 1402.43 1430.15 1413.58 1418.07 11/30/2012 11/23/2012 11/16/2012 11/9/2012 11/2/2012 1416.18 1409.15 1359.88 1379.85 1414.2 10/26/2012 10/19/2012 10/12/2012 10/5/2012 1411.94 1433.19 1428.59 1460.93 9/28/2012 9/21/2012 9/14/2012 9/7/2012 1440.67 1460.15 1465.77 1437.92 8/31/2012 8/24/2012 8/17/2012 8/10/2012 8/3/2012 1406.58 1411.13 1418.16 1405.87 1390.99 7/27/2012 7/20/2012 7/13/2012 7/6/2012 1385.97 1362.66 1356.78 1354.68 6/29/2012 6/22/2012 6/15/2012 6/8/2012 1362.16 1335.02 1342.83 1325.66 7/6/2012 19.85 6/1/2012 1278.05 6/29/2012 6/22/2012 6/15/2012 6/8/2012 6/1/2012 20.33 19.76 19.13 19.1 18.19 5/25/2012 5/18/2012 5/11/2012 5/4/2012 1317.82 1295.22 1353.39 1369.1 4/27/2012 4/20/2012 4/13/2012 4/6/2012 1403.36 1378.53 1370.26 1398.08 3/30/2012 3/23/2012 3/16/2012 3/9/2012 3/2/2012 1408.47 1397.11 1404.17 1370.87 1369.63 2/24/2012 2/17/2012 2/10/2012 2/3/2012 1365.74 1361.23 1342.64 1344.9 1/27/2012 1/20/2012 1/13/2012 1/6/2012 1316.33 1315.38 1289.09 1277.81 12/30/2011 12/23/2011 12/16/2011 12/9/2011 12/2/2011 1257.6 1265.33 1219.66 1255.19 1244.28 11/25/2011 11/18/2011 11/11/2011 11/4/2011 1158.67 1215.65 1263.85 1253.23 10/28/2011 10/21/2011 10/14/2011 10/7/2011 1285.09 1238.25 1224.58 1155.46 9/30/2011 9/23/2011 9/16/2011 1131.42 1136.43 1216.01 5/25/2012 5/18/2012 5/11/2012 5/4/2012 19.25 18.91 20.04 21.66 4/27/2012 4/20/2012 4/13/2012 4/6/2012 23.58 22.58 23.03 24.2 3/30/2012 3/23/2012 3/16/2012 3/9/2012 3/2/2012 25.12 25.5 26.82 26.16 25.98 2/24/2012 2/17/2012 2/10/2012 2/3/2012 26.01 26.03 24.72 24.12 1/27/2012 1/20/2012 1/13/2012 1/6/2012 22.8 23 21.04 20.87 12/30/2011 12/23/2011 12/16/2011 12/9/2011 12/2/2011 19.66 19.91 19.42 20.65 20.71 11/25/2011 11/18/2011 11/11/2011 11/4/2011 18.34 20.32 20.91 20.59 10/28/2011 10/21/2011 21.32 19.92 10/14/2011 10/7/2011 20.07 18.6 9/9/2011 9/2/2011 1154.23 1173.97 9/30/2011 9/23/2011 9/16/2011 9/9/2011 9/2/2011 17.79 16.28 17.66 15.76 16.37 8/26/2011 8/19/2011 8/12/2011 8/5/2011 1176.8 1123.53 1178.81 1199.38 7/29/2011 7/22/2011 7/15/2011 7/8/2011 7/1/2011 1292.28 1345.02 1316.14 1343.8 1339.67 6/24/2011 6/17/2011 6/10/2011 6/3/2011 1268.44 1271.5 1270.98 1300.16 5/27/2011 5/20/2011 5/13/2011 5/6/2011 1331.1 1333.27 1337.77 1340.2 4/29/2011 4/22/2011 4/15/2011 4/8/2011 4/1/2011 1363.61 1337.39 1319.68 1328.17 1332.41 3/25/2011 3/18/2011 3/11/2011 3/4/2011 1313.8 1279.2 1304.28 1321.15 2/25/2011 2/18/2011 2/11/2011 2/4/2011 1319.88 1343.01 1329.15 1310.87 1/28/2011 1/21/2011 1/14/2011 1/7/2011 1276.34 1283.35 1293.24 1271.5 12/31/2010 12/24/2010 1257.64 1256.77 8/26/2011 8/19/2011 8/12/2011 8/5/2011 15.46 14.22 16.25 15.54 7/29/2011 7/22/2011 7/15/2011 7/8/2011 7/1/2011 18.31 20.26 19.79 21.35 20.77 6/24/2011 6/17/2011 6/10/2011 6/3/2011 19.14 18.29 19.08 19.95 5/27/2011 5/20/2011 5/13/2011 5/6/2011 21.22 20.74 21.58 20.99 4/29/2011 4/22/2011 4/15/2011 4/8/2011 4/1/2011 19.84 19.91 19.18 19.79 20.04 3/25/2011 3/18/2011 3/11/2011 3/4/2011 2/25/2011 2/18/2011 2/11/2011 2/4/2011 1/28/2011 21.28 18.59 20.48 21.79 20.93 22.57 21.66 21.22 19.81 1/21/2011 1/14/2011 1/7/2011 19.84 21.34 21.07 12/17/2010 12/10/2010 12/3/2010 1243.91 1240.4 1224.71 12/31/2010 12/24/2010 12/17/2010 12/10/2010 12/3/2010 20.09 19.93 17.47 16.71 16.16 11/26/2010 11/19/2010 11/12/2010 11/5/2010 1189.4 1199.73 1199.21 1225.85 11/26/2010 11/19/2010 11/12/2010 11/5/2010 14.59 15.03 14.39 15.63 10/29/2010 10/22/2010 10/15/2010 10/8/2010 10/1/2010 1183.26 1183.08 1176.19 1165.15 1146.24 10/29/2010 10/22/2010 10/15/2010 10/8/2010 10/1/2010 15.34 14.18 14.75 14.71 14.3 9/24/2010 9/17/2010 9/10/2010 9/3/2010 1148.67 1125.59 1109.55 1104.51 8/27/2010 8/20/2010 8/13/2010 8/6/2010 1064.59 1071.69 1079.25 1121.64 7/30/2010 7/23/2010 7/16/2010 7/9/2010 7/2/2010 1101.6 1102.66 1064.88 1077.96 1022.58 6/25/2010 6/18/2010 6/11/2010 6/4/2010 1076.77 1117.51 1091.6 1064.88 5/28/2010 5/21/2010 5/14/2010 5/7/2010 1089.41 1087.69 1135.68 1110.89 4/30/2010 4/23/2010 4/16/2010 4/9/2010 4/2/2010 1186.69 1217.28 1192.13 1194.37 1178.1 9/24/2010 9/17/2010 9/10/2010 9/3/2010 13.57 12.79 12.22 11.73 8/27/2010 8/20/2010 8/13/2010 8/6/2010 10.82 11.17 11.55 13.29 7/30/2010 7/23/2010 7/16/2010 7/9/2010 7/2/2010 14.51 15.31 14.79 13.97 13.02 6/25/2010 6/18/2010 6/11/2010 6/4/2010 14.4 13.96 13.09 12.66 5/28/2010 5/21/2010 5/14/2010 5/7/2010 13.69 13.15 14.12 14.09 4/30/2010 4/23/2010 4/16/2010 4/9/2010 4/2/2010 3/26/2010 3/19/2010 3/12/2010 3/5/2010 15.32 17.02 16.45 16.8 16.27 16.37 17.34 17.62 16.72 2/26/2010 2/19/2010 2/12/2010 2/5/2010 15.17 15.16 14.74 14.36 1/29/2010 1/22/2010 1/15/2010 1/8/2010 1/1/2010 14.48 15.69 17.04 17.54 17.37 12/25/2009 12/18/2009 12/11/2009 12/4/2009 17.42 14.8 14.06 12.94 11/27/2009 11/20/2009 11/13/2009 11/6/2009 13.34 13.63 14.48 14.29 10/30/2009 10/23/2009 10/16/2009 10/9/2009 10/2/2009 13.38 14.96 14.78 14.35 12.94 9/25/2009 11.87 3/26/2010 3/19/2010 3/12/2010 3/5/2010 1166.59 1159.9 1149.99 1138.7 2/26/2010 2/19/2010 2/12/2010 2/5/2010 1104.49 1109.17 1075.51 1066.19 1/29/2010 1/22/2010 1/15/2010 1/8/2010 1/1/2010 1073.87 1091.76 1136.03 1144.98 1115.1 12/25/2009 12/18/2009 12/11/2009 12/4/2009 1126.48 1102.47 1106.41 1105.98 11/27/2009 11/20/2009 11/13/2009 11/6/2009 1091.49 1091.38 1093.48 1069.3 10/30/2009 10/23/2009 10/16/2009 10/9/2009 10/2/2009 1036.19 1079.6 1087.68 1071.49 1025.21 9/25/2009 1044.38 Name: Company: FILL IN. Date Company Prices % Ret Company FILL IN. FILL IN. FILL IN. USE AS MANY ROW ...
Purchase answer to see full attachment

Tutor Answer

DoctorDickens
School: University of Virginia

Attached.

Name:

Rayan Abdulrahim

Company:

JBL

S&P 500 (SPY)

Date
Company Prices % Ret Company
2/6/2019
27.2475
2.55
2/1/2019
26.57
2.864885792
1/25/2019
1/18/2019
1/11/2019
1/4/2019

25.83
25.42
24.55
23.95

1.612903226
3.543788187
2.505219207
-2.204981625

12/28/2018
12/21/2018
12/14/2018
12/7/2018

24.49
23.4
21.84
23.26

4.658119658
7.142857143
-6.104901118
-6.848217861

11/30/2018
11/23/2018
11/16/2018
11/9/2018
11/2/2018

24.97
24.64
24.99
25.29
26.13

1.339285714
-1.400560224
-1.18623962
-3.214695752
10.57977148

Date

SPY Prices
1/4/2019
2531.94

12/28/2018
12/21/2018
12/14/2018
12/7/2018

2485.74
2416.62
2599.95
2633.08

11/30/2018
11/23/2018
11/16/2018
11/9/2018
11/2/2018

2760.17
2632.56
2736.27
2781.01
2723.06

10/26/2018
10/19/2018
10/12/2018
10/5/2018

2658.69
2767.78
2767.13
2885.57

9/28/2018
9/21/2018
9/14/2018
9/7/2018

2913.98
2929.67
2904.98
2871.68

8/31/2018
8/24/2018
8/17/2018
8/10/2018
8/3/2018

2901.52
2874.69
2850.13
2833.28
2840.35

7/27/2018
7/20/2018
7/13/2018
7/6/2018

2818.82
2801.83
2801.31
2759.82

10/26/2018
10/19/2018
10/12/2018
10/5/2018

23.63
23.93
23.73
25.72

-1.253656498
0.842815002
-7.737169518
-5.022156573

9/28/2018
9/21/2018
9/14/2018
9/7/2018

27.08
29.86
29.5
29.15

-9.310113865
1.220338983
1.200686106
-1.387009472

8/31/2018
8/24/2018
8/17/2018
8/10/2018
8/3/2018

29.56
28.1
27.67
28.08
28.54

5.195729537
1.554029635
-1.46011396
-1.61177295
1.74688057

7/27/2018
7/20/2018
7/13/2018
7/6/2018

28.05
28.56
28.67
28.22

-1.785714286
-0.383676317
1.594613749
2.024584237

6/29/2018
6/22/2018
6/15/2018
6/8/2018
6/1/2018

2718.37
2754.88
2779.66
2779.03
2734.62

6/29/2018

27.66

-2.261484099

5/25/2018

2721.33

6/22/2018
6/15/2018
6/8/2018
6/1/2018

28.3
27.73
29.25
28.68

2.055535521
-5.196581197
1.987447699
1.66607586

5/25/2018
5/18/2018
5/11/2018
5/4/2018

28.21
27.93
27.61
27.44

1.002506266
1.159000362
0.619533528
2.887139108

4/27/2018
4/20/2018
4/13/2018
4/6/2018

26.67
27.94
29.23
27.95

-4.545454545
-4.413274034
4.57960644
-2.714932127

3/30/2018
3/23/2018
3/16/2018
3/9/2018
3/2/2018

28.73
28.59
31.37
28.19
27

0.489681707
-8.861970035
11.28059596
4.407407407
1.465614431

2/23/2018
2/16/2018
2/9/2018
2/2/2018

26.61
26.37
25.44
25.28

0.910125142
3.655660377
0.632911392
-4.711647192

1/26/2018
1/19/2018
1/12/2018
1/5/2018

26.53
27.39
27.66
27.19

-3.139832055
-0.976138829
1.728576683
3.580952381

12/29/2017
12/22/2017
12/15/2017
12/8/2017
12/1/2017

26.25
26.7
27.87
27.88
28.58

-1.685393258
-4.198062433
-0.035868006
-2.44926522
-4.029550034

11/24/2017
11/17/2017
11/10/2017
11/3/2017

29.78
29.22
28.61
28.02

1.916495551
2.132121636
2.105638829
-1.476793249

10/27/2017
10/20/2017
10/13/2017
10/6/2017

28.44
27.96
28.24
29.79

1.716738197
-0.991501416
-5.203088285
4.343257443

5/18/2018
5/11/2018
5/4/2018

2712.97
2727.72
2663.42

4/27/2018
4/20/2018
4/13/2018
4/6/2018

2669.91
2670.14
2656.3
2604.47

3/30/2018
3/23/2018
3/16/2018
3/9/2018
3/2/2018

2640.87
2588.26
2752.01
2786.57
2691.25

2/23/2018
2/16/2018
2/9/2018
2/2/2018

2747.3
2732.22
2619.55
2762.13

1/26/2018
1/19/2018
1/12/2018
1/5/2018

2872.87
2810.3
2786.24
2743.15

12/29/2017
12/22/2017
12/15/2017
12/8/2017
12/1/2017

2673.61
2683.34
2675.81
2651.5
2642.22

11/24/2017
11/17/2017
11/10/2017
11/3/2017

2602.42
2578.85
2582.3
2587.84

10/27/2017
10/20/2017
10/13/2017
10/6/2017

2581.07
2575.21
2553.17
2549.33

9/29/2017
9/22/2017
9/15/2017
9/8/2017
9/1/2017

2519.36
2502.22
2500.23
2461.43
2476.55

9/29/2017
9/22/2017
9/15/2017
9/8/2017
9/1/2017
8/25/2017
8/18/2017
8/11/2017
8/4/2017

28.55
29.44
30.72
30.44
31.34
30.3
29.67
29.22
30.72

-3.023097826
-4.166666667
0.919842313
-2.871729419
3.432343234
2.123356926
1.540041068
-4.8828125
0.490677134

7/28/2017
7/21/2017
7/14/2017
7/7/2017

30.57
30.74
30.49
29.29

-0.553025374
0.819940964
4.09696142
0.342583076

6/30/2017
6/23/2017
6/16/2017
6/9/2017
6/2/2017

29.19
30.09
28.46
31.04
30.86

-2.991026919
5.727336613
-8.31185567
0.583279326
5.252387449

5/26/2017
5/19/2017
5/12/2017
5/5/2017

29.32
28.58
28.95
28.95

2.589223233
-1.27806563
0
-0.241212957

4/28/2017
4/21/2017
4/14/2017
4/7/2017

29.02
28.95
28.24
28.72

0.2417962
2.514164306
-1.671309192
-0.691562932

3/31/2017
3/24/2017
3/17/2017
3/10/2017
3/3/2017

28.92
28.74
28.8
26.33
25.96

0.626304802
-0.208333333
9.380934295
1.425269646
-1.0293557

2/24/2017
2/17/2017
2/10/2017
2/3/2017
1/27/2017
1/20/2017
1/13/2017
1/6/2017

26.23
25.91
25.44
24.39
23.88
23.2
23.58
23.34

1.235044384
1.847484277
4.30504305
2.135678392
2.931034483
-1.611535199
1.028277635
-1.394169835

8/25/2017
8/18/2017
8/11/2017
8/4/2017

2443.05
2425.55
2441.32
2476.83

7/28/2017
7/21/2017
7/14/2017
7/7/2017

2472.1
2472.54
2459.27
2425.18

6/30/2017
6/23/2017
6/16/2017
6/9/2017
6/2/2017

2423.41
2438.3
2433.15
2431.77
2439.07

5/26/2017
5/19/2017
5/12/2017
5/5/2017

2415.82
2381.73
2390.9
2399.29

4/28/2017
4/21/2017
4/14/2017
4/7/2017

2384.2
2348.69
2328.95
2355.54

3/31/2017
3/24/2017
3/17/2017
3/10/2017
3/3/2017

2362.72
2343.98
2378.25
2372.6
2383.12

2/24/2017
2/17/2017
2/10/2017
2/3/2017

2367.34
2351.16
2316.1
2297.42

1/27/2017
1/20/2017
1/13/2017
1/6/2017

2294.69
2271.31
2274.64
2276.98

12/30/2016
12/23/2016
12/16/2016
12/9/2016
12/2/2016

2238.83
2263.79
2258.07
2259.53
2191.95

11/25/2016
11/18/2016
11/11/2016
11/4/2016

2213.35
2181.9
2164.45
2085.18

10/28/2016
10/21/2016
10/14/2016
10/7/2016

2126.41
2141.16
2132.98
2153.74

9/30/2016
9/23/2016
9/16/2016
9/9/2016
9/2/2016

2168.27
2164.69
2139.16
2127.81
2179.98

8/26/2016
8/19/2016
8/12/2016
8/5/2016

2169.04
2183.87
2184.05
2182.87

7/29/2016
7/22/2016
7/15/2016
7/8/2016
7/1/2016

2173.6
2175.03
2161.74
2129.9
2102.95

6/24/2016
6/17/2016
6/10/2016
6/3/2016

2037.41
2071.22
2096.07
2099.13

5/27/2016
5/20/2016
5/13/2016
5/6/2016

2099.06
2052.32
2046.61
2057.14

8.248009101
4.146919431
-0.938967136
-1.843317972

4/29/2016
4/22/2016
4/15/2016
4/8/2016
4/1/2016

2065.3
2091.58
2080.73
2047.6
2072.78

-3.340757238
0.447427293
-0.500834725

3/25/2016
3/18/2016
3/11/2016

2035.94
2049.58
2022.19

12/30/2016
12/23/2016
12/16/2016
12/9/2016
12/2/2016

23.67
24.11
24.15
21.62
20.5

-1.824968893
-0.16563147
11.70212766
5.463414634
-5.180388529

11/25/2016
11/18/2016
11/11/2016
11/4/2016

21.62
20.41
21.65
20.45

5.928466438
-5.727482679
5.86797066
-4.528478058

10/28/2016
10/21/2016
10/14/2016
10/7/2016

21.42
21.68
21.26
21.78

-1.199261993
1.975540922
-2.387511478
-0.183318057

9/30/2016
9/23/2016
9/16/2016
9/9/2016
9/2/2016

21.82
21.89
22.48
20.69
21.42

-0.319780722
-2.62455516
8.651522475
-3.408029879
1.612903226

8/26/2016
8/19/2016
8/12/2016
8/5/2016

21.08
21.08
20.84
20.72

0
1.151631478
0.579150579
1.818181818

7/29/2016
7/22/2016
7/15/2016
7/8/2016
7/1/2016

20.35
20.37
20.57
18.76
18.62

-0.098183603
-0.972289742
9.648187633
0.751879699
0.485698867

6/24/2016
6/17/2016
6/10/2016
6/3/2016

18.53
18.95
18.86
19.43

-2.216358839
0.477200424
-2.933607823
2.101944298

5/27/2016
5/20/2016
5/13/2016
5/6/2016

19.03
17.58
16.88
17.04

4/29/2016
4/22/2016
4/15/2016

17.36
17.96
17.88

4/8/2016
4/1/2016
3/25/2016
3/18/2016
3/11/2016
3/4/2016

17.97
19.2
18.94
19.59
21.72
21.73

-6.40625
1.372756072
-3.318019398
-9.806629834
-0.046019328
4.270633397

2/26/2016
2/19/2016
2/12/2016
2/5/2016

20.84
20.7
19.06
19.91

0.676328502
8.604407135
-4.269211452
0

1/29/2016
1/22/2016
1/15/2016
1/8/2016
1/1/2016

19.91
19.23
19.3
19.84
23.29

3.536141446
-0.362694301
-2.721774194
-14.81322456
-2.552301255

12/25/2015
12/18/2015
12/11/2015
12/4/2015

23.9
23.52
23.84
25.93

1.615646259
-1.342281879
-8.060161975
1.766091052

11/27/2015
11/20/2015
11/13/2015
11/6/2015

25.48
25.21
23.49
24.24

1.07100357
7.322264794
-3.094059406
5.483028721

10/30/2015
10/23/2015
10/16/2015
10/9/2015
10/2/2015

22.98
23.13
23.06
22.52
21.92

-0.648508431
0.303555941
2.397868561
2.737226277
0.182815356

9/25/2015
9/18/2015
9/11/2015
9/4/2015

21.88
20.01
19.77
19.01

9.345327336
1.213960546
3.997895844
-2.362609142

3/4/2016

1999.99

2/26/2016
2/19/2016
2/12/2016
2/5/2016

1948.05
1917.7...

flag Report DMCA
Review

Anonymous
Tutor went the extra mile to help me with this essay. Citations were a bit shaky but I appreciated how well he handled APA styles and how ok he was to change them even though I didnt specify. Got a B+ which is believable and acceptable.

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors