subject
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!
Data is in screenshots attached.

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

ansver
Answers: 3

Other questions on the subject: Business

image
Business, 21.06.2019 22:50, Zagorodniypolina5
Tara incorporates her sole proprietorship, transferring it to newly formed black corporation. the assets transferred have an adjusted basis of $240,000 and a fair market value of $300,000. also transferred was $10,000 in liabilities, $1,000 of which was personal and the balance of $9,000 being business related. in return for these transfers, tara receives all of the stock in black corporation. a. black corporation has a basis of $241,000 in the property. b. black corporation has a basis of $240,000 in the property. c. tara’s basis in the black corporation stock is $241,000. d. tara’s basis in the black corporation stock is $249,000. e. none of the above.
Answers: 1
image
Business, 22.06.2019 10:00, annafellows
Cynthia is a hospitality worker in the lodging industry who prefers to cater to small groups of people. she might want to open a
Answers: 3
image
Business, 22.06.2019 13:30, bobbycisar1205
Hundreds of a bank's customers have called the customer service call center to complain that they are receiving text messages on their phone telling them to access a website and enter personal information to resolve an issue with their account. what action should the bank take?
Answers: 2
image
Business, 23.06.2019 02:00, brennarfa
Suppose that a major city’s main thoroughfare, which is also an interstate highway, will be completely closed to traffic for two years, from january 2014 to december 2015, for reconstruction at a cost of $535 million. if the construction company were to keep the highway open for traffic during construction, the highway reconstruction project would take much longer and be more expensive. suppose that construction would take four years if the highway were kept open, at a total cost of $800 million. the state department of transportation had to make its decision in 2014, one year before the start of construction (so that the first payment was one year away). so the department of transportation had the following choices: (i) close the highway during construction, at an annual cost of $267.5 million per year for two years. (ii) keep the highway open during construction, at an annual cost of $200 million per year for four years. now suppose the interest rate is 80%. calculate the present value of the costs incurred under each plan.
Answers: 3
You know the right answer?
Data is in screenshots attached. Please solve in Excel and show/explain calculations. Thank you!

Questions in other subjects: