A. Modify the spreadsheet 3.1 of Duration Spreadsheet to calculate the duration of the 4-year 8%...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A. Modify the spreadsheet 3.1 of "Duration Spreadsheet" to calculate the duration of the 4-year 8% semiannual coupon bond, YTM=10%. B. Verify your solution of part A) using spreadsheet 3.3. Hint: You can put any settlement date and maturity date as long as the maturity matches the question. C. Modify the spreadsheet 3.1 of "Duration Spreadsheet" to calculate the duration of the 4-year 8% annual coupon bond, YTM=10%. D. Verify your solution of part C) using spreadsheet 3.3. E. Assume you will be paying $10,000 a year in tuition expenses at the end of the next 2 years (i.e. $10,000 at end of the year 1, $10,000 at end of the year 2). Market rate is 8%. Modify the spreadsheet 3.1 of "Duration Spreadsheet" to calculate the duration of your obligation? Hint: you can treat this obligation as a bond. Time until PV of CF Column (C) Payment (Discount rate = Period (Years) Cash flow 5% per period) Weight Column (F) A. 8% coupon bond 1 0.5 40 38.095 0.0395 0.0197 2 1.0 40 36.281 0.0376 0.0376 3 1.5 40 34.554 0.0358 0.0537 4 2.0 1040 855.611 0.8871 1.7741 Sum: 964.540 1.0000 1.8852 Semiannual int rate: 0.05 *Weight = Present value of each payment (Column E) divided by the bond price Time until PV of CF Column (C) Payment (Discount rate = Period (Years) Cash flow 5% per period) Weight* Column (F) A. 8% coupon bond 1 0.5 40 =D4/(1+SBS16)^B4 =E4/ES8 -F4*C4 =D5/(1+SBS16)^B5 =D6/(1+SBS16)^B6 =D7/(1+SBS16)^B7 1 40 =E5/ES8 -F5*C5 3 1.5 40 =E6/ES8 -F6*C6 1040 =E7/ES8 -F7*C7 Sum: =SUM(E4:E7) =SUM(F4:F7) -SUM(G4:G7) Semiannual int rate: 0.05 A. Modify the spreadsheet 3.1 of "Duration Spreadsheet" to calculate the duration of the 4-year 8% semiannual coupon bond, YTM=10%. B. Verify your solution of part A) using spreadsheet 3.3. Hint: You can put any settlement date and maturity date as long as the maturity matches the question. C. Modify the spreadsheet 3.1 of "Duration Spreadsheet" to calculate the duration of the 4-year 8% annual coupon bond, YTM=10%. D. Verify your solution of part C) using spreadsheet 3.3. E. Assume you will be paying $10,000 a year in tuition expenses at the end of the next 2 years (i.e. $10,000 at end of the year 1, $10,000 at end of the year 2). Market rate is 8%. Modify the spreadsheet 3.1 of "Duration Spreadsheet" to calculate the duration of your obligation? Hint: you can treat this obligation as a bond. Time until PV of CF Column (C) Payment (Discount rate = Period (Years) Cash flow 5% per period) Weight Column (F) A. 8% coupon bond 1 0.5 40 38.095 0.0395 0.0197 2 1.0 40 36.281 0.0376 0.0376 3 1.5 40 34.554 0.0358 0.0537 4 2.0 1040 855.611 0.8871 1.7741 Sum: 964.540 1.0000 1.8852 Semiannual int rate: 0.05 *Weight = Present value of each payment (Column E) divided by the bond price Time until PV of CF Column (C) Payment (Discount rate = Period (Years) Cash flow 5% per period) Weight* Column (F) A. 8% coupon bond 1 0.5 40 =D4/(1+SBS16)^B4 =E4/ES8 -F4*C4 =D5/(1+SBS16)^B5 =D6/(1+SBS16)^B6 =D7/(1+SBS16)^B7 1 40 =E5/ES8 -F5*C5 3 1.5 40 =E6/ES8 -F6*C6 1040 =E7/ES8 -F7*C7 Sum: =SUM(E4:E7) =SUM(F4:F7) -SUM(G4:G7) Semiannual int rate: 0.05
Expert Answer:
Related Book For
Financial Institutions Management A Risk Management Approach
ISBN: 978-0071051590
8th edition
Authors: Marcia Cornett, Patricia McGraw, Anthony Saunders
Posted Date:
Students also viewed these banking questions
-
The duration of a 20-year, 8 percent coupon Treasury bond selling at par is 10.292 years. The bonds interest is paid semiannually, and the bond qualifies for delivery against the Treasury bond...
-
Calculate the duration of a 12 percent coupon bond with 10 years remaining to maturity and selling at par. Use annual interest rates. Given the duration calculated, calculate the percentage change in...
-
A coupon bond paying semiannual interest is reported as having an ask price of 117% of its $1,000 par value. If the last interest payment was made one month ago and the coupon rate is 6%, what is the...
-
Good Morning Food, Inc. is using the profitability index (PI) when evaluating projects. You have to find the PI for the company's project, assuming the company's cost of capital is 14.29 percent. The...
-
A set of random variables, X1, X2, X3, Xn, are independent and each uniformly distributed over ( 0, 1). (a) Find the probability density function of Z = max(X1, X2 Xn). (b) With defined as in part...
-
If you double all the coefficients in the overall chemical reaction in an electrochemical cell, the equilibrium constant changes. Does the emf change? Explain your answer.
-
Following are selected questions from an internal control questionnaire relating to a company's debt and equity transactions. A \/es response to any question indicates a potential strength of the...
-
On January 1, 2011, Nathan Company received a 5-year, $5,000,000 loan, with interest payments occurring at the end of each year and the principal to be repaid on December 31, 2015. The interest rate...
-
7. Relative Velocity 10 points): Two airplanes fly between the same two cities. The destination city is due north of the origin, and both planes experience the same west-to-east crosswind but travel...
-
Calculate the following variances and indicate whether each variance is favorable or unfavorable: 1. Volume Variance 2. Total Variance Expected Treatments= 1,000 Standard Cost Profile Lab Treatment...
-
(b) If we have 500 mg of radium 222 Ra (parent atom) that is transformed into radon isotope 222 Rn (daughter atom), how much activity of 222Rn will be collected after 1 day, after 3.8 days, and after...
-
Partnerships between acute care and community-based settings improve continuity of care. How do these partnerships influence reimbursement for health systems?
-
Identify each participant and its role in the process by which the money supply changes and monetary policy is implemented.
-
Why is it financially important for hospitals to institute effective discharge planning programs?
-
Each year, millions of American investors pour billions of dollars into investment companies, which use those dollars to buy the common stock of other companies. What do the investment companies...
-
a. Explain what is meant by the statement "the United States has a fractional reserve banking system." b. How are these items related: total reserves, required reserves, and excess reserves?
-
What are enzyme promiscuity and substrate ambiguity, and how do they contribute to the evolution of new enzyme functions and metabolic pathways through gene duplication and divergence?
-
An investor sells a European call on a share for $4. The stock price is $47 and the strike price is $50. Under what circumstances does the investor make a profit? Under what circumstances will the...
-
Assume that a goal of the regulatory agencies of financial institutions is to immunize the ratio of equity to total assets, that is, ( (E/A) = 0. Explain how this goal changes the desired duration...
-
What is the burnout factor? How is it used in modeling prepayment behavior? What other factors may be helpful in modeling the prepayment behavior of a given mortgage pool?
-
Hands Insurance Company issued a $90 million, one-year note at 8 percent add-on annual interest (paying one coupon at the end of the year) or with an 8 percent yield. The proceeds were used to fund a...
-
If the 3-in.-diameter short rod is made from brittle material having an ultimate strength of \(\sigma_{\text {ult }}=60 \mathrm{ksi}\), for both tension and compression, determine if the shaft fails...
-
If the 3-in.-diameter shaft is made from cast iron having tensile and compressive ultimate strengths of \(\left(\sigma_{\mathrm{ult}} ight)_{t}=40 \mathrm{ksi}\), and \(\left(\sigma_{\mathrm{ult}}...
-
The shaft consists of a solid segment \(A B\) and a hollow segment \(B C\), which are rigidly joined by the coupling at \(B\). If the shaft is made from A-36 steel, determine the maximum torque \(T\)...
Study smarter with the SolutionInn App