1. Use Yahoo Finance to look at stock prices, look for GOOG(Google), follow the link for historical prices. Look at weekly returns from October 18, 2017 to from October 18, 2018, and then click on Download to spreadsheet. Use the "Close" values to calculate weekly returns. From this data find Google's arithmetic weekly return and variance (make sure your variance is unbiased due to the small sample). Use these answers to find the estimated geometric return.(Online fill in 1) Compare this estimated value to the real one. Useful excel commands: Finds unbiased sample variance=Var(data range) Finds the Geometric mean=Geomean(data range). Note the direct data from excel will need to be manipulated before these commands will work. (Geomean needs only positive numbers so take the geomean of 1 + weekly returns) In order for you to be indifferent between the after tax returns on a corporate bond paying 8.5% and a tax-exempt municipal bond paying 6.12%, what would your tax bracket need to be?(online fill in 2) Find the holding period returns for each of the three years: Start price End price Year-end dividend 2006 83.5 88.54 2.5 2007 88.54 84.21 1.5 2008 84.21 93.87 2.5 2. 3. 1. Use Yahoo Finance to look at stock prices, look for GOOG(Google), follow the link for historical prices. Look at weekly returns from October 18, 2017 to from October 18, 2018, and then click on Download to spreadsheet. Use the "Close" values to calculate weekly returns. From this data find Google's arithmetic weekly return and variance (make sure your variance is unbiased due to the small sample). Use these answers to find the estimated geometric return.(Online fill in 1) Compare this estimated value to the real one. Useful excel commands: Finds unbiased sample variance=Var(data range) Finds the Geometric mean=Geomean(data range). Note the direct data from excel will need to be manipulated before these commands will work. (Geomean needs only positive numbers so take the geomean of 1 + weekly returns) In order for you to be indifferent between the after tax returns on a corporate bond paying 8.5% and a tax-exempt municipal bond paying 6.12%, what would your tax bracket need to be?(online fill in 2) Find the holding period returns for each of the three years: Start price End price Year-end dividend 2006 83.5 88.54 2.5 2007 88.54 84.21 1.5 2008 84.21 93.87 2.5 2. 3