Business, 03.06.2021 01:20 nosleepbrooklyn2006

Data is in screenshots attached. Please solve in Excel and show/explain calculations. Thank you!

The daily returns of these three assets.
The average return and standard deviation for these three assets.
The correlations between these three assets.
What is the future value for each of these assets at the end of the day on May 21st if you had $100 invested in each asset on April 5th?
What is the FV and daily returns of a portfolio that placed 70% in VTSAX and 30% in your bond mutual fund. What is the average return and standard deviation of this portfolio?
What is the FV and daily returns of a portfolio that placed 70% in your stock and 30% in your bond mutual fund. What is the average return and standard deviation of this portfolio?
What is the beta of your stock and the bond fund? Use the VTSAX as your proxy for the market.
What is the expected return on the stock for the company you are following? Use reasonable estimates of the variables that enter the CAPM.
What is the WACC for the company you chose to follow?

Data is in screenshots attached.

Please solve in Excel and show/explain calculations. Thank you!

Answers: 3

Show answers

Another question on Business

Business, 21.06.2019 14:00

Will you use single-entry bookkeeping or double-entry bookkeeping? explain why.

Answers: 1

Answer

Business, 21.06.2019 22:00

Email viruses are typically launched by people who modify header information to hide their identity. brightmail's enrique salem says that in the future, your email reader will authenticate the sender before putting hte message in your inbox. that way, you will know the source of all the emails you read. alan nugent of novell says, "i'm kind of a fan of eliminating anonymity if that is the price for security." will eliminating anonymity make computers more secure?

Answers: 3

Answer

Business, 21.06.2019 22:30

Match the vocabulary word to the correct definition. 1. compensation 2. corporate social responsibility 3. discrimination 4. benefits 5. biodegradable a. a business’s obligation to the community and the environment b. the ability to naturally break down or decompose c. treating someone differently because of his or her race, religion,gender, sexual orientation, or disabilities d. indirect and non-cash compensation paid to employees e. the salary and other benefits for doing a job

Answers: 1

Answer

Business, 21.06.2019 23:30

You are frustrated to find that the only way to contact the customer service department is to make a phone call. the number listed would result in long distance charges to your phone bill. which issue should be addressed by the company to keep its crm in line with your expectations?

Answers: 2

Answer

You know the right answer?

Data is in screenshots attached. Please solve in Excel and show/explain calculations. Thank you!

Questions