+ Reply to Thread
Results 1 to 2 of 2

Yield to Maturity

  1. #1
    Registered User
    Join Date
    11-28-2006
    Posts
    1

    Yield to Maturity

    Does anyone know how to computer yield to maturity, in Excel, for a bond that pays interest more than 4 times per year. Excel's builtin function limits payment frequency to 4 times per year. However, many bonds pay interest monthly.

  2. #2
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Hi,

    Following should help ...
    Please Login or Register  to view this content.
    8 Nb of months
    0 Coupon
    98 current price
    100 price at maturity


    HTH
    Carim
    Last edited by Carim; 11-29-2006 at 05:19 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1