Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Modeling

Authors: Simon Benninga

4th Edition

0262027283, 9780262027281

More Books

Students also viewed these Finance questions

Question

=+9-4 How is activity-based costing useful for pricing decisions?

Answered: 1 week ago