Please use data for UIN:

654896597

13.2

1027.8

12.2

9.2

10.2

11.2

12.2

13.2

103.2

104.2

105.2

106.2

107.2

13.2

8.6

A. In a recent trading session, the benchmark 30-year Treasury bonds market price went upA1 dollars per $1000 face value to A2 dollars, while its yield fell from .07 to .068. Thebonds market price then went up another A3 dollars per $1000 face value as the yield fellfurther to .0665 from .068. Report answers for the following (using average of latest twobond prices for duration and average of latest three bond prices for convexity):1. Convexity, using the average of all three market prices of the bond in the denominatorof the formula.2. First modified duration, using average of first two market prices of the bond in thedenominator of the formula.3. Second modified duration, using average of second and third prices of the bond.4. The expected rise in bond price if the interest rate were to fall another 20 basis points(.002) from .0665, using the average of two modified durations and convexity. B. Estimate term structure of discount factors, spot rates and forward rates by using data onfive semi-annual coupon paying bonds with $100 face value each: The bonds,respectively, have 1.25, 5.35, 10.4, 15.15 and 20.2 years to maturity; pay coupon atannual rates of B1, B2, B3, B4, and B5 percent of face value; and are trading at quotedspot market prices in dollars of B6, B7, B8, B9 and B10. Specify the discount factorfunction d(t) by a third degree polynomial with unknown parameters a, b, and c, as donein class. Using estimated d(t) function, determine spot rate and forward rate functions byassuming half-year compounding. Then write the values of the following based on yourestimation.5. Coefficient of parameter a in first bond price equation.6. Coefficient of parameter b in first bond price equation.7. Coefficient of parameter c in first bond price equation.8. Coefficient of parameter a in second bond price equation.9. Coefficient of parameter b in second bond price equation.10.Coefficient of parameter c in second bond price equation.11.Coefficient of parameter a in third bond price equation.12.Coefficient of parameter b in third bond price equation.13.Coefficient of parameter c in third bond price equation.14.Coefficient of parameter a in fourth bond price equation.15.Coefficient of parameter b in fourth bond price equation.16.Coefficient of parameter c in fourth bond price equation.17.Coefficient of parameter a in fifth bond price equation.18.Coefficient of parameter b in fifth bond price equation.19.Coefficient of parameter c in fifth bond price equation.20.Parameter a.21.Parameter b.22.Parameter c.23.Current price of a dollar at 5th year.24.Current price of a dollar at 7th year.25.Current price of a dollar at 10th year.26.Current price of a dollar at 15th year.27.Spot rate for term 2 year.28.Spot rate for term 5 year.29.Spot rate for term 10 year.30.Spot rate for term 17 year.31.Forward rate for half year period 2.5 to 3.0 years.32.Forward rate for half year period 5.5 to 6.0 years.33.Forward rate for half year period 10.5 to 11.0 years.34.Forward rate for half year period 15.5 to 16.0 years. C. Estimate the 2-year, 5-year, and 10-year key rate durations of a 20-year bond carrying acoupon of C1 percent on face value $100 paid semi-annually. The given term structurestarts with C2 percent spot rate of interest at time zero and rises at a rate of 0.002 (.2%)per half year thereafter. Take a 20 basis point (.002) move in each key interest rate tocalculate the key rate durations by the method done in class and given in textbook. Reportanswers for the following:35. Current fair price of the bond with the given term structure.36. Price change needed to calculate 2-year key rate duration.37. Price change needed to calculate 5-year key rate duration.38. Price change needed to calculate 10-year key rate duration.39. 2-year key rate duration.40. 5-year key rate duration.41. 10-year key rate duration.D. Using the following data on the price of a bond and the corresponding interest rate(assuming a flat term structure) and regression method, estimate convexity and duration ofthe bond:Price Interest Rate99 .06100 .057101.5 .052102 .049105 .044106.5 .038108 .033108.5 .031110.1 .02842. What is the estimated value of Duration?43. What is the estimated value of Convexity?

