please help me with these questions! I attached the file below.

Homework #1: BASIC RETURNS CALCULATIONS Questions 7 - 10 are to be done in Excel. Do problems 7 - 10 in Excel. 7. Consider the US 5 3/8 of Feb 2031. This is a US Treasury bond with a 5.375% coupon, maturing on Feb. 15, 2031 and paying half its annual coupon each year on Feb 15 and half on Aug 15 (or the first business day after that, if the date is Saturday, Sunday, or a holiday such as Presidents Day, Feb. 16, 2015). Assume today is the first Wednesday in September of the current year and right now the bond is quoted in the market at a price of 98-14 (i.e., 98 and 14 / 32). The first thing you need to do is figure out how many days are in the current coupon period and the amount of interest that accrues each day. a) If you buy this bond at the quoted price for delivery tomorrow, what will the invoice price be per 100 face value (the invoice price is the quoted price plus accrued interest)? b) Use the built-in Excel spreadsheet function YIELD to calculate the yield to maturity on the bond at this price. c) Suppose the yield to maturity were 1 basis point higher than what you just calculated. How much different would the price be? (Use the built-in Excel function PRICE to do this.) This difference is called the "price equivalent of a basis point" or the "DV01". 8. The closing prices for stocks ABC and XYZ last week were: Day ABC XYZ Mon Tues Weds Thurs Fri 51 53 52.50 51 53 31 32.50 33 31.50 32 a) Calculate the mean logarithmic returns for each stock, the variances, and standard deviations. (Note: The logarithmic, or continuously compounded return, is defined as Rt = ln(St / St-1). ) b) Annualize the means and variances of the log returns (assume 255 trading days per year). c) Compute the volatilities. (Volatility is the annualized standard deviation of log returns.) d) What are the covariance and the correlation coefficient between ABC's and XYZ's returns? 9. Do problem 8 again, but use simple returns instead of log returns. (Note: The simple return is calculated as Rt = (St / St-1) - 1. For "volatility" in part c), just calculate the standard deviation of the annualized percent return. How similar or different are the answers from the two ways of doing the calculations? 1 10. Futures mature every few months, so in estimating optimal hedge ratios, it is common to create a historical series of returns on the "nearby" contract (i.e., the one closest to expiration) by stringing together past returns drawn from a sequence of futures contracts. This must be done carefully to avoid having a spurious jump in the price (and therefore, a weird return) on the day when you roll over to the next maturity. You must first compute the returns for the SEP and DEC contract months and then connect the returns into a single returns series. Suppose these are the prices for the Sep and Dec futures contracts in the week when you want to roll over from the Sep to the Dec future. Rollover day is Thursday, meaning that you use the returns from the SEP contract through Weds, and from the DEC contract for Thursday and Friday. Day SEP DEC Fri Mon Tues Weds Thurs Fri 1311.00 1298.00 1274.50 1262.20 1243.20 1271.70 1322.70 1310.30 1286.30 1275.70 1251.80 1283.00 Construct one returns series for this futures contract for the week, with a rollover from the Sep to the Dec contract on Thursday. (Note: for the "return" on a future, just use the percentage price change.) 2