Bond and Term Structure Essay

Submitted By avrdan
Words: 1494
Pages: 6
Open Document
Professor Kay Giesecke
Fall 2012 October 30, 2012
Project I Date due: Nov. 13, 2012

Bond Portfolio Management Project (Part I)

You are the manager of SCIEN-INVEST Pension Fund. The date is 10/11/2012 and SCIEN-INVEST must purchase a portfolio of U.S. Treasury Bonds to meet the fund’s projected liabilities in the future. In order to construct this optimal bond portfolio, you need to know the term structure of interest rates as of 10/11/2012. Bond price quotations appear on the following page.

Estimating the term structure of interest rates(Step 1)Adjust the bond price quotes so that they reflect all accrued interest. (Note that Excel can ‘add’ and ‘subtract’ dates).
(Step 2)One approach to estimating the term structure is to calculate the market spot interest rates at each maturity date by constructing a zero coupon bond for each maturity. (Construct a portfolio of two bonds with the same maturity to obtain the payout of a zero-coupon bond of that maturity. If there are no coupon payments remaining before maturity, use each bond individually to compute a spot rate and then take an average of those spot rates as your estimate.) Use the continuous compounding form to calculate spot rates from prices of these zero coupon bonds:
D(t) = e – r ( t) t
Where D(t) is the discount factor at time t, r(t) is the spot rate and t is in units of years. For simplicity assume 365 days in a year. Plot this term structure.
(Step 3) On the advice of a consultant, you decide instead to estimate the term structure of interest rates as a smooth function with a polynomial, using the bond prices adjusted for accrued interest in Step 1. (not using the zero-coupon bond data obtained in Step 2). Extensive testing by the consultant has given some merit to estimation with a 4th order polynomial in time: r(tj)= a0 + a1tj + a2 t2j + a3t3j + a4t4j where the ai’s are the polynomial coefficients. To find the ai’s, use an ordinary least squares procedure involving the price of the bonds where we seek to minimize the sum of squared price errors, with the restriction that a0  0. (That is, suppose Pj(t) is the dirty price of j’th bond, and let Qj(t) be the price using the 4th order polynomial for discounting. Note that Qj(t) will depend upon the values of the coefficients, ai. You should minimize the sum of the squared errors, (Pj - Qj)2 , by changing the coefficients ai.) Assume continuous compounding, and use the Microsoft Excel Solver to find the ‘best fit’ coefficients.
(Step 4) Plot this fitted term structure and give the values of the 5 polynomial coefficients, namely, the 5 ai’s. Compare the spot rates you get from Step 2 and Step 3 and discuss the advantages and disadvantages of both methods.
Hint: You should use Excel’s Solver to estimate the term structure with the following OPTION settings. Solver can be found under the FORMULA Menu, or alternatively under Add Ins under the OPTIONS Menu. The procedure is straightforward. You may also wish to read the explanation in Excel HELP.
The followings are recommended settings in using Solver:
Optimization Time: 3600 Seconds
Iteration: 100Precision: 0.000001
Tolerance: 0.05%Convergence: 0.0001
Tangent, Forward Derivative, Newton’s Method
Note:Start with a0 = a1= a2= a3= a4= 0. Solver may be sensitive to starting values if you start with different values. You may also want to run Solver more than once if you don’t get the optimal solution from Solver in your first trial.

Bond Quotations on October 11, 2012.
Assume all payments fall on the 15th of the month and that coupons are paid semi-annually. The par or face value of all bonds is $100. The coupons are stated as a percentage of the face value. Ask Prices are the prices for buying bonds and the fractional part is quoted in $1/32nds.
Ignore all taxes.
Table 1: Bond Quotation Maturity | Coupon (%) | Quoted Ask Price | 15-Feb-2013 | 4 5/8 | 101 | 22 | 15-Feb-2013 | 7/8 | 100
Show More

Related Documents: Bond and Term Structure Essay

Notes On Sequential Immunisation

consecutive years leading up to the maturity date of the liability. At the beginning of each new year, the investor is allowed to re-balance his bondportfolio. At the end of the final year of his strategy, he cashes in all his claims and sells all remaining bonds and uses the proceeds to pay off his liability. We hope that the magnitude of the proceeds from his portfolio is very close to the size of his liability. The same material was also covered in our lectures in Week 6. §1 The Idea of Dynamic Immunisation…

Words 4153 - Pages 17

Bonds and Bond Yields Bond Essay

