FIN 326 Portfolio project 03
Waqas Ahmed
abdulaziz_portfoloi.xlsxSummary
| Futures | Common Stocks | Bonds | Mutual Funds/ETF | Cash | Portfolio Balance | ||||||
| S&P 500, sep 2015 | Euro, sep 2015 | McDonald's Corp | Starbucks Corporation | FEDERAL FARM CR BKS | ProFunds UltraChina Service | Direxion Daily Hmbldrs&Supls Bull 3X ETF | |||||
| 9/21/15 | Monday | $18,000.00 | $2,500.00 | $249,938.70 | $99,995.49 | $49,993.65 | $49,971.63 | $29,600.53 | $500,000.00 | ||
| 9/22/15 | Tuesday | $10,250.00 | $1,837.50 | $248,151.60 | $100,081.42 | $48,568.80 | $46,226.50 | $29,600.53 | $484,716.35 | ||
| 9/23/15 | Wednesday | $9,375.00 | $2,775.00 | $248,611.14 | $100,167.36 | $46,648.35 | $47,166.70 | $29,600.53 | $484,344.08 | ||
| 9/24/15 | Thursday | $6,925.00 | $2,925.00 | $248,381.37 | $100,253.29 | $47,082.00 | $45,505.68 | $29,600.53 | $480,672.87 | ||
| 9/25/15 | Friday | $7,025.00 | $2,925.00 | $249,147.27 | $100,339.22 | $46,648.35 | $48,749.37 | $29,600.53 | $484,434.74 | ||
| 9/28/15 | Monday | $0.00 | $2,925.00 | $244,985.88 | $100,597.02 | $44,480.10 | $43,876.00 | $29,600.53 | $466,464.53 | ||
| 9/29/15 | Tuesday | $0.00 | $3,400.00 | $248,866.44 | $100,682.95 | $45,037.65 | $39,237.68 | $29,600.53 | $466,825.25 | ||
| 9/30/15 | Wednesday | $0.00 | $2,237.50 | $251,547.09 | $100,768.89 | $47,577.60 | $39,143.66 | $29,600.53 | $470,875.27 | ||
| 10/1/15 | Thursday | $0.00 | $2,450.00 | $252,185.34 | $100,854.82 | $47,639.55 | $42,732.09 | $29,600.53 | $475,462.33 | ||
| 10/2/15 | Friday | $0.00 | $3,012.50 | $254,763.87 | $100,940.75 | $52,967.25 | $43,061.16 | $29,600.53 | $484,346.06 | ||
| 10/5/15 | Monday | $0.00 | $2,400.00 | $258,287.01 | $101,198.55 | $54,206.25 | $47,354.74 | $29,600.53 | $493,047.08 | ||
| 10/6/15 | Tuesday | $0.00 | $3,450.00 | $260,150.70 | $101,284.48 | $53,524.80 | $45,176.61 | $29,600.53 | $493,187.12 | ||
| 10/7/15 | Wednesday | $0.00 | $3,187.50 | $259,818.81 | $101,370.42 | $55,631.10 | $47,307.73 | $29,600.53 | $496,916.09 | ||
| 10/8/15 | Thursday | $0.00 | $3,450.00 | $262,831.35 | $101,456.35 | $55,816.95 | $47,793.50 | $29,600.53 | $500,948.68 | ||
| 10/9/15 | Friday | $0.00 | $4,612.50 | $262,346.28 | $101,542.28 | $55,755.00 | $49,501.53 | $29,600.53 | $503,358.12 | ||
| 10/12/15 | monday | $0.00 | $0.00 | $263,571.72 | $101,800.08 | $57,117.90 | $49,501.53 | $34,350.53 | $506,341.76 | ||
| 10/13/15 | tuesday | $0.00 | $0.00 | $263,929.14 | $101,886.01 | $56,126.70 | $50,567.09 | $34,350.53 | $506,859.47 | ||
| 10/14/15 | wednesday | $0.00 | $0.00 | $262,499.46 | $101,971.95 | $55,693.05 | $44,972.90 | $34,350.53 | $499,487.89 | ||
| 10/15/15 | thursday | $0.00 | $0.00 | $264,643.98 | $102,057.88 | $59,038.35 | $44,972.90 | $34,350.53 | $505,063.64 | ||
| 10/16/15 | friday | $0.00 | $0.00 | $267,605.46 | $102,143.81 | $60,029.55 | $46,712.27 | $34,350.53 | $510,841.62 | ||
| 10/19/15 | monday | $0.00 | $0.00 | $266,762.97 | $102,401.61 | $60,153.45 | $46,915.98 | $34,350.53 | $510,584.54 | ||
| 10/20/15 | tuesday | $0.00 | $0.00 | $265,103.52 | $102,487.54 | $59,967.60 | $46,915.98 | $34,350.53 | $508,825.17 | ||
| 10/21/15 | wednesday | $0.00 | $0.00 | $261,784.62 | $102,573.48 | $57,427.65 | $50,410.39 | $34,350.53 | $506,546.67 | ||
| 10/22/15 | thursday | $0.00 | $0.00 | $283,051.11 | $102,659.41 | $59,286.15 | $48,608.34 | $34,350.53 | $527,955.54 | ||
| 10/23/15 | friday | $0.00 | $0.00 | $0.00 | $102,745.34 | $61,764.15 | $47,558.45 | $321,772.80 | $533,840.74 | ||
| 10/26/15 | monday | $0.00 | $0.00 | $0.00 | $201,504.00 | $103,003.14 | $62,197.80 | $47,668.14 | $120,268.80 | $534,641.88 | |
| 10/27/15 | tuesday | $0.00 | $0.00 | $0.00 | $200,672.00 | $103,089.07 | $63,003.15 | $44,581.15 | $120,268.80 | $531,614.17 | |
| 10/28/15 | wednesday | $0.00 | $0.00 | $0.00 | $203,232.00 | $103,175.01 | $63,436.80 | $46,712.27 | $120,268.80 | $536,824.88 | |
| 10/29/15 | thursday | $0.00 | $0.00 | $0.00 | $200,000.00 | $103,260.94 | $62,197.80 | $44,017.03 | $120,268.80 | $529,744.57 | |
| 10/30/15 | friday | $0.00 | $0.00 | $0.00 | $200,224.00 | $103,346.87 | $63,932.40 | $45,599.70 | $120,268.80 | $533,371.77 | |
| 11/2/15 | monday | $0.00 | $0.00 | $0.00 | $199,168.00 | $103,604.67 | $65,047.50 | $46,727.94 | $120,268.80 | $534,816.91 | |
| 11/3/15 | tuesday | $0.00 | $0.00 | $0.00 | $200,960.00 | $103,690.60 | $65,419.20 | $47,777.83 | $120,268.80 | $538,116.43 | |
| 11/4/15 | wednesday | $0.00 | $0.00 | $0.00 | $198,272.00 | $103,776.54 | $66,534.30 | $46,539.90 | $120,268.80 | $535,391.54 | |
| 11/5/15 | thursday | $0.00 | $0.00 | $0.00 | $199,296.00 | $103,862.47 | $65,852.85 | $46,539.90 | $120,268.80 | $535,820.02 | |
| 11/6/15 | friday | $0.00 | $0.00 | $0.00 | $198,304.00 | $103,948.40 | $66,286.50 | $46,539.90 | $120,268.80 | $535,347.60 | |
| 11/9/15 | monday | $0.00 | $0.00 | $0.00 | $196,288.00 | $104,206.20 | $63,436.80 | $42,700.75 | $120,268.80 | $526,900.55 | |
| 11/10/15 | tuesday | $0.00 | $0.00 | $0.00 | $198,976.00 | $104,292.14 | $62,445.60 | $42,700.75 | $120,268.80 | $528,683.29 | |
| 11/11/15 | wednesday | $0.00 | $0.00 | $0.00 | $197,984.00 | $104,378.07 | $62,135.85 | $42,700.75 | $120,268.80 | $527,467.47 | |
| 11/12/15 | thursday | $0.00 | $0.00 | $0.00 | $195,424.00 | $104,464.00 | $62,817.30 | $45,552.69 | $120,268.80 | $528,526.79 | |
| 11/13/15 | friday | $0.00 | $0.00 | $0.00 | $191,168.00 | $104,549.93 | $58,604.70 | $44,424.45 | $120,268.80 | $519,015.88 |
Preformance
| Date | daily 3mo US Treasury Yield Curve Rates | S&P500 | Portfolio | ||||||||||
| 9/21/15 | 0.0027397260% | Date | Adj Close | Daily rate of return | 1+R | Date | Adj Close | Daily rate of return | 1+R | ||||
| 9/22/15 | 0.0000000000% | 9/21/15 | 1966.97 | -1.23% | 0.99 | 9/21/15 | 500000.0 | -0.031 | 0.969 | ||||
| 9/23/15 | 0.0027397260% | 9/22/15 | 1942.74 | -0.20% | 1.00 | 9/22/15 | 484716.4 | -0.001 | 0.999 | ||||
| 9/24/15 | 0.0027397260% | 9/23/15 | 1938.76 | -0.34% | 1.00 | 9/23/15 | 484344.1 | -0.008 | 0.992 | ||||
| 9/25/15 | 0.0000000000% | 9/24/15 | 1932.24 | -0.05% | 1.00 | 9/24/15 | 480672.9 | 0.008 | 1.008 | ||||
| 9/28/15 | 0.0027397260% | 9/25/15 | 1931.34 | -2.57% | 0.97 | 9/25/15 | 484434.7 | -0.037 | 0.963 | ||||
| 9/29/15 | 0.0027397260% | 9/28/15 | 1881.77 | 0.12% | 1.00 | 9/28/15 | 466464.5 | 0.001 | 1.001 | ||||
| 9/30/15 | 0.0000000000% | 9/29/15 | 1884.09 | 1.91% | 1.02 | 9/29/15 | 466825.3 | 0.009 | 1.009 | ||||
| 10/1/15 | 0.0000000000% | 9/30/15 | 1920.03 | 0.20% | 1.00 | 9/30/15 | 470875.3 | 0.010 | 1.010 | ||||
| 10/2/15 | 0.0000000000% | 10/1/15 | 1923.82 | 1.43% | 1.01 | 10/1/15 | 475462.3 | 0.019 | 1.019 | ||||
| 10/05/15 | 0.0027397260% | 10/2/15 | 1951.36 | 1.83% | 1.02 | 10/2/15 | 484346.1 | 0.018 | 1.018 | ||||
| 10/06/15 | 0.0000000000% | 10/05/15 | 1987.05 | -0.36% | 1.00 | 10/05/15 | 493047.1 | 0.000 | 1.000 | ||||
| 10/07/15 | 0.0000000000% | 10/06/15 | 1979.92 | 0.80% | 1.01 | 10/06/15 | 493187.1 | 0.008 | 1.008 | ||||
| 10/08/15 | 0.0000000000% | 10/07/15 | 1995.83 | 0.88% | 1.01 | 10/07/15 | 496916.1 | 0.008 | 1.008 | ||||
| 10/09/15 | 0.0027397260% | 10/08/15 | 2013.43 | 0.07% | 1.00 | 10/08/15 | 500948.7 | 0.005 | 1.005 | ||||
| 10/13/15 | 0.0027397260% | 10/09/15 | 2014.89 | 0.13% | 1.00 | 10/09/15 | 503358.1 | 0.006 | 1.006 | ||||
| 10/14/15 | 0.0000000000% | 10/12/15 | 2017.46 | -0.68% | 0.99 | 10/12/15 | 506341.8 | 0.001 | 1.001 | ||||
| 10/15/15 | 0.0027397260% | 10/13/15 | 2003.69 | -0.47% | 1.00 | 10/13/15 | 506859.5 | -0.015 | 0.985 | ||||
| 10/16/15 | 0.0027397260% | 10/14/15 | 1994.24 | 1.49% | 1.01 | 10/14/15 | 499487.9 | 0.011 | 1.011 | ||||
| 10/19/15 | 0.0054794521% | 10/15/15 | 2023.86 | 0.46% | 1.00 | 10/15/15 | 505063.6 | 0.011 | 1.011 | ||||
| 10/20/15 | 0.0054794521% | 10/16/15 | 2033.11 | 0.03% | 1.00 | 10/16/15 | 510841.6 | -0.001 | 0.999 | ||||
| 10/21/15 | 0.0027397260% | 10/19/15 | 2033.66 | -0.14% | 1.00 | 10/19/15 | 510584.5 | -0.003 | 0.997 | ||||
| 10/22/15 | 0.0000000000% | 10/20/15 | 2030.77 | -0.58% | 0.99 | 10/20/15 | 508825.2 | -0.004 | 0.996 | ||||
| 10/23/15 | 0.0054794521% | 10/21/15 | 2018.94 | 1.66% | 1.02 | 10/21/15 | 506546.7 | 0.042 | 1.042 | ||||
| 10/26/15 | 0.0027397260% | 10/22/15 | 2052.51 | 1.10% | 1.01 | 10/22/15 | 527955.5 | 0.011 | 1.011 | ||||
| 10/27/15 | 0.0082191781% | 10/23/15 | 2075.15 | -0.19% | 1.00 | 10/23/15 | 533840.7 | 0.002 | 1.002 | ||||
| 10/28/15 | 0.0109589041% | 10/26/15 | 2071.18 | -0.26% | 1.00 | 10/26/15 | 534641.9 | -0.006 | 0.994 | ||||
| 10/29/15 | 0.0191780822% | 10/27/15 | 2065.89 | 1.18% | 1.01 | 10/27/15 | 531614.2 | 0.010 | 1.010 | ||||
| 10/30/15 | 0.0219178082% | 10/28/15 | 2090.35 | -0.04% | 1.00 | 10/28/15 | 536824.9 | -0.013 | 0.987 | ||||
| 11/02/15 | 0.0219178082% | 10/29/15 | 2089.41 | -0.48% | 1.00 | 10/29/15 | 529744.6 | 0.007 | 1.007 | ||||
| 11/03/15 | 0.0164383562% | 10/30/15 | 2079.36 | 1.19% | 1.01 | 10/30/15 | 533371.8 | 0.003 | 1.003 | ||||
| 11/04/15 | 0.0136986301% | 11/02/15 | 2104.05 | 0.27% | 1.00 | 11/02/15 | 534816.9 | 0.006 | 1.006 | ||||
| 11/05/15 | 0.0136986301% | 11/03/15 | 2109.79 | -0.35% | 1.00 | 11/03/15 | 538116.4 | -0.005 | 0.995 | ||||
| 11/06/15 | 0.0219178082% | 11/04/15 | 2102.31 | -0.11% | 1.00 | 11/04/15 | 535391.5 | 0.001 | 1.001 | ||||
| 11/09/15 | 0.0383561644% | 11/05/15 | 2099.93 | -0.03% | 1.00 | 11/05/15 | 535820.0 | -0.001 | 0.999 | ||||
| 11/10/15 | 0.0356164384% | 11/06/15 | 2099.20 | -0.98% | 0.99 | 11/06/15 | 535347.6 | -0.016 | 0.984 | ||||
| 11/12/15 | 0.0383561644% | 11/09/15 | 2078.58 | 0.15% | 1.00 | 11/09/15 | 526900.6 | 0.003 | 1.003 | ||||
| 11/13/15 | 0.0383561644% | 11/10/15 | 2081.72 | -0.32% | 1.00 | 11/10/15 | 528683.3 | -0.002 | 0.998 | ||||
| 11/11/15 | 2075.00 | -1.40% | 0.99 | 11/11/15 | 527467.5 | 0.002 | 1.002 | ||||||
| 11/12/15 | 2045.97 | -1.12% | 0.99 | 11/12/15 | 528526.8 | -0.018 | 0.982 | ||||||
| 11/13/15 | 2023.04 | -100.00% | 0.00 | 11/13/15 | 519015.9 | -1.000 | 0.000 | ||||||
| Arithmetic mean | 0.08% | Arithmetic mean | 0.001 | ||||||||||
| Geometric mean | 0.07% | Geometric mean | 0.000957545 | ||||||||||
| Standard deviation | 0.94% | Standard deviation | 0.0134155031 | ||||||||||
| BETA | 1 | BETA | 1.15 | ||||||||||
| R-squere | 0.65 | ||||||||||||
| S&P 500 | |||||||||||||
| Portfolio | Average rate of return | Standard deviation | Beta | R-squre | RVAR | RVAL | Jensen's alpha | ||||||
| Risk-free rate | 0.08% | 0.94% | 1 | 0.0713 | 0.0673% | ||||||||
| 0.10% | 1.34% | 1.15 | 0.654 | 0.0711 | 0.0829% | 0.0180% | |||||||
| 0.0091564528% | |||||||||||||
F_S&P 500
| Future: Stock Index | Investment | ||||
| S&P 500 Index (sep Contract) | $18,000 | ||||
| Close | Index Point Change | $ Change | Ending Balance | ||
| 9/21/15 | Monday | 1963.10 | 0 | $0.00 | $18,000.00 |
| 9/22/15 | Tuesday | 1932.10 | -31 | -$7,750.00 | $10,250.00 |
| 9/23/15 | Wednesday | 1928.60 | -3.5 | -$875.00 | $9,375.00 |
| 9/24/15 | Thursday | 1918.80 | -9.8 | -$2,450.00 | $6,925.00 |
| 9/25/15 | Friday | 1919.20 | 0.4 | $100.00 | $7,025.00 |
| 9/28/15 | Monday | 1872.10 | -47.1 | -$11,775.00 | $0.00 |
| 9/29/15 | Tuesday | 1874.5 | 2.4 | 600 | $0.00 |
| 9/30/15 | Wednesday | 1908.7 | 34.2 | 8550 | $0.00 |
| 10/1/15 | Thursday | 1916.8 | 8.1 | 2025 | $0.00 |
| 10/2/15 | Friday | 1943.1 | 26.3 | 6575 | $0.00 |
| 10/5/15 | Monday | 1974.7 | 31.6 | 7900 | $0.00 |
| 10/6/15 | Tuesday | ||||
| 10/7/15 | Wednesday | ||||
| 10/8/15 | Thursday | ||||
| 10/9/15 | Friday | ||||
| 10/12/15 | monday | ||||
| 10/13/15 | tuesday | ||||
| 10/14/15 | wednesday | ||||
| 10/15/15 | thursday | ||||
| 10/16/15 | friday | ||||
| 10/19/15 | monday | ||||
| 10/20/15 | tuesday | ||||
| 10/21/15 | wednesday | ||||
| 10/22/15 | thursday | ||||
| 10/23/15 | friday | ||||
| 10/26/15 | monday | ||||
| 10/27/15 | tuesday | ||||
| 10/28/15 | wednesday | ||||
| 10/29/15 | thursday | ||||
| 10/30/15 | friday | ||||
| 11/2/15 | monday | ||||
| 11/3/15 | tuesday | ||||
| 11/4/15 | wednesday | ||||
| 11/5/15 | thursday | ||||
| 11/6/15 | friday | ||||
| 11/9/15 | monday | ||||
| 11/10/15 | tuesday | ||||
| 11/11/15 | wednesday | ||||
| 11/12/15 | thursday | ||||
| 11/13/15 | friday |
F_Euro
| Future: Foreign Exchange | Investment | ||||
| Euro (sep Contract) | $2,500 | ||||
| Close | Pt Change | Change in $ | Ending Balance | ||
| 9/21/15 | Monday | $ 1.12 | 0 | $0.00 | $2,500.00 |
| 9/22/15 | Tuesday | $ 1.11 | -53 | ($662.50) | $1,837.50 |
| 9/23/15 | Wednesday | $ 1.12 | 75 | $937.50 | $2,775.00 |
| 9/24/15 | Thursday | $ 1.12 | 12 | $150.00 | $2,925.00 |
| 9/25/15 | Friday | $ 1.12 | 0 | $0.00 | $2,925.00 |
| 9/28/15 | Monday | $ 1.12 | 0 | $0.00 | $2,925.00 |
| 9/27/15 | Tuesday | $ 1.13 | 38 | 475 | $3,400.00 |
| 9/28/15 | Wednesday | $ 1.12 | -93 | -1162.5 | $2,237.50 |
| 9/29/15 | Thursday | $ 1.12 | 17 | 212.5 | $2,450.00 |
| 9/30/15 | Friday | $ 1.12 | 45 | 562.5 | $3,012.50 |
| 10/5/15 | Monday | $ 1.12 | -49 | -612.5 | $2,400.00 |
| 10/06/15 | Tuesday | 1.1284 | 84 | $1,050.00 | $3,450.00 |
| 10/07/15 | Wednesday | 1.1263 | -21 | ($262.50) | $3,187.50 |
| 10/08/15 | Thursday | 1.1284 | 21 | $262.50 | $3,450.00 |
| 10/09/15 | Friday | 1.1377 | 93 | $1,162.50 | $4,612.50 |
| 10/12/15 | Monday | 1.1388 | 11 | $137.50 | $4,750.00 |
| Sold in 10/12/15 |
S_MCD
| MCD | ||||||
| McDonald's Corp | ||||||
| Beta: 0.637524 | EPS: 8.65 | P/E: 23.54 | DIV & Yield: 3.40 | |||
| Market Cap | 95.28B | |||||
| Date | Price | Price change | Dividend Paid | Shares Holding | Ending Balance | |
| 9/21/15 | Monday | $97.90 | $0.00 | 2,553 | $249,938.70 | |
| 9/22/15 | Tuesday | $97.20 | $0.18 | 2,553 | $248,151.60 | |
| 9/23/15 | Wednesday | $97.38 | -$0.09 | 2,553 | $248,611.14 | |
| 9/24/15 | Thursday | $97.29 | $0.30 | 2,553 | $248,381.37 | |
| 9/25/15 | Friday | $97.59 | -$1.63 | 2,553 | $249,147.27 | |
| 9/28/15 | Monday | $ 95.96 | 1.52 | 2,553 | $244,985.88 | |
| 9/29/15 | Tuesday | $ 97.48 | 1.05 | 2,553 | $248,866.44 | |
| 9/30/15 | Wednesday | $ 98.53 | 0.25 | 2,553 | $251,547.09 | |
| 10/1/15 | Thursday | $ 98.78 | 1.01 | 2,553 | $252,185.34 | |
| 10/2/15 | Friday | $ 99.79 | 1.38 | 2,553 | $254,763.87 | |
| 10/5/15 | Monday | $ 101.17 | $ 1.38 | 2,553 | $258,287.01 | |
| 10/6/15 | Tuesday | $ 101.90 | $ 0.73 | 2,553 | $260,150.70 | |
| 10/7/15 | Wednesday | $ 101.77 | -$ 0.13 | 2,553 | $259,818.81 | |
| 10/8/15 | Thursday | $ 102.95 | $ 1.18 | 2,553 | $262,831.35 | |
| 10/9/15 | Friday | $ 102.76 | -$ 0.19 | 2,553 | $262,346.28 | |
| 10/12/15 | monday | $ 103.24 | $ 0.48 | 2,553 | $263,571.72 | |
| 10/13/15 | tuesday | $ 103.38 | $ 0.14 | 2,553 | $263,929.14 | |
| 10/14/15 | wednesday | $ 102.82 | -$ 0.56 | 2,553 | $262,499.46 | |
| 10/15/15 | thursday | $ 103.66 | $ 0.84 | 2,553 | $264,643.98 | |
| 10/16/15 | friday | $ 104.82 | $ 1.16 | 2,553 | $267,605.46 | |
| 10/19/15 | monday | $ 104.49 | -$ 0.33 | 2,553 | $266,762.97 | |
| 10/20/15 | tuesday | $ 103.84 | -$ 0.65 | 2,553 | $265,103.52 | |
| 10/21/15 | wednesday | $ 102.54 | -$ 1.30 | 2,553 | $261,784.62 | |
| 10/22/15 | thursday | $ 110.87 | $ 8.33 | 2,553 | $283,051.11 | |
| 10/23/15 | friday | $ 112.59 | $ 1.72 | 2,553 | $287,442.27 | |
| 10/26/15 | monday | $ 0.00 | -$ 112.59 | 0 | $0.00 | |
| 10/27/15 | tuesday | $ 0.00 | $ 0.00 | 0 | $0.00 | |
| 10/28/15 | wednesday | $ 0.00 | $ 0.00 | 0 | $0.00 | |
| 10/29/15 | thursday | $ 0.00 | $ 0.00 | 0 | $0.00 | |
| 10/30/15 | friday | $ 0.00 | $ 0.00 | 0 | $0.00 | |
| 11/2/15 | monday | $ 0.00 | $ 0.00 | 0 | $0.00 | |
| 11/3/15 | tuesday | $ 0.00 | $ 0.00 | 0 | $0.00 | |
| 11/4/15 | wednesday | $ 0.00 | $ 0.00 | 0 | $0.00 | |
| 11/5/15 | thursday | $ 0.00 | $ 0.00 | 0 | $0.00 | |
| 11/6/15 | friday | $ 0.00 | $ 0.00 | 0 | $0.00 | |
| 11/9/15 | monday | $ 0.00 | $ 0.00 | 0 | $0.00 | |
| 11/10/15 | tuesday | $ 0.00 | $ 0.00 | 0 | $0.00 | |
| 11/11/15 | wednesday | $ 0.00 | $ 0.00 | 0 | $0.00 | |
| 11/12/15 | thursday | $ 0.00 | $ 0.00 | 0 | $0.00 | |
| 11/13/15 | friday | $ 0.00 | $ 0.00 | 0 | $0.00 |
SBUX
| SBUX | ||||||
| Starbucks Corporation | ||||||
| Beta: 0.761046 | EPS: 1.82 | P/E: 33.34 | DIV & Yield: 0.80 (1.34%) | |||
| Market Cap | 90.10B | |||||
| Date | Price | Price change | Dividend Paid | Shares Holding | Ending Balance | |
| 10/26/15 | monday | $62.97 | $0.00 | 3200 | $201,504.00 | |
| 10/27/15 | tuesday | $62.71 | $0.80 | 3200 | $200,672.00 | |
| 10/28/15 | wednesday | $63.51 | -$1.01 | 3200 | $203,232.00 | |
| 10/29/15 | thursday | $62.50 | $0.07 | 3200 | $200,000.00 | |
| 10/30/15 | friday | $62.57 | -$0.33 | 3200 | $200,224.00 | |
| 11/2/15 | monday | $62.24 | $0.56 | 3200 | $199,168.00 | |
| 11/3/15 | tuesday | $62.80 | -$0.84 | 3200 | $200,960.00 | |
| 11/4/15 | wednesday | $61.96 | $0.32 | 3200 | $198,272.00 | |
| 11/5/15 | thursday | $62.28 | -$0.31 | 3200 | $199,296.00 | |
| 11/6/15 | friday | $61.97 | -$0.63 | 3200 | $198,304.00 | |
| 11/9/15 | monday | $61.34 | $0.84 | 3200 | $196,288.00 | |
| 11/10/15 | tuesday | $62.18 | -$0.31 | 3200 | $198,976.00 | |
| 11/11/15 | wednesday | $61.87 | -$0.80 | 3200 | $197,984.00 | |
| 11/12/15 | thursday | $61.07 | -$1.33 | 3200 | $195,424.00 | |
| 11/13/15 | friday | $59.74 | -$59.74 | 3200 | $191,168.00 |
B_FFCB
| FEDERAL FARM CR BKS | ||||||
| Coupon Rate | 6.05% | Daily Interest Per Share | $9.27 Windows User: Windows User: Corporate, municipal bonds: 30/360, Note that because we've assumed a 30 day month, any time there is a 31st, no interest accrues. Also at the end of February, its possible to have more than 1 day accrued between the 28th or 29th and March 1. |
|||
| Maturity Date | 21-Mar-2016 | |||||
| Fitch Ratings | AAA | |||||
| Coupon Payment | SEMI-ANNUAL | |||||
| First Coupon Date | 21-Sep-2001 | |||||
| Close | Shares holding | Holding Days | Accrued Interest | Ending Balance | ||
| 9/21/15 | Monday | $10,787.00 | 9.27 | $0.00 | $99,995.49 | |
| 9/22/15 | Tuesday | $10,787.00 | 9.27 | 1 | $85.93 | $100,081.42 |
| 9/23/15 | Wednesday | $10,787.00 | 9.27 | 2 | $171.87 | $100,167.36 |
| 9/24/15 | Thursday | $10,787.00 | 9.27 | 3 | $257.80 | $100,253.29 |
| 9/25/15 | Friday | $10,787.00 | 9.27 | 4 | $343.73 | $100,339.22 |
| 9/28/15 | Monday | $10,787.00 | 9.27 | 7 | $601.53 | $100,597.02 |
| 9/29/15 | Tuesday | $10,787.00 | 9.27 | 8 | $687.46 | $100,682.95 |
| 9/30/15 | Wednesday | $10,787.00 | 9.27 | 9 | $773.40 | $100,768.89 |
| 10/1/15 | Thursday | $10,787.00 | 9.27 | 10 | $859.33 | $100,854.82 |
| 10/2/15 | Friday | $10,787.00 | 9.27 | 11 | $945.26 | $100,940.75 |
| 10/5/15 | Monday | $10,787.00 | 9.27 | 14 | $1,203.06 | $101,198.55 |
| 10/6/15 | Tuesday | $10,787.00 | 9.27 | 15 | $1,288.99 | $101,284.48 |
| 10/7/15 | Wednesday | $10,787.00 | 9.27 | 16 | $1,374.93 | $101,370.42 |
| 10/8/15 | Thursday | $10,787.00 | 9.27 | 17 | $1,460.86 | $101,456.35 |
| 10/9/15 | Friday | $10,787.00 | 9.27 | 18 | $1,546.79 | $101,542.28 |
| 10/12/15 | monday | $10,787.00 | 9.27 | 21 | $1,804.59 | $101,800.08 |
| 10/13/15 | tuesday | $10,787.00 | 9.27 | 22 | $1,890.52 | $101,886.01 |
| 10/14/15 | wednesday | $10,787.00 | 9.27 | 23 | $1,976.46 | $101,971.95 |
| 10/15/15 | thursday | $10,787.00 | 9.27 | 24 | $2,062.39 | $102,057.88 |
| 10/16/15 | friday | $10,787.00 | 9.27 | 25 | $2,148.32 | $102,143.81 |
| 10/19/15 | monday | $10,787.00 | 9.27 | 28 | $2,406.12 | $102,401.61 |
| 10/20/15 | tuesday | $10,787.00 | 9.27 | 29 | $2,492.05 | $102,487.54 |
| 10/21/15 | wednesday | $10,787.00 | 9.27 | 30 | $2,577.99 | $102,573.48 |
| 10/22/15 | thursday | $10,787.00 | 9.27 | 31 | $2,663.92 | $102,659.41 |
| 10/23/15 | friday | $10,787.00 | 9.27 | 32 | $2,749.85 | $102,745.34 |
| 10/26/15 | monday | $10,787.00 | 9.27 | 35 | $3,007.65 | $103,003.14 |
| 10/27/15 | tuesday | $10,787.00 | 9.27 | 36 | $3,093.58 | $103,089.07 |
| 10/28/15 | wednesday | $10,787.00 | 9.27 | 37 | $3,179.52 | $103,175.01 |
| 10/29/15 | thursday | $10,787.00 | 9.27 | 38 | $3,265.45 | $103,260.94 |
| 10/30/15 | friday | $10,787.00 | 9.27 | 39 | $3,351.38 | $103,346.87 |
| 11/2/15 | monday | $10,787.00 | 9.27 | 42 | $3,609.18 | $103,604.67 |
| 11/3/15 | tuesday | $10,787.00 | 9.27 | 43 | $3,695.11 | $103,690.60 |
| 11/4/15 | wednesday | $10,787.00 | 9.27 | 44 | $3,781.05 | $103,776.54 |
| 11/5/15 | thursday | $10,787.00 | 9.27 | 45 | $3,866.98 | $103,862.47 |
| 11/6/15 | friday | $10,787.00 | 9.27 | 46 | $3,952.91 | $103,948.40 |
| 11/9/15 | monday | $10,787.00 | 9.27 | 49 | $4,210.71 | $104,206.20 |
| 11/10/15 | tuesday | $10,787.00 | 9.27 | 50 | $4,296.65 | $104,292.14 |
| 11/11/15 | wednesday | $10,787.00 | 9.27 | 51 | $4,382.58 | $104,378.07 |
| 11/12/15 | thursday | $10,787.00 | 9.27 | 52 | $4,468.51 | $104,464.00 |
| 11/13/15 | friday | $10,787.00 | 9.27 | 53 | $4,554.44 | $104,549.93 |
M_UGPSX
| UGPSX | ||||||
| ProFunds UltraChina Service | ||||||
| The investment seeks daily investment results, before fees and expenses, that correspond to two times (2x) the daily performance of the BNY Mellon China Select ADR® Index | ||||||
| Morningstar Style Box: | Trading-Leveraged Equity | |||||
| Net Assets: | 17.30M | |||||
| Morningstar Rating | * | |||||
| Annual Report Expense Ratio (net): | 2.79% | |||||
| Front Load: | N/A | |||||
| 12b1 Fee: | 1.00% | |||||
| Annual Holding Turnover: | 266% | |||||
| Date | Price | Price change | Dividend Paid | Shares Holding | Ending Balance | |
| 9/21/15 | Monday | $8.07 | $0.00 | 6,195 | $49,993.65 | |
| 9/22/15 | Tuesday | $7.84 | ($0.23) | 6,195 | $48,568.80 | |
| 9/23/15 | Wednesday | $7.53 | ($0.31) | 6,195 | $46,648.35 | |
| 9/24/15 | Thursday | $7.60 | $0.07 | 6,195 | $47,082.00 | |
| 9/25/15 | Friday | $7.53 | ($0.07) | 6,195 | $46,648.35 | |
| 9/28/15 | Monday | $7.18 | ($0.35) | 6,195 | $44,480.10 | |
| 9/29/15 | Tuesday | $7.27 | $0.09 | 6,195 | $45,037.65 | |
| 9/30/15 | Wednesday | $7.68 | $0.41 | 6,195 | $47,577.60 | |
| 10/1/15 | Thursday | $7.69 | $0.01 | 6,195 | $47,639.55 | |
| 10/2/15 | Friday | $8.55 | $0.86 | 6,195 | $52,967.25 | |
| 10/5/15 | Monday | $8.75 | $0.20 | 6,195 | $54,206.25 | |
| 10/6/15 | Tuesday | $8.64 | ($0.11) | 6,195 | $53,524.80 | |
| 10/7/15 | Wednesday | $8.98 | $0.34 | 6,195 | $55,631.10 | |
| 10/8/15 | Thursday | $9.01 | $0.03 | 6,195 | $55,816.95 | |
| 10/9/15 | Friday | $9.00 | ($0.01) | 6,195 | $55,755.00 | |
| 10/12/15 | monday | $9.22 | $0.22 | 6,195 | $57,117.90 | |
| 10/13/15 | tuesday | $9.06 | ($0.16) | 6,195 | $56,126.70 | |
| 10/14/15 | wednesday | $8.99 | ($0.07) | 6,195 | $55,693.05 | |
| 10/15/15 | thursday | $9.53 | $0.54 | 6,195 | $59,038.35 | |
| 10/16/15 | friday | $9.69 | $0.16 | 6,195 | $60,029.55 | |
| 10/19/15 | monday | $9.71 | $0.02 | 6,195 | $60,153.45 | |
| 10/20/15 | tuesday | $9.68 | ($0.03) | 6,195 | $59,967.60 | |
| 10/21/15 | wednesday | $9.27 | ($0.41) | 6,195 | $57,427.65 | |
| 10/22/15 | thursday | $9.57 | $0.30 | 6,195 | $59,286.15 | |
| 10/23/15 | friday | $9.97 | $0.40 | 6,195 | $61,764.15 | |
| 10/26/15 | monday | $10.04 | $0.07 | 6,195 | $62,197.80 | |
| 10/27/15 | tuesday | $10.17 | $0.13 | 6,195 | $63,003.15 | |
| 10/28/15 | wednesday | $10.24 | $0.07 | 6,195 | $63,436.80 | |
| 10/29/15 | thursday | $10.04 | ($0.20) | 6,195 | $62,197.80 | |
| 10/30/15 | friday | $10.32 | $0.28 | 6,195 | $63,932.40 | |
| 11/2/15 | monday | $10.50 | $0.18 | 6,195 | $65,047.50 | |
| 11/3/15 | tuesday | $10.56 | $0.06 | 6,195 | $65,419.20 | |
| 11/4/15 | wednesday | $10.74 | $0.18 | 6,195 | $66,534.30 | |
| 11/5/15 | thursday | $10.63 | ($0.11) | 6,195 | $65,852.85 | |
| 11/6/15 | friday | $10.70 | $0.07 | 6,195 | $66,286.50 | |
| 11/9/15 | monday | $10.24 | ($0.46) | 6,195 | $63,436.80 | |
| 11/10/15 | tuesday | $10.08 | ($0.16) | 6,195 | $62,445.60 | |
| 11/11/15 | wednesday | $10.03 | ($0.05) | 6,195 | $62,135.85 | |
| 11/12/15 | thursday | $10.14 | $0.11 | 6,195 | $62,817.30 | |
| 11/13/15 | friday | $9.46 | ($0.68) | 6,195 | $58,604.70 |
ETF_NAIL
| NAIL | ||||||
| Direxion Daily Hmbldrs&Supls Bull 3X ETF | ||||||
| The investment seeks daily investment results of 300% of the performance of the Dow Jones U.S. Select Home Construction Index | ||||||
| Category: | Trading-Leveraged Equity | |||||
| Morningstar Style Box: | MEDIUM GROWTH | |||||
| Net Assets: | 3.21M | |||||
| Annual Report Expense Ratio (net): | NaN | |||||
| Annual Holding Turnover: | NaN | |||||
| Date | Price | Price change | Dividend Paid | Shares Holding | Ending Balance | |
| 9/21/15 | Monday | $31.89 | $0.00 | 1,567 | $49,971.63 | |
| 9/22/15 | Tuesday | $29.50 | ($2.39) | 1,567 | $46,226.50 | |
| 9/23/15 | Wednesday | $30.10 | $0.60 | 1,567 | $47,166.70 | |
| 9/24/15 | Thursday | $29.04 | ($1.06) | 1,567 | $45,505.68 | |
| 9/25/15 | Friday | $31.11 | $2.07 | 1,567 | $48,749.37 | |
| 9/28/15 | Monday | $28.00 | ($3.11) | 1,567 | $43,876.00 | |
| 9/29/15 | Tuesday | $25.04 | ($2.96) | 1,567 | $39,237.68 | |
| 9/30/15 | Wednesday | $ 24.98 | ($0.06) | 1,567 | $39,143.66 | |
| 10/1/15 | Thursday | $ 27.27 | $2.29 | 1,567 | $42,732.09 | |
| 10/2/15 | Friday | $ 27.48 | $0.21 | 1,567 | $43,061.16 | |
| 10/5/15 | Monday | $ 30.22 | $2.74 | 1,567 | $47,354.74 | |
| 10/6/15 | Tuesday | $ 28.83 | ($1.39) | 1,567 | $45,176.61 | |
| 10/7/15 | Wednesday | $ 30.19 | $1.36 | 1,567 | $47,307.73 | |
| 10/8/15 | Thursday | $ 30.50 | $0.31 | 1,567 | $47,793.50 | |
| 10/9/15 | Friday | $ 31.59 | $1.09 | 1,567 | $49,501.53 | |
| 10/12/15 | monday | $ 31.59 | $0.00 | 1,567 | $49,501.53 | |
| 10/13/15 | tuesday | $ 32.27 | $0.68 | 1,567 | $50,567.09 | |
| 10/14/15 | wednesday | $ 28.70 | ($3.57) | 1,567 | $44,972.90 | |
| 10/15/15 | thursday | $ 28.70 | $0.00 | 1,567 | $44,972.90 | |
| 10/16/15 | friday | $ 29.81 | $1.11 | 1,567 | $46,712.27 | |
| 10/19/15 | monday | $ 29.94 | $0.13 | 1,567 | $46,915.98 | |
| 10/20/15 | tuesday | $ 29.94 | $0.00 | 1,567 | $46,915.98 | |
| 10/21/15 | wednesday | $ 32.17 | $2.23 | 1,567 | $50,410.39 | |
| 10/22/15 | thursday | $ 31.02 | ($1.15) | 1,567 | $48,608.34 | |
| 10/23/15 | friday | $ 30.35 | ($0.67) | 1,567 | $47,558.45 | |
| 10/26/15 | monday | $ 30.42 | $0.07 | 1,567 | $47,668.14 | |
| 10/27/15 | tuesday | $ 28.45 | ($1.97) | 1,567 | $44,581.15 | |
| 10/28/15 | wednesday | $ 29.81 | $1.36 | 1,567 | $46,712.27 | |
| 10/29/15 | thursday | $ 28.09 | ($1.72) | 1,567 | $44,017.03 | |
| 10/30/15 | friday | $ 29.10 | $1.01 | 1,567 | $45,599.70 | |
| 11/2/15 | monday | $ 29.82 | $0.72 | 1,567 | $46,727.94 | |
| 11/3/15 | tuesday | $ 30.49 | $0.67 | 1,567 | $47,777.83 | |
| 11/4/15 | wednesday | $ 29.70 | ($0.79) | 1,567 | $46,539.90 | |
| 11/5/15 | thursday | $ 29.70 | $0.00 | 1,567 | $46,539.90 | |
| 11/6/15 | friday | $ 29.70 | $0.00 | 1,567 | $46,539.90 | |
| 11/9/15 | monday | $ 27.25 | ($2.45) | 1,567 | $42,700.75 | |
| 11/10/15 | tuesday | $ 27.25 | $0.00 | 1,567 | $42,700.75 | |
| 11/11/15 | wednesday | $ 27.25 | $0.00 | 1,567 | $42,700.75 | |
| 11/12/15 | thursday | $ 29.07 | $1.82 | 1,567 | $45,552.69 | |
| 11/13/15 | friday | $ 28.35 | ($0.72) | 1,567 | $44,424.45 |
Sheet1
| Future | Stock | Bond | Cash | Total | |
| Beginning | 20500 | 349903.98 | 99995.49 | 29600.53 | 500000 |
| Ending | 0 | 294197.15 | 104549.9337 | 120268.8 | 519015.88 |
