NewCrest is looking to invest at most $500,000. The investment can be divided among three options....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
NewCrest is looking to invest at most $500,000. The investment can be divided among three options. The return on each option depends on the economic outlook, which is shown in Table 1. For example, if the economic outlook is bright, investing $1 in option I will generate a gain of $3, and investing $1 in option II will result in a loss of $5. (a) (b) (c) Table 1: Return per dollar invested in the different options Return per dollar invested in option II -5 6 Economic outlook I 3 -2 Bright Gloomy III 7 -3 Axel, a business executive, proposed two alternatives to NewCrest. One is investing $100,000 in option I, $200,000 in II and $150,000 in III. The other is investing $60,000 in option I, $100,000 in II and $125,000 in III. NewCrest takes a conservative approach to decision-making. That is, it chooses the alternative that maximizes the minimum return produced by the two outcomes of the economic outlook. Discuss among the two alternatives proposed by Axel, which one NewCrest will choose. Please write clearly alternatives, states of nature and payoffs in a payoff table. Please limit the answer to within one page. (10 marks) Ben, another business executive, pointed out that NewCrest has an unlimited number of alternatives, not just the two proposed by Axel. Which alternative is best if New Crest takes a conservative approach to decision-making? To answer that question, Ben drafted, "Define x = investment in option I, x = investment in option II, and x3 = investment in option III. The objective is to Maximize min {3x - 5x2 + 7x3,-2x + 6x-3x3}". The objective function is not linear. Please search online "tricks to maximize the min of objective functions" or "transformations into linear programs". Then help Ben develop a complete Linear Programming (LP) model that represents the problem of deciding how much to invest in each option. Please limit the answer to within one page. (10 marks) Use the Excel Solver to find the optimal solution to the problem in Part (b) and summarise how NewCrest should invest. Please paste here three screenshots, (1) the problem worksheet just before clicking the Solver command, (2) the Solver Parameters dialog just before clicking Solve and (3) the Answer Report created by the Solver. Please limit the answer to within three pages. (20 marks) NewCrest is looking to invest at most $500,000. The investment can be divided among three options. The return on each option depends on the economic outlook, which is shown in Table 1. For example, if the economic outlook is bright, investing $1 in option I will generate a gain of $3, and investing $1 in option II will result in a loss of $5. (a) (b) (c) Table 1: Return per dollar invested in the different options Return per dollar invested in option II -5 6 Economic outlook I 3 -2 Bright Gloomy III 7 -3 Axel, a business executive, proposed two alternatives to NewCrest. One is investing $100,000 in option I, $200,000 in II and $150,000 in III. The other is investing $60,000 in option I, $100,000 in II and $125,000 in III. NewCrest takes a conservative approach to decision-making. That is, it chooses the alternative that maximizes the minimum return produced by the two outcomes of the economic outlook. Discuss among the two alternatives proposed by Axel, which one NewCrest will choose. Please write clearly alternatives, states of nature and payoffs in a payoff table. Please limit the answer to within one page. (10 marks) Ben, another business executive, pointed out that NewCrest has an unlimited number of alternatives, not just the two proposed by Axel. Which alternative is best if New Crest takes a conservative approach to decision-making? To answer that question, Ben drafted, "Define x = investment in option I, x = investment in option II, and x3 = investment in option III. The objective is to Maximize min {3x - 5x2 + 7x3,-2x + 6x-3x3}". The objective function is not linear. Please search online "tricks to maximize the min of objective functions" or "transformations into linear programs". Then help Ben develop a complete Linear Programming (LP) model that represents the problem of deciding how much to invest in each option. Please limit the answer to within one page. (10 marks) Use the Excel Solver to find the optimal solution to the problem in Part (b) and summarise how NewCrest should invest. Please paste here three screenshots, (1) the problem worksheet just before clicking the Solver command, (2) the Solver Parameters dialog just before clicking Solve and (3) the Answer Report created by the Solver. Please limit the answer to within three pages. (20 marks)
Expert Answer:
Related Book For
Posted Date:
Students also viewed these finance questions
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Read the case study given below and answer the following questions Assignment: Ethics in Firefighting Firefighter ordered suspended without pay after trying to rescue an elderly woman from a fire By...
-
Four pegs of the same diameter are attached to a board as shown. Two strings are passed around the pegs and pulled with the forces indicated. Determine the diameter of the pegs knowing that the...
-
Fletcher (2003) shows that when congressional districts are redrawn to include more elderly people, members of Congress become more likely to take pro-elderly positions in congressional votes. Why...
-
Name an embedded system that requires both periodic and aperiodic computation.
-
1. China has the most comparative advantages in producing apparel. Free trade theory implies that retailers should import clothing from the most efficient country. Given this, and potential drawbacks...
-
Barker Company had reported the following details for the year ended December 31, 2025: Net sales Total assets Total liabilities $25,650,000 17,300,000 10,600,000 The company's beginning total assets...
-
In this mini-case, you will complete the test of details on accounts receivable for the 2019 audit of EarthWear Clothiers, Inc. The principal test of detail involves sending "confirmations" or...
-
HW7A Q5 - Please help me solve the 4 parts. i included an examplefor you to see the parts Call centers typically have high tumover. The director of human resources for a large bank has compiled data...
-
Suppose that a researcher has observations on the log stock price indexes of Korea (k), Japan (j) and Singapore (s). Each stock price index series is 1(1). (1) (ii) Suppose the researcher estimates...
-
4. You observe following exchange rate quotations: $1 is equal to 7.4521 Chinese yuan 1 Japanese yen equal to 0.0710 Chinese yuan. How many U.S. dollars will you need to purchase 1 billion Japanese...
-
Assume that the principal residence is sold this year at a price equal to its FMV with a 6% commission. The adjusted basis of the home is the original purchase price of $155,000. What is the...
-
a cash-basis individual, wins a $1m lottery price and becomes entitled to the prize on August 1. Con has until September 30 to choose either 20 annual payments of $50,000 each or a lump-sum payment...
-
Raffy deposited $5000 in an investment account for 3 months. The account paid simple interest at a rate of 2.4 percent. What is the future value of his investment?
-
A 4 circular curve based on a 20 m. arc connects the tangents intersecting at an angle of 48. It is to be replaced by another having 20 m. spirals at its ends such that the points of tangency shall...
-
For the following arrangements, discuss whether they are 'in substance' lease transactions, and thus fall under the ambit of IAS 17.
-
The financial manager of Hearty Cereals is in the process of preparing a cash budget for the first quarter of 2010. The firm typically sells 1/3 of its monthly sales on cash terms and the rest on...
-
Using the information in Problem 1, determine what the stock price of Atlantis Manufacturing will be after the cash dividend announcement in a world of no taxes. Assume that the current price is...
-
Raspberry Phones uses external data to forecast the coming years sales. Raspberry Phones have 8% of all new phone sales in the United States and 6% of all replacement phones. Industry forecasts...
-
In Example 6.1, we introduced the Hermitian number and phase operators \(\hat{N}\) and \(\hat{\Theta}\) constructed from the raising and lowering operators, \(\hat{a}^{\dagger}\) and \(\hat{a}\). In...
-
Supersymmetry is a proposed extension of the symmetries of space-time beyond that of just familiar Lorentz transformations and translations. A supersymmetry transformation interchanges fermions and...
-
We studied coherent states, which we had identified as eigenstates of the lowering operator, \(\hat{a}\). A coherent state \(|\psiangle\) is defined by the eigenvalue...
Study smarter with the SolutionInn App