QuestionQuestion

• Select 3 companies from different industrial sectors, e.g. high tech (computers, health), consumer non-durables (food, personal services, retailers), cyclical (mining/metals, forestry, oil & gas), etc. Note that one of the companies will be the subject of your term paper assignment described below. Ensure that you can obtain the minimum of 5 years of monthly pricing data required below.
• Obtain at least 5 years of monthly data on prices (60 months).
• Obtain at least 5 years of monthly data on a broad based market indicator (S&P 500, Russell 3000, Wilshire 5000, etc.; do not use the Dow Jones Industrials Average).
• Calculate the average monthly returns (=average function in Excel) , standard deviation of returns (=stdev function) , and correlations of returns (= correl function) , so you’ll have 4 sets for average returns, standard deviation of returns and 6 correlations -- A&B , A&C, and B&C for the companies and A& Market, B& Market, and C and Market.
• Plot prices of stocks & market indicator all vis-à-vis a beginning value of 100 (time series) [ ( P2/P1) x 100 ]

Solution PreviewSolution Preview

This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.

Companies From Different Industrial Sectors
    $33.00 for this solution

    PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

    Find A Tutor

    View available Finance Tutors

    Get College Homework Help.

    Are you sure you don't want to upload any files?

    Fast tutor response requires as much info as possible.

    Decision:
    Upload a file
    Continue without uploading

    SUBMIT YOUR HOMEWORK
    We couldn't find that subject.
    Please select the best match from the list below.

    We'll send you an email right away. If it's not in your inbox, check your spam folder.

    • 1
    • 2
    • 3
    Live Chats