Compute daily stock returns for three stocks

Assignment Help Finance Basics
Reference no: EM133004153

1) Download daily prices for three stocks: TSLA, AMZN, NVDA (Jan 1, 2021 - Jun 30, 2021) from Bloomberg.

2) Compute daily stock returns for three stocks.

3) Calculate the respective averages standard deviations for daily stock returns.

4) Generate a covariance matrix with three daily stock returns using Data Analysis Toolpak

5) Compute an equal-weighted (33.3%: TSLA, 33.3%: AMZN, 33.3%: NVDA) portfolio return and risk (Hint: Use MMULT function in Excel)

Reference no: EM133004153

Questions Cloud

Compute the expected return on investment : Compute the expected return on an investment in Target stock for the coming year. [Show answer to 2-decimal places xx.xx]
What is the current yield on bond : 1-Muscat Company has a bond with a par value of $1,000 and a 7% annual coupon interest rate. The bond has nine years remaining to the maturity date, and the req
Question on binomial lattice : Choose a lattice specification (e.g., Cox, Rubinstein, and Ross, or Jarrow and Rudd) to implement a binomial model to value European Call and Put options. Provi
What is the firm net income after taxes : For its most recent fiscal year, Blossom Hobby Shop recorded EBITDA of $512,725.00, EBIT of $362,450.20, zero interest expense, and cash flow to investors from
Compute daily stock returns for three stocks : 1) Download daily prices for three stocks: TSLA, AMZN, NVDA (Jan 1, 2021 - Jun 30, 2021) from Bloomberg.
What is the annual cost in the percentage of financing : Amcor Limited, an Australian company, can issue three years Swiss franc-denominated bonds with a coupon rate of 3.02 per cent. Assuming that Amcor can issue bon
Compute the project npv : A new product is being considered for market. An outlay of $16M is required for equipment and $4M for additional net working capital. Management expects the pro
Determining the value of money : 1. José López has $ 15,000 in a 6-year certificate of deposit (CD) that pays a guaranteed annual rate of 4%. Make a timeline showing when the cash flows will oc
Implications of the deviations from purchasing power parity : 1. Discuss the implications of the deviations from purchasing power parity for coun- tries' competitive positions in the world market.

Reviews

Write a Review

Finance Basics Questions & Answers

  What is the expected return on the company shares

What is the expected return on the company's shares if the risk-free rate is 3% and the market return is 12%?

  Evaluate the nut tax

In recent years, farmers in China have been protesting their tax treatment by the government They have many complaints, including a fee that "is collected.

  A cost reduction project for business

A cost reduction project for your business

  Calculate the split-adjusted returns

Compute the covariance and correlation coefficient between IBM and Kellogg (previous two questions). Are there any advantages to diversifying between IBM.

  Significant elections in american history

One of the most significant elections in American history is that of 1860. For one thing the southern response to the Republican presidential victory was secess

  What has happened to the total volume of share repurchases

What do record date, ex-dividend date, and payment date mean, related to dividends? Why would you expect the price of a stock to drop by the amount of the dividend on the ex-dividend date?

  Identify two advantages to using ratio in financial analysis

Using the Ashford University Library as a resource, find two articles that discuss financial ratio analysis. Identify two advantages and two disadvantages to using ratios in financial analysis.

  What should the expected rate of return be for stock

If the risk-free rate of return is 4.0%, and the expected return for the market is 13.0%, what should the expected rate of return be for this stock?

  Identify facts from the scenario which support your decision

Identify the facts from the scenario which support your decision on whether or not a contract exists for the purchase of the automobile.

  Which of the following is the most suitable annuity

Arline is a 70 year old widow with no dependents. She wants to invest in an annuity that will produce income now.

  Genetics experiment on peas

In a heredity experiment on peas, one sample of offspring contained 410 green peas & 121 yellow peas. Based on those final outcomes, determine the probability of getting an offspring pea that is green.

  Areas of organization investment policy

How to handle downgraded credit ratings of investments should be clearly addressed in which of the following areas of an organization's investment policy?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd