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.

Need help with this or similar assignment?

• Tell Us Your Requirements: Please provide us with the specifics of your paper so that we may do our best to personalize it. Select the discipline, word count, format, academic level, and other details on the order form.
• Connect with the Best Writer: Consult and collaborate with an expert and complete your paper on schedule.
• Monitor the progress: Control the work process by checking the completed parts of your document right away. You can easily submit your comments by chatting with your essay writer on our website.
• Download Your Paper: Get your paper written according to your specifications. It is important to note that you only pay for an essay when you are completely satisfied with the outcome. Please provide us your feedback about our collaboration.

About Us

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.