Find weekly returns on the benchmark portfolio

Assignment Help Financial Management

Reference no: EM131926707

This is an individual project and each student must manage a separate portfolio and submit a separate project report, but feel free to form groups to work together.

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 ETF's.

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 in Week 1, along with a one-page description of the strategy you wish to follow.

For selecting a strategy, you can use ideas from Malkiel's 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 Friday's 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 Friday's 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 Friday's 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.

Can someone please clarify how to go about #7?

Reference no: EM131926707

Questions Cloud

Diabetes mellitus to develop ketoacidosis : What are some triggers that may cause a patient with reasonably well controlled type 1 diabetes mellitus to develop ketoacidosis?

What courses of action are open to an international marketer : What courses of action are open to an international marketer who finds all attractive intermediaries already under contract to competitors?

What can customers do to protect themselves from overbilling : What feature of these businesses creates an incentive to misstate cost accounting data on particular jobs?

Why must a country balance of payments always be balanced : Why must a country's balance of payments always be balanced in theory? What is the difference between the merchandise trade balance (BOT).

Find weekly returns on the benchmark portfolio : Your performance is to be evaluated against a benchmark that consists of a 60% investment in the S&P500 index and 40% in cash.

Environment survive and reproduce : Organisms that are well adapted to their environment survive and reproduce. Those that are not well adapted don't survive and reproduce.

What is service trade : What is service trade? Why is foreign direct investment so much more controversial than foreign portfolio investment? How did this relate to Mexico.

Majority of homeostatic control mechanisms : The majority of homeostatic control mechanisms are extrinsic. Postulate why this would be. Wouldn't local control be more practical?

What were the respective balances of japan doing : While the United States ‘‘suffered'' a current account deficit and a capital account surplus in the 1980s, what were the respective balances of Japan doing?

User Account

All Pages