Question




Using Solver to Find the Optimal Stock Portfolio Five investors plan to pool the fund and create a stock portfolio together.
0 0
Add a comment Improve this question Transcribed image text
Answer #1
Calculation of Expected Return on the Stock
Particulars Market Price Profit Expected Return Rank
Google $1,400 $52 3.714 6
Amazon $2,400 $30 1.250 8
Facebook $213 $19 8.920 3
Netflix $440 $21 4.773 5
T- Mobile $97 $8 8.247 4
AT & T $29 $5 17.241 2
Disney $108 $20 18.519 1
Tesla $811 $29 3.576 7
Optimum portfolio according to the investor preferences
Investor Amount Investor Preference Explanation Decision Market price No.of Shares can be bought
Adam $50,000 Google, Facebook, Amazon Among Google, F.B, Amazon , F.B has the highest expected return Facebook $213 234.741784
Bill $80,000 Atleast 50 shares of Disney and Rest can be allocated to AT & T, T-Moble & Netflix Among all the stocks , Disney has higher expected return. It is wise to choose Disney Disney $108 740.7407407
Cindy $65,000 Google & Amazon Among Google & Amazon, Google is yielding higher return Google $1,400 46.42857143
Dianna $90,000 Open to invest in any companies Among all the stocks , Disney has higher expected return. It is wise to choose Disney Disney $108 833.3333333
Elaine $60,000 Open to invest in any companies except Disney Among all the stocks , Disney has higher expected return. It is wise to choose Disney. But the investor does not wany to choose Disney, so the next best alternative which is giving the highest return is AT & T AT & T $29 2068.965517
Add a comment
Know the answer?
Add Answer to:
Using Solver to Find the Optimal Stock Portfolio Five investors plan to pool the fund and...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Rose Corporation has a stock purchase plan with the following provision. Each full-time employee with a...

    Rose Corporation has a stock purchase plan with the following provision. Each full-time employee with a minimum of one year's service may acquire from Rose Corporation, its common stock, $10 par, through payroll deductions at 5% below the market price on the date selected by the employee for a stock purchase (the exercise date). The exercise decision must be made within one year from the payroll deduction date. Employee Deeter signed a payroll deduction agreement form on January 1, 2020,...

  • ch. 16.1 #3 Assume that Amazon.com has a stock-option plan for top management. Each stock option...

    ch. 16.1 #3 Assume that Amazon.com has a stock-option plan for top management. Each stock option represents the right to purchase a share of Amazon $1 par value common stock in the future at a price equal to the fair value of the stock at the date of the grant. Amazon has 4,400 stock options outstanding, which were granted at the beginning of 2020. The following data relate to the option grant. Exercise price for options Market price at grant...

  • 11.2 Russ Alonzo Takes Stock of His Securities Russ Alonzo is 42 years old, single, and...

    11.2 Russ Alonzo Takes Stock of His Securities Russ Alonzo is 42 years old, single, and works as a designer for a major architectural firm. He is well paid and has built up a sizable portfolio of investments. He considers himself an aggressive investor and, because he has no dependents to worry about, likes to invest in high-risk/high-return securities. His records show the following information. 1. In 2006, Russ bought 200 shares of eBay (NASDAQ: symbol EBAY) at $29.77 a...

  • Problem 16-4 Assume that Amazon.com has a stock-option plan for top management. Each stock option represents...

    Problem 16-4 Assume that Amazon.com has a stock-option plan for top management. Each stock option represents the right to purchase a share of Amazon $1 par value common stock In the future at a price equal to the fair value of the stock at the date of the grant. Amazon has 4,200 stack options outstanding, which were granted at the beginning of 2017, The following data relate to Now assume that the market price of Amazon stock on the grant...

  • 2. A financial adviser has a new client and is helping him to diversity his stock...

    2. A financial adviser has a new client and is helping him to diversity his stock portfolio. He's considering 4 stocks for purchase and the table below shows the dividend paid per share. Stock A Stock Stock Stock Dividends $1.51 $2.50 $3.25 $98 paid per share They can purchase no more than a total of 5000 shares. They must purchase at least 500 shares of stocks A and D and no more than 15 shares of stocks and C In...

  • help pls Questions 21-27 are based on the following information. CAPM and stock valuation. Your aunt, Beth, plan...

    help pls Questions 21-27 are based on the following information. CAPM and stock valuation. Your aunt, Beth, plans to invest in the common stock of Smart-investment Corporation Knowing that you are studying finance, she asks for your suggestion. You calculation shows that yield on Treasury securities is 6%. You know that the S&P 500 Index's expected annual return is 14% Your coonometric model tells you that beta of this company's stock is 1.25. Aunt Beth tells you that this company...

  • 543 em 13.1 Assessing the Stalchecks's Portfolio Performance G4 Mary and Nick Stalcheck have an investment...

    543 em 13.1 Assessing the Stalchecks's Portfolio Performance G4 Mary and Nick Stalcheck have an investment portfolio containing four investments. It was developed to provide them with a balance berween current income and capital appreciation. Rather than acquire mutual fund shares or diversify within a given dass of investments, they developed their portfolio with the idea of diversifying across various asset classes. The portfolio currently contains common stock, industrial bonds, mutual fund shares, and options. They acquired each of these...

  • Jennifer is interested in the mutual fund RBC U.S. Index Fund – Series A. She has...

    Jennifer is interested in the mutual fund RBC U.S. Index Fund – Series A. She has a few questions for you before she buys this investment. a) Does the reported fund’s return include the Management Expense Ratio (MER) ? Yes or No b) What type of fee is charged: No-load, Front-end load or a Back-end load? c) Is the status of this mutual fund classified as a closed-end or open-end mutual fund?   d) Based on your response in c), explain...

  • Hello again! These are the other half of my homework,I'd be very happy if you could help me out of these!

    6. Suppose that, as a fund manager, you purchase 5.000 shares of Company X on 1 Jan. 2019 for 10 TL each in order to keep and earn dividends. Simultaneously, you also purchase 4.000 shares of Company Y for 7,5 TL each for trading purposes. The share price of Company X increases to 12 TL, but after a while it drops to 11,2 TL and you sell 3.000 shares. On the other hand, the share price of Company Y drops...

  • objective risk excepr: O All fthe following are methods used by ingurance are methods used by...

    objective risk excepr: O All fthe following are methods used by ingurance are methods used by insurance companies to A. safety education programs. C. investment in investment grade securities only D. use of deductibles. selective underwriting of insureds of: 7. A life insurance company needs more liquidity when selling a high proportion A. one-year renewable term policies B. annuities. C, thirty-year term policies D. whole life policies. one of the following statements about universal life insurance is not true? A....

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT