首页    期刊浏览 2024年11月24日 星期日
登录注册

文章基本信息

  • 标题:Time-Value Concepts, Bond Valuation, and Corresponding Spreadsheet Functions
  • 本地全文:下载
  • 作者:Yi Feng ; Clarence C. Y. Kwan
  • 期刊名称:Spreadsheets in Education
  • 印刷版ISSN:1448-6156
  • 出版年度:2011
  • 卷号:5
  • 期号:1
  • 出版社:Faculty of Information Technology, Bond University
  • 摘要:

    This paper extends the coverage of bond valuation in introductory finance textbooks. Specifically, it extends the basic model for bond valuation to a more versatile model, which can accommodate valuation dates besides those matching the coupon dates of a bond. Such an extension allows the accrued interest to be properly recognized. Various spreadsheet-based exercises with data from bond quotations are proposed, in order to make the bond model more practically relevant and to enhance the learning experience of students. Connections between some bond-specific spreadsheet functions and the underlying time-value concepts are also established.

国家哲学社会科学文献中心版权所有