Answered step by step
Verified Expert Solution
Question
1 Approved Answer
May I just ask how do I calculate the discrete rate of return as well as the continuously compounded rate of return under the compiled
May I just ask how do I calculate the discrete rate of return as well as the continuously compounded rate of return under the compiled tab?
Date Open High Low Close Volume Adj Close 1/4/2016 85.44 85.53 77.65 79.42 2916100 79.42 12/28/2015 83.32 85.85 83.02 85.53 1252800 85.53 12/21/2015 80.77 83.42 80.77 83.32 1686700 83.32 12/14/2015 77.95 81.57 76.87 81.57 4420100 81.57 12/7/2015 81.5 81.81 77.88 78.95 2694200 78.95 11/30/2015 80.25 81.88 79.35 80.22 3112100 80.22 11/23/2015 80 81 78.7 80.12 3163300 80.12 11/16/2015 74.64 80.23 74.63 79.83 2882800 79.83 11/9/2015 76.18 77.69 73.75 75.76 2783700 75.76 11/2/2015 76.85 77.9 75.01 76.59 2533500 76.59 10/26/2015 77.89 78.25 76.13 76.73 3130200 76.73 10/19/2015 77 78.1 74.51 77.35 2134300 77.35 10/12/2015 75.5 77 73.27 76.55 2654800 76.55 10/5/2015 74.44 76.25 73.71 75.53 2233000 75.53 9/28/2015 71.56 74.44 70.15 73.39 3424200 73.39 9/21/2015 74.61 74.78 71.4 71.44 4627800 71.44 9/14/2015 75.05 76.49 73.27 75.83 4882600 75.83 9/7/2015 71.9 76.84 71.34 75.13 3742900 75.13 8/31/2015 75.71 75.71 71.26 72.15 4764400 72.15 8/24/2015 73.6 77.48 71.42 76.36 6944500 76.36 8/17/2015 80.5 81.74 74.16 75.59 6918800 75.59 8/10/2015 80.7127 82.5428 80.0662 81.6775 1453200 78.4902 8/3/2015 87.2473 87.8938 80.8619 80.8619 3173000 77.70642 7/27/2015 84.9895 87.307 84.6514 87.0882 3174400 83.68976 7/20/2015 87.5258 88.401 85.0393 85.3476 2127400 82.01708 7/13/2015 85.1188 87.9336 84.5718 87.5059 2108200 84.09115 7/6/2015 84.6215 87.5258 83.7562 85.3277 2761200 81.99795 7/3/2015 87.0285 87.0285 85.6758 86.193 2500900 82.82949 Date Open High Low Close Volume Adj Close 1/4/2016 4.11 4.15 3.99 4.06 7137200 4.06 12/28/2015 4 4.16 3.98 4.09 3452100 4.09 12/21/2015 3.91 4.04 3.86 4 4180700 4 12/14/2015 3.81 3.96 3.665 3.91 12693200 3.91 12/7/2015 3.74 3.9 3.67 3.83 8057200 3.83 11/30/2015 3.79 3.8 3.64 3.67 8670400 3.67 11/23/2015 3.8 3.84 3.61 3.78 7227300 3.78 11/16/2015 3.55 3.91 3.46 3.8 10548500 3.8 11/9/2015 3.74 3.78 3.55 3.61 6159500 3.61 11/2/2015 3.95 3.97 3.67 3.71 6283900 3.71 10/26/2015 4.12141 4.1853 3.79 3.95 6245000 3.95 10/19/2015 4.15335 4.2492 4.08946 4.11076 6905500 4.37781 10/12/2015 3.81257 4.2066 3.78594 4.164 9425600 4.4345 10/5/2015 4.11076 4.2066 3.81257 3.86581 9749600 4.11694 9/28/2015 3.91906 4.12141 3.90841 4.06816 9365200 4.33244 9/21/2015 3.82322 4.07881 3.80192 3.92971 10459600 4.18499 9/14/2015 3.81257 3.99361 3.75932 3.86581 12791500 4.11694 9/7/2015 3.72737 3.85517 3.69542 3.76997 10939600 4.01488 8/31/2015 3.35 3.78062 3.27 3.69542 13611200 3.93548 8/24/2015 3.33 3.68 3.21 3.39 18199800 3.61022 8/17/2015 3.72 3.9 3.37 3.45 13329600 3.67412 8/10/2015 3.79 3.89 3.65 3.72 7471200 3.96166 8/3/2015 3.75 3.89 3.69 3.77 7934900 4.01491 7/27/2015 3.65 3.86 3.64 3.75 8940500 3.99361 7/20/2015 3.66 3.76 3.59 3.69 7093000 3.92971 7/13/2015 3.32 3.64 3.32 3.63 8109000 3.86581 7/6/2015 3.14 3.46 3.12 3.33 9741900 3.54633 7/3/2015 3.21 3.24 3.13 3.2 7863400 3.40788 Date Open 1/4/2016 12/28/2015 12/21/2015 12/14/2015 12/7/2015 11/30/2015 11/23/2015 11/16/2015 11/9/2015 11/2/2015 10/26/2015 10/19/2015 10/12/2015 10/5/2015 9/28/2015 9/21/2015 9/14/2015 9/7/2015 8/31/2015 8/24/2015 8/17/2015 8/10/2015 8/3/2015 7/27/2015 7/20/2015 7/13/2015 7/6/2015 7/3/2015 High 5.61 5.46 5.42 5.15 5.46 5.4 5.41 5.09 5.29 5.39 5.59 5.44 5.62 5.65 5.67 5.56 5.6 5.6 5.78 5.99 6.08 6.29 6.48 6.34 6.44 6.18 6.1 6.17 Low 5.66 5.665 5.5 5.5 5.47 5.54 5.48 5.46 5.31 5.45 5.61 5.595 5.62 5.78 5.76 5.78 5.665 5.8 5.79 6.01 6.215 6.39 6.53 6.49 6.46 6.48 6.27 6.175 Close 5.26 5.43 5.41 5.14 5.17 5.36 5.355 5.06 5.135 5.28 5.39 5.275 5.41 5.58 5.49 5.5 5.47 5.54 5.53 5.65 6.01 6.05 6.29 6.31 6.32 6.155 6.08 6.12 Volume Adj Close 5.3 22595400 5.3 5.61 9740300 5.61 5.46 9625900 5.46 5.48 31110500 5.48 5.2 30098100 5.2 5.41 27892600 5.41 5.4 21290500 5.4 5.41 29848300 5.41 5.14 29552400 5.14 5.31 26920200 5.31 5.4 36636800 5.4 5.58 39531500 5.58 5.44 26411500 5.44 5.64 21059100 5.64 5.62 27194200 5.62 5.67 27500600 5.67 5.65 29250800 5.65 5.55 30709500 5.55 5.61 33276700 5.61 5.82 53015400 5.82 6.07 33797800 5.84142 6.08 29614800 5.85104 6.29 18204100 6.05313 6.49 19109200 6.2456 6.36 14617300 6.1205 6.42 19372500 6.17824 6.21 22773400 5.97614 6.13 23532000 5.89916 Date Open High Low Close Volume Adj Close 1/4/2016 5295.8999 5331.3999 4940.29981 4990.79981 0 4990.79981 12/29/2015 5207.6001 5325.79981 5189.1001 5295.8999 0 5295.8999 12/21/2015 5106.7002 5211.5 5075.2002 5207.6001 0 5207.6001 12/14/2015 5029.5 5129.1001 4909.6001 5106.7002 0 5106.7002 12/7/2015 5151.6001 5229.8999 4995.6001 5029.5 0 5029.5 11/30/2015 5202.6001 5279.29981 5117.6001 5151.6001 0 5151.6001 11/23/2015 5256.1001 5285.5 5185.79981 5202.6001 0 5202.6001 11/16/2015 5051.29981 5272 4979.2002 5256.1001 0 5256.1001 11/9/2015 5215 5215 5010.3999 5051.29981 0 5051.29981 11/2/2015 5239.3999 5313.7002 5152.79981 5215 0 5215 10/26/2015 5351.6001 5384.79981 5204 5239.3999 0 5239.3999 10/19/2015 5268.2002 5374.5 5195.3999 5351.6001 0 5351.6001 10/12/2015 5279.7002 5294.29981 5164.2002 5268.2002 0 5268.2002 10/5/2015 5052 5284 5052 5279.7002 0 5279.7002 9/28/2015 5042.1001 5119.2002 4918.3999 5052 0 5052 9/21/2015 5170.5 5170.5 4988.79981 5042.1001 0 5042.1001 9/14/2015 5071.1001 5195 5017.79981 5170.5 0 5170.5 9/7/2015 5040.6001 5221.1001 4973.3999 5071.1001 0 5071.1001 8/31/2015 5263.6001 5263.6001 4995.6001 5040.6001 152128000 5040.6001 8/24/2015 5214.6001 5305 4928.29981 5263.6001 0 5263.6001 8/17/2015 5356.5 5397 5171.5 5214.6001 0 5214.6001 8/10/2015 5474.79981 5543.2002 5351.5 5356.5 0 5356.5 8/3/2015 5699.2002 5727.7002 5474.79981 5474.79981 0 5474.79981 7/27/2015 5566.1001 5699.5 5530.8999 5699.2002 0 5699.2002 7/20/2015 5670.1001 5718.8999 5548 5566.1001 0 5566.1001 7/13/2015 5492 5691.2002 5451.1001 5670.1001 0 5670.1001 7/6/2015 5538.29981 5586.2002 5383.7002 5492 0 5492 7/3/2015 5599.79981 5599.79981 5491.1001 5538.29981 0 5538.29981 Date CommonWealth Bank Qantas Telstra 1/4/2016 79.42 4.06 12/28/2015 85.53 4.09 12/21/2015 83.32 4 12/14/2015 81.57 3.91 12/7/2015 78.95 3.83 11/30/2015 80.22 3.67 11/23/2015 80.12 3.78 11/16/2015 79.83 3.8 11/9/2015 75.76 3.61 11/2/2015 76.59 3.71 10/26/2015 76.73 3.95 10/19/2015 77.35 4.11076 10/12/2015 76.55 4.164 10/5/2015 75.53 3.86581 9/28/2015 73.39 4.06816 9/21/2015 71.44 3.92971 9/14/2015 75.83 3.86581 9/7/2015 75.13 3.76997 8/31/2015 72.15 3.69542 8/24/2015 76.36 3.39 8/17/2015 75.59 3.45 8/10/2015 81.6775 3.72 8/3/2015 80.8619 3.77 7/27/2015 87.0882 3.75 7/20/2015 85.3476 3.69 7/13/2015 87.5059 3.63 7/6/2015 85.3277 3.33 7/3/2015 86.193 3.2 5.3 5.61 5.46 5.48 5.2 5.41 5.4 5.41 5.14 5.31 5.4 5.58 5.44 5.64 5.62 5.67 5.65 5.55 5.61 5.82 6.07 6.08 6.29 6.49 6.36 6.42 6.21 6.13 Rate of Returns CBA QAN TLS 7.693% 0.739% -2.584% -2.200% -2.100% -2.250% -3.212% -2.046% 1.609% -4.178% -0.125% 2.997% -0.362% 0.529% -5.098% -5.000% 1.096% 2.770% 0.183% 6.469% 0.808% 4.070% -1.034% 1.295% -1.332% -7.161% -2.833% 5.234% -2.657% -3.403% 6.145% -1.626% -0.923% -2.479% -3.966% -1.977% 5.835% -8.265% -1.008% 1.770% 8.053% 7.826% -0.999% 1.344% 7.700% -0.531% -1.999% -1.600% 2.529% -1.626% -2.489% -8.264% 1.014% -3.904% 5.849% -2.674% 0.366% -5.109% 4.038% -0.185% 0.185% -4.991% 3.307% 1.695% 3.333% -2.509% 3.676% -0.355% 0.890% -0.353% -1.770% 1.081% 3.743% 4.296% 0.165% 3.454% 3.180% -2.003% 0.943% -3.271% -1.288%Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started