FIN 326 Portfolio project 02
Waqas Ahmed
bader8511.xlsxSummary
| Futures | Common Stocks | Bonds | Mutual Funds/ETF | Cash | Portfolio Balance | ||||||
| S&P 500, sep 2015 | Euro, sep 2015 | Sony corporation | FEDERAL HOME LOAN BANKS | GROYX Mutual Funds | KFYP ETF | ||||||
| 9/21/15 | Monday | $18,000.00 | $2,500.00 | $245,671.38 | $99,966.58 | $49,987.50 | $49,976.08 | $ 33,898.46 | $500,000.00 | ||
| 9/22/15 | Tuesday | $10,250.00 | $1,837.50 | $245,278.62 | $100,056.04 | $49,262.50 | $55,306.72 | $ 33,898.46 | $495,889.84 | ||
| 9/23/15 | Wednesday | $9,375.00 | $2,775.00 | $245,671.38 | $100,145.50 | $49,300.00 | $55,306.72 | $ 33,898.46 | $496,472.06 | ||
| 9/24/15 | Thursday | $6,925.00 | $2,925.00 | $248,813.46 | $100,234.96 | $48,825.00 | $55,306.72 | $ 33,898.46 | $496,928.60 | ||
| 9/25/15 | Friday | $7,025.00 | $2,925.00 | $236,146.95 | $100,324.42 | $48,525.00 | $55,306.72 | $ 33,898.46 | $484,151.55 | ||
| 9/28/15 | Monday | $0.00 | $2,925.00 | $231,826.59 | $100,592.80 | $46,912.50 | $55,306.72 | $ 33,898.46 | $471,462.07 | ||
| 9/29/15 | Tuesday | $600.00 | $3,400.00 | $240,565.50 | $100,682.26 | $46,662.50 | $55,306.72 | $ 33,898.46 | $481,115.44 | ||
| 9/30/15 | Wednesday | $9,150.00 | $2,237.50 | $242,725.68 | $100,771.72 | $47,712.50 | $55,306.72 | $ 33,898.46 | $491,802.58 | ||
| 10/1/15 | Thursday | $11,175.00 | $2,450.00 | $252,937.44 | $100,861.18 | $47,850.00 | $56,604.80 | $ 33,898.46 | $505,776.88 | ||
| 10/2/15 | Friday | $0.00 | $3,012.50 | $260,105.31 | $100,950.64 | $48,487.50 | $54,242.72 | $ 33,898.46 | $500,697.13 | ||
| 10/5/15 | Monday | $0.00 | $2,400.00 | $258,534.27 | $101,219.02 | $49,175.00 | $59,318.00 | $ 36,298.46 | $506,944.75 | ||
| 10/6/15 | Tuesday | $0.00 | $ 0.00 | $262,756.44 | $101,308.48 | $48,500.00 | $59,828.72 | $ 36,298.46 | $508,692.10 | ||
| 10/7/15 | Wednesday | $0.00 | $ 0.00 | $259,417.98 | $101,397.94 | $49,012.50 | $59,828.72 | $ 36,298.46 | $505,955.60 | ||
| 10/8/15 | Thursday | $0.00 | $ 0.00 | $261,185.40 | $101,487.40 | $49,362.50 | $59,828.72 | $ 36,298.46 | $508,162.48 | ||
| 10/9/15 | Friday | $0.00 | $ 0.00 | $262,265.49 | $101,576.86 | $49,462.50 | $59,828.72 | $ 36,298.46 | $509,432.03 | ||
| 10/12/15 | Monday | $0.00 | $ 0.00 | $259,319.79 | $101,845.24 | $49,525.00 | $59,828.72 | $ 36,298.46 | $506,817.21 | ||
| 10/13/15 | Tuesday | $0.00 | $ 0.00 | $255,392.19 | $101,934.70 | $48,950.00 | $59,828.72 | $ 36,298.46 | $502,404.07 | ||
| 10/14/15 | Wednesday | $0.00 | $ 0.00 | $265,014.81 | $102,024.16 | $48,612.50 | $59,828.72 | $ 36,298.46 | $511,778.65 | ||
| 10/15/15 | Thursday | $0.00 | $ 0.00 | $266,880.42 | $102,113.62 | $49,437.50 | $59,828.72 | $ 36,298.46 | $514,558.72 | ||
| 10/16/15 | Friday | $0.00 | $ 0.00 | $269,335.17 | $102,203.08 | $49,587.50 | $59,828.72 | $ 36,298.46 | $517,252.93 | ||
| 10/19/15 | Monday | $0.00 | $ 0.00 | $267,371.37 | $102,471.46 | $49,675.00 | $59,828.72 | $ 36,298.46 | $515,645.01 | ||
| 10/20/15 | Tuesday | $0.00 | $ 0.00 | $275,913.90 | $102,560.92 | $49,550.00 | $59,828.72 | $ 36,298.46 | $524,152.00 | ||
| 10/21/15 | Wednesday | $0.00 | $ 0.00 | $282,198.06 | $102,650.38 | $48,925.00 | $59,828.72 | $ 36,298.46 | $529,900.62 | ||
| 10/22/15 | Thursday | $0.00 | $ 0.00 | $282,787.20 | $102,739.84 | $49,437.50 | $59,828.72 | $ 36,298.46 | $531,091.72 | ||
| 10/23/15 | Friday | $0.00 | $ 0.00 | $0.00 | $102,829.30 | $49,875.00 | $59,828.72 | $ 320,460.32 | $532,993.34 | ||
| 10/26/15 | Monday | $0.00 | $ 0.00 | $ 0.00 | $103,097.68 | $49,900.00 | $59,828.72 | $320,460.32 | $533,286.72 | ||
| 10/27/15 | Tuesday | $0.00 | $ 0.00 | $ 0.00 | $ 249,980.64 | $103,187.14 | $49,575.00 | $59,828.72 | $70,479.68 | $533,051.18 | |
| 10/28/15 | Wednesday | $0.00 | $ 0.00 | $ 0.00 | $ 251,330.88 | $103,276.60 | $50,262.50 | $59,828.72 | $70,479.68 | $535,178.38 | |
| 10/29/15 | Thursday | $0.00 | $ 0.00 | $ 0.00 | $ 248,444.16 | $103,366.06 | $50,050.00 | $59,828.72 | $70,479.68 | $532,168.62 | |
| 10/30/15 | Friday | $0.00 | $ 0.00 | $ 0.00 | $ 245,091.84 | $103,455.52 | $50,175.00 | $65,840.32 | $70,479.68 | $535,042.36 | |
| 11/2/15 | Monday | $0.00 | $ 0.00 | $ 0.00 | $ 247,885.44 | $103,723.90 | $50,812.50 | $67,149.04 | $70,479.68 | $540,050.56 | |
| 11/3/15 | Tuesday | $0.00 | $ 0.00 | $ 0.00 | $ 252,122.40 | $103,813.36 | $50,662.50 | $67,149.04 | $70,479.68 | $544,226.98 | |
| 11/4/15 | Wednesday | $0.00 | $ 0.00 | $ 0.00 | $ 253,286.40 | $103,902.82 | $50,612.50 | $67,149.04 | $70,479.68 | $545,430.44 | |
| 11/5/15 | Thursday | $0.00 | $ 0.00 | $ 0.00 | $ 253,193.28 | $103,992.28 | $50,625.00 | $67,149.04 | $70,479.68 | $545,439.28 | |
| 11/6/15 | Friday | $0.00 | $ 0.00 | $ 0.00 | $ 255,707.52 | $104,081.74 | $50,950.00 | $67,149.04 | $70,479.68 | $548,367.98 | |
| 11/9/15 | Monday | $0.00 | $ 0.00 | $ 0.00 | $ 252,168.96 | $104,350.12 | $50,475.00 | $67,755.52 | $70,479.68 | $545,229.28 | |
| 11/10/15 | Tuesday | $0.00 | $ 0.00 | $ 0.00 | $ 249,142.56 | $104,439.58 | $50,487.50 | $67,755.52 | $70,479.68 | $542,304.84 | |
| 11/11/15 | Wednesday | $0.00 | $ 0.00 | $ 0.00 | $ 249,794.40 | $104,529.04 | $50,200.00 | $67,755.52 | $70,479.68 | $542,758.64 | |
| 11/12/15 | Thursday | $0.00 | $ 0.00 | $ 0.00 | $ 248,257.92 | $104,618.50 | $49,200.00 | $67,755.52 | $70,479.68 | $540,311.62 | |
| 11/13/15 | Friday | $0.00 | $ 0.00 | $ 0.00 | $ 246,023.04 | $104,707.96 | $48,537.50 | $64,680.56 | $70,479.68 | $534,428.74 | |
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 | $600.00 |
| 9/30/15 | Wednesday | 1908.7 | 34.2 | 8550 | $9,150.00 |
| 10/1/15 | Thursday | 1916.8 | 8.1 | 2025 | $11,175.00 |
| 10/2/15 | Friday | 1943.1 | 26.3 | 6575 | $0.00 |
| 10/5/15 | Monday | 1974.7 | 31.6 | 7900 | |
| 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 |
| Sold on 10/5/15 at price 2400.00 | |||||
S_SNE
| SNE | ||||||
| Sony corporation (Consumer Goods - Electronic Equipment) | ||||||
| Beta: 1.67802 | EPS: -0.51 | P/E: N/A | DIV & Yield: N/A | |||
| Market Cap | 30.97B | |||||
| Date | Price | Price change | Dividend Paid | Shares Holding | Ending Balance | |
| 9/21/15 | Monday | $25.46 | $0.00 | 9,819 | $249,991.74 | |
| 9/22/15 | Tuesday | $25.02 | -$0.04 | 9,819 | $245,671.38 | |
| 9/23/15 | Wednesday | $24.98 | $0.04 | 9,819 | $245,278.62 | |
| 9/24/15 | Thursday | $25.02 | $0.32 | 9,819 | $245,671.38 | |
| 9/25/15 | Friday | $25.34 | -$1.29 | 9,819 | $248,813.46 | |
| 9/28/15 | Monday | $ 24.05 | -0.44 | 9,819 | $236,146.95 | |
| 9/29/15 | Tuesday | $ 23.61 | 0.89 | 9,819 | $231,826.59 | |
| 9/30/15 | Wednesday | $ 24.50 | 0.22 | 9,819 | $240,565.50 | |
| 10/1/15 | Thursday | $ 24.72 | 1.04 | 9,819 | $242,725.68 | |
| 10/2/15 | Friday | $ 25.76 | 0.73 | 9,819 | $252,937.44 | |
| 10/05/15 | Monday | $ 26.49 | $ 0.73 | 9,819 | $260,105.31 | |
| 10/6/15 | Tuesday | $ 26.33 | -0.16 | 9,819 | $258,534.27 | |
| 10/7/15 | Wednesday | $ 26.76 | 0.43 | 9,819 | $262,756.44 | |
| 10/8/15 | Thursday | $ 26.42 | -0.34 | 9,819 | $259,417.98 | |
| 10/9/15 | Friday | $ 26.60 | 0.18 | 9,819 | $261,185.40 | |
| 10/12/15 | Monday | $ 26.71 | 0.11 | 9,819 | $262,265.49 | |
| 10/13/15 | Tuesday | $ 26.41 | -0.3 | 9,819 | $259,319.79 | |
| 10/14/15 | Wednesday | $ 26.01 | -0.4 | 9,819 | $255,392.19 | |
| 10/15/15 | Thursday | $ 26.99 | 0.98 | 9,819 | $265,014.81 | |
| 10/16/15 | Friday | $ 27.18 | 0.19 | 9,819 | $266,880.42 | |
| 10/19/15 | Monday | $ 27.43 | 0.25 | 9,819 | $269,335.17 | |
| 10/20/15 | Tuesday | $ 27.23 | -0.2 | 9,819 | $267,371.37 | |
| 10/21/15 | Wednesday | $ 28.10 | 0.87 | 9,819 | $275,913.90 | |
| 10/22/15 | Thursday | $ 28.74 | 0.64 | 9,819 | $282,198.06 | |
| 10/23/15 | Friday | $ 28.80 | 0.06 | 9,819 | $282,787.20 | |
| 10/26/15 | Monday | $ 28.94 | 0.14 | 9,819 | $0.00 | |
| Sold on 10/26/15 at price 284161.86 | ||||||
B_FHLB
| FEDERAL HOME LOAN BANKS | ||||||
| Coupon Rate | 1.38% | Daily Interest Per Share | $9.00 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 | 22-Dec-2014 | |||||
| Fitch Ratings | AAA | |||||
| Coupon Payment | Semi-Annual | |||||
| First Coupon Date | 22-Dec-2010 | |||||
| Close | Shares holding | Holding Days | Accrued Interest | Ending Balance | ||
| 9/21/15 | Monday | $10,057.00 | 9.94 | 0 | $0.00 | $99,966.58 |
| 9/22/15 | Tuesday | $10,057.00 | 9.94 | 1 | $89.46 | $100,056.04 |
| 9/23/15 | Wednesday | $10,057.00 | 9.94 | 2 | $178.92 | $100,145.50 |
| 9/24/15 | Thursday | $10,057.00 | 9.94 | 3 | $268.38 | $100,234.96 |
| 9/25/15 | Friday | $10,057.00 | 9.94 | 4 | $357.84 | $100,324.42 |
| 9/28/15 | Monday | $10,057.00 | 9.94 | 7 | $626.22 | $100,592.80 |
| 9/29/15 | Tuesday | $10,057.00 | 9.94 | 8 | $715.68 | $100,682.26 |
| 9/30/15 | Wednesday | $10,057.00 | 9.94 | 9 | $805.14 | $100,771.72 |
| 10/1/15 | Thursday | $10,057.00 | 9.94 | 10 | $894.60 | $100,861.18 |
| 10/2/15 | Friday | $10,057.00 | 9.94 | 11 | $984.06 | $100,950.64 |
| 10/05/15 | Monday | $10,057.00 | 9.94 | 14 | $1,252.44 | $101,219.02 |
| 10/6/15 | Tuesday | $10,057.00 | 9.94 | 15 | $1,341.90 | $101,308.48 |
| 10/7/15 | Wednesday | $10,057.00 | 9.94 | 16 | $1,431.36 | $101,397.94 |
| 10/8/15 | Thursday | $10,057.00 | 9.94 | 17 | $1,520.82 | $101,487.40 |
| 10/9/15 | Friday | $10,057.00 | 9.94 | 18 | $1,610.28 | $101,576.86 |
| 10/12/15 | Monday | $10,057.00 | 9.94 | 21 | $1,878.66 | $101,845.24 |
| 10/13/15 | Tuesday | $10,057.00 | 9.94 | 22 | $1,968.12 | $101,934.70 |
| 10/14/15 | Wednesday | $10,057.00 | 9.94 | 23 | $2,057.58 | $102,024.16 |
| 10/15/15 | Thursday | $10,057.00 | 9.94 | 24 | $2,147.04 | $102,113.62 |
| 10/16/15 | Friday | $10,057.00 | 9.94 | 25 | $2,236.50 | $102,203.08 |
| 10/19/15 | Monday | $10,057.00 | 9.94 | 28 | $2,504.88 | $102,471.46 |
| 10/20/15 | Tuesday | $10,057.00 | 9.94 | 29 | $2,594.34 | $102,560.92 |
| 10/21/15 | Wednesday | $10,057.00 | 9.94 | 30 | $2,683.80 | $102,650.38 |
| 10/22/15 | Thursday | $10,057.00 | 9.94 | 31 | $2,773.26 | $102,739.84 |
| 10/23/15 | Friday | $10,057.00 | 9.94 | 32 | $2,862.72 | $102,829.30 |
| 10/26/15 | Monday | $10,057.00 | 9.94 | 35 | $3,131.10 | $103,097.68 |
| 10/27/15 | Tuesday | $10,057.00 | 9.94 | 36 | $3,220.56 | $103,187.14 |
| 10/28/15 | Wednesday | $10,057.00 | 9.94 | 37 | $3,310.02 | $103,276.60 |
| 10/29/15 | Thursday | $10,057.00 | 9.94 | 38 | $3,399.48 | $103,366.06 |
| 10/30/15 | Friday | $10,057.00 | 9.94 | 39 | $3,488.94 | $103,455.52 |
| 11/2/15 | Monday | $10,057.00 | 9.94 | 42 | $3,757.32 | $103,723.90 |
| 11/3/15 | Tuesday | $10,057.00 | 9.94 | 43 | $3,846.78 | $103,813.36 |
| 11/4/15 | Wednesday | $10,057.00 | 9.94 | 44 | $3,936.24 | $103,902.82 |
| 11/5/15 | Thursday | $10,057.00 | 9.94 | 45 | $4,025.70 | $103,992.28 |
| 11/6/15 | Friday | $10,057.00 | 9.94 | 46 | $4,115.16 | $104,081.74 |
| 11/9/15 | Monday | $10,057.00 | 9.94 | 49 | $4,383.54 | $104,350.12 |
| 11/10/15 | Tuesday | $10,057.00 | 9.94 | 50 | $4,473.00 | $104,439.58 |
| 11/11/15 | Wednesday | $10,057.00 | 9.94 | 51 | $4,562.46 | $104,529.04 |
| 11/12/15 | Thursday | $10,057.00 | 9.94 | 52 | $4,651.92 | $104,618.50 |
| 11/13/15 | Friday | $10,057.00 | 9.94 | 53 | $4,741.38 | $104,707.96 |
M_GROYX
| GROYX | ||||||
| Pioneer Growth Opportunities Y | ||||||
| The investment seeks growth of capital. The fund invests primarily in equity securities of companies that the fund's investment adviser considers to be reasonably priced or undervalued, with above average growth potential | ||||||
| Morningstar Style Box: | Small Growth | |||||
| Net Assets: | 567.27M | |||||
| Morningstar Rating | *** | |||||
| Annual Report Expense Ratio (net): | 0.76% | |||||
| Front Load: | N/A | |||||
| 12b1 Fee: | 0.00% | |||||
| Annual Holding Turnover: | 137% | |||||
| Date | Price | Price change | Dividend Paid | Shares Holding | Ending Balance | |
| 9/21/15 | Monday | $39.99 | $0.00 | 1,250 | $49,987.50 | |
| 9/22/15 | Tuesday | $39.41 | ($0.58) | 1,250 | $49,262.50 | |
| 9/23/15 | Wednesday | $39.44 | $0.03 | 1,250 | $49,300.00 | |
| 9/24/15 | Thursday | $39.06 | ($0.38) | 1,250 | $48,825.00 | |
| 9/25/15 | Friday | $38.82 | ($0.24) | 1,250 | $48,525.00 | |
| 9/28/15 | Monday | $37.53 | ($1.29) | 1,250 | $46,912.50 | |
| 9/29/15 | Tuesday | $37.33 | ($0.20) | 1,250 | $46,662.50 | |
| 9/30/15 | Wednesday | $38.17 | $0.84 | 1,250 | $47,712.50 | |
| 10/1/15 | Thursday | $38.28 | $0.11 | 1,250 | $47,850.00 | |
| 10/2/15 | Friday | $38.79 | $0.51 | 1,250 | $48,487.50 | |
| 10/05/15 | Monday | $39.34 | $0.55 | 1,250 | $49,175.00 | |
| 10/6/15 | Tuesday | $38.80 | ($0.54) | 1,250 | $48,500.00 | |
| 10/7/15 | Wednesday | $39.21 | $0.41 | 1,250 | $49,012.50 | |
| 10/8/15 | Thursday | $39.49 | $0.28 | 1,250 | $49,362.50 | |
| 10/9/15 | Friday | $39.57 | $0.08 | 1,250 | $49,462.50 | |
| 10/12/15 | Monday | $39.62 | $0.05 | 1,250 | $49,525.00 | |
| 10/13/15 | Tuesday | $39.16 | ($0.46) | 1,250 | $48,950.00 | |
| 10/14/15 | Wednesday | $38.89 | ($0.27) | 1,250 | $48,612.50 | |
| 10/15/15 | Thursday | $39.55 | $0.66 | 1,250 | $49,437.50 | |
| 10/16/15 | Friday | $39.67 | $0.12 | 1,250 | $49,587.50 | |
| 10/19/15 | Monday | $ 39.74 | $0.07 | 1,250 | $49,675.00 | |
| 10/20/15 | Tuesday | $39.64 | ($0.10) | 1,250 | $49,550.00 | |
| 10/21/15 | Wednesday | $39.14 | ($0.50) | 1,250 | $48,925.00 | |
| 10/22/15 | Thursday | $39.55 | $0.41 | 1,250 | $49,437.50 | |
| 10/23/15 | Friday | $39.90 | $0.35 | 1,250 | $49,875.00 | |
| 10/26/15 | Monday | $39.92 | $0.02 | 1,250 | $49,900.00 | |
| 10/27/15 | Tuesday | $39.66 | ($0.26) | 1,250 | $49,575.00 | |
| 10/28/15 | Wednesday | $40.21 | $0.55 | 1,250 | $50,262.50 | |
| 10/29/15 | Thursday | $40.04 | ($0.17) | 1,250 | $50,050.00 | |
| 10/30/15 | Friday | $40.14 | $0.10 | 1,250 | $50,175.00 | |
| 11/2/15 | Monday | $40.65 | $0.51 | 1,250 | $50,812.50 | |
| 11/3/15 | Tuesday | $40.53 | ($0.12) | 1,250 | $50,662.50 | |
| 11/4/15 | Wednesday | $40.49 | ($0.04) | 1,250 | $50,612.50 | |
| 11/5/15 | Thursday | $40.50 | $0.01 | 1,250 | $50,625.00 | |
| 11/6/15 | Friday | $40.76 | $0.26 | 1,250 | $50,950.00 | |
| 11/9/15 | Monday | $40.38 | ($0.38) | 1,250 | $50,475.00 | |
| 11/10/15 | Tuesday | $40.39 | $0.01 | 1,250 | $50,487.50 | |
| 11/11/15 | Wednesday | $40.16 | ($0.23) | 1,250 | $50,200.00 | |
| 11/12/15 | Thursday | $39.36 | ($0.80) | 1,250 | $49,200.00 | |
| 11/13/15 | Friday | $38.83 | ($0.53) | 1,250 | $48,537.50 |
ETF_KFYP
| KFYP | ||||||
| KraneShares CSI New China ETF | ||||||
| The investment seeks to provide investment results that, before fees and expenses, correspond generally to the price and yield performance of CSI Overseas China Five-Year | ||||||
| Category: | China Region | |||||
| Morningstar Style Box: | Large growth | |||||
| Net Assets: | 2.72M | |||||
| Annual Report Expense Ratio (net): | 0.71% | |||||
| Annual Holding Turnover: | 36% | |||||
| Date | Price | Price change | Dividend Paid | Shares Holding | Ending Balance | |
| 9/21/15 | Monday | $46.97 | $0.00 | 1,064 | $49,976.08 | |
| 9/22/15 | Tuesday | $51.98 | $5.01 | 1,064 | $55,306.72 | |
| 9/23/15 | Wednesday | $51.98 | $0.00 | 1,064 | $55,306.72 | |
| 9/24/15 | Thursday | $51.98 | $0.00 | 1,064 | $55,306.72 | |
| 9/25/15 | Friday | $51.98 | $0.00 | 1,064 | $55,306.72 | |
| 9/28/15 | Monday | $51.98 | $0.00 | 1,064 | $55,306.72 | |
| 9/29/15 | Tuesday | $51.98 | $0.00 | 1,064 | $55,306.72 | |
| 9/30/15 | Wednesday | $ 51.98 | $0.00 | 1,064 | $55,306.72 | |
| 10/1/15 | Thursday | $ 53.20 | $1.22 | 1,064 | $56,604.80 | |
| 10/2/15 | Friday | $ 50.98 | ($2.22) | 1,064 | $54,242.72 | |
| 10/05/15 | Monday | $ 55.75 | $4.77 | 1,064 | $59,318.00 | |
| 10/6/15 | Tuesday | $ 56.23 | $0.48 | 1,064 | $59,828.72 | |
| 10/7/15 | Wednesday | $ 56.23 | $0.00 | 1,064 | $59,828.72 | |
| 10/8/15 | Thursday | $ 56.23 | $0.00 | 1,064 | $59,828.72 | |
| 10/9/15 | Friday | $ 56.23 | $0.00 | 1,064 | $59,828.72 | |
| 10/12/15 | Monday | $ 56.23 | $0.00 | 1,064 | $59,828.72 | |
| 10/13/15 | Tuesday | $ 56.23 | $0.00 | 1,064 | $59,828.72 | |
| 10/14/15 | Wednesday | $ 56.23 | $0.00 | 1,064 | $59,828.72 | |
| 10/15/15 | Thursday | $ 56.23 | $0.00 | 1,064 | $59,828.72 | |
| 10/16/15 | Friday | $ 56.23 | $0.00 | 1,064 | $59,828.72 | |
| 10/19/15 | Monday | $ 56.23 | $0.00 | 1,064 | $59,828.72 | |
| 10/20/15 | Tuesday | $ 56.23 | $0.00 | 1,064 | $59,828.72 | |
| 10/21/15 | Wednesday | $ 56.23 | $0.00 | 1,064 | $59,828.72 | |
| 10/22/15 | Thursday | $ 56.23 | $0.00 | 1,064 | $59,828.72 | |
| 10/23/15 | Friday | $ 56.23 | $0.00 | 1,064 | $59,828.72 | |
| 10/26/15 | Monday | $ 56.23 | $0.00 | 1,064 | $59,828.72 | |
| 10/27/15 | Tuesday | $ 56.23 | $0.00 | 1,064 | $59,828.72 | |
| 10/28/15 | Wednesday | $ 56.23 | $0.00 | 1,064 | $59,828.72 | |
| 10/29/15 | Thursday | $ 56.23 | $0.00 | 1,064 | $59,828.72 | |
| 10/30/15 | Friday | $ 61.88 | $5.65 | 1,064 | $65,840.32 | |
| 11/2/15 | Monday | $ 63.11 | $1.23 | 1,064 | $67,149.04 | |
| 11/3/15 | Tuesday | $ 63.11 | $0.00 | 1,064 | $67,149.04 | |
| 11/4/15 | Wednesday | $ 63.11 | $0.00 | 1,064 | $67,149.04 | |
| 11/5/15 | Thursday | $ 63.11 | $0.00 | 1,064 | $67,149.04 | |
| 11/6/15 | Friday | $ 63.11 | $0.00 | 1,064 | $67,149.04 | |
| 11/9/15 | Monday | $ 63.68 | $0.57 | 1,064 | $67,755.52 | |
| 11/10/15 | Tuesday | $ 63.68 | $0.00 | 1,064 | $67,755.52 | |
| 11/11/15 | Wednesday | $ 63.68 | $0.00 | 1,064 | $67,755.52 | |
| 11/12/15 | Thursday | $ 63.68 | $0.00 | 1,064 | $67,755.52 | |
| 11/13/15 | Friday | $ 60.79 | ($2.89) | 1,064 | $64,680.56 |
S_MSFT
| MSFT | ||||||
| Microsoft Corporation | ||||||
| Beta: 1.0731 | EPS: 1.50 | P/E: 35.75 | DIV & Yield: 1.44 (2.73%) | |||
| Market Cap | 429.47B | |||||
| Date | Price | Price change | Dividend Paid | Shares Holding | Ending Balance | |
| 10/27/15 | Tuesday | $ 53.69 | 0 | 4,656 | $249,980.64 | |
| 10/28/15 | Wednesday | $ 53.98 | 0.29 | 4,656 | $251,330.88 | |
| 10/29/15 | Thursday | $ 53.36 | -0.62 | 4,656 | $248,444.16 | |
| 10/30/15 | Friday | $ 52.64 | -0.72 | 4,656 | $245,091.84 | |
| 11/2/15 | Monday | $ 53.24 | 0.6 | 4,656 | $247,885.44 | |
| 11/3/15 | Tuesday | $ 54.15 | 0.91 | 4,656 | $252,122.40 | |
| 11/4/15 | Wednesday | $ 54.40 | 0.25 | 4,656 | $253,286.40 | |
| 11/5/15 | Thursday | $ 54.38 | -0.02 | 4,656 | $253,193.28 | |
| 11/6/15 | Friday | $ 54.92 | 0.54 | 4,656 | $255,707.52 | |
| 11/9/15 | Monday | $ 54.16 | -0.76 | 4,656 | $252,168.96 | |
| 11/10/15 | Tuesday | $ 53.51 | -0.65 | 4,656 | $249,142.56 | |
| 11/11/15 | Wednesday | $ 53.65 | 0.14 | 4,656 | $249,794.40 | |
| 11/12/15 | Thursday | $ 53.32 | -0.33 | 4,656 | $248,257.92 | |
| 11/13/15 | Friday | $ 52.84 | -0.48 | 4,656 | $246,023.04 |
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.008 | 0.992 | ||||
| 9/23/15 | 0.0027397260% | 9/22/15 | 1942.74 | -0.20% | 1.00 | 9/22/15 | 495889.8 | 0.001 | 1.001 | ||||
| 9/24/15 | 0.0027397260% | 9/23/15 | 1938.76 | -0.34% | 1.00 | 9/23/15 | 496472.1 | 0.001 | 1.001 | ||||
| 9/25/15 | 0.0000000000% | 9/24/15 | 1932.24 | -0.05% | 1.00 | 9/24/15 | 496928.6 | -0.026 | 0.974 | ||||
| 9/28/15 | 0.0027397260% | 9/25/15 | 1931.34 | -2.57% | 0.97 | 9/25/15 | 484151.6 | -0.026 | 0.974 | ||||
| 9/29/15 | 0.0027397260% | 9/28/15 | 1881.77 | 0.12% | 1.00 | 9/28/15 | 471462.1 | 0.020 | 1.020 | ||||
| 9/30/15 | 0.0000000000% | 9/29/15 | 1884.09 | 1.91% | 1.02 | 9/29/15 | 481115.4 | 0.022 | 1.022 | ||||
| 10/1/15 | 0.0000000000% | 9/30/15 | 1920.03 | 0.20% | 1.00 | 9/30/15 | 491802.6 | 0.028 | 1.028 | ||||
| 10/2/15 | 0.0000000000% | 10/1/15 | 1923.82 | 1.43% | 1.01 | 10/1/15 | 505776.9 | -0.010 | 0.990 | ||||
| 10/05/15 | 0.0027397260% | 10/2/15 | 1951.36 | 1.83% | 1.02 | 10/2/15 | 500697.1 | 0.012 | 1.012 | ||||
| 10/06/15 | 0.0000000000% | 10/05/15 | 1987.05 | -0.36% | 1.00 | 10/05/15 | 506944.8 | 0.003 | 1.003 | ||||
| 10/07/15 | 0.0000000000% | 10/06/15 | 1979.92 | 0.80% | 1.01 | 10/06/15 | 508692.1 | -0.005 | 0.995 | ||||
| 10/08/15 | 0.0000000000% | 10/07/15 | 1995.83 | 0.88% | 1.01 | 10/07/15 | 505955.6 | 0.004 | 1.004 | ||||
| 10/09/15 | 0.0027397260% | 10/08/15 | 2013.43 | 0.07% | 1.00 | 10/08/15 | 508162.5 | 0.002 | 1.002 | ||||
| 10/13/15 | 0.0027397260% | 10/09/15 | 2014.89 | 0.13% | 1.00 | 10/09/15 | 509432.0 | -0.005 | 0.995 | ||||
| 10/14/15 | 0.0000000000% | 10/12/15 | 2017.46 | -0.68% | 0.99 | 10/12/15 | 506817.2 | -0.009 | 0.991 | ||||
| 10/15/15 | 0.0027397260% | 10/13/15 | 2003.69 | -0.47% | 1.00 | 10/13/15 | 502404.1 | 0.019 | 1.019 | ||||
| 10/16/15 | 0.0027397260% | 10/14/15 | 1994.24 | 1.49% | 1.01 | 10/14/15 | 511778.7 | 0.005 | 1.005 | ||||
| 10/19/15 | 0.0054794521% | 10/15/15 | 2023.86 | 0.46% | 1.00 | 10/15/15 | 514558.7 | 0.005 | 1.005 | ||||
| 10/20/15 | 0.0054794521% | 10/16/15 | 2033.11 | 0.03% | 1.00 | 10/16/15 | 517252.9 | -0.003 | 0.997 | ||||
| 10/21/15 | 0.0027397260% | 10/19/15 | 2033.66 | -0.14% | 1.00 | 10/19/15 | 515645.0 | 0.016 | 1.016 | ||||
| 10/22/15 | 0.0000000000% | 10/20/15 | 2030.77 | -0.58% | 0.99 | 10/20/15 | 524152.0 | 0.011 | 1.011 | ||||
| 10/23/15 | 0.0054794521% | 10/21/15 | 2018.94 | 1.66% | 1.02 | 10/21/15 | 529900.6 | 0.002 | 1.002 | ||||
| 10/26/15 | 0.0027397260% | 10/22/15 | 2052.51 | 1.10% | 1.01 | 10/22/15 | 531091.7 | 0.004 | 1.004 | ||||
| 10/27/15 | 0.0082191781% | 10/23/15 | 2075.15 | -0.19% | 1.00 | 10/23/15 | 532993.3 | 0.001 | 1.001 | ||||
| 10/28/15 | 0.0109589041% | 10/26/15 | 2071.18 | -0.26% | 1.00 | 10/26/15 | 533286.7 | -0.000 | 1.000 | ||||
| 10/29/15 | 0.0191780822% | 10/27/15 | 2065.89 | 1.18% | 1.01 | 10/27/15 | 533051.2 | 0.004 | 1.004 | ||||
| 10/30/15 | 0.0219178082% | 10/28/15 | 2090.35 | -0.04% | 1.00 | 10/28/15 | 535178.4 | -0.006 | 0.994 | ||||
| 11/02/15 | 0.0219178082% | 10/29/15 | 2089.41 | -0.48% | 1.00 | 10/29/15 | 532168.6 | 0.005 | 1.005 | ||||
| 11/03/15 | 0.0164383562% | 10/30/15 | 2079.36 | 1.19% | 1.01 | 10/30/15 | 535042.4 | 0.009 | 1.009 | ||||
| 11/04/15 | 0.0136986301% | 11/02/15 | 2104.05 | 0.27% | 1.00 | 11/02/15 | 540050.6 | 0.008 | 1.008 | ||||
| 11/05/15 | 0.0136986301% | 11/03/15 | 2109.79 | -0.35% | 1.00 | 11/03/15 | 544227.0 | 0.002 | 1.002 | ||||
| 11/06/15 | 0.0219178082% | 11/04/15 | 2102.31 | -0.11% | 1.00 | 11/04/15 | 545430.4 | 0.000 | 1.000 | ||||
| 11/09/15 | 0.0383561644% | 11/05/15 | 2099.93 | -0.03% | 1.00 | 11/05/15 | 545439.3 | 0.005 | 1.005 | ||||
| 11/10/15 | 0.0356164384% | 11/06/15 | 2099.20 | -0.98% | 0.99 | 11/06/15 | 548368.0 | -0.006 | 0.994 | ||||
| 11/12/15 | 0.0383561644% | 11/09/15 | 2078.58 | 0.15% | 1.00 | 11/09/15 | 545229.3 | -0.005 | 0.995 | ||||
| 11/13/15 | 0.0383561644% | 11/10/15 | 2081.72 | -0.32% | 1.00 | 11/10/15 | 542304.8 | 0.001 | 1.001 | ||||
| 11/11/15 | 2075.00 | -1.40% | 0.99 | 11/11/15 | 542758.6 | -0.005 | 0.995 | ||||||
| 11/12/15 | 2045.97 | -1.12% | 0.99 | 11/12/15 | 540311.6 | -0.011 | 0.989 | ||||||
| 11/13/15 | 2023.04 | -100.00% | 0.00 | 11/13/15 | 534428.7 | -1.000 | 0.000 | ||||||
| Arithmetic mean | 0.08% | Arithmetic mean | 0.002 | ||||||||||
| Geometric mean | 0.07% | Geometric mean | 0.001708902 | ||||||||||
| Standard deviation | 0.94% | Standard deviation | 0.0111510901 | ||||||||||
| BETA | 1 | BETA | 0.51 | ||||||||||
| R-squere | 0.19 | ||||||||||||
| 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.18% | 1.12% | 0.51 | 0.189 | 0.1505 | 0.3266% | 0.1332% | |||||||
| 0.0091564528% | |||||||||||||
assest allocation
| Future | Stock | Bond | Cash | Total | |
| Beginning | 20500 | 345634.96 | 99966.58 | 33898.46 | 500000 |
| Ending | 0 | 359241.1 | 104707.96 | 70479.68 | 534428.74 |
