Essay about Calculate Convexity
Calculate Convexity
Leann Joseph
Southern New Hampshire University
Author Note:
This short paper was done as an assignment in fulfillment of the requirements for: Southern New Hampshire University’s FIN 645 Analytical Tools in Portfolio 14TW3
Running Head: Calculate Convexity 32 Assignment Using an Excel spreadsheet, calculate the convexity for the two bonds you selected for the Module Two Assignment. Conduct an analysis of their duration and convexity and expound on the difference between the two concepts. Since I did not choose two bonds in Module Two Assignment, I considered the following bonds:
**Using the dollar value of the bond and a $1000 face value,
I considered a bond that …show more content…
Considering the following bond: Coupon Rate  4% 5 year maturity Priced to yield 5% The value of the bond is as follows:
Running Head: Calculate Convexity The calculation of duration and convexity: Year t Cash Flow (1+i)^t PV of cash flow Timeweighted PV cash flow 0.97561 1.90363 2.78580 3.62380 4.41927 5.17378 5.88886 6.56597 7.20656 398.41118 436.95446 (1+i)^2 t^2+t Change of change
0.5 1 1.5 2 2.5 3 3.5 4 4.5 5 Sum
1 2 3 4 5 6 7 8 9 10
2 2 2 2 2 2 2 2 2 102
1.02500 1.05063 1.07689 1.10381 1.13141 1.15969 1.18869 1.21840 1.24886 1.28008
1.95122 1.90363 1.85720 1.81190 1.76771 1.72459 1.68253 1.64149 1.60146 79.68224 95.62397
1.05063 1.05063 1.05063 1.05063 1.05063 1.05063 1.05063 1.05063 1.05063 1.05063
2 6 12 20 30 42 56 72 90 110
3.7144 10.8714 21.2125 34.4919 50.4759 68.9427 86.6816 112.4926 137.1861 8342.6970 8871.7660
Current value is 95.62397 If yield increases by 1%, value is 91.46980
Bodie Z., Zane A. and Marcus AJ. 1996. Investments. Third Edition. Irwin/McGrawHill. Jones CP. 1998. Investments. Sixth Edition. John Wiley & Sons. Sharpe WF, Alexander G. and Bailey JV. 1999. Investments. Sixth Edition. Prentice Hall. Macaulay F. 1938. Some theoretical problems suggested by the movements of interest rates, bond yield, and stock prices in the United States since 1856. New York: National

Use of Scale Soft Pitzer to Calculate Deposition, or Precipitation, in a Reservoir or Core Material During Long Term Flow
3651 Words  15 PagesUse of ScaleSoftPitzer to calculate deposition, or precipitation, in a reservoir or core material during long term flow. Approach will be presented in four steps: 1. Determine whether equilibrium, kinetics, or mass transport is controlling, 2. Relate precipitation to the physical variables in the field or laboratory core, 3. Relate the physical variables that affect scale formation or dissolution to space and time in the reservoir or core material, and 4. Combine the two into a single…

How to Calculate Beta
819 Words  4 PagesHow to Calculate Beta Beta refers to the volatility of a particular stock compared against the volatility of the entire stock market or, in practice, a representative index of that market, such as the Standard and Poor 's (S&P) 500. Beta is an indicator of how risky a particular stock is and is used to evaluate its expected rate of return. Beta is one of the fundamentals stock analysts consider when choosing stocks for their portfolios, along with pricetoearnings ratio, shareholder 's equity…

U3 versus U6 to Calculate U.S. Unemployment Rate
604 Words  2 PagesShow). The U.S. unemployment statistics are not exempt from this theory. There are a few ways the American government calculates the unemployment rate. The two approaches that I will be focusing on are referred to as the U3 and the U6. The U3 is the best known, and the most commonly used unemployment statistics from the Bureau of Labor Statistics (BLS). It calculates the U.S. unemployment rate by taking the total number of unemployed persons and dividing that figure by the total number…

How to Calculate Accounting Terms Using Excel
2305 Words  10 PagesHow to Calculate a Present Value Using Microsoft Excel I want to do this! What 's This? Using Microsoft Excel to calculate the present value of a potential investment is a simple task once you learn the syntax of the required formula. Follow these easy steps and you can calculate present value using Microsoft Excel easily and quickly. Instructions 1. 1 Understand the concept of present value. Present value is one of the Time Value of Money calculations. Use it to answer questions…

