Finance Homework need within 3 hours!!!

profileillmaticallday
qp_problem_set_2_.xlsx
Home>Business & Finance homework help>Finance Homework need within 3 hours!!!

Securities Info

Apple- APPL Exxon-XOM S&P 500- ^GSPC 13 week T-Bill- ^IRX
Date Close Adj Close Date Close Adj Close Date Close Adj Close Date Close Adj Close
5/3/10 256.87997 34.47083 5/3/10 60.46 52.95646 5/3/10 1089.41003 1089.41003 5/3/10 0.15 0.15
6/1/10 251.53003 33.75292 6/1/10 57.07 49.98719 6/1/10 1030.70996 1030.70996 6/1/10 0.17 0.17
7/1/10 257.25 34.52048 7/1/10 59.68 52.27327 7/1/10 1101.59998 1101.59998 7/1/10 0.14 0.14
8/2/10 243.09998 32.62169 8/2/10 59.11 52.14449 8/2/10 1049.32996 1049.32996 8/2/10 0.135 0.135
9/1/10 283.74997 38.07653 9/1/10 61.79 54.50867 9/1/10 1141.19995 1141.19995 9/1/10 0.155 0.155
10/1/10 300.97998 40.38863 10/1/10 66.49 58.65482 10/1/10 1183.26001 1183.26001 10/1/10 0.11 0.11
11/1/10 311.14999 41.75335 11/1/10 69.56 61.74943 11/1/10 1180.55005 1180.55005 11/1/10 0.16 0.16
12/1/10 322.56 43.28446 12/1/10 73.12 64.9097 12/1/10 1257.64001 1257.64001 12/1/10 0.115 0.115
1/3/11 339.32001 45.53349 1/3/11 80.68 71.62082 1/3/11 1286.12 1286.12 1/3/11 0.145 0.145
2/1/11 353.20999 47.39739 2/1/11 85.53 76.32637 2/1/11 1327.21997 1327.21997 2/1/11 0.135 0.135
3/1/11 348.50998 46.7667 3/1/11 84.13 75.07702 3/1/11 1325.82996 1325.82996 3/1/11 0.09 0.09
4/1/11 350.13 46.98409 4/1/11 87.98 78.51274 4/1/11 1363.60999 1363.60999 4/1/11 0.04 0.04
5/2/11 347.82999 46.67545 5/2/11 83.47 74.91051 5/2/11 1345.19995 1345.19995 5/2/11 0.04 0.04
6/1/11 335.67004 45.0437 6/1/11 81.38 73.03483 6/1/11 1320.64001 1320.64001 6/1/11 0.015 0.015
7/1/11 390.48001 52.39867 7/1/11 79.79 71.60788 7/1/11 1292.28003 1292.28003 7/1/11 0.09 0.09
8/1/11 384.82999 51.6405 8/1/11 74.02 66.86826 8/1/11 1218.89001 1218.89001 8/1/11 0.015 0.015
9/1/11 381.32001 51.16949 9/1/11 72.63 65.61256 9/1/11 1131.42004 1131.42004 9/1/11 0.01 0.01
10/3/11 404.77997 54.31759 10/3/11 78.09 70.54502 10/3/11 1253.30005 1253.30005 10/3/11 0.005 0.005
11/1/11 382.19998 51.28757 11/1/11 80.44 73.10095 11/1/11 1246.95996 1246.95996 11/1/11 0.015 0.015
12/1/11 404.99997 54.34711 12/1/11 84.76 77.02682 12/1/11 1257.59998 1257.59998 12/1/11 0.005 0.005
1/3/12 456.48004 61.25525 1/3/12 83.74 76.09987 1/3/12 1312.41003 1312.41003 1/3/12 0.055 0.055
2/1/12 542.44 72.79025 2/1/12 86.5 79.03831 2/1/12 1365.68005 1365.68005 2/1/12 0.075 0.075
3/1/12 599.54999 80.45387 3/1/12 86.73 79.24847 3/1/12 1408.46997 1408.46997 3/1/12 0.065 0.065
4/2/12 583.97998 78.36452 4/2/12 86.34 78.89211 4/2/12 1397.91003 1397.91003 4/2/12 0.09 0.09
5/1/12 577.73004 77.52583 5/1/12 78.63 72.34216 5/1/12 1310.32996 1310.32996 5/1/12 0.06 0.06
6/1/12 584 78.3672 6/1/12 85.57 78.72718 6/1/12 1362.16003 1362.16003 6/1/12 0.08 0.08
7/2/12 610.76001 81.95814 7/2/12 86.85 79.90482 7/2/12 1379.31995 1379.31995 7/2/12 0.1 0.1
8/1/12 665.23999 89.65211 8/1/12 87.3 80.84081 8/1/12 1406.57996 1406.57996 8/1/12 0.085 0.085
9/4/12 667.10004 89.90278 9/4/12 91.45 84.68375 9/4/12 1440.67004 1440.67004 9/4/12 0.09 0.09
10/1/12 595.31995 80.22923 10/1/12 91.17 84.42447 10/1/12 1412.16003 1412.16003 10/1/12 0.105 0.105
11/1/12 585.27997 79.23643 11/1/12 88.14 82.12967 11/1/12 1416.18005 1416.18005 11/1/12 0.075 0.075
12/3/12 532.17004 72.0463 12/3/12 86.55 80.64809 12/3/12 1426.18994 1426.18994 12/3/12 0.035 0.035
1/2/13 455.48999 61.66519 1/2/13 89.97 83.83488 1/2/13 1498.10999 1498.10999 1/2/13 0.065 0.065
2/1/13 441.39999 60.10592 2/1/13 89.55 83.97662 2/1/13 1514.68005 1514.68005 2/1/13 0.1 0.1
3/1/13 442.65997 60.27749 3/1/13 90.11 84.50175 3/1/13 1569.18994 1569.18994 3/1/13 0.065 0.065
4/1/13 442.78003 60.29384 4/1/13 88.99 83.45146 4/1/13 1597.56995 1597.56995 4/1/13 0.045 0.045
5/1/13 449.72998 61.64557 5/1/13 90.47 85.42625 5/1/13 1630.73999 1630.73999 5/1/13 0.03 0.03
6/3/13 396.52997 54.35332 6/3/13 90.35 85.31294 6/3/13 1606.28003 1606.28003 6/3/13 0.03 0.03
7/1/13 452.52997 62.02938 7/1/13 93.75 88.52339 7/1/13 1685.72998 1685.72998 7/1/13 0.03 0.03
8/1/13 487.22003 67.22538 8/1/13 87.16 82.86963 8/1/13 1632.96997 1632.96997 8/1/13 0.02 0.02
9/3/13 476.74997 65.78075 9/3/13 86.04 81.80476 9/3/13 1681.55005 1681.55005 9/3/13 0.005 0.005
10/1/13 522.70001 72.12082 10/1/13 89.62 85.20853 10/1/13 1756.54004 1756.54004 10/1/13 0.033 0.033
11/1/13 556.06995 77.17307 11/1/13 93.48 89.48328 11/1/13 1805.81006 1805.81006 11/1/13 0.055 0.055
12/2/13 561.02002 77.86005 12/2/13 101.2 96.8732 12/2/13 1848.35999 1848.35999 12/2/13 0.063 0.063
1/2/14 500.60004 69.47478 1/2/14 92.16 88.21971 1/2/14 1782.58997 1782.58997 1/2/14 0.01 0.01
2/3/14 526.23999 73.47033 2/3/14 96.27 92.80667 2/3/14 1859.44995 1859.44995 2/3/14 0.043 0.043
3/3/14 536.73999 74.93627 3/3/14 97.68 94.16595 3/3/14 1872.33997 1872.33997 3/3/14 0.028 0.028
4/1/14 590.08997 82.38467 4/1/14 102.41 98.72579 4/1/14 1883.94995 1883.94995 4/1/14 0.02 0.02
5/1/14 633 88.86911 5/1/14 100.53 97.5714 5/1/14 1923.56995 1923.56995 5/1/14 0.03 0.03
6/2/14 92.93 91.32739 6/2/14 100.68 97.71699 6/2/14 1960.22998 1960.22998 6/2/14 0.02 0.02
7/1/14 95.6 93.95135 7/1/14 98.94 96.0282 7/1/14 1930.67004 1930.67004 7/1/14 0.018 0.018
8/1/14 102.5 101.23341 8/1/14 99.46 97.20535 8/1/14 2003.37 2003.37 8/1/14 0.018 0.018
9/2/14 100.75 99.50504 9/2/14 94.05 91.918 9/2/14 1972.29004 1972.29004 9/2/14 0.013 0.013
10/1/14 108 106.66544 10/1/14 96.71 94.51769 10/1/14 2018.05005 2018.05005 10/1/14 0.003 0.003
11/3/14 118.93 117.96971 11/3/14 90.54 89.12643 11/3/14 2067.56006 2067.56006 11/3/14 0.005 0.005
12/1/14 110.38 109.48875 12/1/14 92.45 91.00661 12/1/14 2058.8999 2058.8999 12/1/14 0.037 0.037
1/2/15 117.16 116.214 1/2/15 87.42 86.05514 1/2/15 1994.98999 1994.98999 1/2/15 0.005 0.005
2/2/15 128.46001 127.92565 2/2/15 88.54 87.8137 2/2/15 2104.5 2104.5 2/2/15 0.008 0.008
3/2/15 124.43 123.91241 3/2/15 85 84.30273 3/2/15 2067.88989 2067.88989 3/2/15 0.025 0.025
4/1/15 125.15 124.62942 4/1/15 87.37 86.6533 4/1/15 2085.51001 2085.51001 4/1/15 0.005 0.005
5/1/15 130.28 130.28 5/1/15 85.2 85.2 5/1/15 2107.38989 2107.38989 5/1/15 0.003 0.003

