You purchased a bond on 12/5/2019 for $108 that makes semi-annual payments of $5. The bond matures on 1/31/2029 and makes its final coupon payment on this date. Par value is 100.

#16) What was the yield to maturity of this bond on the date it was purchased?

#17) What was the bond's duration on the date it was purchased?

#18) How much accrued interest did you pay on the bond? Use (Actual/Actual) to determine the fraction of the coupon paid.

#19) Write a user defined function in VBA called 'TR' that computes the 'Treynor ratio' for a stock. The Treynor ratio can be computed by dividing a stock's alpha by its beta (e.g., Alpha/Beta). Your function will have two inputs, an array of returns for the stock and an array of returns for the S&P 500. Use your function to compute the Treynor ratio for GOOGL (use the prices for GOOGL in tab #1 - #8). Report this value in the Answers Tab using your function.

#20) Write a user defined function in VBA called 'Recommendation' that returns whether the stock you are analyzing is a buy (1), hold (0) or sell (-1). You will have two parameter inputs: 1) a projected price for the stock (as determined by the analyst) and 2) the current market price. If the stock's projected price is more than $10 per share greater than the current market price the function will return a 1 indicating 'buy'. If the stock's projected price is more than $10 below (absolute value) the current market price then the function will return a -1 indicating 'sell'. Otherwise, if the projected price is within $10 of the current market price then the function will return a 0 indicating 'hold'. If Microsoft is currently selling for $183 per share, use the function to compute recommendations for the following projected prices: A) $170, B) $180, and C) $195. Report these output values in the Answers Tab using your function.