The purpose of this assignment is for you to value a bond using a yield curve where you must interpolate missing values.
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.
Eprowriters.com, and its afilliate blog Eprowriters.net, is a custom essay writing service that has been providing academic support with great success for more than five years. We are constantly updating our objectives in order to improve the quality of service we deliver and increase client satisfaction. We’ve progressed to an original concept as a result of our success.