{"id":1807,"date":"2018-07-04T17:42:54","date_gmt":"2018-07-04T17:42:54","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=1807"},"modified":"2023-11-02T19:12:37","modified_gmt":"2023-11-02T19:12:37","slug":"accrint","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/functions\/accrint\/","title":{"rendered":"ACCRINT function"},"content":{"rendered":"\n

The ACCRINT function in Excel is used to calculate the accrued interest on a security that pays periodic interest. This function can be helpful when you need to determine how much interest has accumulated on a bond or other financial instrument since the last payment date.<\/p>\n\n\n\n

Syntax<\/h2>\n\n\n\n

The syntax for the ACCRINT function is as follows:<\/p>\n\n\n\n

=ACCRINT(issue, first_interest, settlement, rate, par, frequency, [basis])<\/strong><\/code><\/pre>\n\n\n\n
Arguments<\/h2>\n\n\n\n
Here are the arguments for the ACCRINT function:<\/p>\n\n\n\n
Argument<\/strong><\/td>Description<\/strong><\/td><\/tr>
issue<\/strong><\/td>The security’s issue date.<\/td><\/tr>
first_interest<\/strong><\/td>The first interest payment date after the issue date.<\/td><\/tr>
settlement<\/strong><\/td>The date you want to calculate the accrued interest up to.<\/td><\/tr>
rate<\/strong><\/td>The annual coupon rate of the security.<\/td><\/tr>
par<\/strong><\/td>The security’s face value or par value.<\/td><\/tr>
frequency<\/strong><\/td>The number of interest payments per year (typically 1, 2, or 4).<\/td><\/tr>
[basis]<\/strong><\/td>(Optional) The day count basis to use for calculations. If omitted, Excel uses the default basis (actual\/actual).<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
How to Use<\/h2>\n\n\n\n
Here’s how to use the ACCRINT function with multiple examples:<\/p>\n\n\n\n
Example 1:<\/strong> Calculate accrued interest for a bond.<\/p>\n\n\n\n
=ACCRINT(\"1\/1\/2023\", \"7\/1\/2023\", \"10\/1\/2023\", 0.05, 1000, 2)<\/code><\/pre>\n\n\n\n
In this example, the bond was issued on January 1, 2023, the first interest payment date is July 1, 2023, and the settlement date is October 1, 2023. The coupon rate is 5%, the face value is $1,000, and interest is paid semi-annually (2 times a year).<\/p>\n\n\n\n
Example 2:<\/strong> Calculate accrued interest with a different day count basis.<\/p>\n\n\n\n
=ACCRINT(\"1\/1\/2023\", \"7\/1\/2023\", \"10\/1\/2023\", 0.05, 1000, 2, 1)<\/code><\/pre>\n\n\n\n
In this example, we specify a day count basis of 1, which represents the 30\/360 basis. This affects how Excel calculates the accrued interest.<\/p>\n\n\n\n
Example 3:<\/strong> Calculate accrued interest with omitted optional basis.<\/p>\n\n\n\n
=ACCRINT(\"1\/1\/2023\", \"7\/1\/2023\", \"10\/1\/2023\", 0.05, 1000, 2)<\/code><\/pre>\n\n\n\n
In this example, the optional basis argument is omitted, and Excel uses the default basis for the calculation.<\/p>\n\n\n\n
Remember that the ACCRINT function is a useful tool for financial analysts and investors to determine the interest accrued on bonds and other financial instruments. It considers various factors such as issue date, interest payment dates, settlement date, and coupon rate, allowing you to make precise interest calculations for your financial analysis.<\/p>\n","protected":false},"excerpt":{"rendered":"
The ACCRINT function in Excel is used to calculate the accrued interest on a security that pays periodic interest. This function can be…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[180],"yoast_head":"\nACCRINT function<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/functions\/accrint\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ACCRINT function\" \/>\n<meta property=\"og:description\" content=\"The ACCRINT function in Excel is used to calculate the accrued interest on a security that pays periodic interest. This function can be...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/functions\/accrint\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-04T17:42:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-02T19:12:37+00:00\" \/>\n<meta name=\"author\" content=\"Tomasz Decker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tomasz Decker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/accrint\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/accrint\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"ACCRINT function\",\"datePublished\":\"2018-07-04T17:42:54+00:00\",\"dateModified\":\"2023-11-02T19:12:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/accrint\/\"},\"wordCount\":313,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"keywords\":[\"done\"],\"articleSection\":[\"functions\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/accrint\/\",\"url\":\"https:\/\/officetuts.net\/excel\/functions\/accrint\/\",\"name\":\"ACCRINT function\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"datePublished\":\"2018-07-04T17:42:54+00:00\",\"dateModified\":\"2023-11-02T19:12:37+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/accrint\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/functions\/accrint\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/accrint\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ACCRINT function\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"ACCRINT function","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/officetuts.net\/excel\/functions\/accrint\/","og_locale":"en_US","og_type":"article","og_title":"ACCRINT function","og_description":"The ACCRINT function in Excel is used to calculate the accrued interest on a security that pays periodic interest. This function can be...","og_url":"https:\/\/officetuts.net\/excel\/functions\/accrint\/","article_published_time":"2018-07-04T17:42:54+00:00","article_modified_time":"2023-11-02T19:12:37+00:00","author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/functions\/accrint\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/functions\/accrint\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"ACCRINT function","datePublished":"2018-07-04T17:42:54+00:00","dateModified":"2023-11-02T19:12:37+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/functions\/accrint\/"},"wordCount":313,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"keywords":["done"],"articleSection":["functions"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/functions\/accrint\/","url":"https:\/\/officetuts.net\/excel\/functions\/accrint\/","name":"ACCRINT function","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"datePublished":"2018-07-04T17:42:54+00:00","dateModified":"2023-11-02T19:12:37+00:00","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/functions\/accrint\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/functions\/accrint\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/functions\/accrint\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"ACCRINT function"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1807"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=1807"}],"version-history":[{"count":7,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1807\/revisions"}],"predecessor-version":[{"id":16351,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1807\/revisions\/16351"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=1807"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=1807"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=1807"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}