NotesFAQContact Us
Search Tips
Peer reviewed Peer reviewed
Direct linkDirect link
ERIC Number: EJ1261412
Record Type: Journal
Publication Date: 2020
Pages: 6
Abstractor: As Provided
ISSN: ISSN-0883-2323
An Excel-Based Method to Enhance the Study of "Duration and Convexity" in Financial Management Education
Mangiero, George A.; Qayyum, Arif; Cante, Charles J.
Journal of Education for Business, v95 n6 p402-407 2020
Many concepts in the study of financial management involve complex equations that require manipulating and testing with varying parameters in order to understand the relationships inherent in these equations. Such is the case with the concepts of Bond Duration and Convexity that are taught in such financial management courses as "Financial Futures, Options and Swaps" and "Analysis of Fixed Income Securities" among others. This paper, in comparison to time-consuming mathematical hand calculations, includes Excel-based methods for solving both Duration and Convexity problems in just minutes. In addition, these models are also helpful in classroom settings to explain the effect of interest rate changes on bond price.
Routledge. Available from: Taylor & Francis, Ltd. 530 Walnut Street Suite 850, Philadelphia, PA 19106. Tel: 800-354-1420; Tel: 215-625-8900; Fax: 215-207-0050; Web site:
Publication Type: Journal Articles; Reports - Descriptive
Education Level: Higher Education; Postsecondary Education
Audience: N/A
Language: English
Sponsor: N/A
Authoring Institution: N/A
Grant or Contract Numbers: N/A