Use the following for #1-5:
use yahoo! finance to download the monthly stock prices for netflix (nflx) from january 2012 until january 2015 (36 return observations). (hint: you just need the date and adj close prices column from here).
use excel to answer the following questions:
1. what is the holding period return (hpr)?
what is the geometric average return (gar)?
(hint: gar= [[(1+r1)(1+r2+…+(1+rn)]^(1/n)] – 1)
what is the arithmetic average return (aar)?
what is the standard deviation of the monthly return (sd)?
2. what are the annualized values for each of these? :
annualized gar: (hint: [(1+gar)^(1/12)] – 1)
annualized aar:
annualized sd:

Carla was trying to decide what to do saturday evening. she has $100 available to spend for the evening. she has narrowed her choices down to these events: braves game, a concert of an artist she likes, or the georgia aquarium. admission to the braves game is $25, hot dogs cost $10, sodas cost $5. the concert costs $25 for admission, $20 for a souvernir t-shirt, and $10 for a soda. the georgia aquarium has the show of a lifetime with an all you can eat and drink that costs $100. carla does not want to take any driving chances, so in addition to the cost of the aquarium, she will also need to pay for her uber/lyft, which is $15 each way. which option should carla choose if she wants to spend the least? based on that choice, what then is carla's oppotunity cost? fully explain your answer in at least one paragraph.