Construct a portfolio of stocks and cash

Assignment Help Accounting Basics

Reference no: EM131028217

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.

Reference no: EM131028217

Questions Cloud

Use of technology in developing countries-what challenges : What opportunities do you see for the use of technology in developing countries? What challenges? Use specific examples discovered in your readings or research during this course.

What is probability that the series lasts exactly five games : A Model for the World Series Two teams A and B play a series of games until one team wins four games. We assume that the games are played independently and that the probability that A wins any game is p. What is the probability that the series las..

Risky assets such as the stock market : "Young people with little wealth should not invest money in risky assets such as the stock market, because they can't afford to lose what little money they have." Do you agree or disagree with this statement? Why?

Give a recursive definition of the nth odd positive integer : Find a relation R on a set S that is neither Symmetric nor antisymmetric

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) 2. Obtain a loan (up to 50% Margin) for 7.0% interest per annum.

What is its profit as a percent of total revenue : How profitable is the company? What is its total profit? What is its profit as a percent of total revenue? What is its profit as a perent of total assets?

Calculate the number of subsets : Express the set using set- builder notation. Use inequality notation to express the condition x must meet in order to be a member of the set.

Why china and india have able to enjoy remarkable growth : Discuss why China and India have been able to enjoy such remarkable growth. Why has the example of China been so difficult to replicate in other regions of the Third World?

Describe a career in human resource management : How would you describe a career in human resource management? In your opinion, what are necessary qualities that an HR manager should have (qualities, not qualifications), and what would be the most important quality of an HR manager, in your opinion..

User Account

All Pages