AccrInt



This is the definition of accrued  interest from a web glossary.
accrued interest 
      Interest that is due on a bond or other fixed income security since the last interest payment was made. This often occurs for bonds purchased
      on the secondary market, since bonds usually pay interest every six months, but the interest is accrued by the bondholders every month.
      When a bond is sold, the buyer pays the seller the market price plus the accrued interest, for which the buyer will be reimbursed at the end of
      the six-month period. Accrued interest is calculated on a 30-day month for corporate bonds and municipal bonds, and on
      actual-calendar-days for Government Bonds. Income bonds, bonds in default and zero-coupon bonds trade without accrued interest.


Here is the function definition as gnumeric has it.

       N_("@FUNCTION=ACCRINT\n"
           "@SYNTAX=ACCRINT(issue,first_interest,settlement,rate,par,"
           "frequency[,basis])\n"
           "@DESCRIPTION="
           "ACCRINT calculates the accrued interest for a "
           "security that pays periodic interest.  The @rate is the annual "
           "rate of the security and @par is the par value of the security. "
           "@basis is the type of day counting system you want to use:


I was thinking that issue should be the date of the last interest payment, settlement should be the date of the next interest payment, first_interest should be the date that you are accuring on, and frequency would be the number of interest payments in the year.



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]