[EXCEL] Expected returns: John is watching an old game show rerun on television called Let's Make a Deal in which the contestant chooses a prize behind one of two curtains. Behind one of the curtains is a gag prize worth $150, and behind the other is a round-the-world trip worth $7,200. The producer of the game show has placed a subliminal message on the curtain containing the gag prize, which makes the probability of choosing the gag prize equal to 75 percent. What is the expected value of the selection, and what is the standard deviation of that selection? Please use Excel.

[EXCEL] Expected returns: John is watching an old game show rerun on television called Let's Make a Deal in which the contestant chooses a prize behind one of two curtains. Behind one of the curtains is a gag prize worth $150, and behind the other is a round-the-world trip worth $7,200. The producer of the game show has placed a subliminal message on the curtain containing the gag prize, which makes the probability of choosing the gag prize equal to 75 percent. What is the expected value of the selection, and what is the standard deviation of that selection? Please use Excel.

Essentials of Business Analytics (MindTap Course List)

2nd Edition

ISBN:9781305627734

Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Chapter5: Probability: An Introduction To Modeling Uncertainty

Section: Chapter Questions

Problem 27P: Suppose we are interested in bidding on a piece of land and we know one other bidder is interested.1...

See similar textbooks

Similar questions

So, what could be better than winning a SuperLotto Plus jackpot? Choosing how to receive your winnings! Before playing a SuperLotto Plus jackpot, you have a choice between getting the entire jackpot in 26 annual graduated payments or receiving one lump sum that will be less than the announced jackpot. (See Figure 2.29.) What would these choices come out to for an announced jackpot of $7 million?• Lump-sum cash-value option: The winner would receive the present cash value of the announced jackpot in one lump sum. In this case, the winner would receive about 49.43%, or $3.46 million, in one lump sum (less tax withholdings).This cash value is based on average market costs determined by U.S. Treasury zero-coupon bonds with 5.3383% annual yield.• Annual-payments option: The winner would receive the jackpot in 26 graduated annual payments. In this case, the winner would receive $175,000 as the first payment (2.5% of the total jackpot amount) immediately. The second payment would be $189,000.…
1. A farmer enters a contract to sell her produce at a fixed price in the future and the future market price turns out to be five times as high as the agreed fixed price. The farmer regrets entering into the futures contract. This is an example of efficient risk sharing. question: true or false? 2. Sam-Bankman Fried is the founder of crypto currency exchange FTX. He raised US$420 million from an array of major investors in October 2021. When he pitched to clients, he usually was dressed in a t-shirt. Question: What you wear is not taken into account by professional investors. True or False? 3. “Cooped up at home by stay-at-home orders during the anxious early days of the pandemic, many people used their newfound free time and stimulus checks to pick up a new hobby. Some turned to fitness or learning to play an instrument, while others found a rather unhealthy and risky new side hustle: day trading. Inspired by stupendous returns posted on Reddit’s WallStreetBets and TikTok by random…
P3.1 Ashley Morgan estimates that if he does 15 hours of research using data that will cost $ of there is a good chance that he can improve his expected return on a $ 20,000, 1-year investry, from 7% to 10%. Ashley feels that he must earn at least $25 per hour on the time he devoteres his research. a. Find the cost of Ashley's research. b. By how much (in dollars) will Ashley's return increase as a result of the research? c. On a strict economic basis, should Ashley perform the proposed research
Pls solve all. If we consider the storage cost of $0.35/bu at the beginning, recalculate the following questions: 1. Suppose the elevator buys 100,000 bushels of corn on Nov 1 at $2.00/bu in cash market, and store the corn to sell in the cash market until Jun 1 at $2.30/bu. What is the elevators gain or loss in cash market? 2. On Nov 1, the elevator could sell corn futures contract at $2.50/bu and buy the contract back on Jun 1 at $2.4/bu. What is the elevators gain or loss in futures market? 3. Calculate the basis for both Nov 1 and Jun 1. 4. Calculate the total return of corn to the elevator through such hedging in the futures market? 5. What is the net profit/loss through above hedging in the futures market?
(Present-value comparison) Much to your surprise, you were selected to appear on the TV show "The Price is Right." As a result of your prowess in identifying how many rolls of toilet paper a typical American family keeps on hand, you win the opportunity to choose one of the following:$1,400 today, $5,000 in 14 years, or $27,000 in 26 years. Assuming that you can earn 6 percent on your money, which should you choose? f you are offered $5,000 in 14 years and you can earn 6 percent on your money, what is the present value of $5,000? $______________( round to the nearest cent)
3. Which lottery payout scheme is better? Suppose you win a small lottery and have the choice of two ways to be paid: You can accept the money in a lump sum or in a series of payments over time. If you pick the lump sum, you get $2,950 today. If you pick payments over time, you get three payments: $1,000 today, $1,000 1 year from today, and $1,000 2 years from today. At an interest rate of 8% per year, the winner would be better off accepting the , since that choice has the greater present value. At an interest rate of 10% per year, the winner would be better off accepting , since it has the greater present value. Years after you win the lottery, a friend in another country calls to ask your advice. By wild coincidence, she has just won another lottery with the same payout schemes. She must make a quick decision about whether to collect her money under the lump sum or the payments over time. What is the best advice to give your friend? The lump sum is…
Congratulations. You have just won first prize in a quantitative competition. You have the following choices to receive your winnings: Option I: Receive $3,000,000 immediately. Option II: Receive five $1,000,000 payments paid every other year beginning in year T=2. For example, you receive a $1 million dollars payment in year T=2, T=4, T=6, T=8, and T=10. a. What is the present value of each option if R=0.06? Which option would you choose? b. What is the present value of each option if R=0.12? Which option would you choose? c. What interest rate R will make the present value of both options equal? Hint: use Excel’s Data – What If - Goal Seek analysis Show what you do to se up goal seek for c
Congratulations. You have just won first prize in a quantitative competition. You have the following choices to receive your winnings: Option I: Receive $3,000,000 immediately. Option II: Receive five $1,000,000 payments paid every other year beginning in year T=2. For example, you receive a $1 million dollars payment in year T=2, T=4, T=6, T=8, and T=10. a. What is the present value of each option if R=0.06? Which option would you choose? b. What is the present value of each option if R=0.12? Which option would you choose? c. What interest rate R will make the present value of both options equal? Hint: use Excel's Data - What If - Goal Seek analysis Show what you do to se up goal seek for c Also take snap shots from excel and how did you get the answers, please show work for c!!!
Congratulations. You have just won first prize in a quantitative competition. You have the following choices to receive your winnings: Option I: Receive $3,000,000 immediately. Option II: Receive five $1,000,000 payments paid every other year beginning in year T=2. For example, you receive a $1 million dollars payment in year T=2, T=4, T=6, T=8, and T=10. a. What is the present value of each option if R=0.06? Which option would you choose? b. What is the present value of each option if R=0.12? Which option would you choose? c. What interest rate R will make the present value of both options equal? Hint: use Excel’s Data – What If - Goal Seek analysis.
Please help This is one question with 4 sub-part. don't use excel formulas. A long time ago Lisa had put an amount of $50,000 into an investment in the securities market. Now she has $150,000 in her investment account. Required: If the Lisa would have wished to obtain the target of $150,000 within 10 years only, how much money should she put into the initial investment given the same rate of return is applied? Assume that Lisa would like to put the amount of $150,000 into another investment and aims for a new saving target of $500,000 to buy a new house in 12 years. How much is the rate of return should Lisa aim for to get her $500,000 after 12 year? Lisa decided to borrow 350 000 from Commonwealth Bank to buy her new home. The bank offers Lisa the lending rate of 4.83% per year (compounding monthly) and she is expected to make an equal mortgage payment each month for 30 years. Calculate monthly payment Lisa need to make for the mortgage? Lisa would like to buy some furniture for…
The Weiland Computer Corporation is trying to choose between the following mutually exclusive design projects, P1 and P2: Year 0 1 2 3 Cash flows (P1) -$53,000 27,000 27,000 27,000 Cash flow (P2) -$16,000 9,100 9,100 9,100 If the discount rate is 10 percent and the company applies the profitability index (PI) decision rule, which project should the firm accept? If the firm applies the Net Present Value (NPV) decision rule, which project should it take? Are your answers in (a) and (b) different? Explain why?
Please answer question 1 after reading the scenario thank you. I am confused of which rate I should use for market rate(k) Question at the end Stephanie Carter has been gifted a sum of $50,000 by her grandparents on completing her graduation successfully. She is a fresh finance graduate and is excited to invest some money in the capital market, for which she intends to use the gifted sum of $50,000. However, instead of committing this money to the market immediately, she decides to wait for some time, work in the field and acquire some experience before proceeding with her intended investment. She thus contemplates an extremely conservative investment in a portfolio of stocks and bonds, at the start of year 5 from now. For now, she will leave the $50,000 in a fixed deposit with the bank which promises an interest rate of 6% per annum. She will require a return of at least 9% on her stock investments and 4% on bond investments. Stephanie would have to pay 25% taxes on any interest…