Please show how to solve this in excel for 1 - 6 below Consider an investment for which the expected returns are normally distributed with an expected return of 11% and an annual standard deviation (SD) of 12%. What is the probability that during a given year an investor would earn a return that is:1. greater than -1%?2. lower than -1%3. lower than -13%4. greater than 11%?5. greater than 23%?6. greater than 35%?

Please show how to solve this in excel for 1 - 6 below Consider an investment for which the expected returns are normally distributed with an expected return of 11% and an annual standard deviation (SD) of 12%. What is the probability that during a given year an investor would earn a return that is:1. greater than -1%?2. lower than -1%3. lower than -13%4. greater than 11%?5. greater than 23%?6. greater than 35%?

Managerial Economics: A Problem Solving Approach

5th Edition

ISBN:9781337106665

Author:Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor

Publisher:Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor

Chapter17: Making Decisions With Uncertainty

Section: Chapter Questions

Problem 17.1IP

See similar textbooks

Similar questions

An investment plan allows investors to deposit a minimum of £1,000 at the beginning of the term, which pays a fixed return rate of 5% per annum. Af- ter a year, investors have to deposit a minimum of £800 with an expected return rate of 3% per annum for the second year and a standard deviation of 2% per annum. a. Find the expected value of the total minimum amount earned after two years of investment. b. Find the standard deviation of the total minimum amount earned after two years of investment.
Probability Possible Rate of Return 0.25 -0.10 0.15 0.00 0.35 0.10 0.25 0.25 a. Under what conditions can the standard deviation be used to measure the relative risk of two investments? b. Under what conditions must the coefficient of variation (CoVar) be used to measure the relative risk of two investments?
Guy Fieri has purchased a significant plot of land in Northwest Ohio for his newest venture: FlavorTownship. This hub for mind-boggling flavor and entertainment is a strictly for-profit operation. Guy would like to keep Flavor Township open all year-round, but due to Ohio weather the following are the probabilities of when it will be open: |- 30% chance it is open 300 days a year |- 55% chance it is open 325 days a year |- 15% chance it is open 350 days a year Flavor Township will expect to host 14,000 people each day that it is open and expects an average revenue of $45 per visitor. This paradigm-shifting landmark will cost $420,000,000 to start the investment and will require annual costs (food, employees, etc.) of $115,000,000. Every 3 years, Flavor Township will undergo necessary maintenance that will cost $22,000,000. If the expected life of Flavor Township is 15 years and a 16% return is expected, what is the expected NPV of this project?
A man purchased a $22,500, 1-yr term-life insurance policy for $695. Assuming that the probability that he will live for another year is 0.995, find the company's expected gain. (Round your answer to the nearest cent.) $
2. The annual commissions earned by sales representatives of Machine Products Inc., a manufacturer of light machinery, follow the normal probability distribution. The mean yearly amount earned is $40,000 and the standard deviation is $5,000. a. What percent of the sales representatives earn more than $42,000 per year? b. What percent of the sales representatives earn between $32,000 and $42,000? c. What percent of the sales representatives earn between $32,000 and $35,000?
Consider an investment that pays off $700 or $1,600 per $1,000 invested with equal probability. Suppose you have $1,000 but are willing to borrow to increase your expected return. What would happen to the expected value and standard deviation of the investment if you borrowed an additional $1,000 and invested a total of $2,000? What if you borrowed $2,000 to invest a total of $3,000? Instructions: Fill in the table below to answer the questions above. Enter your responses as whole numbers and enter percentage values as percentages not decimals (.e., 20% not 0.20). Enter a negative sign (-) to indicate a negative number if necessary. Invest $1,000 Invest $2,000 Invest $3,000 Expected Value Percent Increase Standard Deviation 1150 S 28 % $ 8 % $ Expected Return N/A Doubled Tripled : #
r.edu/courses/97574/quizzes/357143/take ch results - yaz... Question 23 Consider the following probability distribution. xi 0 M Question Mode: M... 1 2 3 O 2.5 0.9 O 1.9 P(X = xi) O 1.5 0.1 The expected value is 0.2 0.4 0.3 Question 24 An analyst has constructed the following probability distribution for firm X's predicted return for upcoming year.
You decide to invest in a portfolio consisting of 21 percent Stock X, 48 percent Stock Y, and the remainder in Stock Z. Based on the following information, what is the standard deviation of your portfolio? State of Economy Normal Boom Probability of State of Economy .84 .16 Return if Stat Stock X Stock Y 10.20% 3.60% 17.50% 25.50%
themepans i max Task 3: During the last 10 years, a corporation's net profit increased year over year 6 times and decreased year over babive969 with characteristicsmber of annual earnings increases for the next 10 years is modelled in 4 times. Assume that the accordance with quote of the binomial distribution. Estimate the probability that the corporation's net profit will increase in exactly 4 of the next 10 years. tot twee monteutimut ethomi smo bsd-.2.U A :clesT Diswiot brs toqe ert tuods noitsmotnleysb 08 ni utimut to insmqinle 6 101 000,000,83 vsqof ever lliw 2.0 woled nevig ai 29161 (AU3 8.0 ataoo 020) 008.0 02U AU3 eer.o 020 A03 9161 toqe tre etsi biswiot ysb-08
If the economy booms, Meyer&Co. stock will have a return of 20.8 percent. If the economy goes into a recession, the stock will have a loss of 13.1 percent. The probability of a boom is 63 percent while the probability of a recession is 37 percent. What is the standard deviation of the returns on the stock? 9.29% 12.43% 13.56% 14.61% 14.61%
Asset A will generate a 20% return with probability 0.25; a 15% return with probability 0.50; and a -15% return with probability 0.25. The expected return on Asset A is % Write your answer as a percentage, rounded to 2 decimal places. Example: if the answer is 10.3478%, then write "10.35". Do not type the % sign in your answer.
a. A company produces lightbulbs whose life follows a normal distribution, with mean 1200 hours and standard deviation 250 hours. If we choose a lightbulb at random, what is the probability that its lifetime will be between 900 and 1300 hours? (answer in three decimal places)