APPL Info

Apple- APPL
Date Close Adj Close Monthly Returns Average Monthly Return
5/3/10 256.87997 34.47083
6/1/10 251.53003 33.75292 -2.08% 2.48%
7/1/10 257.25 34.52048 2.27%
8/2/10 243.09998 32.62169 -5.50%
9/1/10 283.74997 38.07653 16.72%
10/1/10 300.97998 40.38863 6.07%
11/1/10 311.14999 41.75335 3.38%
12/1/10 322.56 43.28446 3.67%
1/3/11 339.32001 45.53349 5.20%
2/1/11 353.20999 47.39739 4.09%
3/1/11 348.50998 46.7667 -1.33%
4/1/11 350.13 46.98409 0.46%
5/2/11 347.82999 46.67545 -0.66%
6/1/11 335.67004 45.0437 -3.50%
7/1/11 390.48001 52.39867 16.33%
8/1/11 384.82999 51.6405 -1.45%
9/1/11 381.32001 51.16949 -0.91%
10/3/11 404.77997 54.31759 6.15%
11/1/11 382.19998 51.28757 -5.58%
12/1/11 404.99997 54.34711 5.97%
1/3/12 456.48004 61.25525 12.71%
2/1/12 542.44 72.79025 18.83%
3/1/12 599.54999 80.45387 10.53%
4/2/12 583.97998 78.36452 -2.60%
5/1/12 577.73004 77.52583 -1.07%
6/1/12 584 78.3672 1.09%
7/2/12 610.76001 81.95814 4.58%
8/1/12 665.23999 89.65211 9.39%
9/4/12 667.10004 89.90278 0.28%
10/1/12 595.31995 80.22923 -10.76%
11/1/12 585.27997 79.23643 -1.24%
12/3/12 532.17004 72.0463 -9.07%
1/2/13 455.48999 61.66519 -14.41%
2/1/13 441.39999 60.10592 -2.53%
3/1/13 442.65997 60.27749 0.29%
4/1/13 442.78003 60.29384 0.03%
5/1/13 449.72998 61.64557 2.24%
6/3/13 396.52997 54.35332 -11.83%
7/1/13 452.52997 62.02938 14.12%
8/1/13 487.22003 67.22538 8.38%
9/3/13 476.74997 65.78075 -2.15%
10/1/13 522.70001 72.12082 9.64%
11/1/13 556.06995 77.17307 7.01%
12/2/13 561.02002 77.86005 0.89%
1/2/14 500.60004 69.47478 -10.77%
2/3/14 526.23999 73.47033 5.75%
3/3/14 536.73999 74.93627 2.00%
4/1/14 590.08997 82.38467 9.94%
5/1/14 633 88.86911 7.87%
6/2/14 92.93 91.32739 2.77%
7/1/14 95.6 93.95135 2.87%
8/1/14 102.5 101.23341 7.75%
9/2/14 100.75 99.50504 -1.71%
10/1/14 108 106.66544 7.20%
11/3/14 118.93 117.96971 10.60%
12/1/14 110.38 109.48875 -7.19%
1/2/15 117.16 116.214 6.14%
2/2/15 128.46001 127.92565 10.08%
3/2/15 124.43 123.91241 -3.14%
4/1/15 125.15 124.62942 0.58%
5/1/15 130.28 130.28 4.53%

