I need these 2 Questions done in 1 hours. Excel is related to the Question 1. Excel is for Question13 doc Question.

ONLY Assign yourself if you ca do

\fProblem: Assume that you wish to take a bet on the yield spread between two bonds: a 10-year corporate bond rated BB and a 10-year Treasury bond. Information about both bonds follows: 10 year Treasury bond 10 year BB corporate bond Maturity 10 years 10 years Coupon rate 5% 7% YTM Current price $96.526 DV01 $0.0680 5.5% $96.193 7.5% $0.0744 Assume that you believe the economy is going to get much worse in the future, and you wish to make your bet based on this premise. Also assume that you will buy 1000 units of the bond that you are going to hold "long." Finally, ignore margin requirements, interest on cash proceeds, and any intervening coupon payments of the long and short bonds. Answer the following questions in a Word document: 1. Are you betting that rates are going to converge or diverge? Why? 2. Which bond will you buy and which bond will you short-sell? 3. What is the DV01 ratio? Round to exactly 4 decimal places. 4. Using the DV01 ratio, calculate the number of units of the bond you will short-sell. 5. State your initial balance sheet assuming you implement the trade. Assume that you come up with the cash to fund the long position out of your pocket. Be sure to clearly label each column and describe each entry. Also be sure to include the totals. 6.Assume that in 1 month, the following is the information about the two bonds 10 year Treasury bond 10 year BB corporate bond Maturity 10 years 10 years Coupon rate 5% 7% YTM 6% 7% Current price $92.561 $100 7. 7.Restate your balance sheet using the above information. Be sure to clearly label each column and describe each entry. Also be sure to include the totals. 8. What is your gain or loss on equity in dollars? 9. What is your percentage gain or loss on equity as a holding period return?-- Question 1 - And here are the questions: Using the spreadsheet "Term Structure Template.xlsx" please complete the following exercises. 1. Calculate the prices for the first two bonds (.5 and 1 yr to maturity) 2. Calculate the spot rates, discount factors, and forward rates for the curve. State these rates both on a semi-annual and a BEY basis. 3. Use the spot rates to price a 6-year semi-annual pay 6% coupon bond. (Note: You will want to do this in an extra column in your excel spreadsheet). 4. Use the spot rates to price a 5-year semi-annual pay 9% coupon bond. (Note: You will want to do this in an extra column in your excel spreadsheet). 5. Use the spot rates to price a 4-year 7% semi-annual pay coupon bond. (Note: You will want to do this in an extra column in your excel spreadsheet)