{"id":5592,"date":"2025-07-15T13:34:44","date_gmt":"2025-07-15T13:34:44","guid":{"rendered":"https:\/\/functiontranslator.com\/budhodnota\/"},"modified":"2021-02-26T09:56:00","modified_gmt":"2021-02-26T09:56:00","slug":"fv","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/cs\/fv\/","title":{"rendered":"BUDHODNOTA"},"content":{"rendered":"

Co p\u0159edstavuje funkce BUDHODNOTA<\/h2>\n

Funkce BUDHODNOTA (v angli\u010dtin\u011b ozna\u010dov\u00e1na jako FV pro Future Value) je d\u016fle\u017eit\u00e1 finan\u010dn\u00ed funkce v aplikac\u00edch MS Excel a Google Sheets, kter\u00e1 umo\u017e\u0148uje vypo\u010d\u00edtat budouc\u00ed hodnotu investice za p\u0159edpokladu pravideln\u00fdch \u00farok\u016f nebo vklad\u016f. Tato funkce zahrnuje parametry jako \u00farokovou sazbu, celkov\u00fd po\u010det platobn\u00edch obdob\u00ed, v\u00fd\u0161i jednotliv\u00fdch plateb, sou\u010dasnou hodnotu investice a typ platby.<\/p>\n

Syntaxe funkce<\/h2>\n

Funkce je definov\u00e1na n\u00e1sleduj\u00edc\u00ed syntax\u00ed:<\/p>\n

BUDHODNOTA(\u00farok, obdob\u00ed, platba, [sou\u010dasn\u00e1_hodnota], [typ])<\/code><\/pre>\n
    \n
  • \u00farok<\/strong> – \u00farokov\u00e1 sazba za jednotliv\u00e1 obdob\u00ed.<\/li>\n
  • obdob\u00ed<\/strong> – celkov\u00fd po\u010det obdob\u00ed pro spl\u00e1cen\u00ed nebo akumulaci v r\u00e1mci anuity.<\/li>\n
  • platba<\/strong> – pravideln\u00e1 platba v ka\u017ed\u00e9m obdob\u00ed, kter\u00e1 z\u016fst\u00e1v\u00e1 konstantn\u00ed po celou dobu trv\u00e1n\u00ed.<\/li>\n
  • sou\u010dasn\u00e1_hodnota<\/strong> (voliteln\u00e9) – p\u016fvodn\u00ed investovan\u00e1 \u010d\u00e1stka v dne\u0161n\u00ed hodnot\u011b, reprezentuj\u00edc\u00ed celkovou \u010d\u00e1stku investovanou k sou\u010dasn\u00e9mu dni.<\/li>\n
  • typ<\/strong> (voliteln\u00e9) – indikuje, zda jsou platby prov\u00e1d\u011bny na za\u010d\u00e1tku nebo na konci obdob\u00ed:\n
      \n
    • 0 nebo vynech\u00e1no – platby na konci obdob\u00ed<\/li>\n
    • 1 – platby na za\u010d\u00e1tku obdob\u00ed<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
      P\u0159\u00edklady vyu\u017eit\u00ed<\/h2>\n
      Poj\u010fme si nyn\u00ed \u0159\u00edct, jak m\u016f\u017eete funkci BUDHODNOTA prakticky pou\u017e\u00edt.<\/p>\n
      1. P\u0159\u00edklad – Spo\u0159en\u00ed<\/h2>\n
      P\u0159edpokl\u00e1dejme, \u017ee si chcete ka\u017ed\u00fd m\u011bs\u00edc odkl\u00e1dat 5 000 K\u010d do spo\u0159en\u00ed s ro\u010dn\u00ed \u00farokovou sazbou 3%, a to po dobu 10 let. Jak\u00e1 bude budouc\u00ed hodnota va\u0161ich \u00faspor?<\/p>\n
      = BUDHODNOTA(3%\/12, 10*12, -5000)<\/code><\/pre>\n
        \n
      • \u00darokov\u00e1 sazba byla p\u0159evedena na m\u011bs\u00ed\u010dn\u00ed \u00farok (3% \/ 12).<\/li>\n
      • Doba spo\u0159en\u00ed byla p\u0159evedena na po\u010det m\u011bs\u00edc\u016f (10 let * 12 m\u011bs\u00edc\u016f).<\/li>\n
      • v\u00fd\u0161ka platby je zad\u00e1na jako z\u00e1porn\u00e9 \u010d\u00edslo, co\u017e zna\u010d\u00ed v\u00fddaj z va\u0161eho \u00fa\u010dtu.<\/li>\n<\/ul>\n
        2. P\u0159\u00edklad – Spl\u00e1tka p\u016fj\u010dky<\/h2>\n
        P\u0159edstavte si, \u017ee si p\u016fj\u010dujete 300 000 K\u010d s ro\u010dn\u00ed \u00farokovou sazbou 6% a chcete tuto \u010d\u00e1stku spl\u00e1cet pravideln\u00fdmi m\u011bs\u00ed\u010dn\u00edmi platbami po dobu 5 let. Jak vysok\u00e1 bude posledn\u00ed platba?<\/p>\n
        = BUDHODNOTA(6%\/12, 5*12, 0, -300000)<\/code><\/pre>\n
          \n
        • M\u011bs\u00ed\u010dn\u00ed \u00farok je vypo\u010d\u00edt\u00e1n jako \u0161estina ro\u010dn\u00edho \u00faroku.<\/li>\n
        • Celkov\u00fd po\u010det platb (obdob\u00ed) odpov\u00edd\u00e1 5 let\u016fm p\u0159eveden\u00fdm na m\u011bs\u00edce.<\/li>\n
        • Po\u010d\u00e1te\u010dn\u00ed suma (sou\u010dasn\u00e1 hodnota) je zaps\u00e1na jako z\u00e1porn\u00e9 \u010d\u00edslo, co\u017e reprezentuje va\u0161i p\u016fvodn\u00ed dlu\u017enou \u010d\u00e1stku.<\/li>\n<\/ul>\n
          Tyto p\u0159\u00edklady ilustruj\u00ed, jak efektivn\u011b lze funkci BUDHODNOTA vyu\u017e\u00edt pro pl\u00e1nov\u00e1n\u00ed finan\u010dn\u00edch c\u00edl\u016f nebo spr\u00e1vu dluh\u016f.<\/p>\n","protected":false},"excerpt":{"rendered":"
          Vr\u00e1t\u00ed budouc\u00ed hodnotu investice<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[283],"tags":[],"class_list":["post-5592","post","type-post","status-publish","format-standard","hentry","category-financni"],"acf":[],"yoast_head":"\nFunkce FV (BUDHODNOTA) v Excelu: jak funguje, primjeri kori\u0161tenja formule<\/title>\n<meta name=\"description\" content=\"Opis funkcije FV (BUDHODNOTA) u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\" \/>\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\/cs\/fv\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funkce FV (BUDHODNOTA) v Excelu: jak funguje, primjeri kori\u0161tenja formule\" \/>\n<meta property=\"og:description\" content=\"Opis funkcije FV (BUDHODNOTA) u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/cs\/fv\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T09:56:00+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funkce FV (BUDHODNOTA) v Excelu: jak funguje, primjeri kori\u0161tenja formule\" \/>\n<meta name=\"twitter:label1\" content=\"Napsal(a)\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Odhadovan\u00e1 doba \u010dten\u00ed\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minuty\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/cs\/fv\/\",\"url\":\"https:\/\/functiontranslator.com\/cs\/fv\/\",\"name\":\"Funkce FV (BUDHODNOTA) v Excelu: jak funguje, primjeri kori\u0161tenja formule\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:44+00:00\",\"dateModified\":\"2021-02-26T09:56:00+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Opis funkcije FV (BUDHODNOTA) u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/cs\/fv\/#breadcrumb\"},\"inLanguage\":\"cs\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/cs\/fv\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/cs\/fv\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Funkce aplikace Excel\",\"item\":\"https:\/\/functiontranslator.com\/cs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Finan\u010dn\u00ed\",\"item\":\"https:\/\/functiontranslator.com\/cs\/financni\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"BUDHODNOTA\"}]},{\"@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\":\"cs\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"cs\",\"@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\/cs\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Funkce FV (BUDHODNOTA) v Excelu: jak funguje, primjeri kori\u0161tenja formule","description":"Opis funkcije FV (BUDHODNOTA) u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","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\/cs\/fv\/","og_locale":"cs_CZ","og_type":"article","og_title":"Funkce FV (BUDHODNOTA) v Excelu: jak funguje, primjeri kori\u0161tenja formule","og_description":"Opis funkcije FV (BUDHODNOTA) u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","og_url":"https:\/\/functiontranslator.com\/cs\/fv\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:44+00:00","article_modified_time":"2021-02-26T09:56:00+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funkce FV (BUDHODNOTA) v Excelu: jak funguje, primjeri kori\u0161tenja formule","twitter_misc":{"Napsal(a)":"glavadmin","Odhadovan\u00e1 doba \u010dten\u00ed":"2 minuty"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/cs\/fv\/","url":"https:\/\/functiontranslator.com\/cs\/fv\/","name":"Funkce FV (BUDHODNOTA) v Excelu: jak funguje, primjeri kori\u0161tenja formule","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:44+00:00","dateModified":"2021-02-26T09:56:00+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Opis funkcije FV (BUDHODNOTA) u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/cs\/fv\/#breadcrumb"},"inLanguage":"cs","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/cs\/fv\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/cs\/fv\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Funkce aplikace Excel","item":"https:\/\/functiontranslator.com\/cs\/"},{"@type":"ListItem","position":2,"name":"Finan\u010dn\u00ed","item":"https:\/\/functiontranslator.com\/cs\/financni\/"},{"@type":"ListItem","position":3,"name":"BUDHODNOTA"}]},{"@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":"cs"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"cs","@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\/cs\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5592","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/comments?post=5592"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5592\/revisions"}],"predecessor-version":[{"id":30730,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5592\/revisions\/30730"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/media?parent=5592"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/categories?post=5592"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/tags?post=5592"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}