AccrInt

Phillip J Shelton shelton11@dingoblue.net.au
Tue, 23 Jan 2001 22:51:50 +1000


--------------6BC30F131777E9AFF70A2E75
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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.

--------------6BC30F131777E9AFF70A2E75
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
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. --------------6BC30F131777E9AFF70A2E75--