subject
Mathematics, 28.11.2019 00:31 marissaimuniz

Pat mccormack, a financial advisor for investors r us, is evaluating two stocks in a particular industry. he wants to maximize the variance of a portfolio consisting of these two stocks, but he wants to have an expected return of at least 9%. after obtaining historical data on the variance and returns, he develops the following nonlinear program:

minimize portfolio variance = 0.16x^2 + 0.2xy + 0.09y^2
subject to:
x + y = 1 (all funds must be invested)
0.11x + 0.08y β‰₯ 0.09 (return on the investment)
x, y β‰₯ 0
where
x = proportion of money invested in stock 1
y = proportion of money invested in stock 2
solve using excel and determine how much to invest in each of the two stocks. what is the return on this portfolio? what is the variance in this portfolio?
must show set-up in excel solver.

ansver
Answers: 1

Another question on Mathematics

question
Mathematics, 21.06.2019 15:00
Aformual for 8 bottles of window cleaner calls for 6 cups of rubbing to customers alcohol 2 1/4 gallons of water and 1 1/2 cups of ammonia alcohol would the forula call if a factory made 1,280 bottles for stores to sell to customers
Answers: 1
question
Mathematics, 21.06.2019 16:20
Refer to interactive solution 17.45 to review a method by which this problem can be solved. the fundamental frequencies of two air columns are the same. column a is open at both ends, while column b is open at only one end. the length of column a is 0.504 m. what is the length of column b?
Answers: 1
question
Mathematics, 21.06.2019 18:00
Aplane is taking off from bangladesh headed to new york city. at the same time, a plane from new york city is headed to bangladesh is also taking off. the plane bound to new york city is traveling at 600 mph, while the plane traveling to bangladesh is traveling at 400 mph. how far from new york city will the two planes meet if the distance between new york city and bangladesh is 8,000 miles?
Answers: 3
question
Mathematics, 21.06.2019 20:30
At the "no mutants allowed" country farm, every sheep has 4 legs, every chicken has two legs, and all animals have only 1 head. asked to count how many sheep and chicken are in the fields, a farm boy reports back that there are 140 feet and 50 heads. how many sheep and chicken are there? there are sheep and chicken at the farm.
Answers: 1
You know the right answer?
Pat mccormack, a financial advisor for investors r us, is evaluating two stocks in a particular indu...
Questions
question
Mathematics, 21.01.2020 04:31