ExerciseA business student has $2,500 available from a summer job and has identifiedthree potential stocks in which to invest. The cost per share and expectedreturn over the next two years are given in the table below.a. Identify the decision variables, the objective, and the constraints in simpleverbal statements.b. Develop a linear optimization model to determine the optimal investmentstrategy.Solve this LP problem using Excel Solver and state your recommendation.C.StockPrice/ShareReturn/ShareA$12$8B$15$7C$30$11

Amount available for investment = $2500 ABCPrice/share$12$15$30Return/share$8$7$11

Answered: A business student has $2,500 available…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 1C

See similar textbooks

Similar questions

1. Explain the meaning of the expected value of perfect information (EVPI) in this problem. Based on the results of (iii) and (iv), which investment would you choose? 2. Compute the coefficient of variation, the return-to-risk ratio (RTRR) for each investment. Based on (vii) and (viii), what investment would you choose? Compare the results of (vi) and (ix) and explain any differences
Rollo Megabux has $1 million to invest in stocks orbonds. The percentage yield on each investment during thecoming year depends on whether the economy has a goodor a bad year (see Table 17). It is equally likely that theeconomy will have a good or a bad year.a If Rollo is risk-neutral, how should he invest hismoney?b For $10,000, Rollo can hire a consulting firm toforecast the state of the economy. The consulting firm’sforecasts have the following properties:P(good forecast|economy good) .80P(good forecast|economy bad) .20Should Rollo hire the consulting firm? What are EVSIand EVPI? Economy EconomyHas Good Has BadYear YearYield on stocks 22% 10%Yield on bonds 16% 14%
A business student has $3,500 available from a summer job and has identified three potential stocks in which to invest. The cost per share and expected return over the next two years are given in the table. Complete parts a and b. A $12 $8 Stock Price/share Return/share B $16 $5 A. Amount invested in stock A B. Amount invested in stock B C. Return for each stock D. Amount invested in stock C E. Price of each stock C $25 $11 a. Identify the decision variables, objective function, and constraints in simple verbal expressions. Identify the decision variables. Select all that apply.
West Company’s contribution format income statement for March 2020 is givenbelow:Sales (15,000 units X $30 per unit) $450,000Variable expenses 315,000Contribution margin 135,000Fixed expenses 90,000Net operating income $ 45,000The industry in which West Company operates is quite sensitive to regularmovements in the economy. Thus, profits vary considerably from year to yearaccording to general economic conditions. The company has a large amount ofunused capacity and is studying ways of improving profits.Required:The company CEO has asked you as a Senior Manager to evaluate the belowsituations with recommendations:1- New equipment has come onto the market that would allow WestCompany to automate a portion of its operations. Variable expenseswould be reduced by $9 per unit. However, fixed expenses wouldincrease to a total of $225,000 each month. How Net Income wouldappear if the new equipment were purchased. As a Senior Manager,what factor/s would be paramount in your mind deciding…
5. If money can be invested at 5% compounded annually, A. Accumulate P1,000 for 15 years. B. Discount the result of problem A for 10 years. C. Accumulate P1,000 for 5 years. Compare the results of B and C.
XYZ Co. has provided the following data seeking your advice on the optimum investment strategy: Investment at the beginning of the year Net return data of selected investments Amount P Q R S available (£) 1 95 80 70 60 70 2 75 65 60 50 40 3 70 45 50 40 90 4 60 40 40 30 30 Maximum Investment (£) 40 50 60 60 The following additional information is also provided: o P, Q, R and S represent the selected investments o The company has decided to have four years investment plan o The policy of the company is that the amount invested in any year will remain so until the end of the fourth year o The values in the table represent net returns on investment of £1 till the end of the planning horizon Determine the optimal investment strategy. You may use the transportation technique
26. XYZ and Co has provided the following data seeking your advice on optimum investment strategy: Net return data (in paise) Investment made at the of selected investments Amount beginning of year available (Lakh) 1 95 80 70 60 70 2 75 65 60 50 40 3 70 45 50 40 90 60 40 40 30 30 Маximum Investment (Lakh) 40 50 60 60 The following additional information is also provided: (i) P, Q, R and S represent the selected investments. (ii) The company has decided to have four-year investment plan. (iii) The policy of the company is that amount invested in any year will remain so until the end of the fourth year. (iv) The values (paise) in the table represent net return on investment of 7 1 till the end of the planning horizon (for example, a rupee invested in investment P at the beginning of first year will grow to { 1.95 by the end of the fourth year, yielding a return of 95 paise). Using the above, determine the optimum investment strategy. (CA, November, 1996)
Current Asset Usage Policy Payne Products had $2.4 million in sales revenues in the most recent year and expects sales growth to be 25% this year. Payne would like to determine the effect of various current assets policies on its financial performance. Payne has $3 million of fixed assets and intends to keep its debt ratio at its historical level of 50%. Payne's debt interest rate is currently 9%. You are to evaluate three different current asset policies: (1) a restricted policy in which current assets are 45% of projected sales, (2) a moderate policy with 50% of sales tied up in current assets, and (3) a relaxed policy requiring current assets of 60% of sales. Earnings before interest and taxes are expected to be 11% of sales. Payne's tax rate is 35%. What is the expected return on equity under each current asset level? Round your answers to two decimal places. Tight policy % Moderate policy % Relaxed policy %
Match the following terms to their definitions: valuation, return on investment, discount rate, terminal value 1. The value of an investment at the end of an investment period 2. The return that investors expect to earn for putting their capital at risk 3. The amount of profit made on a given investment 4. An estimate of the economic worth of an asset or business a. Discount rate b. Valuation c. Return on investment d. Terminal value
Formulate an LP model for the following problems.1. Bernadette intends to invest up to ₱50,000 in either Best Fund, or a time deposit orboth. The Best Fund pays 8% per year and the time deposit pays 9%. Because theBest Fund is riskier than the time deposit, so she intends to put at most ₱30,000 intothe time deposit and at least ₱10,000 into the Best Fund. How much should she allotto each investment in order to maximize her returns?
4a Holly Bing stops making her mortgage payments and her home sells at a foreclosure sale for $152,000. Holly owes $131,500 on her first mortgage and owes $31,000 on a second mortgage. How will the $152,000 be distributed. 4b How will the money be distributed if the home sells for $175,000.
Mr. Johnnie B. Good has a furniture business which he operates as a sole proprietor. The business has been doing well for several years and now he wants to finance the expansion of his business by way of a loan and he is thinking of approaching BCN Bank accordingly. He is also planning to buy a great deal of raw material on credit from Miller’s Hardware in support of the business expansion. Mr. Good in looking at the potential risks to his personal assets and in an effort to safeguard himself from losing his personal assets if the business failed and was not able to repay the loan or pay for the material he got on credit, filed the relevant documents with the companies office and incorporated a private company, Good Furniture Ltd, with him as the sole shareholder and director and then went ahead and obtained a loan in the company’s name from the bank and bought the raw material on credit on behalf of the company. The bank in providing the loan ensured that Mr. Good signed a personal…

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS

A business student has $2,500 available from a summer job and has identified three potential stocks in which to invest. The cost per share and expected return over the next two years are given in the table below. Identify the decision variables the obiective and the constraints in simple