XOM Info

Exxon-XOM
Date Close Adj Close Monthly Returns Average Monthly Return
5/3/10 60.46 52.95646
6/1/10 57.07 49.98719 -5.61% 0.89%
7/1/10 59.68 52.27327 4.57%
8/2/10 59.11 52.14449 -0.25%
9/1/10 61.79 54.50867 4.53%
10/1/10 66.49 58.65482 7.61%
11/1/10 69.56 61.74943 5.28%
12/1/10 73.12 64.9097 5.12%
1/3/11 80.68 71.62082 10.34%
2/1/11 85.53 76.32637 6.57%
3/1/11 84.13 75.07702 -1.64%
4/1/11 87.98 78.51274 4.58%
5/2/11 83.47 74.91051 -4.59%
6/1/11 81.38 73.03483 -2.50%
7/1/11 79.79 71.60788 -1.95%
8/1/11 74.02 66.86826 -6.62%
9/1/11 72.63 65.61256 -1.88%
10/3/11 78.09 70.54502 7.52%
11/1/11 80.44 73.10095 3.62%
12/1/11 84.76 77.02682 5.37%
1/3/12 83.74 76.09987 -1.20%
2/1/12 86.5 79.03831 3.86%
3/1/12 86.73 79.24847 0.27%
4/2/12 86.34 78.89211 -0.45%
5/1/12 78.63 72.34216 -8.30%
6/1/12 85.57 78.72718 8.83%
7/2/12 86.85 79.90482 1.50%
8/1/12 87.3 80.84081 1.17%
9/4/12 91.45 84.68375 4.75%
10/1/12 91.17 84.42447 -0.31%
11/1/12 88.14 82.12967 -2.72%
12/3/12 86.55 80.64809 -1.80%
1/2/13 89.97 83.83488 3.95%
2/1/13 89.55 83.97662 0.17%
3/1/13 90.11 84.50175 0.63%
4/1/13 88.99 83.45146 -1.24%
5/1/13 90.47 85.42625 2.37%
6/3/13 90.35 85.31294 -0.13%
7/1/13 93.75 88.52339 3.76%
8/1/13 87.16 82.86963 -6.39%
9/3/13 86.04 81.80476 -1.28%
10/1/13 89.62 85.20853 4.16%
11/1/13 93.48 89.48328 5.02%
12/2/13 101.2 96.8732 8.26%
1/2/14 92.16 88.21971 -8.93%
2/3/14 96.27 92.80667 5.20%
3/3/14 97.68 94.16595 1.46%
4/1/14 102.41 98.72579 4.84%
5/1/14 100.53 97.5714 -1.17%
6/2/14 100.68 97.71699 0.15%
7/1/14 98.94 96.0282 -1.73%
8/1/14 99.46 97.20535 1.23%
9/2/14 94.05 91.918 -5.44%
10/1/14 96.71 94.51769 2.83%
11/3/14 90.54 89.12643 -5.70%
12/1/14 92.45 91.00661 2.11%
1/2/15 87.42 86.05514 -5.44%
2/2/15 88.54 87.8137 2.04%
3/2/15 85 84.30273 -4.00%
4/1/15 87.37 86.6533 2.79%
5/1/15 85.2 85.2 -1.68%

