{"id":10725,"date":"2025-07-15T13:34:51","date_gmt":"2025-07-15T13:34:51","guid":{"rendered":"https:\/\/functiontranslator.com\/jurosacum\/"},"modified":"2021-02-25T17:12:56","modified_gmt":"2021-02-25T17:12:56","slug":"accrint","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/pt-pt\/accrint\/","title":{"rendered":"JUROSACUM"},"content":{"rendered":"

A fun\u00e7\u00e3o JUROSACUM \u00e9 amplamente utilizada no Microsoft Excel e no Google Planilhas para calcular os juros acumulados de um t\u00edtulo que efetua pagamentos peri\u00f3dicos antes do seu vencimento. Essa fun\u00e7\u00e3o \u00e9 particularmente valiosa no \u00e2mbito financeiro, pois permite aos investidores calcular o montante de juros que ir\u00e3o receber em t\u00edtulos como notas promiss\u00f3rias, obriga\u00e7\u00f5es e outras formas de investimentos de renda fixa.<\/p>\n

Sintaxe e Exemplos<\/h2>\n

A sintaxe da fun\u00e7\u00e3o JUROSACUM \u00e9 a seguinte:<\/p>\n

JUROSACUM(data_emissao, data_primeiro_cupom, data_vencimento, taxa, valor_nominal, frequencia, [tipo_base])<\/code><\/pre>\n
    \n
  • data_emissao<\/strong>: A data na qual o t\u00edtulo foi emitido.<\/li>\n
  • data_primeiro_cupom<\/strong>: A data do pagamento do primeiro cupom de juros.<\/li>\n
  • data_vencimento<\/strong>: A data em que o t\u00edtulo expira ou \u00e9 resgatado.<\/li>\n
  • taxa<\/strong>: A taxa anual de juros do t\u00edtulo.<\/li>\n
  • valor_nominal<\/strong>: O valor de face ou principal do t\u00edtulo.<\/li>\n
  • frequencia<\/strong>: A periodicidade dos pagamentos dos juros (1 = anual, 2 = semestral, 4 = trimestral).<\/li>\n
  • tipo_base<\/strong> (opcional): O m\u00e9todo utilizado para calcular os dias no ano (0 = 30\/360, 1 = real\/real, 2 = real\/360, 3 = real\/365).<\/li>\n<\/ul>\n
    Exemplo pr\u00e1tico de c\u00e1lculo de juros acumulados:<\/p>\n
    =JUROSACUM(\"01\/01\/2020\", \"01\/07\/2020\", \"01\/01\/2025\", 0.05, 1000, 2)<\/code><\/pre>\n
    Neste exemplo, o t\u00edtulo foi emitido em 1\u00ba de janeiro de 2020, o primeiro pagamento de juros ocorre em 1\u00ba de julho de 2020, o vencimento est\u00e1 programado para 1\u00ba de janeiro de 2025, a taxa de juros anual \u00e9 de 5%, com um valor principal de R$ 1000, e os juros s\u00e3o pagos semestralmente.<\/p>\n
    Aplica\u00e7\u00f5es Pr\u00e1ticas<\/h2>\n
    Cen\u00e1rio 1: Investimento em Obriga\u00e7\u00f5es<\/strong><\/p>\n
    Um investidor adquire uma obriga\u00e7\u00e3o e deseja determinar o total de juros acumulados que receber\u00e1 at\u00e9 o pr\u00f3ximo pagamento de cupom, dadas as seguintes caracter\u00edsticas:<\/p>\n
      \n
    • Data de emiss\u00e3o: 01\/01\/2023<\/li>\n
    • Data do primeiro cupom: 01\/07\/2023<\/li>\n
    • Data de vencimento: 01\/01\/2028<\/li>\n
    • Taxa de juro anual: 4%<\/li>\n
    • Valor nominal: R$5000<\/li>\n
    • Frequ\u00eancia de pagamento de juros: semestral<\/li>\n<\/ul>\n
      =JUROSACUM(\"01\/01\/2023\", \"01\/07\/2023\", \"01\/01\/2028\", 0.04, 5000, 2)<\/code><\/pre>\n
      Cen\u00e1rio 2: Compara\u00e7\u00e3o de T\u00edtulos<\/strong><\/p>\n
      Um analista financeiro deseja comparar os juros acumulados de dois t\u00edtulos distintos para aconselhar um cliente sobre a melhor escolha de investimento:<\/p>\n
      =JUROSACUM(\"01\/02\/2021\", \"01\/08\/2021\", \"01\/02\/2026\", 0.03, 3000, 2) =JUROSACUM(\"03\/03\/2021\", \"03\/09\/2021\", \"03\/03\/2026\", 0.045, 3000, 2)<\/code><\/pre>\n
      Esses c\u00e1lculos possibilitam ao analista fazer uma avalia\u00e7\u00e3o r\u00e1pida e fundamentada sobre qual t\u00edtulo apresenta um retorno mais atrativo.<\/p>\n
      Fun\u00e7\u00f5es financeiras como JUROSACUM s\u00e3o cruciais para investidores e analistas que necessitam de precis\u00e3o e agilidade nos c\u00e1lculos relacionados aos retornos dos seus investimentos em t\u00edtulos e outros instrumentos de d\u00edvida.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Devolve os juros acumulados de um t\u00edtulo que paga juros peri\u00f3dicos<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[438],"tags":[],"class_list":["post-10725","post","type-post","status-publish","format-standard","hentry","category-financeira"],"acf":[],"yoast_head":"\nFun\u00e7\u00e3o ACCRINT (JUROSACUM) no Excel \u2013 como funciona, exemplos e sintaxe<\/title>\n<meta name=\"description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o ACCRINT (JUROSACUM) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\" \/>\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\/pt-pt\/accrint\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fun\u00e7\u00e3o ACCRINT (JUROSACUM) no Excel \u2013 como funciona, exemplos e sintaxe\" \/>\n<meta property=\"og:description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o ACCRINT (JUROSACUM) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/pt-pt\/accrint\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T17:12:56+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fun\u00e7\u00e3o ACCRINT (JUROSACUM) no Excel \u2013 como funciona, exemplos e sintaxe\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/accrint\/\",\"url\":\"https:\/\/functiontranslator.com\/pt-pt\/accrint\/\",\"name\":\"Fun\u00e7\u00e3o ACCRINT (JUROSACUM) no Excel \u2013 como funciona, exemplos e sintaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:51+00:00\",\"dateModified\":\"2021-02-25T17:12:56+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o ACCRINT (JUROSACUM) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/accrint\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/pt-pt\/accrint\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/accrint\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fun\u00e7\u00f5es do Excel\",\"item\":\"https:\/\/functiontranslator.com\/pt-pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Financeira\",\"item\":\"https:\/\/functiontranslator.com\/pt-pt\/financeira\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"JUROSACUM\"}]},{\"@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\":\"pt-PT\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@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\/pt-pt\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fun\u00e7\u00e3o ACCRINT (JUROSACUM) no Excel \u2013 como funciona, exemplos e sintaxe","description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o ACCRINT (JUROSACUM) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","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\/pt-pt\/accrint\/","og_locale":"pt_PT","og_type":"article","og_title":"Fun\u00e7\u00e3o ACCRINT (JUROSACUM) no Excel \u2013 como funciona, exemplos e sintaxe","og_description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o ACCRINT (JUROSACUM) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","og_url":"https:\/\/functiontranslator.com\/pt-pt\/accrint\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:51+00:00","article_modified_time":"2021-02-25T17:12:56+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fun\u00e7\u00e3o ACCRINT (JUROSACUM) no Excel \u2013 como funciona, exemplos e sintaxe","twitter_misc":{"Escrito por":"glavadmin","Tempo estimado de leitura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/pt-pt\/accrint\/","url":"https:\/\/functiontranslator.com\/pt-pt\/accrint\/","name":"Fun\u00e7\u00e3o ACCRINT (JUROSACUM) no Excel \u2013 como funciona, exemplos e sintaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:51+00:00","dateModified":"2021-02-25T17:12:56+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o ACCRINT (JUROSACUM) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/pt-pt\/accrint\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/pt-pt\/accrint\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/pt-pt\/accrint\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fun\u00e7\u00f5es do Excel","item":"https:\/\/functiontranslator.com\/pt-pt\/"},{"@type":"ListItem","position":2,"name":"Financeira","item":"https:\/\/functiontranslator.com\/pt-pt\/financeira\/"},{"@type":"ListItem","position":3,"name":"JUROSACUM"}]},{"@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":"pt-PT"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"pt-PT","@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\/pt-pt\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/10725","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/comments?post=10725"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/10725\/revisions"}],"predecessor-version":[{"id":25554,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/10725\/revisions\/25554"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/media?parent=10725"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/categories?post=10725"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/tags?post=10725"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}