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

  Calculate the projected portfolio return

Use an Excel spreadsheet to calculate the projected portfolio return, rp, for each of the six years. Use an Excel spreadsheet to calculate the average portfolio

  Suppose that a bank has 10 billion of one-year loans and 30

suppose that a bank has 10 billion of one-year loans and 30 billion of five year loans. these are financed by 35

  Should smc make this investment explain

Conduct sensitivity analysis on the NPV to the variables: selling price, variable cost, fixed cost, investment cost, net working capital, and discount rate

  What would be the change in firm value

If the debt actually increases (keeping operating cash flows unchanged), what would be the change in firm value?

  An introducing broker and a commodity trading advisor

Explain the difference between an introducing broker, a commodity trading advisor, a commodity pool operator, and an associated person.

  What is the coupon rate of bond

What is the coupon rate of this bond? (Answer to the nearest hundredth of a percent, i.e. 1.23 without the % sign).

  Based on the progression of changes how banks are able to

based on the progression of changes how banks are able to adjust their asset portfolios and evaluate whether or not a

  Calculate a the current ratio b the debt to total assets

kalbs books amp music inc. reported the following selected information at march 31.2012total current assets262787total

  What is the impact of overhead allocation

What is the impact of overhead allocation when the project is underway?

  What was the cash flow to stockholders for the year

The 2014 balance sheet of Sugarpova's Tennis Shop, Inc., showed $630,000 in the common stock account and $4.9 million in the additional paid-in surplus account.

  Discuss the pros and cons of the markowitz model

Discuss the pros and cons of the Markowitz model and the Single Index model. Share at least one Internet link (other than Investopedia, Wikipedia, etc.) that supports the points you make.

  Discuss quantitative models you will employ for forecasting

QBUS6830, Financial Time Series and Forecasting Assignment - Motivate and discuss quantitative models you will employ for forecasting the asset returns series

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