S&P 500 Info

S&P 500- ^GSPC
Date Close Adj Close Monthly Returns Average Monthly Return
5/3/10 1089.41003 1089.41003
6/1/10 1030.70996 1030.70996 -5.39% 1.17%
7/1/10 1101.59998 1101.59998 6.88%
8/2/10 1049.32996 1049.32996 -4.74%
9/1/10 1141.19995 1141.19995 8.76%
10/1/10 1183.26001 1183.26001 3.69%
11/1/10 1180.55005 1180.55005 -0.23%
12/1/10 1257.64001 1257.64001 6.53%
1/3/11 1286.12 1286.12 2.26%
2/1/11 1327.21997 1327.21997 3.20%
3/1/11 1325.82996 1325.82996 -0.10%
4/1/11 1363.60999 1363.60999 2.85%
5/2/11 1345.19995 1345.19995 -1.35%
6/1/11 1320.64001 1320.64001 -1.83%
7/1/11 1292.28003 1292.28003 -2.15%
8/1/11 1218.89001 1218.89001 -5.68%
9/1/11 1131.42004 1131.42004 -7.18%
10/3/11 1253.30005 1253.30005 10.77%
11/1/11 1246.95996 1246.95996 -0.51%
12/1/11 1257.59998 1257.59998 0.85%
1/3/12 1312.41003 1312.41003 4.36%
2/1/12 1365.68005 1365.68005 4.06%
3/1/12 1408.46997 1408.46997 3.13%
4/2/12 1397.91003 1397.91003 -0.75%
5/1/12 1310.32996 1310.32996 -6.27%
6/1/12 1362.16003 1362.16003 3.96%
7/2/12 1379.31995 1379.31995 1.26%
8/1/12 1406.57996 1406.57996 1.98%
9/4/12 1440.67004 1440.67004 2.42%
10/1/12 1412.16003 1412.16003 -1.98%
11/1/12 1416.18005 1416.18005 0.28%
12/3/12 1426.18994 1426.18994 0.71%
1/2/13 1498.10999 1498.10999 5.04%
2/1/13 1514.68005 1514.68005 1.11%
3/1/13 1569.18994 1569.18994 3.60%
4/1/13 1597.56995 1597.56995 1.81%
5/1/13 1630.73999 1630.73999 2.08%
6/3/13 1606.28003 1606.28003 -1.50%
7/1/13 1685.72998 1685.72998 4.95%
8/1/13 1632.96997 1632.96997 -3.13%
9/3/13 1681.55005 1681.55005 2.97%
10/1/13 1756.54004 1756.54004 4.46%
11/1/13 1805.81006 1805.81006 2.80%
12/2/13 1848.35999 1848.35999 2.36%
1/2/14 1782.58997 1782.58997 -3.56%
2/3/14 1859.44995 1859.44995 4.31%
3/3/14 1872.33997 1872.33997 0.69%
4/1/14 1883.94995 1883.94995 0.62%
5/1/14 1923.56995 1923.56995 2.10%
6/2/14 1960.22998 1960.22998 1.91%
7/1/14 1930.67004 1930.67004 -1.51%
8/1/14 2003.37 2003.37 3.77%
9/2/14 1972.29004 1972.29004 -1.55%
10/1/14 2018.05005 2018.05005 2.32%
11/3/14 2067.56006 2067.56006 2.45%
12/1/14 2058.8999 2058.8999 -0.42%
1/2/15 1994.98999 1994.98999 -3.10%
2/2/15 2104.5 2104.5 5.49%
3/2/15 2067.88989 2067.88989 -1.74%
4/1/15 2085.51001 2085.51001 0.85%
5/1/15 2107.38989 2107.38989 1.05%

