Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Financial Management Expert

Download monthly price data for Apple, Microsoft, Exxon Mobil, and Johnson & Johnson for the period of Jan. 2000 through Sep. 2017 (use Finance.Yahoo.com). Use Excel for this question.

Create a column in Excel and apply a range of weights between -1 and +1 (with step size of 0.1) to IBM to construct a portfolio consisting of the two shares (remember that the sum of weights should be one; so you can easily calculate the weight for Microsoft. Don’t worry if it gets larger than 1!). Plot a scatter-plot graph showing average return and the standard deviation of the portfolio.

Now apply a constraint on weights: eliminate negative values of weights and change the weight only between 0 and 1 (with step size of 0.05) and re-plot the scatter plot of average return and variance of portfolio.

Eliminating negative weights is called short sales constraints. Compare the results of parts (1) and (2) and discuss the effects of imposing short-sales constraints on a market.

Repeat previous stages for the portfolio consisting Exxon Mobil and Johnson & John- son. Do you observe any differences between this portfolio and the portfolio of (Apple, Microsoft)?

Financial Management, Finance

  • Category:- Financial Management
  • Reference No.:- M92714518

Have any Question?


Related Questions in Financial Management

Nbspassignmentchapter 4 mini-case - samps air long term

Assignment Chapter 4 mini-case - S&S Air long term financial planning Note: data is based on the S&S Air financial statements S&S Air, INC. 2009 Income Statement Sales   $30,499,420 Cost of goods sold   $22,224,580 Other ...

Managerial finance ronsoninc a technology company is

Managerial Finance RonsonInc.; a technology company, is evaluating the possible acquisitionof Blake equipment company. If the acquisition is made, it will occur on January 1, 2009. All cash flows shown in the income stat ...

The following examination is due no later than 9 am monday

The following examination is due no later than 9 AM Monday, October 22nd. You are to email me the exam in an XLSX file named after yourself and containing your section. For example, if your name is Leslie King, the file ...

Exerciseas the executive of a bank or thrift institution

Exercise As the executive of a bank or thrift institution you are faced with an intense seasonal demand for loans. Assuming that your loanable funds are inadequate to take care of the demand, how might your Reserve Bank ...

Assignment1before the truth in lending act auto dealers

Assignment 1. Before the Truth in Lending Act, auto dealers used to use a trick called add on interest. Suppose you bought a $30,000 car and financed it over 5 years at 6% interest. To calculate your payment, they'd take ...

Please respond to the following discussion not an essay

Please respond to the following: {Discussion, NOT an Essay. Under 350 WORDS} a) Propose three reforms to the investment markets that might reduce their exposure to systematic risk. Support your proposals with examples. b ...

This week you are to research the issue of healthcare

This Week, you are to research the issue of healthcare charging and develop a charging policy for a healthcare institution that reflects current market trends. You should consider various methods of establishing this pol ...

The investment logic for sustainabilitywatch the investment

The Investment Logic for Sustainability Watch the Investment Logic for Sustainability video. Then perform a few internet searches on terms such as the following: Sustainable funds Socially responsible investing ESG Envir ...

1 activities of a company that require the spending of cash

1) Activities of a company that require the spending of cash are known as: A) Uses of cash. B) Cash on hand. C) Cash receipts. D) Sources of cash. E) Cash collections. 2) Relationships determined from a firm's financial ...

Introductionlast week you determined the root causes of the

Introduction Last week, you determined the root cause(s) of the problem you are trying to resolve for your final paper. As a reminder, the decision you are working on is the one that you selected in week two. This week, ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As