Determine the probability that in any given year

Assignment Help Financial Management

Reference no: EM132001890

Suppose the average return on an asset is 11.6 percent and the standard deviation is 21.2 percent. Further assume that the returns are normally distributed.

Use the NORMDIST function in Excel® to determine the probability that in any given year you will lose money by investing in this asset.

(Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.)

Probability of losing money in a given year %

Reference no: EM132001890

Questions Cloud

Comment on bechtels hedging strategy : Comment on Bechtel's hedging strategy. Is Bechtel really protecting its downside risk? What if Bechtel loses its bid and the yen appreciates?

Calculate the product demand if price were 32 dollars : Suppose an analyst used Excel do generate a simple linear regression model describing the relationship between price (in dollars) and demand (in units).

What is the future worth at the end of 7 years : Suppose that $5.000 is placed in a bank account at the end of each quarter over the next 7 years.

Should you sell or buy more preference shares : Suppose you own 500 shares of XYZ Co's preference shares. The preference shares currently sell for $3.80 per share and pays annual dividends.

Determine the probability that in any given year : Use the NORMDIST function in Excel® to determine the probability that in any given year you will lose money by investing in this asset.

Should you start saving at the end of this year : You would like to save each year an amount that grows by 5% each year (that is, if you save $1 this year, you will save $1.05 next year).

What is the value of an fra : Suppose that the 9-month and 12-month LIBOR rates are 2% and 2.3%, respectively. All rates are quarterly compounded.

Determine what is taxable bond equivalent yield : If the municipal bond yield is 4%, what is taxable bond equivalent yield? If a 10-year corporate bond with similar credit quality provides 8% yield.

What is the free cash flow of the lease for bmi : Suppose BMI Regional is considering the purchase of new airplanes to facilitate operation of new routes. In total, it plans to purchase a new airline fleet.

User Account

All Pages