Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need assistance in completing the open ended portion that could be found on the last page of the pdf file. Part A most importantly
I need assistance in completing the open ended portion that could be found on the last page of the pdf file. Part A most importantly is what I need assistance with, the data that needs to be manipulated is within the data file
DATE TICKER 20060131 MSFT 20060228 MSFT 20060331 MSFT 20060428 MSFT 20060531 MSFT 20060630 MSFT 20060731 MSFT 20060831 MSFT 20060929 MSFT 20061031 MSFT 20061130 MSFT 20061229 MSFT 20070131 MSFT 20070228 MSFT 20070330 MSFT 20070430 MSFT 20070531 MSFT 20070629 MSFT 20070731 MSFT 20070831 MSFT 20070928 MSFT 20071031 MSFT 20071130 MSFT 20071231 MSFT 20080131 MSFT 20080229 MSFT 20080331 MSFT 20080430 MSFT 20080530 MSFT 20080630 MSFT 20080731 MSFT 20080829 MSFT 20080930 MSFT 20081031 MSFT 20081128 MSFT 20081231 MSFT 20090130 MSFT 20090227 MSFT 20090331 MSFT 20090430 MSFT 20090529 MSFT 20090630 MSFT 20090731 MSFT 20090831 MSFT 20090930 MSFT 20091030 MSFT 20091130 MSFT 20091231 MSFT 20100129 MSFT 20100226 MSFT 20100331 MSFT 20100430 MSFT 20100528 MSFT 20100630 MSFT 20100730 MSFT 20100831 MSFT 20100930 MSFT 20101029 MSFT 20101130 MSFT 20101231 MSFT 20110131 MSFT 20110228 MSFT 20110331 MSFT 20110429 MSFT 20110531 MSFT 20110630 MSFT 20110729 MSFT 20110831 MSFT 20110930 MSFT 20111031 MSFT 20111130 MSFT 20111230 MSFT 20120131 MSFT 20120229 MSFT 20120330 MSFT 20120430 MSFT 20120531 MSFT 20120629 MSFT 20120731 MSFT 20120831 MSFT 20120928 MSFT 20121031 MSFT 20121130 MSFT 20121231 MSFT 20130131 MSFT 20130228 MSFT COMPANY MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP RET 7.65% -4.23% 1.27% -11.25% -5.84% 2.87% 3.26% 7.19% 6.42% 4.97% 2.61% 1.70% 3.35% -8.39% -1.07% 7.43% 2.84% -3.98% -1.63% -0.55% 2.54% 24.95% -8.42% 5.95% -8.43% -16.23% 4.34% 0.49% -0.32% -2.86% -6.51% 6.53% -2.20% -16.34% -8.87% -3.86% -12.04% -4.80% 13.75% 10.29% 3.75% 13.79% -1.05% 5.36% 4.34% 7.81% 6.53% 3.64% -7.55% 2.20% 2.15% 4.26% -15.08% -10.81% 12.17% -8.58% 4.37% 8.88% -4.68% 10.50% -0.66% -3.55% -4.48% 2.09% -2.89% 3.96% 5.38% -2.34% -6.43% 6.99% -3.19% 1.49% 13.75% 8.16% 1.62% -0.74% -8.20% 4.80% -3.66% 5.26% -3.44% -4.10% -5.94% 0.36% 2.77% 2.11% DATE 20060131 20060228 20060331 20060428 20060531 20060630 20060731 20060831 20060929 20061031 20061130 20061229 20070131 20070228 20070330 20070430 20070531 20070629 20070731 20070831 20070928 20071031 20071130 20071231 20080131 20080229 20080331 20080430 20080530 20080630 20080731 20080829 20080930 20081031 20081128 20081231 20090130 20090227 20090331 20090430 20090529 20090630 20090731 20090831 20090930 20091030 20091130 20091231 20100129 20100226 20100331 20100430 20100528 20100630 20100730 20100831 20100930 20101029 20101130 20101231 20110131 20110228 20110331 20110429 20110531 20110630 20110729 20110831 20110930 20111031 20111130 20111230 20120131 20120229 20120330 20120430 20120531 20120629 20120731 20120831 20120928 20121031 20121130 20121231 20130131 20130228 mktrf 3.04% -0.30% 1.46% 0.73% -3.57% -0.35% -0.78% 2.03% 1.84% 3.23% 1.71% 0.87% 1.40% -1.96% 0.68% 3.49% 3.24% -1.96% -3.73% 0.92% 3.22% 1.80% -4.83% -0.87% -6.36% -3.09% -0.93% 4.60% 1.86% -8.44% -0.77% 1.53% -9.24% -17.23% -7.86% 1.74% -8.12% -10.10% 8.95% 10.19% 5.21% 0.43% 7.72% 3.33% 4.08% -2.59% 5.56% 2.75% -3.36% 3.40% 6.31% 2.00% -7.89% -5.56% 6.93% -4.77% 9.54% 3.88% 0.60% 6.82% 1.99% 3.49% 0.45% 2.90% -1.27% -1.75% -2.36% -5.99% -7.59% 11.35% -0.28% 0.74% 5.05% 4.42% 3.11% -0.85% -6.19% 3.89% 0.79% 2.55% 2.73% -1.76% 0.78% 1.18% 5.57% 1.29% rf 0.35% 0.34% 0.37% 0.36% 0.43% 0.40% 0.40% 0.42% 0.41% 0.41% 0.42% 0.40% 0.44% 0.38% 0.43% 0.44% 0.41% 0.40% 0.40% 0.42% 0.32% 0.32% 0.34% 0.27% 0.21% 0.13% 0.17% 0.18% 0.18% 0.17% 0.15% 0.13% 0.15% 0.08% 0.03% 0.00% 0.00% 0.01% 0.02% 0.01% 0.00% 0.01% 0.01% 0.01% 0.01% 0.00% 0.00% 0.01% 0.00% 0.00% 0.01% 0.01% 0.01% 0.01% 0.01% 0.01% 0.01% 0.01% 0.01% 0.01% 0.01% 0.01% 0.01% 0.00% 0.00% 0.00% 0.00% 0.01% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.01% 0.00% 0.00% 0.01% 0.01% 0.01% 0.01% 0.01% 0.00% 0.00% 20130328 MSFT 20130430 MSFT 20130531 MSFT 20130628 MSFT 20130731 MSFT 20130830 MSFT 20130930 MSFT 20131031 MSFT 20131129 MSFT 20131231 MSFT 20140131 MSFT 20140228 MSFT 20140331 MSFT 20140430 MSFT 20140530 MSFT 20140630 MSFT 20140731 MSFT 20140829 MSFT 20140930 MSFT 20141031 MSFT 20141128 MSFT 20141231 MSFT 20150130 MSFT 20150227 MSFT 20150331 MSFT 20150430 MSFT 20150529 MSFT 20150630 MSFT 20150731 MSFT 20150831 MSFT 20150930 MSFT 20151030 MSFT 20151130 MSFT 20151231 MSFT 20060131 KO 20060228 KO 20060331 KO 20060428 KO 20060531 KO 20060630 KO 20060731 KO 20060831 KO 20060929 KO 20061031 KO 20061130 KO 20061229 KO 20070131 KO 20070228 KO 20070330 KO 20070430 KO 20070531 KO 20070629 KO 20070731 KO 20070831 KO 20070928 KO 20071031 KO 20071130 KO 20071231 KO 20080131 KO 20080229 KO 20080331 KO 20080430 KO 20080530 KO 20080630 KO 20080731 KO 20080829 KO 20080930 KO 20081031 KO 20081128 KO 20081231 KO 20090130 KO 20090227 KO 20090331 KO 20090430 KO 20090529 KO 20090630 KO 20090731 KO 20090831 KO 20090930 KO 20091030 KO 20091130 KO 20091231 KO 20100129 KO 20100226 KO 20100331 KO 20100430 KO 20100528 KO MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP MICROSOFT CORP COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO 2.90% 15.71% 6.13% -1.02% -7.83% 5.62% -0.36% 6.39% 8.49% -1.89% 1.15% 1.98% 7.00% -1.44% 2.03% 1.86% 3.50% 5.91% 2.05% 1.27% 2.49% -2.84% -13.02% 9.31% -7.29% 19.64% -3.02% -5.78% 5.78% -6.15% 1.70% 18.93% 3.93% 2.08% 2.65% 1.43% 0.50% 0.22% 4.93% -1.59% 3.44% 0.70% 0.40% 4.57% 0.90% 3.03% -0.77% -2.51% 3.56% 8.73% 1.53% -0.64% -0.38% 3.20% 7.49% 7.46% 1.10% -1.18% -3.86% -0.92% 4.77% -3.29% -2.73% -8.56% -0.92% 1.11% 2.29% -16.68% 7.24% -3.41% -5.63% -4.38% 8.59% -2.05% 14.19% -1.55% 3.86% -2.15% 10.95% -0.73% 8.07% -0.35% -4.82% -2.82% 5.16% -2.82% -3.84% 20130328 20130430 20130531 20130628 20130731 20130830 20130930 20131031 20131129 20131231 20140131 20140228 20140331 20140430 20140530 20140630 20140731 20140829 20140930 20141031 20141128 20141231 20150130 20150227 20150331 20150430 20150529 20150630 20150731 20150831 20150930 20151030 20151130 20151231 4.03% 1.56% 2.80% -1.20% 5.65% -2.71% 3.77% 4.18% 3.12% 2.81% -3.32% 4.65% 0.43% -0.19% 2.06% 2.61% -2.04% 4.23% -1.97% 2.52% 2.55% -0.06% -3.11% 6.13% -1.12% 0.59% 1.36% -1.53% 1.54% -6.04% -3.07% 7.75% 0.56% -2.17% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.01% 20100630 KO 20100730 KO 20100831 KO 20100930 KO 20101029 KO 20101130 KO 20101231 KO 20110131 KO 20110228 KO 20110331 KO 20110429 KO 20110531 KO 20110630 KO 20110729 KO 20110831 KO 20110930 KO 20111031 KO 20111130 KO 20111230 KO 20120131 KO 20120229 KO 20120330 KO 20120430 KO 20120531 KO 20120629 KO 20120731 KO 20120831 KO 20120928 KO 20121031 KO 20121130 KO 20121231 KO 20130131 KO 20130228 KO 20130328 KO 20130430 KO 20130531 KO 20130628 KO 20130731 KO 20130830 KO 20130930 KO 20131031 KO 20131129 KO 20131231 KO 20140131 KO 20140228 KO 20140331 KO 20140430 KO 20140530 KO 20140630 KO 20140731 KO 20140829 KO 20140930 KO 20141031 KO 20141128 KO 20141231 KO 20150130 KO 20150227 KO 20150331 KO 20150430 KO 20150529 KO 20150630 KO 20150731 KO 20150831 KO 20150930 KO 20151030 KO 20151130 KO 20151231 KO 20060131 XOM 20060228 XOM 20060331 XOM 20060428 XOM 20060531 XOM 20060630 XOM 20060731 XOM 20060831 XOM 20060929 XOM 20061031 XOM 20061130 XOM 20061229 XOM 20070131 XOM 20070228 XOM 20070330 XOM 20070430 XOM 20070531 XOM 20070629 XOM 20070731 XOM 20070831 XOM COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO COCA COLA CO EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP -1.63% 9.96% 1.40% 5.51% 4.78% 3.73% 4.12% -4.44% 1.70% 4.52% 1.69% -0.96% 1.42% 1.07% 3.59% -3.44% 1.12% -0.91% 4.08% -3.49% 3.45% 6.67% 3.12% -2.08% 5.31% 3.34% -7.43% 2.10% -1.98% 2.68% -4.40% 2.73% 3.97% 5.17% 4.67% -5.53% 1.00% -0.07% -4.74% -0.05% 4.46% 2.27% 2.79% -8.45% 1.00% 2.00% 5.51% 0.29% 4.29% -7.25% 6.18% 2.98% -1.83% 7.77% -5.82% -2.49% 5.17% -5.59% 0.02% 0.99% -3.42% 4.72% -4.28% 2.87% 5.56% 1.42% 0.80% 11.71% -4.88% 2.51% 3.65% -2.93% 0.72% 10.42% 0.37% -0.84% 6.44% 8.00% -0.23% -3.30% -2.83% 5.26% 5.21% 5.22% 0.85% 1.49% 1.12% 20070928 XOM 20071031 XOM 20071130 XOM 20071231 XOM 20080131 XOM 20080229 XOM 20080331 XOM 20080430 XOM 20080530 XOM 20080630 XOM 20080731 XOM 20080829 XOM 20080930 XOM 20081031 XOM 20081128 XOM 20081231 XOM 20090130 XOM 20090227 XOM 20090331 XOM 20090430 XOM 20090529 XOM 20090630 XOM 20090731 XOM 20090831 XOM 20090930 XOM 20091030 XOM 20091130 XOM 20091231 XOM 20100129 XOM 20100226 XOM 20100331 XOM 20100430 XOM 20100528 XOM 20100630 XOM 20100730 XOM 20100831 XOM 20100930 XOM 20101029 XOM 20101130 XOM 20101231 XOM 20110131 XOM 20110228 XOM 20110331 XOM 20110429 XOM 20110531 XOM 20110630 XOM 20110729 XOM 20110831 XOM 20110930 XOM 20111031 XOM 20111130 XOM 20111230 XOM 20120131 XOM 20120229 XOM 20120330 XOM 20120430 XOM 20120531 XOM 20120629 XOM 20120731 XOM 20120831 XOM 20120928 XOM 20121031 XOM 20121130 XOM 20121231 XOM 20130131 XOM 20130228 XOM 20130328 XOM 20130430 XOM 20130531 XOM 20130628 XOM 20130731 XOM 20130830 XOM 20130930 XOM 20131031 XOM 20131129 XOM 20131231 XOM 20140131 XOM 20140228 XOM 20140331 XOM 20140430 XOM 20140530 XOM 20140630 XOM 20140731 XOM 20140829 XOM 20140930 XOM 20141031 XOM 20141128 XOM EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP 7.97% -0.62% -2.70% 5.08% -7.78% 1.11% -2.79% 10.04% -4.20% -0.71% -8.74% -0.02% -2.94% -4.56% 8.68% -0.40% -4.20% -10.70% 0.29% -2.10% 4.65% 0.81% 0.69% -1.16% -0.78% 4.46% 5.33% -9.16% -5.51% 1.54% 3.05% 1.18% -10.14% -5.61% 4.57% -0.22% 4.53% 7.61% 5.28% 5.12% 10.34% 6.56% -1.64% 4.58% -4.59% -2.50% -1.95% -6.64% -1.88% 7.52% 3.61% 5.37% -1.20% 3.86% 0.27% -0.45% -8.27% 8.83% 1.50% 1.17% 4.75% -0.31% -2.70% -1.80% 3.95% 0.17% 0.63% -1.24% 2.37% -0.13% 3.76% -6.36% -1.29% 4.16% 5.01% 8.26% -8.93% 5.14% 1.46% 4.84% -1.16% 0.15% -1.73% 1.22% -5.44% 2.83% -5.67% 20141231 XOM 20150130 XOM 20150227 XOM 20150331 XOM 20150430 XOM 20150529 XOM 20150630 XOM 20150731 XOM 20150831 XOM 20150930 XOM 20151030 XOM 20151130 XOM 20151231 XOM 20060131 AAPL 20060228 AAPL 20060331 AAPL 20060428 AAPL 20060531 AAPL 20060630 AAPL 20060731 AAPL 20060831 AAPL 20060929 AAPL 20061031 AAPL 20061130 AAPL 20061229 AAPL 20070131 AAPL 20070228 AAPL 20070330 AAPL 20070430 AAPL 20070531 AAPL 20070629 AAPL 20070731 AAPL 20070831 AAPL 20070928 AAPL 20071031 AAPL 20071130 AAPL 20071231 AAPL 20080131 AAPL 20080229 AAPL 20080331 AAPL 20080430 AAPL 20080530 AAPL 20080630 AAPL 20080731 AAPL 20080829 AAPL 20080930 AAPL 20081031 AAPL 20081128 AAPL 20081231 AAPL 20090130 AAPL 20090227 AAPL 20090331 AAPL 20090430 AAPL 20090529 AAPL 20090630 AAPL 20090731 AAPL 20090831 AAPL 20090930 AAPL 20091030 AAPL 20091130 AAPL 20091231 AAPL 20100129 AAPL 20100226 AAPL 20100331 AAPL 20100430 AAPL 20100528 AAPL 20100630 AAPL 20100730 AAPL 20100831 AAPL 20100930 AAPL 20101029 AAPL 20101130 AAPL 20101231 AAPL 20110131 AAPL 20110228 AAPL 20110331 AAPL 20110429 AAPL 20110531 AAPL 20110630 AAPL 20110729 AAPL 20110831 AAPL 20110930 AAPL 20111031 AAPL 20111130 AAPL 20111230 AAPL 20120131 AAPL 20120229 AAPL EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP EXXON MOBIL CORP APPLE COMPUTER INC APPLE COMPUTER INC APPLE COMPUTER INC APPLE COMPUTER INC APPLE COMPUTER INC APPLE COMPUTER INC APPLE COMPUTER INC APPLE COMPUTER INC APPLE COMPUTER INC APPLE COMPUTER INC APPLE COMPUTER INC APPLE COMPUTER INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC 2.11% -5.44% 2.07% -4.00% 2.79% -1.65% -2.35% -4.80% -4.09% -1.18% 11.28% -0.42% -4.54% 5.04% -9.30% -8.42% 12.23% -15.09% -4.18% 18.67% -0.16% 13.46% 5.33% 13.05% -7.44% 1.05% -1.31% 9.81% 7.42% 21.43% 0.70% 7.96% 5.10% 10.82% 23.77% -4.07% 8.70% -31.66% -7.64% 14.78% 21.22% 8.51% -11.29% -5.07% 6.66% -32.96% -5.34% -13.87% -7.90% 5.60% -0.91% 17.70% 19.70% 7.93% 4.87% 14.72% 2.95% 10.19% 1.70% 6.05% 5.41% -8.86% 6.54% 14.85% 11.10% -1.61% -2.08% 2.27% -5.50% 16.72% 6.07% 3.38% 3.67% 5.20% 4.09% -1.33% 0.47% -0.66% -3.50% 16.33% -1.45% -0.91% 6.15% -5.58% 5.97% 12.71% 18.83% 20120330 AAPL 20120430 AAPL 20120531 AAPL 20120629 AAPL 20120731 AAPL 20120831 AAPL 20120928 AAPL 20121031 AAPL 20121130 AAPL 20121231 AAPL 20130131 AAPL 20130228 AAPL 20130328 AAPL 20130430 AAPL 20130531 AAPL 20130628 AAPL 20130731 AAPL 20130830 AAPL 20130930 AAPL 20131031 AAPL 20131129 AAPL 20131231 AAPL 20140131 AAPL 20140228 AAPL 20140331 AAPL 20140430 AAPL 20140530 AAPL 20140630 AAPL 20140731 AAPL 20140829 AAPL 20140930 AAPL 20141031 AAPL 20141128 AAPL 20141231 AAPL 20150130 AAPL 20150227 AAPL 20150331 AAPL 20150430 AAPL 20150529 AAPL 20150630 AAPL 20150731 AAPL 20150831 AAPL 20150930 AAPL 20151030 AAPL 20151130 AAPL 20151231 AAPL 20060131 F 20060228 F 20060331 F 20060428 F 20060531 F 20060630 F 20060731 F 20060831 F 20060929 F 20061031 F 20061130 F 20061229 F 20070131 F 20070228 F 20070330 F 20070430 F 20070531 F 20070629 F 20070731 F 20070831 F 20070928 F 20071031 F 20071130 F 20071231 F 20080131 F 20080229 F 20080331 F 20080430 F 20080530 F 20080630 F 20080731 F 20080829 F 20080930 F 20081031 F 20081128 F 20081231 F 20090130 F 20090227 F 20090331 F 20090430 F 20090529 F APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC APPLE INC FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL 10.53% -2.60% -1.07% 1.09% 4.58% 9.35% 0.28% -10.76% -1.24% -9.07% -14.41% -2.51% 0.29% 0.03% 2.26% -11.83% 14.12% 8.34% -2.15% 9.64% 6.97% 0.89% -10.77% 5.73% 2.00% 9.94% 7.83% 2.77% 2.87% 7.71% -1.71% 7.20% 10.56% -7.19% 6.14% 10.05% -3.14% 0.58% 4.51% -3.73% -3.29% -6.61% -2.18% 8.34% -0.57% -11.02% 12.44% -7.11% -0.13% -11.43% 3.02% -3.21% -3.03% 25.49% -3.35% 2.35% -1.81% -7.63% 8.26% -2.71% -0.25% 1.90% 3.73% 12.95% -9.66% -8.23% 8.71% 4.48% -15.33% -10.39% -1.34% -1.66% -12.40% 44.41% -17.68% -29.26% -0.21% -7.08% 16.59% -57.88% 22.83% -14.87% -18.34% 6.95% 31.50% 127.38% -3.85% 20090630 F 20090731 F 20090831 F 20090930 F 20091030 F 20091130 F 20091231 F 20100129 F 20100226 F 20100331 F 20100430 F 20100528 F 20100630 F 20100730 F 20100831 F 20100930 F 20101029 F 20101130 F 20101231 F 20110131 F 20110228 F 20110331 F 20110429 F 20110531 F 20110630 F 20110729 F 20110831 F 20110930 F 20111031 F 20111130 F 20111230 F 20120131 F 20120229 F 20120330 F 20120430 F 20120531 F 20120629 F 20120731 F 20120831 F 20120928 F 20121031 F 20121130 F 20121231 F 20130131 F 20130228 F 20130328 F 20130430 F 20130531 F 20130628 F 20130731 F 20130830 F 20130930 F 20131031 F 20131129 F 20131231 F 20140131 F 20140228 F 20140331 F 20140430 F 20140530 F 20140630 F 20140731 F 20140829 F 20140930 F 20141031 F 20141128 F 20141231 F 20150130 F 20150227 F 20150331 F 20150430 F 20150529 F 20150630 F 20150731 F 20150831 F 20150930 F 20151030 F 20151130 F 20151231 F 20060131 WFC 20060228 WFC 20060331 WFC 20060428 WFC 20060531 WFC 20060630 WFC 20060731 WFC 20060831 WFC FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL FORD MOTOR CO DEL WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW 5.57% 31.80% -5.00% -5.13% -2.91% 27.00% 12.49% 8.40% 8.30% 7.07% 3.58% -9.91% -14.07% 26.69% -11.63% 8.46% 15.44% 12.81% 5.33% -5.00% -5.64% -0.93% 3.76% -3.56% -7.57% -11.46% -8.93% -13.04% 20.79% -9.25% 1.51% 15.89% -0.32% 0.77% -9.18% -6.38% -9.19% -3.65% 1.62% 5.57% 13.69% 2.60% 13.10% 0.77% -2.63% 4.28% 4.26% 15.10% -1.34% 9.76% -4.09% 4.20% 2.02% -0.18% -9.66% -2.24% 2.87% 1.36% 4.33% 1.80% 4.87% -0.55% 2.29% -15.05% -3.89% 11.64% -1.46% -4.13% 11.08% -1.22% -1.18% -3.99% -1.05% -0.20% -6.47% -2.16% 10.24% -3.24% -1.67% -0.75% 3.78% -0.51% 7.55% -2.62% 1.07% 7.84% -3.15% 20060929 WFC 20061031 WFC 20061130 WFC 20061229 WFC 20070131 WFC 20070228 WFC 20070330 WFC 20070430 WFC 20070531 WFC 20070629 WFC 20070731 WFC 20070831 WFC 20070928 WFC 20071031 WFC 20071130 WFC 20071231 WFC 20080131 WFC 20080229 WFC 20080331 WFC 20080430 WFC 20080530 WFC 20080630 WFC 20080731 WFC 20080829 WFC 20080930 WFC 20081031 WFC 20081128 WFC 20081231 WFC 20090130 WFC 20090227 WFC 20090331 WFC 20090430 WFC 20090529 WFC 20090630 WFC 20090731 WFC 20090831 WFC 20090930 WFC 20091030 WFC 20091130 WFC 20091231 WFC 20100129 WFC 20100226 WFC 20100331 WFC 20100430 WFC 20100528 WFC 20100630 WFC 20100730 WFC 20100831 WFC 20100930 WFC 20101029 WFC 20101130 WFC 20101231 WFC 20110131 WFC 20110228 WFC 20110331 WFC 20110429 WFC 20110531 WFC 20110630 WFC 20110729 WFC 20110831 WFC 20110930 WFC 20111031 WFC 20111130 WFC 20111230 WFC 20120131 WFC 20120229 WFC 20120330 WFC 20120430 WFC 20120531 WFC 20120629 WFC 20120731 WFC 20120831 WFC 20120928 WFC 20121031 WFC 20121130 WFC 20121231 WFC 20130131 WFC 20130228 WFC 20130328 WFC 20130430 WFC 20130531 WFC 20130628 WFC 20130731 WFC 20130830 WFC 20130930 WFC 20131031 WFC 20131129 WFC WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW 4.12% 0.30% -2.12% 0.91% 1.80% -3.40% -0.78% 4.24% 1.34% -2.55% -3.98% 9.12% -2.52% -4.52% -3.73% -6.91% 12.89% -13.32% -0.44% 2.23% -6.29% -13.86% 27.45% 1.12% 23.98% -9.27% -14.16% 2.04% -35.89% -34.18% 17.69% 40.52% 27.69% -4.86% 0.82% 12.71% 2.40% -2.34% 2.07% -3.74% 5.34% -3.66% 13.83% 6.39% -13.20% -10.77% 8.32% -14.89% 6.65% 3.76% 4.60% 13.89% 4.61% -0.34% -1.49% -8.20% -2.13% -1.09% -0.43% -6.16% -7.59% 7.42% 0.27% 6.57% 5.99% 7.53% 9.43% -2.12% -3.43% 4.34% 1.11% 1.30% 1.47% -2.43% -1.37% 3.54% 2.63% 0.72% 5.44% 2.68% 7.56% 1.78% 5.40% -4.87% 0.58% 3.32% 3.82% 20131231 WFC 20140131 WFC 20140228 WFC 20140331 WFC 20140430 WFC 20140530 WFC 20140630 WFC 20140731 WFC 20140829 WFC 20140930 WFC 20141031 WFC 20141128 WFC 20141231 WFC 20150130 WFC 20150227 WFC 20150331 WFC 20150430 WFC 20150529 WFC 20150630 WFC 20150731 WFC 20150831 WFC 20150930 WFC 20151030 WFC 20151130 WFC 20151231 WFC 20060131 JPM 20060228 JPM 20060331 JPM 20060428 JPM 20060531 JPM 20060630 JPM 20060731 JPM 20060831 JPM 20060929 JPM 20061031 JPM 20061130 JPM 20061229 JPM 20070131 JPM 20070228 JPM 20070330 JPM 20070430 JPM 20070531 JPM 20070629 JPM 20070731 JPM 20070831 JPM 20070928 JPM 20071031 JPM 20071130 JPM 20071231 JPM 20080131 JPM 20080229 JPM 20080331 JPM 20080430 JPM 20080530 JPM 20080630 JPM 20080731 JPM 20080829 JPM 20080930 JPM 20081031 JPM 20081128 JPM 20081231 JPM 20090130 JPM 20090227 JPM 20090331 JPM 20090430 JPM 20090529 JPM 20090630 JPM 20090731 JPM 20090831 JPM 20090930 JPM 20091030 JPM 20091130 JPM 20091231 JPM 20100129 JPM 20100226 JPM 20100331 JPM 20100430 JPM 20100528 JPM 20100630 JPM 20100730 JPM 20100831 JPM 20100930 JPM 20101029 JPM 20101130 JPM 20101231 JPM 20110131 JPM 20110228 JPM WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW WELLS FARGO & CO NEW JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO 3.13% -0.13% 3.04% 7.15% -0.20% 3.00% 3.51% -3.16% 1.75% 0.84% 2.35% 3.28% 0.62% -5.29% 6.20% -0.71% 1.29% 2.24% 0.50% 2.90% -7.20% -3.71% 5.43% 2.47% -1.34% 1.01% 3.50% 1.22% 9.80% -6.04% -1.50% 9.43% 0.09% 2.85% 1.75% -2.45% 4.36% 6.15% -3.02% -2.04% 8.39% -0.52% -6.52% -8.38% 1.16% 2.92% 3.40% -2.94% -4.32% 9.46% -14.24% 5.66% 11.83% -9.76% -20.21% 19.53% -5.27% 21.33% -10.86% -23.25% -0.41% -17.89% -10.43% 16.32% 24.34% 11.82% -7.56% 13.46% 12.45% 0.83% -4.56% 1.72% -1.93% -6.43% 7.78% 6.62% -4.74% -7.05% -7.50% 10.16% -9.73% 4.68% -1.00% -0.61% 13.42% 6.06% 3.89% 20110331 JPM 20110429 JPM 20110531 JPM 20110630 JPM 20110729 JPM 20110831 JPM 20110930 JPM 20111031 JPM 20111130 JPM 20111230 JPM 20120131 JPM 20120229 JPM 20120330 JPM 20120430 JPM 20120531 JPM 20120629 JPM 20120731 JPM 20120831 JPM 20120928 JPM 20121031 JPM 20121130 JPM 20121231 JPM 20130131 JPM 20130228 JPM 20130328 JPM 20130430 JPM 20130531 JPM 20130628 JPM 20130731 JPM 20130830 JPM 20130930 JPM 20131031 JPM 20131129 JPM 20131231 JPM 20140131 JPM 20140228 JPM 20140331 JPM 20140430 JPM 20140530 JPM 20140630 JPM 20140731 JPM 20140829 JPM 20140930 JPM 20141031 JPM 20141128 JPM 20141231 JPM 20150130 JPM 20150227 JPM 20150331 JPM 20150430 JPM 20150529 JPM 20150630 JPM 20150731 JPM 20150831 JPM 20150930 JPM 20151030 JPM 20151130 JPM 20151231 JPM 20060131 AXP 20060228 AXP 20060331 AXP 20060428 AXP 20060531 AXP 20060630 AXP 20060731 AXP 20060831 AXP 20060929 AXP 20061031 AXP 20061130 AXP 20061229 AXP 20070131 AXP 20070228 AXP 20070330 AXP 20070430 AXP 20070531 AXP 20070629 AXP 20070731 AXP 20070831 AXP 20070928 AXP 20071031 AXP 20071130 AXP 20071231 AXP 20080131 AXP 20080229 AXP 20080331 AXP 20080430 AXP 20080530 AXP JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO JPMORGAN CHASE & CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO -1.26% -0.48% -5.24% -5.32% -0.59% -7.14% -19.81% 16.24% -10.90% 7.36% 12.93% 5.20% 17.18% -5.87% -22.87% 7.78% 1.60% 3.17% 8.99% 3.71% -1.44% 7.03% 7.69% 3.97% -2.98% 3.90% 11.39% -3.30% 6.29% -9.33% 2.30% 0.45% 11.02% 2.20% -4.69% 2.64% 6.85% -7.17% -0.73% 3.69% 0.78% 3.09% 1.33% 1.06% -0.53% 4.02% -12.46% 12.69% -1.14% 5.08% 3.98% 3.01% 1.79% -6.46% -4.88% 6.10% 3.78% -0.97% 2.16% 2.73% -2.47% 2.63% 1.02% -2.10% -1.90% 0.92% 6.74% 3.35% 1.57% 3.32% -3.79% -2.32% -0.83% 7.84% 7.10% -5.85% -4.07% 0.14% 1.28% 2.91% -3.23% -11.80% -5.21% -13.90% 3.36% 10.25% -3.48% 20080630 AXP 20080731 AXP 20080829 AXP 20080930 AXP 20081031 AXP 20081128 AXP 20081231 AXP 20090130 AXP 20090227 AXP 20090331 AXP 20090430 AXP 20090529 AXP 20090630 AXP 20090731 AXP 20090831 AXP 20090930 AXP 20091030 AXP 20091130 AXP 20091231 AXP 20100129 AXP 20100226 AXP 20100331 AXP 20100430 AXP 20100528 AXP 20100630 AXP 20100730 AXP 20100831 AXP 20100930 AXP 20101029 AXP 20101130 AXP 20101231 AXP 20110131 AXP 20110228 AXP 20110331 AXP 20110429 AXP 20110531 AXP 20110630 AXP 20110729 AXP 20110831 AXP 20110930 AXP 20111031 AXP 20111130 AXP 20111230 AXP 20120131 AXP 20120229 AXP 20120330 AXP 20120430 AXP 20120531 AXP 20120629 AXP 20120731 AXP 20120831 AXP 20120928 AXP 20121031 AXP 20121130 AXP 20121231 AXP 20130131 AXP 20130228 AXP 20130328 AXP 20130430 AXP 20130531 AXP 20130628 AXP 20130731 AXP 20130830 AXP 20130930 AXP 20131031 AXP 20131129 AXP 20131231 AXP 20140131 AXP 20140228 AXP 20140331 AXP 20140430 AXP 20140530 AXP 20140630 AXP 20140731 AXP 20140829 AXP 20140930 AXP 20141031 AXP 20141128 AXP 20141231 AXP 20150130 AXP 20150227 AXP 20150331 AXP 20150430 AXP 20150529 AXP 20150630 AXP 20150731 AXP 20150831 AXP AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO -18.73% -0.98% 6.90% -10.71% -21.87% -15.24% -20.42% -8.84% -27.91% 13.02% 86.35% -1.47% -5.75% 21.90% 19.38% 0.77% 2.77% 20.06% -3.13% -6.61% 1.41% 8.51% 11.78% -13.55% 0.03% 12.44% -10.69% 5.42% -0.93% 4.25% -0.69% 1.49% 0.44% 3.74% 8.98% 5.13% 0.54% -3.21% -0.66% -9.68% 13.14% -5.10% -1.81% 6.68% 5.48% 9.40% 4.41% -7.27% 4.26% -0.52% 1.02% -2.47% -1.21% -0.13% 2.83% 2.66% 5.68% 8.54% 1.70% 10.67% -1.25% -1.02% -2.52% 5.02% 8.62% 4.89% 5.75% -6.04% 7.36% -1.37% -2.63% 4.66% 3.68% -6.97% 1.76% -2.24% 3.05% 2.75% 0.67% -12.99% 1.12% -3.93% -0.86% 2.93% -2.15% -2.14% 0.87% 20150930 AXP 20151030 AXP 20151130 AXP 20151231 AXP 20060131 GS 20060228 GS 20060331 GS 20060428 GS 20060531 GS 20060630 GS 20060731 GS 20060831 GS 20060929 GS 20061031 GS 20061130 GS 20061229 GS 20070131 GS 20070228 GS 20070330 GS 20070430 GS 20070531 GS 20070629 GS 20070731 GS 20070831 GS 20070928 GS 20071031 GS 20071130 GS 20071231 GS 20080131 GS 20080229 GS 20080331 GS 20080430 GS 20080530 GS 20080630 GS 20080731 GS 20080829 GS 20080930 GS 20081031 GS 20081128 GS 20081231 GS 20090130 GS 20090227 GS 20090331 GS 20090430 GS 20090529 GS 20090630 GS 20090731 GS 20090831 GS 20090930 GS 20091030 GS 20091130 GS 20091231 GS 20100129 GS 20100226 GS 20100331 GS 20100430 GS 20100528 GS 20100630 GS 20100730 GS 20100831 GS 20100930 GS 20101029 GS 20101130 GS 20101231 GS 20110131 GS 20110228 GS 20110331 GS 20110429 GS 20110531 GS 20110630 GS 20110729 GS 20110831 GS 20110930 GS 20111031 GS 20111130 GS 20111230 GS 20120131 GS 20120229 GS 20120330 GS 20120430 GS 20120531 GS 20120629 GS 20120731 GS 20120831 GS 20120928 GS 20121031 GS 20121130 GS AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO AMERICAN EXPRESS CO GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC -3.38% -0.78% -2.21% -2.92% 10.80% 0.03% 11.09% 2.34% -5.83% -0.34% 1.77% -2.68% 13.80% 12.40% 2.64% 2.34% 6.60% -4.91% 2.42% 5.97% 5.59% -6.10% -12.95% -6.55% 23.14% 14.55% -8.58% -5.11% -7.04% -14.99% -2.50% 15.92% -7.82% -0.86% 5.43% -10.91% -21.94% -27.46% -14.61% 6.84% -4.34% 13.40% 16.40% 21.20% 12.78% 1.99% 10.76% 1.54% 11.42% -7.69% -0.09% -0.48% -11.92% 5.37% 9.13% -14.90% -0.41% -9.00% 14.89% -8.98% 5.59% 11.45% -2.88% 7.70% -2.70% 0.31% -3.16% -4.79% -6.58% -5.43% 1.41% -13.63% -18.65% 15.86% -12.18% -5.66% 23.27% 3.61% 8.02% -7.41% -16.49% 0.17% 5.26% 5.23% 7.53% 7.66% -3.35% 20121231 GS 20130131 GS 20130228 GS 20130328 GS 20130430 GS 20130531 GS 20130628 GS 20130731 GS 20130830 GS 20130930 GS 20131031 GS 20131129 GS 20131231 GS 20140131 GS 20140228 GS 20140331 GS 20140430 GS 20140530 GS 20140630 GS 20140731 GS 20140829 GS 20140930 GS 20141031 GS 20141128 GS 20141231 GS 20150130 GS 20150227 GS 20150331 GS 20150430 GS 20150529 GS 20150630 GS 20150731 GS 20150831 GS 20150930 GS 20151030 GS 20151130 GS 20151231 GS 20060131 GLD 20060228 GLD 20060331 GLD 20060428 GLD 20060531 GLD 20060630 GLD 20060731 GLD 20060831 GLD 20060929 GLD 20061031 GLD 20061130 GLD 20061229 GLD 20070131 GLD 20070228 GLD 20070330 GLD 20070430 GLD 20070531 GLD 20070629 GLD 20070731 GLD 20070831 GLD 20070928 GLD 20071031 GLD 20071130 GLD 20071231 GLD 20080131 GLD 20080229 GLD 20080331 GLD 20080430 GLD 20080530 GLD 20080630 GLD 20080731 GLD 20080829 GLD 20080930 GLD 20081031 GLD 20081128 GLD 20081231 GLD 20090130 GLD 20090227 GLD 20090331 GLD 20090430 GLD 20090529 GLD 20090630 GLD 20090731 GLD 20090831 GLD 20090930 GLD 20091030 GLD 20091130 GLD 20091231 GLD 20100129 GLD 20100226 GLD GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC GOLDMAN SACHS GROUP INC SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST 8.29% 15.91% 1.62% -1.74% -0.73% 11.30% -6.68% 8.45% -6.95% 4.00% 1.68% 5.36% 4.92% -7.41% 1.75% -1.56% -2.46% 0.34% 4.77% 3.24% 3.93% 2.49% 3.50% -0.52% 2.88% -11.05% 10.43% -0.96% 4.50% 5.31% 1.26% -1.78% -7.71% -7.87% 7.91% 1.69% -5.15% 9.93% -1.11% 3.62% 12.03% -1.32% -4.67% 3.15% -1.38% -4.53% 1.29% 6.89% -1.83% 2.56% 2.55% -1.11% 2.05% -2.31% -1.94% 2.37% 1.11% 10.51% 6.95% -1.65% 6.65% 10.84% 5.23% -6.00% -4.16% 0.92% 4.52% -1.44% -9.29% 4.11% -16.14% 12.57% 7.73% 5.54% 1.45% -2.54% -3.33% 10.23% -5.22% 2.38% 0.05% 5.84% 3.72% 12.79% -7.20% -1.26% 3.27% 20100331 GLD 20100430 GLD 20100528 GLD 20100630 GLD 20100730 GLD 20100831 GLD 20100930 GLD 20101029 GLD 20101130 GLD 20101231 GLD 20110131 GLD 20110228 GLD 20110331 GLD 20110429 GLD 20110531 GLD 20110630 GLD 20110729 GLD 20110831 GLD 20110930 GLD 20111031 GLD 20111130 GLD 20111230 GLD 20120131 GLD 20120229 GLD 20120330 GLD 20120430 GLD 20120531 GLD 20120629 GLD 20120731 GLD 20120831 GLD 20120928 GLD 20121031 GLD 20121130 GLD 20121231 GLD 20130131 GLD 20130228 GLD 20130328 GLD 20130430 GLD 20130531 GLD 20130628 GLD 20130731 GLD 20130830 GLD 20130930 GLD 20131031 GLD 20131129 GLD 20131231 GLD 20140131 GLD 20140228 GLD 20140331 GLD 20140430 GLD 20140530 GLD 20140630 GLD 20140731 GLD 20140829 GLD 20140930 GLD 20141031 GLD 20141128 GLD 20141231 GLD 20150130 GLD 20150227 GLD 20150331 GLD 20150430 GLD 20150529 GLD 20150630 GLD 20150731 GLD 20150831 GLD 20150930 GLD 20151030 GLD 20151130 GLD 20151231 GLD SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST SPDR GOLD TRUST -0.44% 5.88% 3.05% 2.35% -5.09% 5.71% 4.78% 3.68% 2.11% 2.44% -6.38% 6.00% 1.60% 8.94% -1.79% -2.43% 8.42% 12.27% -11.06% 5.87% 1.67% -10.66% 11.40% -2.97% -1.32% -0.15% -6.34% 2.35% 0.84% 4.94% 4.67% -2.94% -0.47% -2.43% -0.51% -5.09% 0.96% -7.57% -6.20% -11.06% 7.43% 5.20% -4.78% -0.34% -5.51% -3.79% 3.42% 6.27% -3.14% 0.49% -3.05% 6.32% -3.63% 0.38% -6.18% -3.05% -0.49% 1.31% 8.69% -5.91% -2.15% -0.17% 0.56% -1.52% -6.62% 3.71% -1.80% 2.28% -6.75% -0.45% Financial Management The Sellinger School of Business and Management Loyola University Maryland Exam III - Spring 2016 Name___________________________ This exam must be completed individually. Collaborating with another person for any reason will result in a grade of 0% for this exam. The answer that appears on your scantron form is the answer that will be graded for the multiple choice questions. For the free response question, please use a paperclip and attach your results. Your exam must be hand delivered at the beginning of class on April 28. Late submissions will not be accepted. 1. Which of the following best describes the NPV profile? A. A graph of a project's NPV as a function of possible IRRs. B. A graph of a project's NPV over time. C. A graph of a project's NPV as a function of possible capital costs. D. None of these statements is correct. 2. Compute the payback statistic for Project X and recommend whether the firm should accept or reject the project with the cash flows shown as follows if the appropriate cost of capital is 9 percent and the maximum allowable payback is four years. A. 3.4375 years, accept B. 3.78 years, reject C. 4.4375 years, reject D. 4.78 years, accept 3. Which of the following statements is correct regarding the NPV profile? A. The IRR appears as the intersection of the NPV profile with the x-axis. B. The IRR appears at the crossover point or where the two profiles intersect. C. NPV profiles for independent projects with normal cash flows will intersect. D. All of these statements are correct. 4. A firm is evaluating a potential investment that is expected to generate cash flows of $100 in years 1 through 4 and $400 in years 5 through 7. The initial investment is $750. What is the payback for this investment? A. 4.88 years B. 4.48 years C. 5.88 years D. 5.48 years 1 5. Which of the following is a technique for evaluating capital projects that is particularly useful when firms face time constraints in repaying investors? A. Payback B. Internal rate of return C. Net present value D. Profitability index 6. A disadvantage of the payback statistic is that: A. it does not reflect the time value of money. B. it does not give an indication of the project's riskiness. C. it does not consider cash flows beyond the payback period. D. All of these are disadvantages of payback. 7. Which of these describe groups or pairs of projects where you can accept one but not all? A. Dependent B. Independent C. Mutually exclusive D. Mutually dependent 8. A project has normal cash flows. Its IRR is 15 percent and its cost of capital is 10 percent. Which of the following statements is incorrect? A. The project has only one negative cash flow. B. The project's MIRR is less than 15 percent but greater than 10 percent. C. The project's discounted payback is less than the project's payback. D. The project's NPV > 0. 9. The MIRR statistic is different from the IRR statistic in that: A. the MIRR assumes that the cash inflows can be reinvested at the cost of capital. B. the MIRR assumes that the cash inflows can be reinvested at the IRR. C. the MIRR uses weighted-average dollars. D. the MIRR uses input from the NPV whereas the IRR does not. 10. Suppose your firm is considering investing in a project with the cash flows shown as follows, that the required rate of return on projects of this risk class is 8 percent, and that the maximum allowable payback statistic for the project are 3.5 and 4.5 years, respectively. Use the IRR decision to evaluate this project; should it be accepted or rejected? A. IRR = 16.92 percent; accept the project B. IRR = 7.123 percent; reject the project C. IRR = 18.32 percent; accept the project D. IRR = 7.59 percent; reject the project 2 11. All of the following capital budgeting tools are suitable for non-normal cash flows EXCEPT: A. MIRR. B. profitability index. C. IRR. D. NPV. 12. A project costs $101,000 today and is expected to generate cash flows of $31,000 per year for the next 15 years. At what rate is the NPV equal to zero? A. 30.10 percent B. 29.83 percent C. 22.47 percent D. 31.38 percent 13. Projects A and B are mutually exclusive. Project A costs $20,000 and is expected to generate cash inflows of $7,500 for 4 years. Project B costs $10,000 and is expected to generate a single cash flow in year 4 of $20,000. The cost of capital is 12%. Which project would you accept and why? A. Project B because it has the higher NPV. B. Project B because it has the higher IRR. C. Project A because it has the higher NPV. D. Project A because it has the higher IRR. 14. A capital budgeting technique that generates a decision rule and associated metric for choosing projects based on the total discounted value of their cash flows is referred to as: A. PI. B. IRR. C. NPV. D. MIRR. 15. Which of the following tools is suitable for choosing between mutually exclusive projects? A. NPV B. IRR C. MIRR D. None are suitable 16. Suppose your firm is considering investing in a project with the cash flows shown as follows, that the required rate of return on projects of this risk class is 8 percent, and that the maximum allowable payback statistic for the project are three and a half and four and a half years, respectively. Use the MIRR decision to evaluate this project; should it be accepted or rejected? A. MIRR = 13.59 percent; accept the project B. MIRR = 7.96 percent; reject the project C. MIRR = 7.19 percent; reject the project D. MIRR = 12.58 percent; accept the project 3 17. We accept projects with a positive NPV because it means that: A. we have recovered all our costs. B. we are creating wealth for shareholders. C. the project's expected return exceeds the cost of capital. D. all of these. 18. A project costs $91,000 today and is expected to generate cash flows of $11,000 per year for the next 20 years. The firm has a cost of capital of 8 percent. Should this project be accepted, and why? A. Yes, the project should be accepted since it has a NPV = $15,391.23. B. Yes, the project should be accepted since it has a NPV = $13,610.89. C. Yes, the project should be accepted since it has a NPV = $16,999.62. D. None of these answers is correct. 19. Suppose your firm is considering two independent projects with the cash flows shown as follows. The required rate of return on projects of both of their risk class is 12 percent, and the maximum allowable payback statistic for the projects are two and a half and three years, respectively. Use the NPV decision rule to evaluate these projects; which one(s) should be accepted or rejected? A. Accept both A and B B. Accept neither A nor B C. Accept A, reject B D. Reject A, accept B 20. Which of these statements is true? A. When people purchase a stock, they know exactly what their dollar and percent return are going to be. B. Many people purchase stocks as they find comfort in the certainty for this safe form of investing. C. When people purchase a stock, they know the short-term return, but not the long term return. D. When people purchase a stock, they do not know what their return is going to beeither short term or in the long run. 21. Which of the following is an index that tracks 500 companies, which allows for a great deal of diversification? A. Nasdaq B. Fortune 500 C. S&P 500 D. Wall Street Journal 4 22. Which of these is defined as a combination of investment assets held by an investor? A. Bundle B. Market basket C. Portfolio D. All of these 23. Which of the following is defined as the portion of total risk that is attributable to firm or industry factors and can be reduced through diversification? A. Firm specific risk B. Market risk C. Modern portfolio risk D. Total risk 24. Which of these is the portion of total risk that is attributable to overall economic factors? A. Firm specific risk B. Market risk C. Modern portfolio risk D. Total risk 25. MedTech Corp. stock was $50.95 per share at the end of last year. Since then, it paid a $0.45 per share dividend. The stock price is currently $62.50. If you owned 500 shares of MedTech, what was your percent return? A. 7.20 percent B. 8.83 percent C. 22.67 percent D. 23.55 percent 26. Year to date, Company Y had earned a 10.8 percent return. During the same time period, Company R earned 12.20 percent and Company C earned -1.56 percent. If you have a portfolio made up of 45 percent Y, 35 percent R, and 20 percent C, what is your portfolio return? A. 7.15 percent B. 8.19 percent C. 8.82 percent D. 9.44 percent 27. The standard deviation of the past five monthly returns for K and Company are 4.25 percent, 4.13 percent, -2.05 percent, 3.25 percent, and 7.75 percent. What is the standard deviation? A. 1.40 percent B. 3.37 percent C. 3.53 percent D. 16.83 percent 5 28. The standard deviation of the past five monthly returns for PG Company are 2.75 percent, -0.75 percent, 4.15 percent, 6.29 percent, and 3.84 percent. What is the standard deviation? A. 2.309 percent B. 2.581 percent C. 3.256 percent D. 3.406 percent 29. The following table shows your stock positions at the beginning of the year, the dividends that each stock paid during the year, and the stock prices at the end of the year. What is your portfolio percentage return? A. B. C. D. 3.21 percent 4.06 percent 7.26 percent 8.97 percent 30. The past five monthly returns for K and Company are 2.28 percent, 2.64 percent, -1.05 percent, 4.25 percent, and 9.25 percent. What is the average monthly return? A. 1.45 percent B. 1.62 percent C. 3.47 percent D. 3.89 percent 31. Which of the following is defined as the volatility of an investment, which includes firm specific risk as well as market risk? A. Diversifiable risk B. Market risk C. Standard deviation D. Total risk 32. Rank the following three stocks by their level of total risk, highest to lowest. Rail Haul has an average return of 10 percent and standard deviation of 15 percent. The average return and standard deviation of Idol Staff are 15 percent and 25 percent; and of Poker-R-Us are 12 percent and 35 percent. A. Rail Haul, Poker-R-Us, Idol Staff B. Idol Staff, Poker-R-Us, Rail Haul C. Poker-R-Us, Idol Staff, Rail Haul D. Idol Staff, Rail Haul, Poker-R-Us 6 33. Which of the following is another term for market risk? A. Firm specific risk B. Modern portfolio risk C. Nondiversifiable risk D. Total risk 34. Which statement is true? A. The larger the standard deviation, the lower the total risk. B. The larger the standard deviation, the higher the total risk. C. The larger the standard deviation, the more portfolio risk. D. The standard deviation is not an indication of total risk. 35. Capital structure decisions refer to the: A. dividend yield of the firm's stock. B. blend of equity and debt used by the firm. C. capital gains available on the firm's stock. D. maturity date for the firm's securities. 36. To calculate the present value of a business, the firm's free cash flows should be discounted at the firm's: A. weighted-average cost of capital. B. pre-tax cost of debt. C. aftertax cost of debt. D. cost of equity. 37. The weighted-average cost of capital for a firm with a 65/35 debt/equity split, 8% pre-tax cost of debt, 15% cost of equity, and a 35% tax rate would be: A. 8.63%. B. 9.12%. C. 10.45%. D. 13.80%. 38. A firm has 12,000 shares of common stock outstanding with a book value of $20 per share and a market value of $39. There are 5,000 shares of preferred stock with a book value of $10 and a market value of $26. There is a $400,000 face value bond issue outstanding that is selling at 87% of par. What weight should be placed on the preferred stock when computing the firm's WACC? A. 7.25% B. 13.74% C. 11.48% D. 15.09% 7 39. An increase in which one of the following is most apt to decrease the WACC of a firm that has both debt and equity in its capital structure? A. Firm's beta B. Market rate of return C. Tax rate D. Yield on preferred stock 40. The yield-to-maturity of a firm's bond is 8.5%. The firm has a beta of 1.3 and a tax rate of 34%. The market risk premium is 8.4% and the risk-free rate is 3.8%. What is the firm's WACC if the firm has a capital structure that is 40% debt financed? A. 10.74% B. 11.08% C. 11.61% D. 11.38% 41. If a firm has twice as much equity as debt in its capital structure, then the firm is financed with: A. 75.0% debt. B. 66.7% equity. C. 40.0% debt. D. 33.3% equity. 42. If a company's cost of capital is less than the required return on equity, then the firm: A. is financed with more than 50% debt. B. is perceived to be safe. C. has debt in its capital structure. D. is all equity financed. 43. WACC can be used to determine the value of a firm by discounting the firm's: A. after-tax net profits. B. pretax profits. C. cash inflows. D. free cash flows. 44. Find the required rate of return for equity investors of a firm with a beta of 1.3 when the risk free rate is 5% and the return on the market is 13.6%. A. 11.54% B. 13.08% C. 16.18% D. 18.02% 8 45. XYZ Company issues common stock at a price of $25 a share. The firm expects to pay a dividend of $2.20 a share next year. If the dividend is expected to grow at 2.5% annually, what is XYZ's cost of common equity? A. 6.3% B. 11.3% C. 13.7% D. 8.9% 46. What percentage of value should be allocated to equity in WACC computations for a firm with $50 million in debt selling at 85% of par, $50 million in book value of equity, and $65 million in market value of equity? A. 50.00% B. 54.18% C. 56.55% D. 60.47% 47. Which one of the following changes offers the greatest chance of changing a project's NPV from negative to positive? A. Substituting preferred stock for debt B. Selling the debt at less than par value C. Reducing the risk level of the project D. Decreasing the marginal tax rate Free Response Please format your output and ensure that it is easy to follow. If it is not organized, points will be deducted. Part a 1) Create descriptive statistics for all of your stocks. What are your results telling you about risk and return? Riskiest and least risky? Highest return and lowest return? 2) Create histograms for all of your stocks. 3) What do you think each of your stocks' returns will be between 68%, 95%, and 99.7% of the time? 4) Create a correlation matrix of all of your stocks. What are your results telling you about possible diversification benefits? Which stocks appear to have the most and least benefits of diversification? 5) Find the beta of each stock using the two approaches discussed in class. Then form an equally weighted portfolio and find that portfolio's beta. For your CAPM results, is your beta statistically significant for each stock? Explain the key portions of your regression results for each stock. Part b Using Yahoo Finance, find the average annual dividend growth rate for McCormick & Company (MKC) using the last six years of data (note that you will use the dividends of MKC for 2010 - 2015 and will only have five growth rates despite having six years of dividends in your sample period). 9Step 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