Download monthly prices for the Vanguard Total Stock Market ETF (Ticker: VTI) and Vanguard Total Bond Market ETF (Ticker: BND) from January 2013 to December 2017. [1.5Points] a. Using the price information, calculate monthly returns from February 2013 to December 2017. [0.25 Points] b. Calculate expected returns for VTI and BND. [0.25 points] c. For each ticker, calculate the variance of returns by: [0. 5 Points] i. Manually computing the average of the sum of squared deviations between the realized (ex-post) return and expected (ex-ante) returns. ii. Using the VARP function. d. For each ticker, calculate the standard deviation of returns by: [0. 5 Points] i. Taking the square root of the average of sum of squared deviations between the realized and expected returns. ii. Using the STDEVP function.

Please use excel to solve questions, Thank you!