Please answer it correctly with clear formula, thank you The table below shows the annual return ZipZap stock and the S P500 stock index for the period of 2019 2022 Annual Percentage Change Year ZipZap S P 500 2006 24 1 15 8 2007 28 7 5 5 2008 31 8 37 0 2009 2 7 26 5 Arithmetic average 5 9 (a) Geometric average (b) 0 7 Standard deviation 27 6 (c) Correlation coefficient 0 7 a) Calculate the values for cell (a), (b), and (c) b) An investor has $100,000 at the end of year 2022 He invests $40,000 in ZipZap stock and the rest is invested in the S P500 ETF fund What is the standard deviation of his portfolio c) based on the given information on question b), if you have to guess what the return of her portfolio will be in 2010, what is your best guess Explain your answer

The Answer is in the image, click to view ...

Question: Please answer it correctly & with clear formula, thank you! The table below shows the annual return ZipZap stock and the S&P500 stock index for

Please answer it correctly & with clear formula, thank you!

The table below shows the annual return ZipZap stock and the S&P500 stock index for the period of 2019-2022.

	Annual Percentage Change
Year	ZipZap	S&P 500
2006	24.1%	15.8%
2007	28.7%	5.5%
2008	-31.8%	-37.0%
2009	2.7%	26.5%
Arithmetic average	5.9%	(a)
Geometric average	(b)	-0.7%
Standard deviation	27.6%	(c)
Correlation coefficient	0.7

a) Calculate the values for cell (a), (b), and (c)

b) An investor has $100,000 at the end of year 2022. He invests $40,000 in ZipZap stock and the rest is invested in the S&P500 ETF fund. What is the standard deviation of his portfolio?

c) based on the given information on question b), if you have to guess what the return of her portfolio will be in 2010, what is your best guess? Explain your answer.

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 table below shows the annual return of ARK Innovation ETF (ARKK) [1] and the S&P500 stock index for the period of 2019-2022. Year 2019 2020 2021 2022 Arithmetic average Geometric average Standard...

The table below shows the annual return of Berkshire Hathaway Class A stock and the S&P500 stock index for the period of 2006-2009. Annual Percentage Change Year Berkshire Hathaway S&P 500 2006 24.1%...

Hi Ruchi, I need help with the attached assignment. It's due in about a week. Thanks 1) The paper should be written in APA style Research Paper format. This is the link that explains the research...

Refer to the Excel Projects Guidelines file in the Group Corner folder. CAPM & Stock Valuation Project The estimation of company betas is normally brushed over in many introductory finance texts....

https://drive.google.com/drive/folders/1NKlv36eMkXDYee-HkWJnuRmyUhrqShsB?usp=drive_link This is all the question and part 1 and part 2 and google links it not example its is review 4 def get_beta...

Please answer question #6 in it's entirety :) Thank you. Finance 221 Time Value of Money Excel Project Compass Submission Due by 11:59 PM, Tuesday, Feb. 9 Please use Excel financial functions or...

i have the above case study , and i want to answer for its questions, please CASE 27 LINCOLN SPORTS EQUIPMENT CAPITAL BUDGETING "This could be about the riskiest project we have ever considered," Sam...

Please help me answer with clear formula so I can understand it. Thank you! The table below shows the annual return of ZipZap stock and the S&P500 stock index for the period of 2006-2009. Annual...

Only need the excel section completed. I will do the written report stuff. Model is the format I want it complete in. Thanks Date 6/1/2010 7/1/2010 8/1/2010 9/1/2010 10/1/2010 11/1/2010 12/1/2010...

For the network of Fig. 9.74: a. Determine the mathematical expression for the magnitude of the ratio Vo/Vi. b. Using the results of part (a), determine Vo/Vi at 100 Hz, 1 kHz, 2 kHz, 5 kHz, and 10...

Describe public speaking as an interactive process.

A financial analyst developed a regression model to predict quarterly investment returns lin $ 1 . 0 0 0 s 1 . The table below shows the actual and predicted returns for four clients: \ table [ [...

Draw a class diagram and its relationship based on the following statements. You can use any UML tool/software to represent your class diagram. Do NOT copy and paste your diagram, use the attachment...