User Account

All Pages

What is the variance of the portfolio

Assignment Help Finance Basics
Reference no: EM132185327

All answers must be entered as a formula in excel

1. Consider the following information. Your portfolio is invested 30 percent each in A and C, and 40 percent in B. What is the expected return of the portfolio? What is the variance of the portfolio? The standard deviation?

State               Probability                  Stock A                      Stock B                   Stock C

Boom             0.10                            0.35                            0.45                         0.27

Good              0.60                            0.16                            0.10                         0.08

Poor                0.25                            (0.01)                          (0.06)                    (0.04)

Bust                0.05                            (0.12)                          (0.20)                    (0.09)

Weights                                             0.30                            0.40                         0.30

Complete the following analysis. Do not hard code values in your calculations.

                       Portfolio                               Return              Squared          

State               Return            Product          Deviation         Deviation       Product

Boom

Good

Poor

Bust                                        ___________                                                 ___________

                                   E(R)=                                                      Variance

Standard Deviation=

Reference no: EM132185327

Questions Cloud

Salary for a permanent research scientist : Lakeside Cancer Research Institute just received a $2.5 million gift to cover the salary for a permanent research scientist in perpetuity to study Hodgkin
How changes in competition effect commercialization strategy : Explain in detail how changes in competition effects the commercialization strategy in emerging. The response must be typed, single spaced.
Would you currently invest in a mutual fund : Would you currently invest in a Mutual Fund, If so, what type?
Comparing purchase and lease options : From a financial perspective, should Mercy lease the surgical device or borrow the money to purchase it? Show your work by comparing purchase and lease options.
What is the variance of the portfolio : What is the expected return of the portfolio? What is the variance of the portfolio? The standard deviation?
Create a summary report that justifies the content : Based on your research, create an initial draft of an incident response policy for your organization. Consider HIPAA and other health care-related compliance.
Generate net operating cash flows : Blackmore Health System is considering a new orthopedic center. The building and equipment for the new center will cost $7,500,000. The new orthopedic center
Create a good security policy : Cyber security is one of the most critical issues the U.S. and across the globe today. With the threats being real, and the need is pressing to create a good.
Determine the security concerns of technological landscape : In 2006, Thomas Friedman authored a book entitled, The World Is Flat. Since that time many people have adopted a global perspective to business.

Reviews

Write a Review

Finance Basics Questions & Answers

  Hester amp wayne is a regional food distribution company

hester amp wayne is a regional food distribution company. mr. chester ceo has asked your assistance in preparing

  What was the firms operating cash flow

Sankey Inc. has current assets of $6,000, net fixed assets of$23,200, current liabilities of $5,600 and long term debt of $13,600. What was the firm's operating cash flow? What is the value of the shareholder's equity account for this firm?

  Stereotypical roles of men and women or rejecting them

What do you think? Do you think Picasso was reinforcing these stereotypical roles of men and women or rejecting them?

  Financial break-even points

How to determine and interpret cash, accounting, and financial break-even points

  The project requires 36000 of fixed assets that will be

chesters has a proposed project that will generate sales of 2750 units at a selling price of 36 each. the fixed costs

  Permitting hobbies on capital

It was chosen in April 2011 that benefits ought to be disseminated just as in the wake of permitting hobbies on capital @ 6%per annum with impact from first April, 2010.

  How much must you invest in your account today

How much must you invest in your account today if you want to pay yourself $230 at the end of each of the next 15 years?

  Discuss the impact of major accounting

Discuss the impact of major accounting/financial scandals on investors

  Ceo of merck and pfizer

1. What would you recommend to Richard Clark and Jeffrey Kindler as they become CEO's of Merck and Pfizer, respectively?

  What is the realized return on abc investment

What is the realized return on ABC's investment? b) The firm does far better than expected and bondholders receive all of the promised interest and principal payments. What is the realized return on ABC's investment?

  What is the price of the austin power bonds

Austin Power Co. bonds have a 14% annual coupon rate. Interest is paid semi-annually. The bonds have a par value of $1,000 and will mature 10 years from now.

  A firm is considering a project that is expected to cost

Suppose a firm is considering a project that is expected to cost $2,115,000 (= C). The project is expected to produce cash flows for four years. Cash flow in year 1 will be $647,000 (= CF1), cash flow in year 2 will be $738,000 (= CF2), cash f..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd