ACCRINTM(issue, maturity, rate [,par] [,basis]) |
Returns the accrued interest for a security that pays interest at maturity. |
issue | The date the security is issued. |
maturity | The maturity date of the security. |
rate | The annual coupon rate of the security. |
par | (Optional) The par value of the security (1000). |
basis | (Optional) The type of day counting to use: 0 = US 30/360 (default) 1 = Actual/Actual 2 = Actual/360 3 = Actual/365 4 = European 30/360 |
Remarks |
* Dates must be entered as text strings within quotation marks or as serial numbers. * The maturity date is the date that the security expires. * If "issue" is not an integer, it is truncated. * If "issue" is not a valid date, then #VALUE! is returned. * If "issue" >= "maturity", then #NUM! is returned. * If "maturity" is not an integer, it is truncated. * If "maturity" is not a valid date, then #VALUE! is returned. * If "rate" <= 0, then #NUM! is returned. * If "par" <= 0, then #NUM! is returned. * If "par" is left blank, then 1000 is used. * If "basis" is left blank, then 0 is used. * If "basis" is not an integer, it is truncated. * If "basis" < 0, then #NUM! is returned. * If "basis" > 4, then #NUM! is returned. * You can use the ACCRINT function to return the accrued interest for a security that pays interest periodically. * You can use the DATE function to enter your dates. * For the Microsoft documentation refer to support.microsoft.com |
|
1 - How much interest has accrued at maturity on a US treasury bond with a par value of $1,000 issued on 1 Jan 2011 with a maturity date of 1 Dec 2011 with a coupon of 6% paid semi-annually with a day count of 30/360. |
© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top