Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using the historical stock price, how would I be able to calculate the historical return? Historical Stock Price Historical Return Date Market Apple Tesla Microsoft

image text in transcribed

Using the historical stock price, how would I be able to calculate the historical return?

image text in transcribed
Historical Stock Price Historical Return Date Market Apple Tesla Microsoft Amazon FCAU Market Apple Tesla Microsoft Amazon FCAU 9/1/15 1920.03 25.23197 49.68 40.11825 511.89 6.91043 10/1/15 2079.36 27.33655 41.386 47.71407 625.9 7.658494 0.082983 11/1/15 2080.41 27.06204 46.052 49.26405 664.8 7.454476 0.000505 12/1/15 2043.94 24.18211 48.002 50.62727 675.89 7.318465 -0.0175 1/1/16 1940.24 22.36259 38.24 50.27139 587 5.597815 -0.050735 2/1/16 1932.23 22.21326 38.386 46.42962 552.52 5.453255 -0.004128 3/1/16 2059.74 25.17489 45.954 50.76099 593.64 6.41653 0.065991 1/1/16 2065.3 21.6524 48.152 45.8347 659.59 6.440413 0.00269 5/1/16 23.06602 44.646 48.71143 2.79 5.708005 0.015325 5/1/16 2098.86 22.21647 42.456 47.35846 715.62 4.872105 0.000911 /1/16 2173.6 24.21734 46.958 52.45802 758.81 5.102973 0.0356 8/1/16 2170.95 24.65656 42.402 53.17992 769.16 5.477137 -0.001219 9/1/16 2168.27 26.41399 40.806 53.64176 837.31 5.095012 -0.001234 10/1/16 2126.15 26.52848 39.546 55.80233 789.82 5.827419 0.01942 11/1/16 2198.81 25.8228 37.88 56.11897 50.57 6.098092 0.034175 12/1/16 2238.83 27.20013 42.738 58.26071 768.66 7.260391 0.018201 1/1/17 2278.87 28.49884 50.386 60.61402 823.48 8.74909 0.017884 2/1/17 2363.64 32.17187 49.998 59.98585 845.04 8.733169 0.037198 3/1/17 2362.72 33.88459 55.66 62.12283 886.54 8.701324 -0.000389 4/1/17 2384.2 33.88223 62.814 64.5753 924.99 9.051607 0.009091 5/1/17 2411.8 36.03097 68.202 65.87699 994.62 8.414729 0.011576 6/1/17 2423.41 34.10971 72.322 65.3913 968 8.462496 0.004814 7/1/17 2470.3 35.22523 64.694 68.96776 987.78 9.624796 0.019349 8/1/17 2471.65 38.84178 71.18 70.9315 980.6 12.04493 0.00054 9/1/17 2519.36 36.64514 68.22 71.04237 961.35 14.25807 0.019303 10/1/17 2575.26 40.19267 66.306 79.33018 1105.28 13.81226 0.022188 11/1/17 2584.84 40.86081 61.77 80.27436 1176.75 13.61323 0.00372 12/1/17 2673.61 40.3825 62.27 81.99067 1169.47 14.20235 0.034343 1/1/18 2823.81 39.95298 70.862 91.06771 1450.89 19.24163 0.056179 2/1/18 2713.83 42.50388 68.612 89.87916 1512.45 16.86927 0.038947 3/1/18 2640.87 40.19973 53.226 87.89385 1447.34 16.33588 -0.026884 4/1/18 2648.05 39.59594 58.78 90.06059 1566.13 17.37877 0.002719 5/1/18 2705.27 44.77365 56.946 95.18382 1629.62 18.4933 0.021608 6/1/18 2718.37 44.52298 68.59 95.37394 1699.8 15.03824 0.004842 7/1/18 2816.29 45.7688 59.628 102.5988 1777.44 13.5177 0.036022 8/1/18 2901.52 54.74997 60.332 108.6437 2012.71 1 13.6212 0.030263 9/1/18 2913.98 54.4858 52.954 111.0424 2003 13.93963 0.004294 10/1/18 2711.74 52.82521 67.464 103.7024 1598.01 12.029 -0.069403 11/1/18 2760.17 43.10302 70.096 107.6637 1690.17 13.20723 0.017859 12/1/18 2506.85 38.2058 66.56 99.04086 1501.97 11.51154 -0.091777 1/1/19 2704.1 40.31301 61.404 101.8297 1718.73 13.70081 0.078684 2/1/19 2784.49 41.93822 63.976 109.2404 1639.83 11.72649 0.029729 3/1/19 2834.4 46.20462 55.972 115.4944 1780.75 11.82202 0.017924 4/1/19 2945.83 48.81222 47.738 127.8919 1926.52 12.26783 0.03931 5/1/19 2752.06 42.58512 37.032 121.1154 1775.07 10.51254 0.065778 6/1/19 2941.76 48.3287 44.692 131.6678 1893.63 12.61826 0.06893 7/1/19 2980.38 52.02074 48.322 133.9383 1866.78 12.04304 0.013128 8/1/19 2926.46 50.97076 45.122 135.5011 1776.29 11.99739 0.01809 9/1/19 2976.74 54.89745 48.174 137.1061 1735.91 11.82391 0.017181 10/1/19 3037.56 60.97374 62.984 141.386 1776.66 13.98783 0.020432 11/1/19 3140.98 65.50584 65.988 149.2852 1800.8 13.46739 0.034047 12/1/19 3230.78 72.19286 83.666 156.0469 1847.84 13.4 0.02859 1/1/20 3225.52 76.092 130.114 168.4456 2008.72 11.88783 -0.001628 2/1/20 2954.22 67.20463 133.598 160.3117 1883.75 11.35826 0.08411 3/1/20 2584.59 62.66471 104.8 156.483 1949.72 6.564783 0.125119 1/1/20 2912.43 72.40115 156.376 177.8158 2474 7.861304 0.126844 5/1/20 3044.31 78.34998 167 181.8244 2442.37 8.84 0.045282 5/1/20 3100.29 90.87907 215.962 202.4891 2758.82 10.24 0.018388 7/1/20 3271.12 105.8861 286.152 203.9816 3164.68 10.15 0.055101 8/1/20 3478.73 128.5859 498.32 224.3987 3450.96 11.03 0.063468

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Core Concepts Of Accounting Information Systems

Authors: Mark G. Simkin, Carolyn A. Strand Norman, Scott Paquette

1st Canadian Edition

1118738101, 978-1118738108

Students also viewed these Finance questions