Question

In: Finance

Tom sold his old house in upstate New York and now has a sum of $175,000...

Tom sold his old house in upstate New York and now has a sum of $175,000 for investment. Tom is considering select only one of the three possible investments to invest his $175,000: a mutual fund (MF), a technology stock (TS), or a certificate of deposit (CD). The investment industry estimates the probability of a good, average, and poor market to be 42%, 27%, and 31%, respectively. The CD is guaranteed to pay a 3.5% return regardless of the market condition. The financial consultant estimates the return on the mutual fund (MF) as 7%, 2%, or -3%, depending on whether market condition is good, average, or poor, respectively. Under the same condition, the financial consultant estimates the technology stock (TS) would yield 9%, 5%, or -11%.

Create a regret table for Tom. What decision should be made according to the minimax approach? What decision should be made according to the expected value approach?

Solutions

Expert Solution

Please have a look at below tables.

We are given three strategies to choose from: Mutual Fund, Technology Stock and CD

We are also give the three possible states of nature as Good, Average and Poor with their respective probabilities.

We are also given the return we would generate from each strategy for every State of nature.

Given the above information we first create a Payoff Table (First Table in the screenshot). This table lists the payoffs that each strategy (columns) would generate given the respective States of Natures (Rows).

Regret Table

Regret Table displays the opportunistic loss for a strategy given a state of nature occured. In simple terms it is what could have been earned given a state of nature occured but is not earned because of our choice of strategy. For example if state of nature happened to be Good, then from the payoff table we see that we could have earned a maximum return of 9% on choosing Technology stock. However, if we had chosen Mutual Fund and the state of nature was good so we earned 7% which is 2% less than what we could have earned if we had chosen technology stock. So, in regret table we write 2% under Mutual Fund in a Good scenario. Similarly we fill the other cells in the regret table.

So to make the regret table we first look at the payoff table to find the maximum return for each state of nature (highlighted in blue)

Then for each state of nature we subtract the return from each strategy from the maximum return for that state of nature.

We now apply the minimax approach to the regret table to make our decision

We find out in the regret table the maximum value under each strategy. For example for Mutual fund the maximum value in 6.5%. This is the maximum regret. We wish to minimise the maximum regret and so we chose the strategy with minimum value of maximum regret. So maximum regret/loss for Mutual fund is 6.5%, for Technology stock the maximum regret is 14.5% and for  CD the maximum regret is 3.5%. The minimum of these three values is for CD. Hence, CD is our answer.

Expected Value Approach

The expected values from the three strategies have been shown in the payoff table bottom line.

The Expected Value approach utilises the probabilities of the states of nature. For each strategy we simply mutiply the return under each state of nature with the probability of occurence of that state of nature. This gives the expected value of return of that strategy.

For example the expected value of retiurn for Mutual Fund is:

7% * 42% + 2% * 27% - 3% * 31% = 2.5%

The strategy with maximum value of expected value will be chosen under this approach. We find that CD will generate the maximum expected value (3.5%) hence CD should be the choice.


Related Solutions

