Question
Your employer, Stock Fund Managers, has given you a $100 million portfolio to manage. Your mandate is to invest the portfolio in stocks and cash
Your employer, Stock Fund Managers, has given you a $100 million portfolio to manage. Your mandate is to invest the portfolio in stocks and cash (i.e., cash equivalents).
1. Your performance is to be evaluated against a benchmark that consists of a 60% investment in the S&P500 index and 40% in cash. Calculate weekly returns on the benchmark portfolio with these 60-40 weightings.
2. Your portfolio must contain 5 stocks, and cash if you wish to take a position in cash. The stocks must be bought and sold in round lots of 100 shares. No mutual funds or ETFs.
3. You can choose any level of investment in cash, and it can be a long or a short position (borrowing). Assume that the rate of return on cash is 0.01% per week. Thus, if you invest in cash you will earn 0.01% per week on the cash investment; if you borrow money (short position in cash) you will pay 0.01% in interest per week on the amount borrowed.
4. In the second week of class submit your initial portfolio holdings as of the close on Friday of the first week of class, along with a one-page description of the strategy you wish to follow. This will be your Week-0 portfolio. For selecting a strategy, you can use ideas from Malkiels book, Chapter 16 of Reilly and Brown, or any other source. In the initial portfolio holdings report include at least the stock symbol, stock name, number of shares, price per share, dollar investment in each stock and the percent weight of each stock in your portfolio using the preceding Fridays closing prices, and also include the dollar investment in cash and its percent weight. Use an Excel spreadsheet for this initial portfolio holdings report.
5. Rebalance the portfolio once a week, using Fridays closing prices. Assume there are no transactions costs.
6. Keep track of stocks that go ex-dividend, add the dividend received to the cash in your portfolio, and then use the cash to buy stocks if you wish. All trading is done at Fridays close.
7. Each week submit your portfolio holdings, along with a performance summary for the week for your portfolio, the S&P500 index and the benchmark. The performance summary should include returns on the stock component of your portfolio, the cash component of your portfolio, your overall portfolio, the S&P500 index and the benchmark. Develop an Excel spreadsheet to perform these functions.
8. Liquidate your portfolio at the close of trading on the Friday of the eighth week of class. This will be your Week-7 portfolio. The Week-0 through Week-7 portfolio values will give you 7 weeks of portfolio returns. Calculate benchmark returns for the same 7 weeks.
9. Evaluate your portfolios performance using the techniques described in Chapter 25 of Reilly and Brown. Include a performance attribution analysis for the last week only.
10. Submit the written project report in Week 11. With exhibits it should be at most ten pages long, not counting appendices. Use line spacing of one and a half lines, and 12 point type. You can structure the report any way you like; one example: (1) Introduction, (2) Economic environment and market analysis, (3) Industry analysis, (4) Company analysis, (5) Portfolio performance analysis, and (6) Conclusion. Include significant events that had an impact on your portfolio.
WHICH STOCKS SHOULD I CHOOSE? Please help me up until #4.
Step 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