|
|
| Week 2 - Purchase a Portfolio of 10 Common Stocks, 3, Mutual Funds, and 2 ETFs At Beginning of Week 2 |
| Stock Ticker Symbol | Number of Shares | Purchase Price Per Share | Beginning Value Total Investment | Per Share Price End of Week 3 | Per Share Price End of Week 4 | Per Share Price End of Week 5 | Per Share Price End of Week 6 | Estimated Dividends Paid per Share | Ending Value of Total Investment at End of Week 6 |
| MKC | 200 | 65 | $13,000.00 | | | | $68.00 | $0.44 | $13,688.00 | Example |
| | | | $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 |
| Total Portfolio | | | $0.00 | INVEST $100,000 | | | | | $0.00 |
| Week 3 - Purchase a Portfolio of 5 Bonds at Beginning of Week 3 (Note: Assume $1,000 par value for all bonds.) |
| Issuer | Number of Bonds | Coupon Rate & Maturity | Current Price Per Bond | Beginning Value Total Investment | Per Bond Price End of Week 4 | Per Bond Price End of Week 5 | Per Bond Price End of Week 6 | Per Bond Estimated Interest Earned | Ending Value of Total Investment at End of Week 6 |
| Verizon (VZ) | 6 | Sept. 15, 2033 (6.4%) | $1,162.35 | $6,974.10 | | | $1,150.00 | $3.76 | $6,922.56 | Example |
| | | | | $0.00 | | | | | $0.00 |
| | | | | $0.00 | | | | | $0.00 |
| | | | | $0.00 | | | | | $0.00 |
| | | | | $0.00 | | | | | $0.00 |
| | | | | $0.00 | | | | | $0.00 |
| | | | | $0.00 | Invest $100,000 | | | | $0.00 |
| Week 4 - Purchase a Portfolio of 5 Option Contracts At Beginning of Week 4 (Note: Recommend Using CBOE.com for Option Information.) |
| Issuer | Number of Option Contracts (100 Options in a Contract) | Month of Maturity | Call or Put | Ask Price per Option (Use "Ask" Price) | Beginning Value Total Investment | Per Option Premium End of Week 5 | Per Option Premium End of Week 6 | | Ending Value of Total Investment at End of Week 6 |
| DE\14B07\88.0 | 100 | June 2014 | Call | $0.20 | $2,000.00 | | $0.25 | | $2,500.00 | Example |
| | | | | | $0.00 | | | | $0.00 |
| | | | | | $0.00 | | | | $0.00 |
| | | | | | $0.00 | | | | $0.00 |
| | | | | | $0.00 | | | | $0.00 |
| | | | | | $0.00 | | | | $0.00 |
| | | | | | $0.00 | Invest $100,000 | | | $0.00 |
| Week 5 - Purchase a Portfolio of 5 Futures Contracts At Beginning of Week 6 (Note: Recommend Using CME.com for Futures Information.) |
| Commodity, Energy, Equity, Interest Rate, Metals, Weather, etc. | Number of Futures Contracts | Maturity Date | Number of Units in Each (1) Futures Contract (bushels, pounds, units, barrels, etc.) | Price per Unit | Estimated Margin per Contract | Estimated Total Margin for All Contracts | Total Beginning Notional (Face) Value of Contracts | Price per Unit Per Unit End of Week 6 | Total Ending Notional (Face) Value of Contracts |
| Corn | 10 | March 2014 | 5,000 | $4.32 | $2,363.00 | $23,630.00 | $216,000.00 | $4.40 | $220,000.00 | Example |
| | | | | | | $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 |
| | | | | | Invest $100,000 | $0.00 | $0.00 | | $0.00 |
| | | ASSIGNMENTS |
| SITUATION |
| As a professional financial advisor, it is your assignment to create and manage a long-term portfolio for a client. |
| The client wants a diversified portfolio with $100,000 invested in each of the following types of securities: |
| Stocks, Bonds, Options and Futures. |
| WEEK 1 |
| Develop an investment policy statement to guide the portfolio construction and asset management. |
| The investment policy statement must have quantitative objectives for both return and risk. |
| The investment policy statement must be presented to the class in the Week 1 Discussion. |
| WEEK 2 |
| Select 15 stocks for the portfolio and record all required information. |
| Submit Investment Policy statement for evaluation and grading. |
| WEEK 3 |
| Select 5 bonds for the portfolio and record all required information. |
| End of Week - Update price information for the stocks. |
| WEEK 4 |
| Select 5 options for the portfolio and record all required information. |
| End of Week - Update price information for the stocks. |
| End of Week - Update price information for the bonds. |
| WEEK 5 |
| Select 5 futures contracts and record all required information. |
| End of Week - Update price information for the stocks. |
| End of Week - Update price information for the bonds. |
| End of Week - Update price information for the options. |
| WEEK 6 |
| End of Week - Update price information for the stocks. |
| End of Week - Update price information for the bonds. |
| End of Week - Update price information for the options. |
| End of Week - Update price information for the futures. |
| WEEK 7 COMPLETE AND SUBMIT FINAL PORTFOLIO ANALYSIS (ASSIGNED QUESTIONS) |
| Submit final written report. The report must organized and presented using the required subheadings. |
anglia85
portfolio_project_in_excel.xls
