Fund1234567CO8910123111121314151617RiskHighHighHighHighHighHighMediumMediumMediumMediumMediumLowLowLowLowLowLowТуреStockStockStockStockStockStockBlendBlendBlendBlendBlendBlendBlendBondBondBondBondReturn11.98%13.18%9.40%7.71%8.35%16.38%4.10%12.52%8.62%11.14%8.78%9.44%8.38%7.65%6.90%5.53%6.30%His financial advisor has suggested that at most 40% ofthe portfolio should be composed of high-risk funds. Atleast 25% should be invested in bond funds, and at most40% can be invested in any single fund. At least six fundsshould be selected, and if a fund is selected, it should befunded with at least 5% of the total contribution.Develop and solve an integer optimizationmodel to determine which funds should be selectedand what percentage of his total investment shouldbe allocated to each fund.

To optimize his portfolio and adhere to specific investment guidelines provided by his financial…

Answered: Fund 1 2 3 4 5 6 7 8 9 10 11 12 13 14…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

17) Which of the following is the significance of Capital Budgeting? a. Irreversible b. All the options c. Long term effect d. Growth
uestion The company's bank won't lend it any more money than it already has, and investment bankers have said that debentures are out of the question. The treasurer has asked you to do some research and suggest a few ways in which bonds might be made attractive enough to allow the company to borrow. Explain how to secure the bonds with owned assets in great detial. In what ways does it make the bonds more attractive to allow the company to borrow?
Please answer along with the excel formulas - 1. Sue now has $125. How much would she have after 8 years if she leaves it invested at 8.5% with annual compounding? $205.83 $216.67 $228.07 $240.08 $252.08 2. Suppose you have $1,500 and plan to purchase a 5-year certificate of deposit (CD) that pays 3.5% interest, compounded annually. How much will you have when the CD matures? $1,781.53 $1,870.61 $1,964.14 $2,062.34 $2,165.46 3. Last year Rocco Corporation's sales were $225 million. If sales grow at 6% per year, how large (in millions) will they be 5 years later? $271.74 $286.05 $301.10 $316.16 $331.96
9.3 Consider another set of net cash flows: Year Cash Flow ($) 0 2,000 1 2,000 2 0 3 1,500 4 2,500 5 4,000 What is the net present value of the stream if the opportunity cost of capital is 10 percent? What is the value of the stream at the end of year 5 if the cash flows are invested in an account that pays 10 percent annually? What cash flow today (time 0), in lieu of the $2,000 cash flow, would be needed to accumulate $20,000 at the end of year 5? (Assume that the cash flows for years 1 through 5 remain the same.)
Evaluate the following statements:S1. Any investment income of general borrowing is deducted from capitalizable borrowing cost.S2. If the asset is financed by specific borrowing but a portion is used for working capital purposes, the borrowing shall be treated as general borrowing in determining capitalizable borrowing cost. a.False, False b.False, True c.True, True d.True, False
3:25 ull 1 Search A moodle1.du.edu.om Topic: Ch 3 ): Assume you are the finance manager of Methanol Company, and the company is considering investing in one of the two projects. The life for both the Projects X and Project Y is 6 years. Project X costs OMR. 20500 and Project Y costs OMR.20500. The discount rate/cost of capital is 3.55%. Required: Use the following techniques to help company to decide which Machine is better and justify why? a) Payback period b) Discount payback period c) Net Present Value d) Present value index -Profitability index. Year Project X Project 1 9876 9300 2 7056 7609 3 9676 4508 7050 8905 9900 9904 3490 1239 : What factors should you keep in our mind as a financial manager when selecting methods of capital budgeting? and Why is rebalancing between methods of capital budgeting are important? II
According to the CAPM, what is the expected risk premium of a stock with a beta of 0.8 if the market risk premium is 8%? Select one: O a. 8% O b. 6% O c. 6.4% O d. 8.4% O e. More information is required to answer this question.
Explain, why doesn't an estimated absolute covariance number tell the investor much about the relationship between the returns on the two assets.
Limitations of Portfolio analysis is Naively following the prescriptions of a portfolio model may actually reduce corporate profits if they are used inappropriately that have caused some companiesto reduce their use of this approach.Why?
A stock had annual returns of 3.6 percent, -8.7 percent, 5.6 percent and 12.5 percent over the past 4 years. Which one of the following best describes the probability that this stock will produce a return of 22 percent or more in a single year? a. less than 5 percent but greater than 2.5 percent b. less than 1.0 percent but greater than 0.5 percent c. less than 2.5 percent but greater than .5 percent d. less than 0.1 percent e. less than 0.5 percent but greater than 0.1 percent
Fred has been told that diversifying his investments will significantly reduce risk. He hastherefore invested in two stocks. His portfolio consists of a $1 500 000 investment in DrugsLimited and $750 000 invested in shares of Pharmaceuticals Limited.Economy Probability ReturnsDrugs Limited PharmaceuticalsLimitedBoom 0.4 12% 19%Normal 0.5 8% 11%Recession 0.1 2% -4% i. What is the expected return on Fred’s portfolio? ii. Advise Huron as to the effectiveness of his diversification strategy.
You have recently won the super jackpot in the WashingtonState Lottery. On reading the fine print, you discover that you have the following twooptions:a. You will receive 31 annual payments of $250,000, with the first payment beingdelivered today. The income will be taxed at a rate of 28 percent. Taxes will bewithheld when the checks are issued.b. You will receive $530,000 now, and you will not have to pay taxes on this amount.In addition, beginning one year from today, you will receive $200,000 each yearfor 30 years. The cash flows from this annuity will be taxed at 28 percent.Using a discount rate of 7 percent, which option should you select?

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS