Question: Question: Using excel, find average monthly return(%), standard deviation, annualised return(%), annualised standard deviation and reward to risk ratio. A B E Month 1 N

Question: Using excel, find average monthly return(%), standard deviation, annualised return(%),

Question:

Using excel, find average monthly return(%), standard deviation, annualised return(%), annualised standard deviation and reward to risk ratio.

A B E Month 1 N 3 3 1 2 3 4. 5 6 7 8 9 10 11 4 5 6 12 Year 2008 2008 2008 2008 2008 2008 2008 2008 2008 2008 2008 2008 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 7 8 9 10 11 12 1 2 C D Size Premium Across Regions Global Market Developed -7.85 -0.95 -0.04 2.11 -1.25 -0.8 4.92 -2.77 1.83 1.66 -8.06 1.16 -2.79 -0.44 -2.1 -0.5 - 12.28 -1.25 -19.51 -2.82 -6.53 -0.49 4.44 2.17 -8.55 2.24 -9.93 1.06 7.27 -1.31 11.41 1.6 9.95 1.65 -0.26 2.83 8.6 -1.4 3.88 0.9 4.46 1.61 -2.1 -0.44 3.64 -2.42 1.93 0.68 Emerging -0.34 -0.99 -0.53 -1.98 -1.35 1.04 1.61 -0.11 -2.26 0.11 -2.04 -0.96 1.53 1.34 -2.64 1.69 -0.36 1.1 -0.25 3.06 -0.34 1.22 0.58 2.13 13 14 15 16 17 18 19 20 21 22 23 24 25 26 2 3 4 Ji 5 6 7 8 9 10 11 12 A B E Month 1 N 3 3 1 2 3 4. 5 6 7 8 9 10 11 4 5 6 12 Year 2008 2008 2008 2008 2008 2008 2008 2008 2008 2008 2008 2008 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 7 8 9 10 11 12 1 2 C D Size Premium Across Regions Global Market Developed -7.85 -0.95 -0.04 2.11 -1.25 -0.8 4.92 -2.77 1.83 1.66 -8.06 1.16 -2.79 -0.44 -2.1 -0.5 - 12.28 -1.25 -19.51 -2.82 -6.53 -0.49 4.44 2.17 -8.55 2.24 -9.93 1.06 7.27 -1.31 11.41 1.6 9.95 1.65 -0.26 2.83 8.6 -1.4 3.88 0.9 4.46 1.61 -2.1 -0.44 3.64 -2.42 1.93 0.68 Emerging -0.34 -0.99 -0.53 -1.98 -1.35 1.04 1.61 -0.11 -2.26 0.11 -2.04 -0.96 1.53 1.34 -2.64 1.69 -0.36 1.1 -0.25 3.06 -0.34 1.22 0.58 2.13 13 14 15 16 17 18 19 20 21 22 23 24 25 26 2 3 4 Ji 5 6 7 8 9 10 11 12

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 average monthly return, standard deviation, reward to risk ratio, annualized return and annualized standard deviation for six regions (developed, emerging, Europe, Japan,...

Finance Help please thumbs up for all correct answers . 2 part question. plaase use average sample not population please answer question i zoom on graphs on final pics hope this helps thank you 1....

You are to build a portfolio of four stocks. Each stock should have at least 1 0 years of data. Do not pick all stocks from the same sector. Part 1 : ( 1 5 % ) Choosing the portfolio and getting some...

Go to Yahoo Finance and download the monthly prices for the following ETFs: EWJ, EWZ FXI, EWG, EWC, EWA, EWQ, EWW, EWY and EWU for the period from January 2013-January 2018 in Excel. Also download...

Question 3B Question 3C Qantas Airways Limited (QAN.AX) Singapore Airlines Limited (C6L.SI) -0.52% 3.94% Cathay Pacific Airlines (0293.HK) -0.51% 2.61% Average Daily Return Standard Deviation 0.06%...

Hello Tutors.I need help with 4 finance investment questions. Please be detailed as much as possible base on the steps taken. Besides your answer to the question, please attached the excel sheets...

HOMEWORK 1. Use the data on Table 6.3 in the book (shown below). Table 6-3 Monthly Holding-Period Returns, eBay versus the S&P 500 Index, June 2014 through May 2015 (1 of 2) eBay Returns S&P 500...

PERSONAL INFORMATION: Javier and Sofia Garca live in Roanoke, VA in a home Javier inherited from his parents. They have two daughters: Ariana (age 8) and Isabela (age 10); both attend the...

A steel tube with the cross section shown is 6 ft long and has a wall thickness of 0.12 in. (a) If the allowable shear stress is 8000 psi, determine the largest torque that can be applied safely to...

Stoll Co. s long- term available- for- sale portfolio at December 31, 2012, consists of the following. Stoll enters into the following long-term investment transactions during year 2013. Jan. 29 Sold...

Puts are an option to _ _ _ _ _ _ _ _ a specified number of shares of stock during a specified period of time at a specified price. A buyer of a put option expects the price of the underlying stock...

Consider the four programming paradigms and the languages we covered this term. For the following problem, determine which paradigm is objectively best suited to solve. A program to keep track of...