{"id":262,"date":"2025-07-15T13:34:46","date_gmt":"2025-07-15T13:34:46","guid":{"rendered":"https:\/\/functiontranslator.com\/2021\/02\/12\/intrate\/"},"modified":"2021-02-13T11:34:44","modified_gmt":"2021-02-13T11:34:44","slug":"intrate","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/en\/intrate\/","title":{"rendered":"INTRATE"},"content":{"rendered":"

Below is a detailed guide on how to use the INTRATE function in Microsoft Excel and Google Sheets.<\/p>\n

Overview<\/h2>\n

The INTRATE function in Excel and Google Sheets is designed to calculate the interest rate of a fully invested security. It provides the interest rate for securities that pay periodic interest, based on a par value of $100.<\/p>\n

Syntax<\/h2>\n

The syntax for the INTRATE function is identical in both Excel and Google Sheets:<\/p>\n

INTRATE(settlement, maturity, investment, redemption, basis)<\/code><\/pre>\n
where:<\/p>\n
    \n
  • settlement<\/b> – The settlement date of the security, which is when the security is purchased.<\/li>\n
  • maturity<\/b> – The maturity date of the security, or when it expires.<\/li>\n
  • investment<\/b> – The amount of money invested in the security.<\/li>\n
  • redemption<\/b> – The redemption value of the security at maturity.<\/li>\n
  • basis<\/b> – The day count basis to be used in the calculation.<\/li>\n<\/ul>\n
    Examples<\/h2>\n
    Let us review some practical examples of how the INTRATE function can be implemented:<\/p>\n
    Example 1: Calculate Interest Rate<\/h3>\n
    Compute the interest rate for an investment given the following details:<\/p>\n\n\n\n
    Settlement Date<\/th>\nMaturity Date<\/th>\nInvestment Amount<\/th>\nRedemption Value<\/th>\nBasis<\/th>\n<\/tr>\n
    1\/1\/2021<\/td>\n12\/31\/2021<\/td>\n$95<\/td>\n$100<\/td>\n0 (actual\/actual)<\/td>\n<\/tr>\n<\/table>\n
    Using the formula: =INTRATE(\"1\/1\/2021\", \"12\/31\/2021\", 95, 100, 0)<\/code><\/p>\n
    Example 2: Varying Day Count Basis<\/h3>\n
    Calculate the interest rate using varying day count bases:<\/p>\n\n\n\n\n
    Basis<\/th>\nInterest Rate<\/th>\n<\/tr>\n
    1 (actual\/actual)<\/td>\n=INTRATE(\"1\/1\/2021\", \"12\/31\/2021\", 95, 100, 1)<\/code><\/td>\n<\/tr>\n
    4 (30\/360)<\/td>\n=INTRATE(\"1\/1\/2021\", \"12\/31\/2021\", 95, 100, 4)<\/code><\/td>\n<\/tr>\n<\/table>\n
    By exploring these examples, you can efficiently utilize the INTRATE function in Excel and Google Sheets to determine the interest rate for investments. Ensure that dates, amounts, and basis parameters are entered correctly to obtain accurate results.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Returns the interest rate for a fully invested security<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[199],"tags":[],"class_list":["post-262","post","type-post","status-publish","format-standard","hentry","category-financial"],"acf":[],"yoast_head":"\nExcel INTRATE Function \u2013 How It Works, Formula Examples and Syntax<\/title>\n<meta name=\"description\" content=\"Learn what the Excel INTRATE function does. Clear syntax explanation and useful formula examples.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/en\/intrate\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel INTRATE Function \u2013 How It Works, Formula Examples and Syntax\" \/>\n<meta property=\"og:description\" content=\"Learn what the Excel INTRATE function does. Clear syntax explanation and useful formula examples.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/en\/intrate\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-13T11:34:44+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel INTRATE Function \u2013 How It Works, Formula Examples and Syntax\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/en\/intrate\/\",\"url\":\"https:\/\/functiontranslator.com\/en\/intrate\/\",\"name\":\"Excel INTRATE Function \u2013 How It Works, Formula Examples and Syntax\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:46+00:00\",\"dateModified\":\"2021-02-13T11:34:44+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Learn what the Excel INTRATE function does. Clear syntax explanation and useful formula examples.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/en\/intrate\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/en\/intrate\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/en\/intrate\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Function Excel\",\"item\":\"https:\/\/functiontranslator.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Financial\",\"item\":\"https:\/\/functiontranslator.com\/en\/financial\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"INTRATE\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/en\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel INTRATE Function \u2013 How It Works, Formula Examples and Syntax","description":"Learn what the Excel INTRATE function does. Clear syntax explanation and useful formula examples.","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:\/\/functiontranslator.com\/en\/intrate\/","og_locale":"en_US","og_type":"article","og_title":"Excel INTRATE Function \u2013 How It Works, Formula Examples and Syntax","og_description":"Learn what the Excel INTRATE function does. Clear syntax explanation and useful formula examples.","og_url":"https:\/\/functiontranslator.com\/en\/intrate\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:46+00:00","article_modified_time":"2021-02-13T11:34:44+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel INTRATE Function \u2013 How It Works, Formula Examples and Syntax","twitter_misc":{"Written by":"glavadmin","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/en\/intrate\/","url":"https:\/\/functiontranslator.com\/en\/intrate\/","name":"Excel INTRATE Function \u2013 How It Works, Formula Examples and Syntax","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:46+00:00","dateModified":"2021-02-13T11:34:44+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Learn what the Excel INTRATE function does. Clear syntax explanation and useful formula examples.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/en\/intrate\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/en\/intrate\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/en\/intrate\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Function Excel","item":"https:\/\/functiontranslator.com\/en\/"},{"@type":"ListItem","position":2,"name":"Financial","item":"https:\/\/functiontranslator.com\/en\/financial\/"},{"@type":"ListItem","position":3,"name":"INTRATE"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/en\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/262","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/comments?post=262"}],"version-history":[{"count":3,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/262\/revisions"}],"predecessor-version":[{"id":3153,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/262\/revisions\/3153"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/media?parent=262"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/categories?post=262"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/tags?post=262"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}