Info
Warning
Danger
/ Homework Answers / Accounting / Question an individual project and each student

Question

Question

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? I am not sure what to do with S&P 500 index?

Solution
5 (1 Ratings )

Solved
Accounting 3 Months Ago 125 Views
This Question has Been Answered!
Premium Content -

Unlimited Access

Explore More than 2 Million+
  • Textbook Solutions
  • Flashcards
  • Homework Answers
  • Documents
Signup for Better Grades!

Ask an Expert

Our Experts can answer your tough homework and study questions
124312 Accounting Questions Answered!
Post a Question

Welcome Back!

ScholarOn has more then 20 Million answers, flashcards & more being added everyday!

or
Forgot?
Login
Don't have an account? Signup

Join ScholarOn

ScholarOn has more then 20 Million answers, flashcards & more being added everyday!

or
Signup
By registering, I agree to the Terms and Privacy Policies
Already have an account? Log in

Verify Your Email

Check your inbox & click on the link to activate your account.

Resend Email
Verification Mail Send Successfully. Please Check Your Email.

Forgot Password

Please enter your registered email to recieve the password reset link.

Send reset link
Already have an account? Log in
Did you know?

ScholarOn has more than 2 Million+ answers, textbook solutions & flashcards. Explore Now!

Let us boost your grade together!