finance portfolio and report project
Kyh
portfolio_euro3-4.xlsxSummary
| Futures | Common Stocks | Bonds | Mutual Funds/ETF | Cash | Portfolio Balance | |||||
| S&P 500, June 2015 | Euro, June 2015 | Microsoft, Technology, MSFT | Verizon, 6.0%, 4/1/2041, BBB | Treasury Bond 6.125% 15-AUG-2029 | TIAA-CREF Growth & Income Instl, TIGR, Mutual Funds | SPDR S&P China, GXC, ETF | ||||
| 3/30/15 | Monday | $18,000.00 | $2,500.00 | $245,760.00 | $61,135.00 | $29,937.50 | $37,440.00 | $68,192.00 | $37,035.50 | $500,000.00 |
| 3/31/15 | Tuesday | $14,300.00 | $1,500.00 | $243,960.00 | $61,143.33 | $29,940.86 | $37,110.00 | $67,712.00 | $37,035.50 | $492,701.69 |
| 4/1/15 | Wednesday | $12,375.00 | $1,762.50 | $244,320.00 | $61,151.67 | $29,944.21 | $36,942.31 | $68,792.00 | $37,035.50 | $492,323.19 |
| 4/2/15 | Thursday | $241,740.00 | $61,160.00 | $29,785.07 | $37,104.72 | $69,783.12 | $37,035.50 | $476,608.41 | ||
| 4/6/15 | Monday | $249,300.00 | $61,193.33 | $29,754.74 | $37,327.29 | $70,608.08 | $37,035.50 | $485,218.95 | ||
| 4/7/15 | Tuesday |
F_S&P 500
| Future: Stock Index | Investment | ||||
| S&P 500 Index (June Contract) | $18,000 | ||||
| Close | Index Point Change | $ Change | Ending Balance | ||
| 3/30/15 | Monday | 2075.60 | $18,000.00 | ||
| 3/31/15 | Tuesday | 2060.80 | -14.8 | -$3,700.00 | $14,300.00 |
| 4/1/15 | Wednesday | 2053.10 | -7.7 | -$1,925.00 | $12,375.00 |
| 4/2/15 | Thursday | 2059.50 | 6.4 | $1,600.00 | $13,975.00 |
| 4/6/15 | Monday | 2073.20 | 13.7 | $3,425.00 | $17,400.00 |
| 4/7/15 | Tuesday | 2067.80 | -5.4 | -$1,350.00 | $16,050.00 |
F_Euro
| Future: Foreign Exchange | Investment | ||||
| Euro (June Contract) | $2,500 | ||||
| Close | Pt Change | Change in $ | Ending Balance | ||
| 3/30/15 | Monday | 1.0834 | $2,500.00 | ||
| 3/31/15 | Tuesday | 1.0754 | -80 | ($1,000.00) | $1,500.00 |
| 4/1/15 | Wednesday | 1.0775 | 21 | $262.50 | $1,762.50 |
| 4/2/15 | Thursday | 1.0905 | 130 | $1,625.00 | $3,387.50 |
| 4/6/15 | Monday | 1.0987 | 82 | $1,025.00 | $4,412.50 |
| 4/7/15 | Tuesday | 1.0839 | -148 | ($1,850.00) | $2,562.50 |
S_MSFT
| MSFT | ||||||
| Microsoft (Technology - Business Software & Services) | ||||||
| Beta: 0.81 | EPS: 2.48 | P/E: 16.23 | DIV & Yield: 1.24 (3.00%) | |||
| Market Cap | 330.08B | |||||
| Date | Price | Price change | Dividend Paid | Shares Holding | Ending Balance | |
| 3/30/15 | Monday | $40.96 | 6,000 | $245,760.00 | ||
| 3/31/15 | Tuesday | $40.66 | -$0.30 | 6,000 | $243,960.00 | |
| 4/1/15 | Wednesday | $40.72 | $0.06 | 6,000 | $244,320.00 | |
| 4/2/15 | Thursday | $40.29 | -$0.43 | 6,000 | $241,740.00 | |
| 4/6/15 | Monday | $41.55 | $1.26 | 6,000 | $249,300.00 | |
| 4/7/15 | Tuesday | |||||
B_Verizon
| Verizon | ||||||
| Coupon Rate | 6.00% | Daily Interest Per Share | $0.17 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 | 1-Apr-2041 | |||||
| Fitch Ratings | BBB | |||||
| Coupon Payment | Semi-Annual | |||||
| First Coupon Date | 1-Oct-2011 | |||||
| Close | Shares holding | Holding Days | Accrued Interest | Ending Balance | ||
| 3/30/15 | Monday | $1,222.70 | 50 | $61,135.00 | ||
| 3/31/15 | Tuesday | $1,222.70 | 50 | 1 | $8.33 | $61,143.33 |
| 4/1/15 | Wednesday | $1,222.70 | 50 | 2 | $16.67 | $61,151.67 |
| 4/2/15 | Thursday | $1,222.70 | 50 | 3 | $25.00 | $61,160.00 |
| 4/6/15 | Monday | $1,222.70 | 50 | 7 | $58.33 | $61,193.33 |
| 4/7/15 | Tuesday | $1,222.70 | 50 | 8 | $66.67 | $61,201.67 |
Treasury Bond
| Treasury Bond 6.125% 15-AUG-2029 | ||||||
| Coupon Rate | 6.125% | Daily Interest Per Share | $0.17 Windows User: Windows User: Based on calendar day |
|||
| Maturity Date | 15-Aug-2029 | |||||
| Coupon Payment | Semi-Annual | |||||
| First Coupon Date | 15-Feb-2000 | |||||
| Close Windows User: Windows User: https://www.treasurydirect.gov/GA-FI/FedInvest/selectSecurityPriceDate.htm | Shares holding | Holding Days | Accrued Interest | Ending Balance | ||
| 3/30/15 | Monday | $1,485.31 | 20 | 0 | $0.00 | $29,937.50 |
| 3/31/15 | Tuesday | $1,496.88 | 20 | 1 | $3.36 | $29,940.86 |
| 4/1/15 | Wednesday | $1,496.88 | 20 | 2 | $6.71 | $29,944.21 |
| 4/2/15 | Thursday | $1,488.75 | 20 | 3 | $10.07 | $29,785.07 |
| 4/6/15 | Monday | $1,486.56 | 20 | 7 | $23.49 | $29,754.74 |
| 4/7/15 | Tuesday |
M_TIGRX
| TIGRX | ||||||
| TIAA-CREF Growth & Income Instl (Mutual Funds) | ||||||
| The investment seeks a favorable long-term total return, through both capital appreciation and investment income, primarily from income-producing equity securities. | ||||||
| Morningstar Style Box: | Large Growth | |||||
| Net Assets: | 4.98B | |||||
| Morningstar Rating | **** | |||||
| Annual Report Expense Ratio (net): | 0.44% | |||||
| Front Load: | 0.00% | |||||
| 12b1 Fee: | 0.00% | |||||
| Annual Holding Turnover: | 98% | |||||
| Date | Price | Price change | Dividend Paid | Shares Holding | Ending Balance | |
| 3/30/15 | Monday | $12.48 | 3,000 | $37,440.00 | ||
| 3/31/15 | Tuesday | $12.37 | ($0.11) | 3,000 | $37,110.00 | |
| 4/1/15 | Wednesday | $12.31 | ($0.06) | 3,001 | $36,942.31 | |
| 4/2/15 | Thursday | $12.36 | $0.05 | 3,002 | $37,104.72 | |
| 4/6/15 | Monday | $12.43 | $0.07 | 3,003 | $37,327.29 | |
| 4/7/15 | Tuesday |
ETF_GXC
| GXC | ||||||
| SPDR S&P China (ETF) | ||||||
| The fund employs a sampling strategy in seeking to track the performance of the S&P China BMI Index | ||||||
| Category: | China Region | |||||
| Morningstar Style Box: | Large Blend | |||||
| Net Assets: | 1.12B | |||||
| Annual Report Expense Ratio (net): | 0.59% | |||||
| Annual Holding Turnover: | 10% | |||||
| Date | Price | Price change | Dividend Paid | Shares Holding | Ending Balance | |
| 3/30/15 | Monday | $85.24 | 800 | $68,192.00 | ||
| 3/31/15 | Tuesday | $84.64 | ($0.60) | 800 | $67,712.00 | |
| 4/1/15 | Wednesday | $85.99 | $1.35 | 800 | $68,792.00 | |
| 4/2/15 | Thursday | $87.12 | $1.13 | 801 | $69,783.12 | |
| 4/6/15 | Monday | $88.04 | $0.92 | 802 | $70,608.08 | |
| 4/7/15 | Tuesday | |||||
