Finance project

profilebadrbanan
3_HPRcalculationfromRWJJbook.xlsx
Home>Business & Finance homework help>Accounting homework help>Finance project

Sheet1

Return Data
Date S&P 500 Amazon.com
7/1/11 1292.28 $ 222.52 S&P 500 return Amazon return Blue Arrow Adjusted close prices
8/1/11 1218.89 $ 215.23 -5.68% -3.28% Red Arrow Holding period return
9/1/11 1131.42 $ 216.23 -7.18% 0.46%
10/3/11 1253.30 $ 213.51 10.77% -1.26%
11/1/11 1246.96 $ 192.29 -0.51% -9.94%
12/1/11 1257.60 $ 173.10 0.85% -9.98%
1/3/12 1312.41 $ 194.44 4.36% 12.33%
2/1/12 1365.68 $ 179.69 4.06% -7.59%
3/1/12 1408.47 $ 202.51 3.13% 12.70%
4/2/12 1397.91 $ 231.90 -0.75% 14.51%
5/1/12 1310.33 $ 212.91 -6.27% -8.19%
6/1/12 1362.16 $ 228.35 3.96% 7.25%
7/2/12 1379.32 $ 233.30 1.26% 2.17%
8/1/12 1406.58 $ 248.27 1.98% 6.42%
9/4/12 1440.67 $ 254.32 2.42% 2.44%
10/1/12 1412.16 $ 232.89 -1.98% -8.43%
11/1/12 1416.18 $ 252.05 0.28% 8.23%
12/3/12 1426.19 $ 250.87 0.71% -0.47%
1/2/13 1498.11 $ 265.50 5.04% 5.83%
2/1/13 1514.68 $ 264.27 1.11% -0.46%
3/1/13 1569.19 $ 266.49 3.60% 0.84%
4/1/13 1597.57 $ 253.81 1.81% -4.76%
5/1/13 1630.74 $ 269.20 2.08% 6.06%
6/3/13 1606.28 $ 277.69 -1.50% 3.15%
7/1/13 1685.73 $ 301.22 4.95% 8.47%
8/1/13 1632.97 $ 280.98 -3.13% -6.72%
9/3/13 1681.55 $ 312.64 2.97% 11.27%
10/1/13 1756.54 $ 364.03 4.46% 16.44%
11/1/13 1805.81 $ 393.62 2.80% 8.13%
12/2/13 1848.36 $ 398.79 2.36% 1.31%
1/2/14 1782.59 $ 358.69 -3.56% -10.06%
2/3/14 1859.45 $ 362.10 4.31% 0.95%
3/3/14 1872.34 $ 336.37 0.69% -7.11%
4/1/14 1883.95 $ 304.13 0.62% -9.58%
5/1/14 1923.57 $ 312.55 2.10% 2.77%
6/2/14 1960.23 $ 324.78 1.91% 3.91%
7/1/14 1930.67 $ 312.99 -1.51% -3.63%
8/1/14 2003.37 $ 339.04 3.77% 8.32%
9/2/14 1972.29 $ 322.44 -1.55% -4.90%
10/1/14 2018.05 $ 305.46 2.32% -5.27%
11/3/14 2067.56 $ 338.64 2.45% 10.86%
12/1/14 2058.90 $ 310.35 -0.42% -8.35%
1/2/15 1994.99 $ 354.53 -3.10% 14.24%
2/2/15 2104.50 $ 380.16 5.49% 7.23%
3/2/15 2067.89 $ 372.10 -1.74% -2.12%
4/1/15 2085.51 $ 421.78 0.85% 13.35%
5/1/15 2107.39 $ 429.23 1.05% 1.77%
6/1/15 2063.11 $ 434.09 -2.10% 1.13%
7/1/15 2103.84 $ 536.15 1.97% 23.51%
8/3/15 1972.18 $ 512.89 -6.26% -4.34%
9/1/15 1920.03 $ 511.89 -2.64% -0.19%
10/1/15 2079.36 $ 625.90 8.30% 22.27%
11/2/15 2080.41 $ 664.80 0.05% 6.22%
12/1/15 2043.94 $ 675.89 -1.75% 1.67%
1/4/16 1940.24 $ 587.00 -5.07% -13.15%
2/1/16 1932.23 $ 552.52 -0.41% -5.87%
3/1/16 2059.74 $ 593.64 6.60% 7.44%
4/1/16 2065.30 $ 659.59 0.27% 11.11%
5/2/16 2096.95 $ 722.79 1.53% 9.58%
6/1/16 2098.86 $ 715.62 0.09% -0.99%
7/1/16 2173.60 $ 758.81 3.56% 6.04%
Return 0.93% 2.40%
STDEV 3.49% 8.34%

Sheet2

Sheet3