Rates and Bond Valuation 7-1 McGraw-Hill/Irwin Copyright © 2013 by The McGraw-Hill Companies, Inc. All rights reserved. Chapter Outline • • • • • • • • 7-2 Bond Definition Bond Features Valuation of a Bond Bond Relationships Inflation and Interest Rates Determinants of Bond Yields Bond Ratings Bond Markets Chapter Outline • • • • • • • • 7-3 Bond Definition Bond Features Valuation of a Bond Bond Relationships Inflation and Interest Rates Determinants of Bond Yields Bond Ratings Bond Markets…

Words 1604 - Pages 7

EC223 Clicker Questions Essay

assets c) Spreading the cost of borrowed funds over many customers d) Providing depositors with a variety of savings certificates The primary assets of a finance company are: a) Corporate stocks and bonds (these are their liabilities) b) Mortgages c) Consumer and business loans d) Municipal bonds Adverse selection is a problem associated with equity and debt contracts arising from a) The borrower’s lack of incentive to seek a loan for highly risky investments b) The borrower’s lack of good options…

Words 2373 - Pages 10

Intel Capital Structure Essay

Question 5: Evaluate the Put-Warrant/Convertible Bond proposal. Does it solve Intel’s capital structure dilemma? What arguments might be made in favor of it? Intel’s capital structure dilemma was that it was holding too much cash on hand. Eventually, there were three available strategies or alternatives that Intel could undertake in terms of cash disbursement policies. First, it could continue or expand its market-repurchase program. Secondly, Intel could declare dividends to its shareholders…

Words 885 - Pages 4

Fixed Income Securities Essay example

474 Outline 1 Discount Factors 2 Interest Rates 3 The Term Structure of Interest Rates 4 Coupon Bonds 5 Quoting Conventions 6 Floating Rate Bonds COMM 474 Basics of Fixed Income Securities 1 / 35 Outline 1 Discount Factors 2 Interest Rates 3 The Term Structure of Interest Rates 4 Coupon Bonds 5 Quoting Conventions 6 Floating Rate Bonds COMM 474 Basics of Fixed Income Securities 1 / 35 Discount Factors…

Words 6805 - Pages 28

Par Value Bond Essay

time? How do they vary among different types of bonds (treasuries, short term corporate bonds, long-term corporate bonds). 4. Explain how the term structure of interest rates determines a yield curve. What is the shape of the current yield curve for Treasuries? (show it or describe it). 5. What is the pure expectations theory? What does it imply about the term structure of interest rates? 6. What are the key features of a bond? 7. What are call provisions and sinking fund…

Words 436 - Pages 2

Financial Structure and International Debt Essay

Chapter 14 Financial Structure and International Debt ( Questions 1. Objective. What, in simple wording, is the objective sought by finding an optimal capital structure? When taxes and bankruptcy costs are considered, a firm has an optimal financial structure determined by that particular mix of debt and equity that minimizes the firm’s cost of capital for a given level of business risk. If the business risk of new projects differs from the risk of existing projects, the optimal mix…

Words 3484 - Pages 14

ACCT302 Research paper

paper I have designated Long-term Liabilities as for the topic which include specific issues on how corporations operates and how they raise money by issuing bonds and current financial crisis in Italy and circumstances of us and European debt. A corporation, per its by laws, usually requires approval by a company’s board of directors and the stockholders before bonds or notes can be issued. The same holds true for other types of long-term debt planning. Long-term liabilities are existing obligations…

Words 1493 - Pages 6

Learning Objectives For Chapter 5

1-5 Chapter 1 Understand what emergent properties and reductionism are. Think of some examples. Know the hierarchy of life -atom, molecule, cell, tissue, organ, organ system, organism, population, community, ecosystem, biosphere. Understand how structure relates to function. Understand how living things interact with their environment. -How do living things obtain energy? How is this energy stored as potential energy and released as kinetic energy? Understand and think of some examples of positive…

Words 763 - Pages 4

Multiple Choice Questions: Introducing Money And The Financial System

real assets 2. Financial institutions: examples; basic functions 3. The Federal Reserve and other financial regulators: basics about Fed. Five key categories of financial assets: definition & basic features 1. Money 2. Stocks 3. Bonds 4. Foreign exchange 5. Securitized loans The financial system matches savers and borrowers through two channels: 1. Banks and other financial intermediaries 2. Financial market: primary vs secondary markets The financial system provides…

Words 499 - Pages 2