View the step-by-step solution to:

Project Description Construct a portfolio of Stocks and Cash (Excel) using the following information: Initial Capital $50,000 (Equity) Obtain a loan...

Hey I have this project and I need help in it. If anyone can do it that would be great 

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 (May 2, 2016) 5. Maintain DiversiFcation 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 (Nov 2, 2015) 2. List of stocks (Symbols) 3. Business Description and Industry categorization for each stock 4. Monthly Cash ±low 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, ±eb 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 Coe²cient calculation, Regression Analysis between portfolio and S&P500). Suggested website to use: http://fnance.yahoo.com *DiversiFcation 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 1
Background image of page 1
Across 8 diferent industry sectors and one oF the industry sector should have at least 2 companies. 2
Background image of page 2
Sign up to view the entire interaction

Top Answer

I am supplying the... View the full answer

9249804.xlsx

Initial Capital
Loan Amount
Total Amount
Annual Interest Rate
Start Date
Value Date
Cash %age to be Maintained
Minimum No Of Stock Trading During the Period
Trading Costs $ 50,000.00
$ 40,000.00
$...

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online