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 19:30

Clonex labs, inc., uses the weighted-average method in its process costing system. the following data are available for one department for october: percent completed units materials conversion work in process, october 1 53,000 90 % 65 % work in process, october 31 29,000 74 % 52 % the department started 381,000 units into production during the month and transferred 405,000 completed units to the next department. required: compute the equivalent units of production for october.

Answers: 2

Answer

Business, 21.06.2019 21:00

Consider a small island country whose only industry is weaving. the following table shows information about the small economy in two different years. complete the table by calculating physical capital per worker as well as labor productivity. hint: recall that productivity is defined as the amount of goods and services a worker can produce per hour. in this problem, measure productivity as the quantity of goods per hour of labor. year physical capital labor force physical capital per worker labor hours output labor productivity (looms) (workers) (looms) (hours) (garments) (garments per hour of labor) 2024 160 40 1,800 14,400 2025 180 60 3,900 23,400

Answers: 2

Answer

Business, 21.06.2019 23:10

You are the new chief information officer for the video-game developer, necturus games. the company has recently undergone a major expansion of its primary product, and you must staff up the is department and determine the best way to develop new game "capsules" for the game, "escape velocity."

Answers: 1

Answer

Business, 22.06.2019 17:00

Aaron corporation, which has only one product, has provided the following data concerning its most recent month of operations: selling price $ 102 units in beginning inventory 0 units produced 4,900 units sold 4,260 units in ending inventory 640 variable costs per unit: direct materials $ 20 direct labor $ 41 variable manufacturing overhead $ 5 variable selling and administrative expense $ 4 fixed costs: fixed manufacturing overhead $ 64,200 fixed selling and administrative expense $ 2,900 the total contribution margin for the month under variable costing is:

Answers: 2

Answer

You know the right answer?

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

Questions