Bond Valuation Using Yield Curve After you have completed the yield curve model, you can work on this assignment by creating a new tab in the module file. Obtain the latest yield curve rates from US Department of Treasury website. Use these yield curve rates, price a 10-year bond with $1000 face value, 4% coupon rate with semi-annual coupon payments. Therefore, this bond will have 20 periods to maturity. When yield curve rates are not available in between two periods, use simply linear extrapolation. For example, year 8's interest rate can be the average of Year 6's and Year 10's interest rates. After you price the bond, calculate the implied YTM of this bond. M4 Assignment - Bond Valuation Rubric Obtain the yield curve rates Timeline and variables setup Assign the appropriate discount rates for each period Calculate Bond price Calculate YTM 1 pt 1 pt 2 pts 1 pt 1 pt 6 pts If you didn't complete all the class work prior to this sheet -2 pts Total

Bond Valuation Using Yield Curve After you have completed the yield curve model, you can work on this assignment by creating a new tab in the module file. Obtain the latest yield curve rates from US Department of Treasury website. Use these yield curve rates, price a 10 -year bond with $1000 face value, 4% coupon rate with semi-annual coupon payments. Therefore, this bond will have 20 periods to maturity. When yield curve rates are not available in between two periods, use simply linear extrapolation. For example, year 8 's interest rate can be the average of Year 6's and Year 10's interest rates. After you price the bond, calculate the implied YTM of this bond