Question
Project Description Construct a portfolio of Stocks and Cash (Excel) using the following information: 1.Initial Capital $50,000 (Equity) 2.Obtain a loan (up to 50% Margin)
Project Description
Construct a portfolio of Stocks and Cash (Excel) using the following information:
1.Initial Capital $50,000 (Equity)
2.Obtain a loan (up to 50% Margin) for 7.0% interest per annum.
3.Entry Date (May 1, 2020) - Closing stock for that day
4.Exit Date (Dec 1, 2020)
5.Maintain Diversification discipline (see below) *
6.Always maintain at least 10% Cash. Cash interest income at 1.5% per annum.
7.Trading stocks at least 5 times during this period (5 initial stock positions need to be replaced during this period)
8.Assume no trading costs or any additional expenses (except interest on the margin loan)
You Spreadsheet should include the following:
1.Initial Transaction Sources and Uses (May 1, 2020)
2.List of stocks (Symbols)
3.Business Description (one line) and Industry categorization for each stock
4.Monthly Cash Flow which will include any dividends, gains and losses on trades, interest payments, interest income of cash balance.
5.Overall monthly performance (including a graph)
6.S&P 500 Index on May 1, Jun 1, Jul 1, Aug 3, Sep 1, Oct 1, Nov 2, Dec 1, 2020 (using closing)
At Value Date calculate the following:
1.Total Portfolio total HPR - both Levered and Unlevered
2.Total Portfolio Standard Deviation of average monthly returns.
3.Portfolio performance as compared (including a graph) to S&P500 index during this period - (Beta Coefficient calculation (manual), Regression Analysis and ANOVA, Correlation between portfolio and S&P500).
4.Sharpe Ratio of both of your portfolio and the S&P Index.
Suggested website to use:http://finance.yahoo.com
*Diversification Discipline:
No less than 10 stocks in the portfolio at all times
Each stock value cannot represent more than 20% of the total portfolio.
Each industry value cannot represent more than 25% of the total portfolio
Across 8 different industry sectors and one of the industry sectors should have at least 2 companies.
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