Case study 02 – Bond valuation and yield curve interpolation Topic: Structure of interest rates – Interpolation FNCE –
Purpose: The purpose of this assignment is for you to value a bond using a yield curve where you must interpolate missing values.
Directions: Using the Case02_ExcelTemplate, follow the guidelines below to interpolate the yield curve and complete the bond valuation.
Step 1: Go to https://www.treasury.gov/resource-center/data-char… and fill in the yield curve (blue-font cells in column C). The date you must use is 09/01/2023.
Step 2: Complete the linear interpolation in column D.
Step 3: Complete the Nelson-Siegel model (as per video in brightspace). The final step is to find the value of a bond with 12 years to maturity, has an annual coupon payment and coupon rate of 7%. Par value is $1,000.
Step 4: Fill in cells L16 through W17 with the bond cash flows. Do the same for cells L24 through W24.
Step 5: Using the linear interpolated yield curve, fill in cells L17 through W17. Using the Nelson-Siegel yield curve, fill in cells L25 through W25. The bond prices will automatically calculate for you.