Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Retirees Complete Annuity Handbook

Authors: Scot Whiskeyman

1st Edition

8647470052, 979-8647470058

More Books

Students also viewed these Finance questions

Question

You have

Answered: 1 week ago