Question: 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

PLEASE EXPLAIN WITH THE EXCELL FORMULA THANKSPLEASE SHOW THE FORMAL IN

PLEASE EXPLAIN WITH THE EXCELL FORMULA THANKS

PLEASE SHOW THE FORMAL IN EACH CELL

EACH CELL The following table provides the 2005-2009 annual returns for AIG

The following table provides the 2005-2009 annual returns for AIG Insurance and New York Life Insurance. Year AIG NYL 2005 15.70% 45.00% 2006 42.40% 33.80% 2007 27.00% -13.80% 2008 -11.80% 29.40% 2009 -37.20% 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

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 EXPLAIN WITH THE EXCEL 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 2005...

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 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%...

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%...

I've attached the attachment as a word file, thanks! JWCL165_c13_612-673.qxd 8/13/09 11:15 AM Page 612 13 Statement of Cash Flows Chapter STUDY OBJECTIVES After studying this chapter, you should be...

PLEASE COMPLETE NO LATER THAN 11/04 @8am Each question(1,2,& 3) must be a minimum of 200 words. Please EXPLAIN answers in FULL detail and make answers knowledgeable based off the attached reading,...

Public relations (PR) is the practice of managing and disseminating information from an individual or an organization (such as a business, government agency, or a non-profit organization) to the...

In a survey for a statistics class project, students in the class were asked if they had ever been in a traffic accident, including a minor fender-bender. Of the 23 males in the class, 16 reported...

The amount of coffee that people drink per day is normally distributed with the mean 1 4 Standard deviation 5 . 5 ounces. Eight randomly selective people are surveyed Round all answers to four...

At the time the cosmic microwave background radiation originated, the temperature of the universe was about 3000 K. What were (a) The median wavelength of the newly formed radiation (Equation 34.2b)...

Large Corporation acquired and placed in service the following 100% business-use assets. Large did not claim Sec. 179 or bonus depreciation expensing on any of these properties. Truck (light-duty,...

Major League Apparel has two classes of stock authorized: 6%, $10 par preferred, and $1 par value common. The following transactions affect stockholders equity during 2021, its first year of...

Design an experiment for confounding a 26 factorial in four blocks. Suggest an appropriate confounding scheme, different from the one shown in Table 7-8. Table 7-8.

Determine the relationship between the kinematic viscosity ratio v m /v P and the scale ratio if both the Reynolds-number and the Froude number criteria are to be satisfied in a given model test.

Create a 200 word summary on the Juvenile Justice System than and today. Describe The Juvenile system and provide a generalizable definition. Highlight the issues in the Juvenile system and why this...

Advanced What are the behavioural aspects which should be borne in mind by those who are designing and operating standard costing and budgetary control systems? (20 marks) CIMA Cost Accounting 2

Advanced You are required, within the context of budgetary control, to: (a) explain the specific roles of planning, motiva tion and evaluation; (7 marks) (b) describe how these roles may conflict...

Advanced In the context of budgeting, describe the meaning of and write notes on four of the following terms: Feedback control; Feedforward control; Budgetary slack; Aspiration level; Control limits;...