Reference no: EM131026081
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. Starting Date (Nov 2, 2015)
4. Value Date (May2, 2016)
5. Maintain Diversification discipline*
6. Always maintain at least 10% Cash at all times. 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 (Nov2, 2015)
2. List of stocks (Symbols)
3. Business Description 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 Nov 2, Dec 1, 2015, Jan 4, Feb 1, Mar 1, Apr 1 and May 2, 2016
At Value Date calculate the following:
1. Total Portfolio HPR
2. Total Portfolio Standard Deviation of average returns.
3. Portfolio performance as compared (including a graph) to S&P500 index during this period - (Beta Coefficient calculation, Regression Analysis between portfolio and S&P500).
Suggested website to use: https://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 sector should have at least 2 companies.
|
How does porter''s competitive forces model
: How does Porter's competitive forces model help companies develop competitive strategies using information systems?Define Porter's competitive forces model and explain how it works.
|
|
Management usually adapts certain values
: A company's culture evolves from its core values and its ethical standards. A company's commitment to certain values and belief in proper behavior is the basis upon which a company operates. Management usually adapts certain values and ethical standa..
|
|
Draw the graph and explain it step by step
: Let T be a tree of order at least 4, and let e1, e2, e3 belong E(T^), T^ means Complement of T.
|
|
Establish workplace discrimination based on sexual orientati
: Discuss the factors that make it more difficult to establish workplace discrimination based on sexual orientation as illegal as opposed to discrimination on other factors such as race, color, religion, sex, or national origin.
|
|
Construct a portfolio of stocks and cash
: Construct a portfolio of Stocks and Cash (Excel) using the following information: 1. Initial Capital $50,000 (Equity)
|
|
Write a paper about the drug trade in south america
: Studying the drug trade in South America and how it impacts the US. Include information about each country in South America and how they are dealing with drugs, how it impacts the economy and the culture.
|
|
Find the power loss and efficiency with full load
: The full-load speed is 1750 rpm. Under no-load conditions, the speed is 1797 rpm, and the line current is 6.5A rms at a power factor of 30 percent lagging. Find the power loss and efficiency with full load, the input power with no load, and the sp..
|
|
Discuss the meaning of professionalism
: Professionalism is a word used often with regard to Medical personnal.Complete the following: Answer EACH of the following questions using 2- 3 full sentences.1) discuss the meaning of professionalism.
|
|
How many of each type of plate was served
: The St. Marks community bbq served 250 dinners. a child's plate cost 3.50 and an adult's plate cost 7.00. A total of 1347.50 was collected. how many of each type of plate was served?
|