Question
Please help with setting up excel template and spreadsheet Your employer, Stock Fund Managers, has given you a $100 million portfolio to manage. Your mandate
Please help with setting up excel template and spreadsheet
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). 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. 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.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.02% per week (not 2%). Thus, if you invest in cash you will earn 0.02% per week on the cash investment; if you borrow money (short position in cash) you will pay 0.02% in interest per week on the amount borrowed.
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. 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.
submit 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. You do not need to track individual stock performance.
Please help with excel template and spreadsheet:
Evaluate your portfolios performance Include a performance attribution analysis for the first week only.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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