With today’s improvements in technology and healthcare, many people are living much longer lives. Why do many elderly individuals need long-term care insurance?

For a multistate lottery, the following probability distribution represents the cash prizes of the lottery with their corresponding probabilities. complete parts (a) through (c) below. x (cash prize, $) p(x) grand prizegrand prize 0.000000008860.00000000886 200,000 0.000000390.00000039 10,000 0.0000016950.000001695 100 0.0001582930.000158293 7 0.0039114060.003911406 4 0.0080465690.008046569 3 0.012865710.01286571 0 0.975015928140.97501592814 (a) if the grand prize is $13 comma 000 comma 00013,000,000, find and interpret the expected cash prize. if a ticket costs $1, what is your expected profit from one ticket? the expected cash prize is $nothing.

The total value of your portfolio is $10,000: $3,000 of it is invested in stock a and the remainder invested in stock b. stock a has a beta of 0.8; stock b has a beta of 1.2. the risk premium on the market portfolio is 8%; the risk-free rate is 2%. additional information on stocks a and b is provided below. return in each state state probability of state stock a stock b excellent 15% 15% 5% normal 50% 9% 7% poor 35% -15% 10% what are each stock’s expected return and the standard deviation? what are the expected return and the standard deviation of your portfolio? what is the beta of your portfolio? using capm, what is the expected return on the portfolio? given your answer above, would you buy, sell, or hold the portfolio?

Excel allows you to take a lot of data and organize it in one document. what are some of the features you can use to clarify, emphasize, and differentiate your data?