Question: Please answer with EXCEL FORMULA 5. The following table provides the 2005-2009 annual returns for AIG Insurance and New York Life Insurance. Year 2005 2006

Please answer with EXCEL FORMULA 2005-2009 annual returns for AIG Insurance and New York Life Insurance. Year

5. The following table provides the 2005-2009 annual returns for AIG Insurance and New York Life Insurance. Year 2005 2006 2007 2008 2009 AIG 15.70% 42.40% 27.00% -11.80% -37.20% NYL 45.00% 33.80% -13.80% 29.40% 40.00% Required: 1. Prepare a fourth column in the chart with a combined portfolio of 30% invested in AIG and 70% invested in NYL (Portfolio AIG/NYL) 2. Determine the average returns, variance and standard deviation of AIG, NYLIFE and the combined Portfolio AIG/NYL. (20 POINTS) D Focus Clipboard VI Font Alignment Number D14 X A D E F 5 6 Problem 5 7 8 9 10 Year 2005 2006 2007 2008 2009 Average Return AIG 15.70% 42.40% 27.00% -11.80% -37.20% NYL 45.00% 33.80% -13.80% 29.40% 40.00% 11 12 13 14 15 16 Variance 17 18 Standard Deviation 19 20 21 22 23

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!

please answer with excel formula. 5. The following table provides the 2005-2009 annual returns for AIG Insurance and New York Life Insurance. Year 2005 2006 2007 2008 2009 AIG 15.70% 42.40% 27.00%...

PLEASE ANSWER WITH EXCEL FORMULA 5. The following table provides the 2005-2009 annual returns for AIG Insurance and New York Life Insurance. Year 2005 2006 2007 2008 2009 AIG 15.70% 42.40% 27.00%...

PLEASE ANSWER WITH EXCEL FORMULA. 5. The following table provides the 2005-2009 annual returns for AIG Insurance and New York Life Insurance. Year 2005 2006 2007 2008 2009 AIG 15.70% 42.40% 27.00%...

NEED IT IN EXCEL FORMAT 5. The following table provides the 2005-2009 annual returns for AIG Insurance and New York Life Insurance. Year 2005 2006 2007 2008 2009 AIG 15.70% 42.40% 27.00% -11.80%...

The following table provides the 2005-2009 annual returns for AIG Insurance and New York Life Insurance. Year 2005 2006 2007 2008 2009 AIG 15.70% 42.40% 27.00% -11.80% 37.20% NYL 45.00% 33.80%...

PLEASE EXPLAIN WITH THE EXCELL FORMULA THANKS PLEASE SHOW THE FORMAL IN EACH CELL The following table provides the 2005-2009 annual returns for AIG Insurance and New York Life Insurance. Year AIG NYL...

London School of Science & Technology Qualification Unit number and title BTEC Level 5 HND Diploma Business UNIT 6: Business Decision Making Student name and ID number Assessor name Al Hassan Barrie...

Read the case on p. 472-486, then solve the problem: Case 5 The US Airline Industry in 2015 During the first quarter of 2015, it was clear the strong upswing in the profitability of US airlines that...

The Reckoning notes that Datini recorded all in his Libro Segreto and this was his most important and comprehensive accounting. What is the modern-day equivalent of the Libro Segreto? Does such a...

Bridgeport Company's organization chart includes the president; the vice president of production; three assembly factories-Dallas, Atlanta, and Tucson; and two departments within each...

Question content area top Part 1 Which of the following is a limitation of the direct write - off method of accounting for uncollectibles? Question content area bottom Part 1 A . The direct write -...

Write both a prescriptive and a descriptive conclusion for each issue 1) Deciding whether to sanction organizations, coaches, officials, and athletes who have not complied with rules, regulations,...

3. What is the difference between perception and assessment of a particular everyday situation? Give at least three examples.

7. One or other combination of 16.

1. Discuss the following statements: a) Mastery is not the same as understanding. b) Being bigger than is not the same as being the thing that is bigger. c) The difference between order and disorder...