Convexity & Duration
989 Words  4 Pagesis the modified duration of the bond? a) 5.0 b) 5.0 c) 4.5 d) 4.5 Example 16: FRl\1 Exam 1998Question 22 What is the price impact of a 10basispoint increase in yield on a 10year par bond with a modified duration of 7 and convexity of 50? a) 0.705 b) 0.700 c) 0.698 d) 0.690 Example 18: FRl\1 Exam 1998Question 20 Coupon curve duration is a useful method for estimating duration from market prices of a mortgagebacked security (MBS). Assume the coupon…

Computer Program to Calculate a Customer's Monthly Cellphone Bill
501 Words  2 Pages200 MB: For $15 per month a customer gets 200 MB of data usage. Package C: 1 GB: For $25 per month a customer gets 1 GB of data usage. Additional usage over the allotted amount for each plan is charged at $0.01 per 5KB. Write a program that calculates a customer's monthly bill. It should ask the user to enter the letter of the package the customer has purchased (A, B, or C) and the number of KB of data that were used. It should then display the total charges.**/ import javax.swing.JOptionPane;…

How to Calculate GDP
635 Words  3 PagesGDP 1. The basic formula for calculating GDP is Y = C + I + E + G Y = C + I + E + G where Y = GDP C = Consumer Spending I = Investment made by industry E = Excess of Exports over Imports G = Government Spending Thus, GDP = 1000 + 300 + 150 + 200 = $1650 2. If more energy was produced domestically, this would increase the GDP. The imports would be reduced, leading to an improved (XM) figure. In addition, I would also increase in order to extract that energy. Both of these functions serve…

1. Calculate the revised product costs for the four pens, based on the activity information collected by Dempsey
935 Words  4 Pages1. Calculate the revised product costs for the four pens, based on the activity information collected by Dempsey1. Calculate the revised product costs for the four pens, based on the activity information collected by Dempsey1. Calculate the revised product costs for the four pens, based on the activity information collected by Dempseyvvv1. Calculate the revised product costs for the four pens, based on the activity information collected by Dempsey1. Calculate the revised product costs for the four…

Describe the Methods Used to Calculate Value Added. How Does Value Added Contribute Towards Understanding the Connections Between the Business and Its Product Markets? Use Relevant Examples to Illustrate Points.
1400 Words  6 PagesEssay n°=1: Describe the methods used to calculate value added. How does value added contribute towards understanding the connections between the business and its product markets? Use relevant examples to illustrate points. Within the framework of value added in general, Pigou and Bernard Cox suggested the calculation of Value Added that is used for classical nationals accounts. In 1920, Pigou gave his interpretation of value added, consisting of being able to precisely determine the earnings…

What Solutions Are Possible to the Free Rider Problem, Both Inside and Outside of Government
2176 Words  9 PagesCHAPTER 16 MANAGING BOND PORTFOLIOS 161 Outline of the Chapter • Bond pricing and sensitivity of bond pricing to interest rate changes • Duration analysis – What is duration? – What determines duration? • Convexity • Passive bond management – Immunization • Active bond management 162 Interest Rate Risk • There is an inverse relationship between interest rates (yields) and price of the bonds. • The changes in interest rates cause capital gains or losses. • This makes fixedincome investments…
More about Essay about Calculate Convexity

Use of Scale Soft Pitzer to Calculate Deposition, or Precipitation, in a Reservoir or Core Material During Long Term Flow
3651 Words  15 Pages 
How to Calculate Beta
819 Words  4 Pages 
U3 versus U6 to Calculate U.S. Unemployment Rate
604 Words  2 Pages 
How to Calculate Accounting Terms Using Excel
2305 Words  10 Pages 
Convexity & Duration
989 Words  4 Pages 
Computer Program to Calculate a Customer's Monthly Cellphone Bill
501 Words  2 Pages 
How to Calculate GDP
635 Words  3 Pages 
1. Calculate the revised product costs for the four pens, based on the activity information collected by Dempsey
935 Words  4 Pages 
Describe the Methods Used to Calculate Value Added. How Does Value Added Contribute Towards Understanding the Connections Between the Business and Its Product Markets? Use Relevant Examples to Illustrate Points.
1400 Words  6 Pages 
What Solutions Are Possible to the Free Rider Problem, Both Inside and Outside of Government
2176 Words  9 Pages