Calculate the monthly standard deviation for each stock

Assignment Help Other Subject

Reference no: EM132413561 , Length: word count:2500

Assignment -

Learning Outcomes -

1. Demonstrate a detailed understanding of the main concepts of finance.

2. Use financial ratios to measure and evaluate a firm's liquidity, profitability, market value and asset utilization.

Questions -

1. Summary Table

This table is to be completed after questions 2 & 3 are answered. It is to provide a summary of your findings in one table.

Provide a summary table with all the ratios side by side like the below:

Ratio APPL GOOGL Industry Average S & P Average.

2. Ratio Analysis

Use 5 different ratios/indicators from the ones you learned in class (or others you may have found) to try to compare and explain the two companies (Apple & Google), their market cap and their share price growth/decline. Present answers in a table format.

Ratio APPL GOOGL Ratio Analysis.

3. Cross-sectional Analysis

Below are industry averages. For the ratios, you chose above, compare Apple (Appl), Sector and S&P500 ratios.

Compare the two companies performance against sector and S&P index; provide an overall cross-sectional analysis. Present answers in table format as below: Ratio APPL Industry Average S & P Average Cross-sectional Analysis

4. Dividends and Market cap

Apple has a higher market cap, higher market revenue and pays dividends. Apple's share is selling for USD 174.97 per share (2/March/2019) while Google, does not pay a dividend and is about USD 30billion less in market cap yet selling for USD 1,148.52 per share (2/March/2019). Why is this? Has Apple always paid a dividend? Why? In your explanation, describe the different ways a person can make money purchasing stock and how and why this may differ between the two companies.

For questions 5,6, 7 & 8 Calculations to be submitted via the excel sheet. Ensure only the FINAL answer is on the word document & any justification that is needed for question 8.

5. Calculate the monthly return (% change) of each stock.

6. Calculate the monthly standard deviation for each stock.

7. Calculate the coefficient of variation (CV) for each company.

8. Using the stock valuation models, calculate the stock price that Apple (APPL) should be selling at and determine if it's overvalued, undervalued or selling at the valuation price. Choose a closing price for (APPL) at any date, but you should show a screen shot for that price. Justify the model you will choose and discuss factors that cause the difference between the valuation price and the market price.

9. If you had to invest in only one of the two companies, which company would you pick? There is no right or wrong answer, but you must justify your choice with reference to each stock's ratios (and any other research you may have done) by explaining; you should refer to answers given in previous sections as well:

Your risk tolerance (risk-seeking or risk-averse)

Your investment timeframe (short term or long term)

Your investment goals (do you want to beat an index or reach a certain amount of money?)

Stock's potential in the future. (Growth or Fall)

Personal reasons (justify).

Attachment:- Assignment Files.rar

Reference no: EM132413561

Questions Cloud

State the null and alternate hypothesis : State the null and alternate hypothesis. In the first box, enter the appropriate symbol (like = or ), and in the second box, enter the appropriate value.

Computer-graphics-related paper : What is the general theme of the paper you read? What does the title mean? What are they trying to do? Why are they trying to do it?

What is the probability that the sample mean of dau : An analyst is analyzing data for the past 400 days. What is the probability that the sample mean of DAU is larger than 50,000?

Find the expected value for the number of democrats : He has collected data on 409 persons in three age categories. Is there evidence that age and political affiliation are related?

Calculate the monthly standard deviation for each stock : Calculate the monthly standard deviation for each stock. Calculate coefficient of variation (CV) for each company. Calculate the monthly return of each stock

What is the probability that you will roll doubles : Suppose you have two six-sided dice where each side is equally likely to land face up when rolled.

What is the hypotheses and conclusion : A sample of 60 workers promoted and 6 later resigned. A sample of 50 workers not promoted and 15 resigned. What is the hypotheses and conclusion.

Which types of assessment data beneficial to share : There are a variety of different assessment types used to assess children in early childhood classrooms including screenings, diagnostic assessments.

Null and alternative hypothesis for research : a. What would be the null and alternative hypothesis for this research? b. What is the type I error in general and in this situation?

User Account

All Pages