# Finance

Please see attached file for full question
1. You need to complete the below table by selecting ANY two stocks (except for Microsoft) on Nasdaq and collect the data on Dec 31 each year (or the last trading day in that year):

2. Use the data you have collected to calculate annual returns for Company 1, Company 2, and the Market Index, and then calculate average returns over the five-year period. Give comments on your calculation results. Which stock has a higher return?
3. Calculate the standard deviation of the returns for Company 1, Company 2, and the Market Index. Do you think the standard deviation can reflect the stocks’ risks? And why?
4. Construct a scatter diagram graph that shows Company 1’s and Company 2’s returns on the vertical axis and the Market Index’s returns on the horizontal axis. What’s the relationship between the two stocks from your observation?
5. Estimate or use data to find Company 1’s and Company 2’s betas,  as the slopes of regression lines with stock returns on the vertical axis (y-axis) and market return on the horizontal axis (x-axis). Are these betas consistent with your graph? Do you think beta can reflect the stocks’ risks? And why?
6. You need to determine the risk-free rate.  What will be your approach and why do you select this method? How much the rate will be?
7. What’s the market risk premium? Assume that the market risk premium is 5.5%. What is the expected return on the market? Use the SML equation to calculate the two companies’ required returns.
8. If you formed a portfolio that consisted of 50% Company 1 stock and 50% Company 2 stock, what would be its beta and its required return? How will the portfolio hedge the risk?
9. Suppose an investor wants to include any one of the two stocks that you recommended in his or her portfolio. Stocks A, B, and C are currently in the portfolio, and their betas are 0.869, 1.985, and 1.02, respectively. Recommend a stock from the two stocks you’ve selected to her/him and calculate the new portfolio’s required return if it consists of 25% of the company you’ve recommended, 15% of Stock A, 40% of Stock B, and 20% of Stock C. Give your comments to risk of the new portfolio. Do you recommend it or not? And why?

## Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
\$26
The price is based on these factors:
Number of pages
Urgency
Basic features
• Free title page and bibliography
• Unlimited revisions
• Plagiarism-free guarantee
• Money-back guarantee
On-demand options
• Writer’s samples
• Part-by-part delivery
• Overnight delivery
• Copies of used sources
Paper format
• 275 words per page
• 12 pt Arial/Times New Roman
• Double line spacing
• Any citation style (APA, MLA, Chicago/Turabian, Harvard)

# Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

### Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

### Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

### Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.