FREE Trial
Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

PLEASE EXPLAIN WITH THE EXCELL FORMULA THANKS

PLEASE SHOW THE FORMAL IN EACH CELL

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Multinational Business Finance

Multinational Business Finance

Authors: David K. Eiteman, Arthur I. Stonehill, Michael H. Moffett

15th edition

134796551, 134796550, 978-0134796550

Students also viewed these Finance questions

Question

★★★★★
Using Mohrs circle, determine the moments of inertia and the product of inertia of the area of Problem 9.72 with respect to new centroidal axes obtained by rotating the x and y axes 45 clockwise.

Answered: 1 week ago

Question

★★★★★
Costello Company has several divisions. The controller, Sarah James, prepares monthly segment reports for each division. Each division manager is evaluated annually, based largely on the segment...

Answered: 1 week ago

Question

★★★★★
Discuss other design issues, such as the type of treatment variable, ordering effects, and matching subjects.

Answered: 1 week ago

Question

★★★★★
Bylund Corporation was organized in June 2011. In auditing its books, you find the following land, buildings, and equipment account: An analysis of this account and of other accounts disclosed the...

Answered: 1 week ago

Question

★★★★★
Interest revenue earned on held-to-maturity debt investments is reported on the income statement in the ________ section. A. operating income B. current assets C. noncontrolling interest D. other...

Answered: 1 week ago

Question

★★★★★
Recording Revenue and Receivables Under a Consignment Arrangement On March 15, 2020, Drexel Corp. provides goods to a retailer through consignment where Drexel Corp. retains ownership of the goods...

Answered: 1 week ago

Question

★★★★★
Pre Pour Inspections include: Group of answer choices B. Rebar- material type, size, spacing, tie down, clearances C. Anchor Bolts- Projection, dimensionally square, nut on bottom secured, proper...

Answered: 1 week ago

Question

★★★★★
Alyssa launched her new shaver as being revolutionary, innovative, and unisex. Instead her brand is being purported as very feminine and too close to the Schick Shaver. What should Alyssa start to do?

Answered: 1 week ago

Question

★★★★★
A roofer is working to cover a 2,500squarefoot roof. He must first install rafters, then sheathing, then felt, and finally shingles. He assumes the previous tasks compose 35%, 20%, 15%, and 30% of...

Answered: 1 week ago

Question

★★★★★
Dakota is an unmarried taxpayer with one dependent child, age 18, living in Dakota's home. Dakota does not itemize deductions and reports AGI of $40,200. The dependent child earned $16,400 from a...

Answered: 1 week ago

Question

★★★★★
Hi-Tek Manufacturing, Incorporated, makes two types of industrial component parts-the B300 and the T500. An absorption costing income statement for the most recent period is shown: Hi-Tek...

Answered: 1 week ago

Question

★★★★★
What cycle time improvements would you expect after the BPR effort in Case I: The London market Maker? What cycle time improvements would you expect after the BPR effort in Case II: The Privatized...

Answered: 1 week ago

Question

★★★★★
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

Answered: 1 week ago

Question

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

Answered: 1 week ago

Question

★★★★★
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;...

Answered: 1 week ago

Previous Question Next Question