Question: PLEASE ONLY SHOW ON EXCEL, I can do by hand. Calculate the standard deviation of returns for each stock and for the portfolio. When I

PLEASE ONLY SHOW ON EXCEL, I can do by hand. Calculate the standard deviation of returns for each stock and for the portfolio.

When I use the standard deviation function on Excel, I'm not getting the correct answers. The correct answers should be 30%, 30% and 29% for the portfolio. Thank you!

Stocks A and B have the following historical returns: Year -24% 2015 2016 2017 -18% 44 -22 2018 2019

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

The following data applies to all questions in this assignment: Show work: you answer cells should have the embedded algebra or Excel function. Rate of Return Year Asset A Asset B Market 1 20.00%...

Hello, I must create a variance-covariance matrix in Excel that will allow me to calculate the standard deviation of an 8-asset portfolio. I was provided with the estimated annual real returns and...

Leave all answers to 2-decimal places. Show work: you answer cells should have the embedded algebra or Excel function. The following data applies to all questions in this assignment: Rate of Return...

This assignment requires you to use real data from finance.yahoo.com to answer the following questions. you can find data under the markets tab. 1. Pick 3 stocks from the Most Actives List and...

Attached I need these questions answered with work shown. Name: Group: Leave all answers to 2-decimal places. Show work: you answer cells should have the embedded algebra or Excel function. The...

Risk and Return using EXCEL Use the following data to explore the return-risk relation and the concept of beta for Apple stock, JPMorgan Chase & Co stock, and the S&P 500 market index: Year | Apple...

This is an individual Excel assignment. You must use Excel functions to answer ALL calculations. Each question/problem must be on a new Excel sheet. This means that you must use 10 Excel sheets for...

Needed ASAP Which has the highest return on investment-the S\&P 500, high-grade corporate bonds, or U S. Treasury bonds? Download the Inyestment Returns data set in Excel. The source is Aswath...

6.1 Warren Buffett, arguably the most famous investor in the United States, is the CEO of Berkshire Hathaway (BRK), a company that has enjoyed great success in temrs of its stock price. Below are the...

Why would the option-adjusted spread vary across dealer firms?

Find the inverse of in terms of c. 2 -c3

E3.5 A system is represented by a block diagram as shown in Figure E3.5. Write the state equations in the form U(s) 51- f x(t) = Ax(t) + Bu(t) ==== y(t) Cx(t) + Du(t) d 1 b Y(s) a X(5) X(s) k FIGURE...

Mo, Lu, and Barb formed the MLB Partnership by making investments of $67,500, $262,500, and $420,000, respectively. They predict annual partnership net income of $450,000 and are considering the...