^IRX Info

13 week T-Bill- ^IRX
Date Close Adj Close Monthly Returns Average Monthly Return
5/3/10 0.15 0.15
6/1/10 0.17 0.17 13.33% 46.20%
7/1/10 0.14 0.14 -17.65%
8/2/10 0.135 0.135 -3.57%
9/1/10 0.155 0.155 14.81%
10/1/10 0.11 0.11 -29.03%
11/1/10 0.16 0.16 45.45%
12/1/10 0.115 0.115 -28.13%
1/3/11 0.145 0.145 26.09%
2/1/11 0.135 0.135 -6.90%
3/1/11 0.09 0.09 -33.33%
4/1/11 0.04 0.04 -55.56%
5/2/11 0.04 0.04 0.00%
6/1/11 0.015 0.015 -62.50%
7/1/11 0.09 0.09 500.00%
8/1/11 0.015 0.015 -83.33%
9/1/11 0.01 0.01 -33.33%
10/3/11 0.005 0.005 -50.00%
11/1/11 0.015 0.015 200.00%
12/1/11 0.005 0.005 -66.67%
1/3/12 0.055 0.055 1000.00%
2/1/12 0.075 0.075 36.36%
3/1/12 0.065 0.065 -13.33%
4/2/12 0.09 0.09 38.46%
5/1/12 0.06 0.06 -33.33%
6/1/12 0.08 0.08 33.33%
7/2/12 0.1 0.1 25.00%
8/1/12 0.085 0.085 -15.00%
9/4/12 0.09 0.09 5.88%
10/1/12 0.105 0.105 16.67%
11/1/12 0.075 0.075 -28.57%
12/3/12 0.035 0.035 -53.33%
1/2/13 0.065 0.065 85.71%
2/1/13 0.1 0.1 53.85%
3/1/13 0.065 0.065 -35.00%
4/1/13 0.045 0.045 -30.77%
5/1/13 0.03 0.03 -33.33%
6/3/13 0.03 0.03 0.00%
7/1/13 0.03 0.03 0.00%
8/1/13 0.02 0.02 -33.33%
9/3/13 0.005 0.005 -75.00%
10/1/13 0.033 0.033 560.00%
11/1/13 0.055 0.055 66.67%
12/2/13 0.063 0.063 14.55%
1/2/14 0.01 0.01 -84.13%
2/3/14 0.043 0.043 330.00%
3/3/14 0.028 0.028 -34.88%
4/1/14 0.02 0.02 -28.57%
5/1/14 0.03 0.03 50.00%
6/2/14 0.02 0.02 -33.33%
7/1/14 0.018 0.018 -10.00%
8/1/14 0.018 0.018 0.00%
9/2/14 0.013 0.013 -27.78%
10/1/14 0.003 0.003 -76.92%
11/3/14 0.005 0.005 66.67%
12/1/14 0.037 0.037 640.00%
1/2/15 0.005 0.005 -86.49%
2/2/15 0.008 0.008 60.00%
3/2/15 0.025 0.025 212.50%
4/1/15 0.005 0.005 -80.00%
5/1/15 0.003 0.003 -40.00%