uin A1 A2 A3 B1 B2 B3 B4 B5 B6 B7 B8 B9 B10 C1 C2 654784434 6.9 1034.1 5.9 2.9 3.9 4.9 5.9 6.9 96.9 97.9 98.9 99.9 100.9 6.9 1.1 672477838 7.8 1033.2 6.8 3.8 4.8 5.8 6.8 7.8 97.8 98.8 99.8 100.8 101.8 7.8 2.2 658888740 8.7 1032.3 7.7 4.7 5.7 6.7 7.7 8.7 98.7 99.7 100.7 101.7 102.7 8.7 3.2 669116578 9.6 1031.4 8.6 5.6 6.6 7.6 8.6 9.6 99.6 100.6 101.6 102.6 103.6 9.6 4.3 664970417 10.5 1030.5 9.5 6.5 7.5 8.5 9.5 10.5 100.5 101.5 102.5 103.5 104.5 10.5 5.4 677851922 11.4 1029.6 10.4 7.4 8.4 9.4 10.4 11.4 101.4 102.4 103.4 104.4 105.4 11.4 6.5 652433262 12.3 1028.7 11.3 8.3 9.3 10.3 11.3 12.3 102.3 103.3 104.3 105.3 106.3 12.3 7.6 654896597 13.2 1027.8 12.2 9.2 10.2 11.2 12.2 13.2 103.2 104.2 105.2 106.2 107.2 13.2 8.6 659869110 14.1 1026.9 13.1 10.1 11.1 12.1 13.1 14.1 104.1 105.1 106.1 107.1 108.1 14.1 9.7 676769598 15 1026 14 11 12 13 14 15 105 106 107 108 109 15 10.8 FIN415 Exam-2 Due by 5:30 p.m., November 16, 2015 Read the following paragraph before proceeding. Late Submissions Carry No Credit It is required that you submit in plain text, within the body of the email sent to sacharya@uic.edu, your UIN and then only two columns of numbers: (a) question serial number and (b) the corresponding numerical answer. Write 999999 for all blank answers. You are also required to attach to the email detailed works (scanned, pdf or doc or excel files) to your email; do not attach the answers which must be in plain text within the email itself. Non-numerical characters or explanations for answers within the body of the email will not be accepted. Each question carries equal weight. If you believe that more data are necessary to solve, assume whatever you think is necessary to answer the questions. All questions are required to be answered independently without any consultation with other students or professors. Email submissions with works attached are due by the deadline. Answers submitted by any other means, after the deadline or without matching work will be treated as missing with zero credit. Take the data from the attached page corresponding to your UIN on A1, A2, A3, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, C1 and C2. Interest rates are expressed as annualized rates for the term specified. Report your interest rate answers as fractional numbers like 0.11 for 11% per year. A. In a recent trading session, the benchmark 30-year Treasury bond's market price went up A1 dollars per $1000 face value to A2 dollars, while its yield fell from .07 to .068. The bond's market price then went up another A3 dollars per $1000 face value as the yield fell further to .0665 from .068. Report answers for the following (using average of latest two bond prices for duration and average of latest three bond prices for convexity): 1. Convexity, using the average of all three market prices of the bond in the denominator of the formula. 2. First modified duration, using average of first two market prices of the bond in the denominator of the formula. 3. Second modified duration, using average of second and third prices of the bond. 4. The expected rise in bond price if the interest rate were to fall another 20 basis points (.002) from .0665, using the average of two modified durations and convexity. B. Estimate term structure of discount factors, spot rates and forward rates by using data on five semi-annual coupon paying bonds with $100 face value each: The bonds, respectively, have 1.25, 5.35, 10.4, 15.15 and 20.2 years to maturity; pay coupon at annual rates of B1, B2, B3, B4, and B5 percent of face value; and are trading at quoted spot market prices in dollars of B6, B7, B8, B9 and B10. Specify the discount factor function d(t) by a third degree polynomial with unknown parameters a, b, and c, as done in class. Using estimated d(t) function, determine spot rate and forward rate functions by assuming half-year compounding. Then write the values of the following based on your estimation. 5. Coefficient of parameter a in first bond price equation. 6. Coefficient of parameter b in first bond price equation. 7. Coefficient of parameter c in first bond price equation. 8. Coefficient of parameter a in second bond price equation. 9. Coefficient of parameter b in second bond price equation. 10. Coefficient of parameter c in second bond price equation. 11. Coefficient of parameter a in third bond price equation. 12. Coefficient of parameter b in third bond price equation. 13. Coefficient of parameter c in third bond price equation. 14. Coefficient of parameter a in fourth bond price equation. 15. Coefficient of parameter b in fourth bond price equation. 16. Coefficient of parameter c in fourth bond price equation. 17. Coefficient of parameter a in fifth bond price equation. 18. Coefficient of parameter b in fifth bond price equation. 19. Coefficient of parameter c in fifth bond price equation. 20. Parameter a. 21. Parameter b. 22. Parameter c. 23. Current price of a dollar at 5th year. 24. Current price of a dollar at 7th year. 25. Current price of a dollar at 10th year. 26. Current price of a dollar at 15th year. 27. Spot rate for term 2 year. 28. Spot rate for term 5 year. 29. Spot rate for term 10 year. 30. Spot rate for term 17 year. 31. Forward rate for half year period 2.5 to 3.0 years. 32. Forward rate for half year period 5.5 to 6.0 years. 33. Forward rate for half year period 10.5 to 11.0 years. 34. Forward rate for half year period 15.5 to 16.0 years. C. Estimate the 2-year, 5-year, and 10-year key rate durations of a 20-year bond carrying a coupon of C1 percent on face value $100 paid semi-annually. The given term structure starts with C2 percent spot rate of interest at time zero and rises at a rate of 0.002 (.2%) per half year thereafter. Take a 20 basis point (.002) move in each key interest rate to calculate the key rate durations by the method done in class and given in textbook. Report answers for the following: 35. 36. 37. 38. 39. 40. 41. Current fair price of the bond with the given term structure. Price change needed to calculate 2-year key rate duration. Price change needed to calculate 5-year key rate duration. Price change needed to calculate 10-year key rate duration. 2-year key rate duration. 5-year key rate duration. 10-year key rate duration. D. Using the following data on the price of a bond and the corresponding interest rate (assuming a flat term structure) and regression method, estimate convexity and duration of the bond: Price 99 100 101.5 102 105 106.5 108 108.5 110.1 42. 43. Interest Rate .06 .057 .052 .049 .044 .038 .033 .031 .028 What is the estimated value of Duration? What is the estimated value of Convexity