A

B

C

D

E

F

G

$H$

$1$

$2$

Probability of Price

Probability of Price

Investment

Increase, Daily

Decrease, Daily

Size of Price Change

$3$ Broad Stock Market Index

$4$ Small Capitalization Market Index

$5$ Local Casino

$0\mathrm{.}5030$

$0\mathrm{.}4970$

$0\mathrm{.}0550$

$0\mathrm{.}5005$

$0\mathrm{.}4995$

$0\mathrm{.}1050$

$6$

$11$

$12$ Required:

$13$ Using the information in the tables above, please calculate the expected return of each investment over one day, one month, and one year.

$14($Use cells A$3$ to D$10$ from the given information to complete this question.$)$

$16$

$17$

Stock Name

Expected Return: Daily

Broad Stock Market Index

Small Capitalization Market Index

Local Casino

Expected Return:

Monthly

Expected Return

Yearly

$21$

$22$

$23$

$24$ Students: The scratchpad area is for you to do any additional work you need to solve this question or can be used to show your work.

$25$ Nothing in this area will be graded, but it will be submitted with your assignment.

$26$

$27$