The following spreadsheet contains monthly returns for Cola Co. and Gas Co. for 2013.

a. Using these data, estimate the average monthly return and volatility for each stock.

b. Assume your portfolio consists of 30% of Cola Co and 70% of Gas Co., what is the average monthly return and volatility for your portfolio? (you can paste the table below to Excel)

Realized Returns Date Cola Co. Gas Co. Jan -10.84% -6.00% Feb 2.36% 1.28% Mar 6.60% -1.86% Apr 2.01% -1.90% May 18.36% 7.40% Jun -1.22% -0.26% Jul 2.25% 8.36% Aug -6.89% -2.46% Sep -6.04% -2.00% Oct 13.61% 0.00% Nov 51% 4.68% Dec 0.54% 2.22%