Mary Johnson recently received a lump sum of $240,000 after selling her old house in upstate...
Mary Johnson recently received a lump sum of $240,000 after selling her old house in upstate New York. Mary would like to invest this amount of money. Her local bank offers Mary an available Gold Client account for her entire $240,000 deposit that guarantees 3.75% return regardless of the future market climate. Mary is also interested in investing her $240,000 in two stock options. The first one is to spend the entire $240,000 to purchase stocks from EliteCure, an upcoming...
Mary Johnson recently received a lump sum of $240,000 after selling her old house in upstate...
Mary Johnson recently received a lump sum of $240,000 after selling her old house in upstate New York. Mary would like to invest this amount of money. Her local bank offers Mary an available Gold Client account for her entire $240,000 deposit that guarantees 3.75% return regardless of the future market climate. Mary is also interested in investing her $240,000 in two stock options. The first one is to spend the entire $240,000 to purchase stocks from EliteCure, an upcoming...
Upstate Growers (Upstate) is a cooperative corporation owned by 12 large apple farmers in New York...
Upstate Growers (Upstate) is a cooperative corporation owned by 12 large apple farmers in New York State. Upstate is responsible for managing all 12 apple orchards, picking and sorting the apples, and producing the final apple products. Apples are washed and sorted into three grades: “large unbruised apples,” “large bruised apples,” or “small apples.” These three apple grades/categories comprise the final products produced and sold by Upstate. Large unbruised apples are sold in supermarkets as whole “eating apples” after they...
The new candy Green Globules is being test-marketed in an area of upstate New York. The...
The new candy Green Globules is being test-marketed in an area of upstate New York. The market research firm decided to sample 6 cities from the 45 cities in the area and then to sample supermarkets within cities, wanting to know the number of cases of Green Globules sold. City 1 2 3 4 5 6 Number of Supermarkets 52 19 37 39 8 14 Number of Cases Sold 146,180,251,152,72,181,171,361,73,186 99,101,52,121 199,179,98,63,126,87,62 226,129,57,46,86,43,85,165 12, 23 87,43,59 Obtain summary statistics for...
The following data are collected to study unemployment in a particular region in upstate New York.
The following data are collected to study unemployment in a particular region in upstate New York. The first column shows the number of months unemployed and the second column shows the count of people in the study with the corresponing unemployment length. Let X be a random variable indicating the number of months a person is unemployed. a)Use the data to develop the probability mass function for X. b)Find the cumulative distribution function for X. c)Calculate the mean and standard...
Creamy Dairy is a family-owned dairy located in upstate New York. They are trying to decide...
Creamy Dairy is a family-owned dairy located in upstate New York. They are trying to decide how to process their corn into feed for their livestock. Because they are dairy farmers (and good ones at that), financial choices have a mystical quality about them, so they could use your help. The farm is currently earning $300,000 per year, and an improvement could provide additional revenue. Each of the options will result in an additional (above the current dairy earnings) yearly...
               Electricity distribution in upstate New York is provided by only one firm, NYSEG.   Demand for...
               Electricity distribution in upstate New York is provided by only one firm, NYSEG.   Demand for electricity is characterized by P=31-Q_D, and NYSEG has a total cost function TC(Q)=72+Q+2Q^2, and a marginal cost function MC(Q_D )=1+4Q. a. What is NYSEG’s marginal revenue equation? b. What is the quantity and price NYSEG will choose? Show your math for full credit. c. Will NYSEG be able to operate in the market in the short run? What about the long run? Explain briefly....
2. Purchasing a Home in Upstate New York A quantitatively savvy, young couple is interested in...
2. Purchasing a Home in Upstate New York A quantitatively savvy, young couple is interested in purchasing a home in northern New York. They collected data on 26 houses that had recently sold in the area. They want to predict the selling price of homes (in thousands of dollars) based on the size of the home (in square feet). The regression equation is: Price ̂ = -86.097 + 0.248*Size Regression Statistics Multiple R 0.745865819 R Square 0.55631582 Adjusted R Square...
Tom has owned his house for 20 years, and he paid $400,000 for it. In 2016...
Tom has owned his house for 20 years, and he paid $400,000 for it. In 2016 he married Gisele and she moved into the house, which remained their main residence until 2019. In late 2019, Tom sold the house (Gisele was not added to the ownership records) and moved to Tampa. The house was sold for $1,100,000. Neither Tom nor Gisele excluded the sale of another house in the last two years.  How much of the gain can be excluded for...
A coal burning power plant in upstate New York has been the only provider of power in the region for many years.
A coal burning power plant in upstate New York has been the only provider of power in the region for many years. Recently, a plant that uses wind to create energy was built nearby. The wind plant produces less energy than the coal plant but at a lower cost. Will the coal plant be able to remain competitive in this new market environment?A. Yes, if the coal plant sells energy at a price below its marginal cost.B. Yes, if the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT